It is said that to avoid frequent running of intence, resource consuming PACKDISK process, we have to define FreeSpace for each table inorder to make sure that free space is available during bulk loading.
PACKDISK command basically works at cylinders level where data of multiple tables may be present but FSP is defined while creating a table(Table level).
My actual question is when we run PACKDISK command, does it works on cylinders for each table as FSP will be defined for each table differently?
If "A" is a table with FSP=20% and "B" is a table with FSP=30%. And we see that space in cylinders is getting low. Then how the PACKDISK works for these 2 tables with different FSP?
These links perchance can answer your questions:
The last sentence in caution is worth seeing.
In Ferret, set the SCOPE to TABLE and PACKDISK FSP = xxxx