Teradata Packdisk Job Schedule

[omarsaeed22]

Hi All,

Need to know that if the Packdisk is running twice a week in a small size database, is it a problem?

If yes then after how much duration we need to run the Packdisk?

Please mention the advantages and dis-advantages of running the Packdisk frequently.

Thanks and Regards,

Mohammad Omar Saeed

[Tuen]

you can write a script to look at your system to see if you need to run packdisk and then only trigger it if you need to run it.

you can run these from a script on the PDN (primary node)

So for example, we run showspace first and look at the percent free cylinders in the output of showspace.  If that is below a certain threshold, we then call the packdisk utility.  If we aren't below the threshold the job outputs the current freespace as an email and we exit the process till the next week.

an example to call show space from command line.

    /usr/pde/bin/cnsrun -utility ferret -commands "{output over /tmp/showspace.out} {showspace} {quit}" -multi ok

to find the average free cylinders from the file created in the command (double check this with output from your system).

    grep "Average Free Cylinders" /tmp/showspace.out | cut -f2 -d":" | cut -f1 -d"%"

you can then use this value to determine whether or not to run packdisk.

an example of calling packdisk from commandline

    /usr/pde/bin/cnsrun -utility ferret -commands "{output over /tmp/packdisk.out} {enable scriptmode} {packdisk /Y} {quit}" -multi ok

You probably don't want to be running packdisk too often especially if you don't really need have it running.

[omarsaeed22]

Hi,

Below is the output which I got after the Packdisk Job ran:-

Tue Feb 10, 2015  14:00:16 : Packdisk has been started

                           On All AMP vprocs

Type 'ABORT' to stop the command before completion

Type 'INQUIRE' to check on progress of command

Tue Feb 10, 2015  19:41:14 : vproc  10  response

Packdisk completed successfully.  Freed up 10685 (0029BD) cylinders

Tue Feb 10, 2015  19:47:41 : vproc  18  response

Packdisk completed successfully.  Freed up 10708 (0029D4) cylinders

Tue Feb 10, 2015  19:48:19 : vproc  6  response

Packdisk completed successfully.  Freed up 10581 (002955) cylinders

Tue Feb 10, 2015  19:53:56 : vproc  12  response

Packdisk completed successfully.  Freed up 10542 (00292E) cylinders

Tue Feb 10, 2015  19:55:35 : vproc  9  response

Packdisk completed successfully.  Freed up 10542 (00292E) cylinders

Tue Feb 10, 2015  19:56:00 : vproc  14  response

Packdisk completed successfully.  Freed up 10510 (00290E) cylinders

Tue Feb 10, 2015  19:56:38 : vproc  17  response

Packdisk completed successfully.  Freed up 10576 (002950) cylinders

Tue Feb 10, 2015  19:57:26 : vproc  2  response

Packdisk completed successfully.  Freed up 10533 (002925) cylinders

Tue Feb 10, 2015  19:59:05 : vproc  5  response

Packdisk completed successfully.  Freed up 10603 (00296B) cylinders

Tue Feb 10, 2015  19:59:12 : vproc  23  response

Packdisk completed successfully.  Freed up 10493 (0028FD) cylinders

Tue Feb 10, 2015  20:05:46 : vproc  16  response

Packdisk completed successfully.  Freed up 10591 (00295F) cylinders

Tue Feb 10, 2015  20:06:09 : vproc  22  response

Packdisk completed successfully.  Freed up 10623 (00297F) cylinders

Tue Feb 10, 2015  20:08:45 : vproc  8  response

Packdisk completed successfully.  Freed up 10628 (002984) cylinders

Tue Feb 10, 2015  20:10:01 : vproc  11  response

Packdisk completed successfully.  Freed up 10673 (0029B1) cylinders

Tue Feb 10, 2015  20:12:26 : vproc  13  response

Packdisk completed successfully.  Freed up 10569 (002949) cylinders

Tue Feb 10, 2015  20:14:31 : vproc  19  response

Packdisk completed successfully.  Freed up 10596 (002964) cylinders

Tue Feb 10, 2015  20:15:13 : vproc  3  response

Packdisk completed successfully.  Freed up 10662 (0029A6) cylinders

Tue Feb 10, 2015  20:16:27 : vproc  4  response

Packdisk completed successfully.  Freed up 10671 (0029AF) cylinders

Tue Feb 10, 2015  20:20:45 : vproc  21  response

Packdisk completed successfully.  Freed up 10647 (002997) cylinders

Tue Feb 10, 2015  20:22:09 : vproc  15  response

Packdisk completed successfully.  Freed up 10533 (002925) cylinders

Tue Feb 10, 2015  20:23:59 : vproc  1  response

Packdisk completed successfully.  Freed up 10631 (002987) cylinders

Tue Feb 10, 2015  20:24:55 : vproc  7  response

Packdisk completed successfully.  Freed up 10492 (0028FC) cylinders

Tue Feb 10, 2015  20:26:46 : vproc  20  response

Packdisk completed successfully.  Freed up 10633 (002989) cylinders

Tue Feb 10, 2015  20:42:06 : vproc  0  response

Packdisk completed successfully.  Freed up 10592 (002960) cylinders

Please let me know if  running Packdisk is necessary in this case. 

I would like to know more if it uses any resources and hampers the running of the System.