When you select option 7 from the Manager Selection Menu, the Spill File panel is displayed. You can also invoke this panel by issuing the following TSO command:
CALL 'QMFHPO.SRAALOAD(RAAMAIN)' 'RM S'
DB2P / DB2PLOCATION -- Spill File ------------------------------------ 8.1.0 Command ===> To calculate the number of tracks to allocate for spill file, enter: Name of Largest Table (Creator) ===> (Name)... ===> Device Type (3350, 3380, 3390) ===> ----------------------------------------------------------------------------- When you press ENTER, the spill file allocation will be computed. Maximum number of tracks for spill file: ----------------------------------------------------------------------------- |
If you press Enter, the spill file track allocation will be calculated based on the specified input table name and the storage device type.
If you press PF3, you will return to the previous panel without performing any more calculations.