The SORTEX01 data set is needed in the TYPE=SCAN process.
To calculate the value for SORTEX01 in worksheet 2, complete the following
procedure.
Procedure
- Fill in columns E and F in worksheet 1.
- Column E: Total number of internal pointers
- For an HD database (including HALDBs) or a HISAM database, see
the TOTAL POINTER STATISTICS part in the Database Statistics report,
and put the following value in column E:
- If you specify INCORE=YES, the value of the BEYOND column in the
row TOTALS (SAME DBDS)
- If you specify INCORE=NO, the value of the TOTAL column under
USED in the row TOTALS (SAME DBDS)
For an index database, see the TOTALS part in the Scan of
Index Database report, and put the following value in column E:
- If column B is INDEX, the sum of the value of TOTAL VALID SEGMENTS
of INDEX and twice the value of TOTAL VALID SEGMENTS of OVERFLOW
- If column B is PSINDEX, the sum of TOTAL VALID SEGMENTS of INDEX
for all partitions
- Column F: Total number of external pointers
- Take the value of the column TOTAL in the row TOTALS (NOT SAME
DBDS). The row TOTALS (NOT SAME DBDS) is next to the row TOTALS (SAME
DBDS). Put the value in column F.
- Calculate SORTEX01 in worksheet 2 by the following formula:
SORTEX01 = 40 x (E + F) Bytes