Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Re: Procedure to set up PACKDISK utility on database node
 
From:   JAMES PARK

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
     [email protected]

     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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023