Archives of the TeradataForum

Message Posted: Fri, 18 Apr 2014 @ 22:20:59 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

I've created a file 'packdisk-scandisk.txt' under '/var/opt/Teradata/bteqdba'.

The content of the file is,

     cat /var/opt/Teradata/bteqdba/packdisk-scandisk.txt
     output over /var/opt/Teradata/bteqdba/TAREAS_DBA.log
     enable scriptmode
     scope vproc all
     showspace
     packdisk fsp=10
     y
     showspace
     scandisk
     yes
     quit

I prepared a cron job called 'crontab.packdisk' as 'su' under etc directory.

The content of the file is

     SHELL=/bin/sh
     PATH=/usr/bin:/usr/sbin:/sbin:/bin:/usr/lib/news/bin
     MAILTO=jpark@XXX.XXX.XXX.XXX

     30  19 * * Thu /opt/Teradata/tdat/pde/14.00.04.03/bin/cnsrun -utility ferret

     -multi -file /var/opt/Teradata/bteqdba/packdisk-scandisk.txt

     ***I set up this way to run packdisk every Thursday 7pm
     *** I added my userid in cron.allow in etc.

But I don't see the output file in /var/opt/Teradata/bteqdba

1. Should the output file exist before the cron job runs? Or, when a cron job runs does it create the output file?

2. What should I fix to make it run?

Thanks for your support.

James Park
Database Specialist

	<Prev	Next>		<<First	<Prev	Next>	Last>>