Create/Edit Db2 table

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

Create DB2 Table

File-AID/RDX ---------------- Create DB2 Table ------------------------------
Command ===>

Primary Commands: LimitKey


Source Object:                            SSID: DSN Location: DSNLOCAT
   Table: FRSAMP.ORDER_TABLE
   Partitioned . : Yes                     NUMPARTS: 4


Target Object:                            SSID: DSN Location: DSNLOCAT

   Creator    ===> TSOID01
   Table Name ===> ORDER_TABLE
   Database   ===> FRSAMPDB
   Tablespace ===> ORDERRTA                BLANK For Implicit Tablespace
   Partitioned . : Yes                     NUMPARTS: 4

Use this screen to update the Db2 table information for the Db2 table to be loaded. After you modify the table information, press END to return to the Target Environment.

If the Db2 table, as specified on this screen, does not exist in the Target Environment, File-AID/RDX will attempt to create and then load the Db2 table during the execution phase of the Load function.

Source Object

SSID

Displays the Db2 subsystem ID of the “Source Environment” as specified in the extract file.

Location

Displays the remote Db2 location name of the “Source Environment” as specified in the extract file.

Table Name

Displays the full Db2 source table name, including creator ID of the table, as specified in the extract file.

Partitioned

Indicates whether the table is in a partitioned tablespace or not.

NUMPARTS

Displays the number of partitions.

MAXPARTITIONS

Displays 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.

Target Object

SSID

Displays the Db2 subsystem ID of the Target Environment.

Location

Displays the remote Db2 location name of the Target Environment.

Creator

Specify the creator ID of the table. This field is prefilled with the target creator ID for Db2 objects as specified in the Load Object Specifications or Source to Target Mapping screen.

Table Name

Specify the name of the table. This field is prefilled with the extracted table name or as specified in the Source to Target Mapping screen.

Important

When the source table is a Temporal Table, File-AID/RDX does not support creating the target Temporal Table, instead, File-AID/RDX creates a regular table. To load into a Temporal Table, it must already exist in the target environment.

Database

Displays the name of the Db2 database where the table resides in the Target Environment. This field is protected for tables that already exist in the target environment. If the target table does not exist, you can change the database only to an existing database or one to be created that is in the Target Environment list. To use a new database name please specify it at the database level.

Tablespace

Displays the name of the Db2 tablespace of the Target Environment for the table. This field is protected for existing tables. If the target table does not exist, you can change the tablespace field. If the tablespace does not exist in the Target Environment, File-AID/RDX will create it during the load process.

Important

Blank out the tablespace field and File-AID/RDX generates DDL to create the tablespace implicitly as long as only one table is associated with the tablespace and it’s a non-partitioned tablespace. The current SQLID must have the proper Db2 authority to create the tablespace in the execution phase.

Partitioned

Indicates whether the table is in a partitioned tablespace or not. Must be No for implicit tablespace.

NUMPARTS

Displays the number of partitions.

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.

Primary Commands

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

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.

Limit Key Definition Window

When you enter the LimitKey primary command, File-AID/RDX displays the Limit Key Definition screen as shown in the following figure. File-AID/RDX provides initial default values that you can change for each partition. In the Values field for each partition, enter the maximum key value, then press END to execute the value definition and exit the window.

Limit Key Definition

File-AID/RDX ----------------- Limit Key Definition   ------- Row 1 to 4 of 4
Command ===>                                                  Scroll ===> CSR

Primary commands: Size

Index: TSOID01.XEMP_PARTTS41                      Target NUMPARTS. . : 4
   Table: TSOID01.EMPPART                          Source NUMPARTS. . : 4
   Partitioning fields: PART,ASC


  PART Values
  ---- -------------------------------------------------------------------------
     1 '099999'
     2 '199999'
     3 '299999'
     4 '999999'
******************************* Bottom of data ********************************

Index

Displays the Db2 index name only if LimitKey command was issued from the Create Index screen.

Table

Displays the full Db2 object name, including creator ID of the table for which the limit key information is to be defined.

Partitioning fields

Displays the Db2 column names that are used in the partitioned index/tablespace.
If the index has an expression (IX_EXTENSION_TYPE field in SYSINDEXES equals 'S'), the expression(s) are listed here instead of the index columns.

Target NUMPARTS

Displays the number of partitions for the target tablespace.

Source NUMPARTS

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

PART

Displays the number of each partition.

Values

Specify the limit key value for each partition. This is an expandable field to allow specifying a value longer than a single line.

Primary Commands

The following File-AID/RDX-specific primary commands are valid on this screen:

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.