Kbase P110698: How to find out if an extent is a Type I or a Type II Storage Area?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
9/29/2009 |
|
Status: Verified
GOAL:
How to find out if an extent is a Type I or a Type II Storage Area?
GOAL:
Is the Storage Area a Type I or Type II Storage Area?
GOAL:
Does setting a blocks per cluster to 1 make an area Type 1 and not Type 2?
FIX:
The following methods can be used:
1.) From the result of running "prostrct dbname -C list" against the database in question, the resulting dbname.st file will show;
A cluster-value of {8,64,512} blocks after the records per block definition for Type II Storage Area extents
example: d "Data_256_512":10,256;512 . << the last value <> 1
Otherwise, a value of 1 for Type I Storage Area extents
example: d "Data_256_1":11,256;1 . << the last value = 1
2.) Through querying the _Area VST table:
for each _Area:
disp _Area._area-name _Area._Area-clustersize.
end.
Will show an _Area-clustersize of 1 for Type I Storage Areas,
otherwise the cluster-value of {8,64,512} blocks for Type II Storage Area extents.