Load defaults
The following figure is displayed when you select Option 3 from the RDX Profile Screen. Use this screen to specify the default values for a load using the current profile.
This screen has a large scrollable area. Be sure to navigate to the bottom of the scrollable area as to not miss any fields. Use the UP and DOWN keys to scroll up or down in this screen.
Load Defaults - Scrollable Screen
Command ===> SITE Profile: RDXMENU
More: +
-------------------- Locking Values and Navigation --------------------------
Any profile value setting can be locked so that it can not be changed on the
FA/RDX function panels. Values can always be changed in the Profile function.
To LOCK a value place the cursor on the value and press the TOGGLE key.
--------------------------- DB2 Data Defaults -------------------------------
Target DB2 Environment:
Default SQLID: ===>
SSID ===> *
Location ===>
Creator ===>
Index name prefix value ===>
Index name suffix value ===>
DB2 Load Method ===> DB2 (DB2 OR SQL)
Auto Create Defaults for DB2 Objects:
Database ===>
Tablespace ===>
Implicit Tablespace ===> N (Y = Yes; N = No)
STOGROUP ===>
Primary Quantity(K) ===> 20
Secondary Quantity(K) ===> 15
Freepage ===> 10
Pctfree ===> 10
Buffer Pool ===> BP0
Space recalculation ===> N (Y = Yes; N = No)
....................Defaults for Load Method = SQL Insert .....................
Existing Data Options:
Delete all rows ===> N (Y = Yes; N = No)
Replace matches ===> Y (Y = Yes; N = No)
Processing Options:
Lock during load ===> N (Y = Yes; N = No)
Commit Every Nth Row ===> 2000 (1 - 2000)
Maximum Rows to Discard ===> * (* for no maximum)
Save Discarded Rows ===> N (Y = Yes; N = No)
....................Defaults for Load Method = DB2 Load........................
Existing Data Option:
Delete all rows ===> Y (Y = Yes; N = No)
Processing Options:
Log Option ===> 1 (1 = Log; 2 = Image Copy
3 = Repair; 4 = Inline Image Copy)
--------------------------- MVS Data Defaults ---------------------------------
Auto Create Defaults for MVS Objects:
High level qualifier ===>
File name suffix value ===>
Space recalculation ===> Y (Y = Yes; N = No)
Storage Class ===>
Management Class ===>
Existing Data Options for MVS Objects:
Delete and Define ===> Y (Y = Yes; N = No)
Replace Matches ===> Y (Y = Yes; N = No)
--------------------- Objects with Zero Rows Extracted ------------------------
Include Objects with Zero Rows Extracted:
Generate Control Datasets ===> N (Y = Yes; N = No)
--------------------------- Panel Customization -------------------------------
Load Panel Flow Options:
First load panel ===> R (R = Recently Referenced List;
F = Saved Request File)
Display Load Menu ===> Y (Y = display Load Menu
N = display first FLOW panel)
Load Menu Contents:
1 - Load Object Specification ===> FLOW Place the cursor on value and
2 - Source to Target Mapping ===> FLOW press TOGGLE to change value.
3 - Target Environment ===> SHOW SHOW = Include on load menu.
4 - Existing Data Options ===> SHOW LOCK = Lock choice on load menu.
5 - Processing Options ===> SHOW FLOW = Include on the load menu
6 - Save Load Request ===> SHOW and pre-select the option
7 - View JCL/View REXX ===> SHOW for flow mode navigation.
8 - Submit JCL/Execute REXX ===> SHOW
Db2 Data Defaults
Target Db2 Environment Area
Default SQLID
Specify the Db2 SQLID to be used during load and delete processing using this profile. If blank, SQLID defaults to USER.
SSID
Specify the Db2 subsystem ID of the target Db2 objects to be loaded using this profile.
Location
Specify the location of the target objects you want to load if they reside in a remote Db2 subsystem. The location you enter must be defined in the Db2 system catalog table, SYSIBM.LOCATIONS.
You may leave this field blank if the Db2 objects you want to load reside in the Db2 subsystem you specified in the SSID field.
Creator
Specify the authorization ID of the owner of the target Db2 objects that you want to load using this profile.
Index name prefix value
Specify the default prefix to be added to the index names in the target environment. Leave blank if you don’t want to specify a default prefix.
Index name suffix value
Specify the default suffix to be added to the index names in the target environment. Leave blank if you don’t want to specify a default suffix.
If an index were named XDEPT1, adding a prefix of T would make the new index name T_XDEPT1, adding a suffix of T would make it XDEPT1_T, adding both prefix and suffix would make it T_XDEPT1_T.
Db2 Load Method
Specify whether you want to load Db2 data using SQL INSERT statements or the Db2 Batch Load Utility. See also SQL Insert and Db2 Load Utility Load Options.
SQL
Perform the load using SQL INSERT statements. This option allows you to update rows if they already exist.
DB2
Perform the load using the Db2 Batch Load Utility.
Auto Create Defaults for DB2 Objects Area
When File-AID/RDX creates Db2 objects it uses the DDL as extracted. You can specify the following default values to override the extracted values.
Database
Specify the default Db2 database in which the new tables will reside. When loading an extract file created with a Release earlier than 4.0, the database must already exist in the target environment.
Tablespace
Specify the default tablespace in which the new tables will reside. Leave blank if the target tablespace name(s) should be the same as the source. When loading an extract file created with a Release earlier than 4.0, the tablespace must already exist in the database specified in the Database field above. See also Create/Edit Db2 Tablespace.
Implicit Tablespace
Specify whether Db2 should create an implicit tablespace for each table to be created. If set to Yes, it overrides the name specified in the Tablespace field above. Implicit tablespace request does not apply to tables that are extracted from multi-table or partitioned tablespaces.
STOGROUP
Specify the default target storage group for database, index, and tablespace creation.
Primary Quantity(K)
Specify the default number of storage units to be allocated for the file in which your tablespace or index is to reside.
Secondary Quantity(K)
Specify how much more space should be allocated for the file if it exceeds the primary quantity.
Freepage
Specify how often the system should leave a free page when the tablespace or index is updated.
Pctfree
Specify how much of each page to leave free when the tablespace or index is updated.
Buffer Pool
Specify the default Db2 buffer pool name associated with the target database, tablespace or index.
Space recalculation
Specify Yes if you want File-AID/RDX to calculate the space allocation for the new target Db2 objects based on the extracted data. The calculated space will not exceed the space allocation of the source.
When set to No the Db2 allocation parameters for the new object will be the same as for the source object.
Defaults for Load Method = SQL Insert
Existing DB2 Data Options Area
Delete all rows
Specify whether or not File-AID/RDX should delete ALL of the data residing in the target objects before it loads data from the extract file. For Db2 tables, Db2 delete rules are in effect.
Replace Matches
When you are adding data to an object that is not empty and the INSERT operation fails because the row or record already exists, specify whether or not it should be replaced. Only applies to SQL INSERT load option.
Processing Option Defaults Area
Lock During Load
Indicates whether or not tables will be locked during load. You cannot change the value in this field if File-AID/RDX was configured at installation to prevent users from locking tables. In this case, the values in this column will always be set to No.
Commit Every Nth Row
Specify the number of rows File-AID/RDX should insert or update before it performs a Db2 COMMIT. This value must be less than or equal to the value specified for the Max Commit Interval installation parameter.
Maximum Rows to Discard
Specify the maximum number of errors encountered before processing stops. Specify an asterisk (*) for no maximum or a value greater than 0. Specify 1 if you want processing to stop if any errors are encountered. Specify YES in the Save Discarded Rows field to save these rows for future use. The discard file need not exist to specify a value in this field.
Save Discarded Rows
Specify whether or not to save rows, or records, that could not be inserted or updated.
Defaults for Load Method = DB2 Load
Existing DB2 Data Options Area
Delete all rows
Specify whether or not File-AID/RDX should delete ALL of the data residing in the target objects before it loads data from the extract file. For Db2 tables, Db2 delete rules are in effect.
Processing Option Defaults Area
Log Option
Specify which log option to use during the execution of the Db2 LOAD utility for the Db2 objects.
1
Log Db2 logging will occur during the load process.
2
Image Copy Db2 logging of data will not occur during the load process. Db2 sets a COPY PENDING restriction against the tablespace being loaded. An IMAGECOPY step is generated to remove the COPY PENDING status.
3
Repair Db2 logging of data will not occur during the load process. Db2 sets a COPY PENDING restriction against the tablespace being loaded. A REPAIR step is generated to set NOCOPYPEND for the tablespace(s). To execute this utility, the privilege set of the process must include one of the following:
- REPAIR privilege for the database
- DBADM or DBCTRL authority for the database
- SYSCTRL or SYSADM authority.
4
Inline Image Copy When “Delete All” is also set to ‘YES’ this option will invoke inline image copy. Db2 logging of data will not occur during the load process. The tablespace into which the data is being loaded will not be placed into a copy pending state.
If there are multiple tables in a tablespace then inline image copy is not used; instead an IMAGECOPY step is generated to remove the COPY PENDING status.
MVS Data Defaults
Auto Create Defaults for MVS Objects Area
High level qualifier
Specify the default high level qualifier you want to use when creating MVS objects in the target environment.
File name suffix value
Specify the default file name suffix to be added when creating MVS objects in the target environment, e.g. FRSAMP.ORDERTAB becomes FRSAMP.ORDERTAB.NEW.
Space recalculation
Specify YES if you want File-AID/RDX to calculate the space allocation for the new target file based on the extracted data. The calculated space will not exceed the space allocation of the source.
When set to NO the MVS file allocation parameters for the new object will be the same as for the source file.
Storage Class
Specify the default storage class for the target files.
Management Class
Specify the default management class for the target files.
Existing Data Options for MVS Objects Area
Delete/Define
Specify whether or not File-AID/RDX should delete the target file and then redefine it before it loads data from the extract file.
Yes
File-AID/RDX generates a step in the JCL to delete the object and then create it again before loading data.
No
Appends data to the existing target object.
Replace Matches
When you are adding data to an object that is not empty and the INSERT operation fails because the row or record already exists, specify whether or not it should be replaced. Only applies if the target object is indexed.
Objects with Zero Rows Extracted Area
Generate control datasets
Specify whether or not File-AID/RDX should create Load Control Table (LCT) data sets and SORT data sets for objects which have zero rows extracted. By default Load will not process objects with zero rows extracted.
Yes
File-AID/RDX generates LCT and SORT data sets and associated JCL steps for objects with zero rows extracted.
No
Do not generate these data sets and JCL steps.
Panel Customization
The profile also stores information on what panels will be part of the online load specification process, allowing you to customize the flow through the load panels.
Load Panel Flow Options
First load panel
Specify which panel displays first when selecting Option 3 Load from the File-AID/RDX Primary Option Menu.
R
Recently Referenced List (default)
F
Saved Request File
Display Load Menu
YES will display the Load Menu, NO will bypass the display of the Load Menu and go directly to the first FLOW panel. When set to No, you must set at least one Load Menu option to FLOW.
Load Menu contents
For each of the Load Menu options you can specify whether the menu option will be displayed, locked or its selection automatically included in the load panel flow.
Place the cursor on value in each field and press TOGGLE to change the value.
The toggle values are:
SHOW
Include on load menu.
LOCK
Lock menu choice.
FLOW
Include on load menu and pre-select the option for flow mode navigation. When Display Load Menu is set to No, you must set at least one Load Menu option to FLOW.