Target environment screen

The Target Environment screen shown in the following figure is displayed when you select Option 3 from the Load Menu. It displays all extracted objects as they will be loaded in the target environment. That includes all changes to object names you made in Options 1 and 2 of the Load Menu. If the objects don’t exist in the target environment, File-AID/RDX will create them as long as you have authorization to create them. For Db2 objects, File-AID/RDX also requires that the extract file includes the DDL captured during extract processing.

Initially, all objects are displayed. You may use the HIDE command to control which objects are hidden from the display.

Target Environment

For Db2 objects, use this screen to specify and modify the Db2 database, tablespace, and storage group information for the Db2 tables and indexes to be loaded based on the extracted data. For more information on how File-AID/RDX creates new Db2 tables, see  Generating CREATE DDL.

For VSAM objects, use this screen to specify an alternate index, if the source MVS object has one. You also have the choice to exclude non-primary indexes. File-AID/RDX does not support alternate indexes for IAM files.

After completing the target environment information, press END to return to the Load Menu.

During the execution phase of the Load function, File-AID/RDX will attempt to create the object(s) that are marked for creation as specified on this screen.

Global Settings

The upper portion of this screen allows you to specify settings that apply to all listed Db2 or MVS objects.

Automatic Space Calculation

Specify whether you want File-AID/RDX to calculate the space allocation for new target objects based on the extracted data or not. The calculated space will not exceed the space allocation of the source. This field sets the status globally. You can also set the status for individual objects. The plus (+) sign indicates that the status for one or more individual objects has been changed.

N

(No) The space allocation parameters for objects to be created will be the same as for the source objects at their original creation.

M

(MVS objects only) File-AID/RDX will calculate the space allocation for new target MVS files based on the extracted data.

D

(Db2 objects only) File-AID/RDX will calculate the space allocation for new target Db2 objects based on the extracted data.

B

(Both Db2 and MVS objects) File-AID/RDX will calculate the space allocation for new Db2 and MVS target objects based on the extracted data.

This field sets the status globally. You can also set the status for individual objects. The plus (+) sign indicates that the status has been changed for one or more individual objects.

Create Target Environment Only

Specify whether you want File-AID/RDX to only create the target objects or also load data into the target objects.

N

(No) Loads the extracted data into the target objects.

Y

(Yes) File-AID/RDX will only create the target objects without loading any of the extracted data.

Lower Portion

The lower portion of this screen contains a list of Db2 and/or MVS objects in the target environment corresponding to the extracted (source) objects. If there are more entries on the list than will fit in the screen, you can scroll the fields in the lower portion of the screen up and down using standard scrolling commands (see Scrolling).

Db2 objects to be loaded are listed in hierarchal and alphabetical order, starting with the database, listing all tablespaces within that database, and all tables in the tablespace. If a table is to be created, it also lists all indexes, views, aliases, and synonyms for the table.

CMD

Enter the line commands in this column to edit the individual target objects.

Type

The object type is indicated in the next column:

• 
  
  • DATABASE indicates a Db2 database
  • TBLSPACE indicates a Db2 tablespace
  • TABLE indicates a Db2 table
  • TABLE_SYS indicates a Db2 SYSTEM TEMPORAL table
  • TABLE_BUS indicates a Db2 BUSINESS TEMPORAL table
  • TABLE_BIT indicates a Db2 BI-TEMPORAL table
  • TABLE_PAR indicates a Db2 partitioned table
  • FILE indicates an MVS sequential file, including GDG types
  • VSAM indicates an MVS VSAM KSDS file
  • IAM indicates an IAM (Innovation Access Method) file
  • AIX indicates an alternate index for an MVS object
  • PATH indicates a VSAM Path

The following object types are only displayed if their corresponding table is marked to be created:

• 
  
  • INDX indicates a secondary index for a Db2 table
  • IX_REQ indicates a required primary index for a Db2 table
  • IX_PAR indicates a partitioned index for a Db2 table
  • IX_P_REQ indicates a required partitioned index, either a primary, clustering, or index with UniqueRule of 'C' or 'R'. Indexes with UniqueRule of 'C' are required to enforce constraints and Indexes with a UniqueRule of 'R' are required for RI.
  • IX_P indicates a secondary partitioned index for a Db2 table
  • IX_DPSI indicates a data partitioned secondary index for a Db2 table

• 
  
  • VIEW indicates a view for a Db2 table
  • ALIAS indicates an alias for a Db2 table
  • SYNONYM indicates a synonym for a Db2 table

Object Name

