Create/Edit Db2 tablespace

The following panel is displayed when you enter the S (Select) line command on a Db2 tablespace in the Target Environment screen. This screen lets you modify the create tablespace information from the extract file to your new target environment.

Create Tablespace

Use this screen to update the Db2 tablespace information. After you view or modify the tablespace information, press END to return to the Target Environment.

Source Object

SSID

Displays the Db2 subsystem ID as specified in the extract file.

Location

Displays the remote Db2 location name as specified in the extract file.

Database

Displays the name of the source Db2 database as specified in the extract file.

Tablespace

Displays the name of the Db2 tablespace as specified in the extract file.

TS Type

Displays the tablespace type as specified in the extract file. See also Valid Tablespace Types. Valid types are:

Simple

Simple tablespace (No partitions).

Partitioned

Partitioned tablespace. The number of partitions are shown in the NUMPARTS field.

Segmented

Segmented tablespace. The segment size is shown in the SEGSIZE field.

Universal Table Space Range-partitioned

(Identifies a range-partitioned universal tablespace (UTS). Both, the number of partitions and the segment size are shown in the NUMPARTS and SEGSIZE fields respectively.

Universal Table Space Partitioned-by-growth

Identifies a partition-by-growth universal tablespace (UTS). Both, the maximum number of partitions and the segment size are shown in the MAXPARTITIONS and SEGSIZE fields respectively.

NUMPARTS

Displays the number of partitions as specified in the extract file.

MAXPARTITIONS

Displays the maximum number of partitions for a partition-by-growth universal tablespace (UTS) as specified in the extract file. The MAXPARTITIONS field displays in place of the NUMPARTS field for a partition-by-growth universal tablespace.

SEGSIZE

Displays the segment size of the tablespace, if the tablespace is segmented.

Target Object

SSID

Displays the Db2 subsystem ID of the Target Environment.

Location

Displays the remote Db2 location name of the Target Environment.

Database

Displays the name of the Db2 database of the Target Environment. You can only change it to an existing database or one to be created that is in the Target Environment list. To use a new database name please specify at the database level.

Tablespace

Specify the name of the Db2 tablespace of the Target Environment. If the tablespace does not exist in the Target Environment, File-AID/RDX will create it during the load process.

TS Type

Displays the tablespace type as specified in the extract file. See also Valid Tablespace Type Changes. Valid types are:

Simple

Simple tablespace (No partitions).

Partitioned

Partitioned tablespace. The number of partitions are shown in the NUMPARTS field. You can change the number of partitions in the NUMPARTS field. To change the partition attributes, issue the PART primary command.

Segmented

Segmented tablespace. The segment size is shown in the SEGSIZE field. You can change the segment size in the SEGSIZE field.

Universal Table Space Range-partitioned

Specifies a range-partitioned universal tablespace (UTS). Both, the number of partitions and the segment size can be changed in the NUMPARTS and SEGSIZE fields respectively. Either the NUMPARTS and SEGSIZE value or both values can be changed to zero for the target environment; this causes the type of tablespace to be different in the target environment than it was in the source environment. If NUMPARTS is set to zero but SEGSIZE is not, the new tablespace will be segmented. If SEGSIZE is set to zero but NUMPARTS is not, the new tablespace will be partitioned. If both NUMPARTS and SEGSIZE are set to zero, the new tablespace will be segmented with the default SEGSIZE of 4.

Universal Table Space Partitioned-by-growth

Specifies a partition-by-growth universal tablespace (UTS). Both, the maximum number of partitions and the segment size can be specified in the MAXPARTITIONS and SEGSIZE fields respectively. Either the MAXPARTITIONS and SEGSIZE value or both values can be changed to zero for the target environment; this causes the type of tablespace to be different in the target environment than it was in the source environment. If MAXPARTITIONS is set to zero but SEGSIZE is not, the new tablespace will be segmented. If SEGSIZE is set to zero but MAXPARTITIONS is not, this result in a partitioned-by-growth tablespace with a default SEGSIZE of 4. If both MAXPARTITIONS and SEGSIZE are set to zero, the new tablespace will be segmented with the default SEGSIZE of 4.

NUMPARTS

If this is to be a partitioned tablespace, enter the number of partitions. This field is protected as long as the target tablespace is an existing one. Once you change the target tablespace to a non-existing one, you can then enter the desired number of partitions. This field MUST NOT BE BLANK OR ZERO before attempting to define the partitions using the PARTITION command.

MAXPARTITIONS

Specify the maximum number of partitions for a partition-by-growth universal tablespace (UTS). The actual maximum partition size allowed is dependent on the DSSIZE and Page size defined for the Tablespace. The MAXPARTITIONS field displays in place of the NUMPARTS field for a partition-by-growth universal tablespace.

SEGSIZE

If this is to be a segmented tablespace, enter the desired segment size. This field MUST NOT BE BLANK OR ZERO before attempting to define the partitions using the PARTITION command.

Automatic Space Calculation

Specify whether you want File-AID/RDX to calculate the space allocation for the new target tablespace based on the extracted data or not. The calculated space will not exceed the space allocation of the source. It overrides the status set with the Automatic Space Calculation field in the Target Environment screen. This field is protected when selecting implicit tablespace creation. When this field displays an M, it indicates that the space allocation values have been entered manually which overrides the automatic space calculation.

Automatic Space calculation ===> M ( N = No; Y = Yes; M =Manual)

STOGROUP

Specify the Db2 storage group in which the new tablespace will reside. The storage group must already exist. This field is prefilled with your profile’s value or the extracted value, if the profile value is blank.

PRIQTY(K)

Primary Quantity. Specify the number of storage units allocated for the file in which your tablespace is to reside.

SECQTY(K)

Secondary Quantity. Specify how much more space should be allocated for the file if it exceeds the primary quantity.

BUFFERPOOL

Specify the Db2 buffer pool name associated with the tablespace. This field is prefilled with the extracted value.

FREEPAGE

Specify how often the system should leave a free page when the tablespace is updated.

PCTFREE

Specify how much of each page to leave free when the tablespace is updated.

Primary Commands

The following File-AID/RDX-specific primary command is valid on this screen:

PARTITION (PART)

Displays the Tablespace Partition Definition screen which lets you define the attributes for each tablespace partition.

LimitKey (LK)

Displays the Limit Key Definition screen which lets you define the limit key value for each logical partition, if the tablespace is partitioned.

Valid Tablespace Types

The following table shows what types of tablespaces are created in each Db2 Version.

Valid Tablespace Types

• ¹: CRTS = Create Tablespace
• ²: CRTB = Create Table

Valid Tablespace Type Changes

The following table shows what changes are valid for changing the type of tablespace.

Valid Tablespace Type Changes