Tablespace partition definition
The following panel is displayed when you enter the PARTITION primary command for a Db2 tablespace in the Create Tablespace screen. This screen lets you specify or modify the tablespace partition information.
Command ===> Scroll ===> CSR
Primary commands: Change, Size
Line commands: I = Insert; D = Delete; R = Repeat
Database .: FATSSSDB Target NUMPARTS. . : 200
Tablespace: CUSTOMER Source NUMPARTS. . : 4
Automatic space calculation ===> N (N = No; Y = Yes; M = Manual)
Target - Calculated total primary space . :
Source - Actual total primary space . . . : 40810
*** Any partition not displayed will be defined the same as the MODEL ***
PART STOGROUP PRIQTY SECQTY FREEPAGE PCTFREE
___ 1 STG002 10 20 20 20 <-MODEL
---- -------- ------- ------- -------- ------- -------------
___ 50 STG002 30 20 10 10
___ 100 STG002 30 20 10 10
___ 150 STG002 30 20 10 10
___ 200 STG002 30 20 10 10
******************************* Bottom of data ********************************
Use this screen to update the Db2 tablespace partition information. After you view or modify the tablespace partition information, press END to return to the Create Tablespace screen.
Database
Displays the name of the Db2 database of the Target Environment where the tablespace will reside.
Target NUMPARTS
Displays the number of partitions for the target tablespace.
Tablespace
Displays the name of the Db2 tablespace of the Target Environment for which you want to specify partition information.
Source NUMPARTS
Displays the number of partitions as specified in the extract file.
Automatic Space Calculation
Specify whether you want File-AID/RDX to calculate the space allocation for the new target tablespace partitions based on the extracted data or not. The calculated space will be distributed equally over all partitions. It overrides the status set with the Automatic Space Calculation field in the Target Environment screen.
Target - Calculated total primary space
Displays the total calculated space requirement for the new tablespace.
Source - Actual total primary space
Displays the total primary space allocation (at its original creation) of the tablespace from which the data was extracted.
Partition Fields
By default, partition 1 is used as the model partition. If all partitions have the same values as the model, no other partitions are displayed. Only partitions that are different from the model are displayed in the scrollable area below the model partition. Use the line commands to insert, repeat, or delete partitions that have different values than the model.
PART
For the model, it is the first partition of the source. In the list of differing partition definitions, it displays the number of each partition that is different from the model partition.
STOGROUP
Specify the Db2 storage group in which the new tablespace partition will reside. The storage group must already exist. This field is prefilled with the extracted storage group value.
PRIQTY(K)
Specify the number of storage units allocated for the file in which your tablespace partition is to reside.
SECQTY(K)
Specify how much more space should be allocated for the file for the new tablespace partition if it exceeds the primary quantity.
FREEPAGE
Specify how often the system should leave a free page when the tablespace partition is updated.
PCTFREE
Specify how much of each page to leave free when the tablespace partition is updated.
Primary Commands
The following File-AID/RDX-specific primary commands are valid on this screen:
CHANGE (C)
The CHANGE command allows you to globally update the entry fields for the partition definition. Specify the change ’from string’ and change ‘to string’ values in the CHANGE Command Window - Partition Definition and select the fields to change.
CHANGE Command Window
When you enter the CHANGE command, File-AID/RDX will pop up the CHANGE Command Window as shown in the following figure. Enter the Change ‘from string’ and the Change ‘to string’ values you want to change globally for all displayed partitions, then press END to execute the change and exit the window.
CHANGE Command Window - Partition Definition
SIZE (S)
Increases the scrollable area to display more entries at a time by hiding some of the screen header lines. See Target Environment - SIZE Screen with SHOW DATABASE for an example. SIZE is a toggle switch so enter SIZE again to return to the original format.
Line Commands
The following File-AID/RDX-specific line commands are valid on this screen:
I (Insert)
Enter the I (Insert) line command to insert a different partition definition after the current partition. The inserted partition(s) are based on the model partition. To insert more than 1 partition, enter the number of partitions with the I line command (nnn = 1 - 999). Then modify the partition values as required.
D (Delete)
Enter the D (Delete) line command to delete a partition definition in the list of different partitions from the model. To delete more than 1 partition, enter the number of partitions with the D line command (nnn = 1 - 999).
R (Repeat)
Enter the R (Repeat) line command to repeat a partition definition in the list of different partitions from the model. To repeat a partition definition more than once, enter the number of repetitions with the R line command (nnn = 1 - 999).