Displays the fully qualified name of the object to be loaded. If it is a Db2 table it includes the creator ID of the owner of the table.

You can modify the entries in this column directly. Simply type the new name over the one displayed or use the S line command. You can also modify the target object name in the Source to Target Mapping screen (Load Option 2). There, you can modify the value in the Target field.

SHOW

Displays the result of the SHOW primary command. Depending on the specified parameter, the column name changes to and displays the associated Db2 DATABASE, STOGROUP, or TABLESPACE for the appropriate Db2 objects. See SHOW for the command description and Target Environment - SIZE Screen with SHOW DATABASE for an example. This column is blank until you enter a SHOW command.

Status

Displays a status message for the object to be loaded. See Target Objects Status Messages for a list of possible messages not listed in the following table. When there are multiple messages for an object, only the first is displayed

Object Status Messages

C

(Create Object) Displays a Y to indicate that the object will be created during the load process. Blank indicates that the object already exists, or is an implicit tablespace.

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 object names displayed in the list. Specify the change’ from string’ and change ‘to string’ in the CHANGE Command Window.

CHANGE Command Window

When you enter the CHANGE command, File-AID/RDX displays 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 object names, then press END to execute the change and exit the window.

CHANGE Command Window

When the SHOW STOGROUP is in effect and you enter the CHANGE command, File-AID/RDX displays 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. In Field to Change, specify what fields the change should act on, either O for all displayed object names, or S for stogroup names. Then press END to execute the change and exit the window.

CHANGE Command Window with Stogroup Option

END

The END command returns to the Load Menu. There are no operands associated with this command.

EXCLUDE (EX)

Enter the EXCLUDE command in the COMMAND line to exclude select target objects in the displayed list. Use this command in conjunction with the U (Unexclude) line command or UNEXCLUDE primary command when you have a long list of target objects displayed and you want to include only a few target objects in the load.

Valid parameters for EXCLUDE are:

When entered without a parameter, EXCLUDE displays the Exclude Command Window. See the following figure for an example.

Exclude Command Window

When you enter the EXCLUDE command without parameters, File-AID/RDX will display the Exclude Command Window as shown in the following figure. Select the object status types and object types you want to exclude from the load.

Exclude Command Window

Select the object status and/or object types to exclude, then press END to exit the window.

Object Types to Exclude

All DB2 objects

Enter Y to exclude all Db2 objects from the load. Enter N and all Db2 objects will not be excluded.

Indexes

Enter Y to exclude all Db2 indexes. Enter N to unexclude all Db2 indexes.

Aliases

Enter Y to exclude all Db2 aliases. Enter N to unexclude all Db2 aliases.

Synonyms

Enter Y to exclude all Db2 synonyms. Enter N to unexclude all Db2 synonyms.

Views

Enter Y to exclude all Db2 views. Enter N to unexclude all Db2 views.

All MVS objects

Enter Y to exclude all MVS objects from the load. Enter N and all MVS objects will not be excluded.

VSAM

Enter Y to exclude all VSAM files. Enter N to unexclude all VSAM files.

VSAM AIX

Enter Y to exclude all VSAM alternate indexes. Enter N to unexclude all VSAM alternate indexes.

VSAM PATH

Enter Y to exclude all VSAM paths. Enter N to unexclude all VSAM paths.

Non-VSAM

Enter Y to exclude all sequential (non-VSAM) files. Enter N to unexclude all sequential files.

FIND (F)

Searches the list for the specified string and scrolls the list to display the first matching entry at the top of the displayed entries. Use RFind to repeat the search.

HIDE (H)

Use the HIDE command to control which object types to hide from the displayed list. See also RESET (RES).

Valid parameters for HIDE and RESET are:

When entered without a parameter, HIDE displays the Hide Command Window. See the following figure for an example.

HIDE Command Window

When you enter the HIDE command without parameter, File-AID/RDX will display the Hide Command Window as shown in the following figure. Select the object status types and/or object types you want to hide from the display.

Hide Command Window

Select the object status and/or object types to hide or redisplay, then press END to exit the window.

Allow objects with errors to be hidden?

Enter Y to hide all objects that are marked with a special error status. Enter N to (re)display all objects that are marked with a special error status.

By Object Status

Auto-create objects

Enter Y to hide all objects that File-AID/RDX will create during the load. Enter N to (re)display all objects to be created.

Existing objects

Enter Y to hide all objects that already exist in the target environment. Enter N to (re)display all existing objects.

Excluded objects

Enter Y to hide all objects that are excluded from the load. Enter N to (re)display all excluded objects.

By Object Type

Databases

