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
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.
Hi,
Below is the output which I got after the Packdisk Job ran:-