Enter Y to hide all Db2 databases. Enter N to (re)display all Db2 databases. Enter R (restore) to redisplay only those hidden databases whose lower level objects are not hidden.

Tablespaces

Enter Y to hide all Db2 tablespaces. Enter N to (re)display all Db2 tablespaces. Enter R (restore) to redisplay only those hidden tablespaces whose lower level objects are not hidden.

Tables

Enter Y to hide all Db2 tables. Enter N to (re)display all Db2 tables. Enter R (restore) to redisplay only those hidden tables whose lower level objects are not hidden.

Indexes

Enter Y to hide all Db2 indexes. Enter N to (re)display all Db2 indexes.

Aliases

Enter Y to hide all Db2 aliases. Enter N to (re)display all Db2 aliases.

Synonyms

Enter Y to hide all Db2 synonyms. Enter N to (re)display all Db2 synonyms.

Views

Enter Y to hide all Db2 views. Enter N to (re)display all Db2 views.

VSAM

Enter Y to hide all VSAM files. Enter N to (re)display all VSAM files. Enter R (restore) to redisplay only those hidden VSAM files whose lower level objects are not hidden.

VSAM AIX

Enter Y to hide all VSAM alternate indexes. Enter N to (re)display all VSAM alternate indexes.

VSAM PATH

Enter Y to hide all VSAM paths. Enter N to (re)display all VSAM paths.

Non-VSAM

Enter Y to hide all sequential (non-VSAM) files. Enter N to (re)display all sequential files.

REFRESH (R)

Refreshes the list of objects of the Target Environment screen. Use the REFRESH command after changes to the listed objects have an influence on the hierarchal and alphabetical order of the display.

REPORT (REP)

Prints the logical contents of the display. This report includes all of the displayable lines formatted like the current view.

RESET (RES)

Use the RESET command to return all hidden objects to the display. See also HIDE (H) for a list of parameters.

SHOW

The SHOW command alters the contents of the SHOW column in the Target Environment screen. Depending on the specified parameter, the SHOW column can display the associated database, tablespace or stogroup information for the appropriate Db2 objects in the list. SHOW without a parameter displays the Show Command Window.

Valid parameters for SHOW are:

• 
  
  • NOne
  • STgroup
  • DB (DataBase)
  • TS (TableSpace)

SHOW Command Window

When you enter the SHOW command without parameters, File-AID/RDX displays the Show Command Window as shown in the following figure. Specify the parameter you want to display in the SHOW column. None is the initial setting.

Show Command Window

Specify which Db2 information you want to display in the SHOW column, then press END to exit the window.

Data to display in SHOW column

N

(None) Clears or leaves the SHOW column empty.

S

(Stogroup) Displays the name of the Db2 storage group associated with the listed Db2 table or index.

D

(Database) Displays the name of the Db2 database associated with the listed Db2 table or tablespace.

T

(Tablespace) Displays the name of the Db2 tablespace associated with the listed Db2 table.

SIZE (S)

Increases the scrollable area to display more entries at a time by hiding some of the screen header lines. See the following figure for an example. SIZE is a toggle switch so enter SIZE again to return to the original format.

Target Environment - SIZE Screen with SHOW DATABASE

UNEXCLUDE (UNEX)

Enter the UNEXCLUDE command in the Command line to include all excluded source/target objects in the load again. Use this command in conjunction with the X (Exclude) line command or EXCLUDE primary command when you have a long list of source/target objects displayed and you want to reverse previous exclude commands.

See also EXCLUDE (EX) for a list of parameters.

When entered without a parameter, UNEXCLUDE displays the “Unexclude Command Window”. The window displays the same object types as the “Exclude Command Window”. 

Line Commands

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

E (Edit)

(Obsolete, replaced by the S line command) Enter the E (Edit) line command for each object you want to view or change. Depending on the object, File-AID/RDX will invoke the appropriate Create/Edit screen.

I (Information)

The I (Information) line command display the statements that will be used to create the object. For Db2 objects that will be the DDL, for MVS VSAM objects it will be the IDCAMS DEFINE, and for non-VSAM it will be the DD statement. I is only valid for objects marked to be created.

S (Select)

Enter the S (Select) line command for each object you want to view or change. Depending on the object, File-AID/RDX will invoke the appropriate Create/Edit screen.

X (Exclude)

Enter the X (Exclude) line command for each object you want to exclude from the current load request. Primary indexes may not be excluded.

U (Unexclude)

Enter the U (Unexclude) line command for each excluded object you want to include again in the Auto Create process.

This section provides information about the following topics: