Writer instructions | ||
Purpose | Use this page to display a banner announcement on each page of the space. Create the Space announcements page in the master space, outside of the Home branch. You can version the Space announcements page to enable different banners to be published into different target spaces, however, the banner that is displayed in the versioned (master) space itself only displays the most recently-published banner. If you find errors in the banner area of your versioned space and you are sure the Space announcements page is set up correctly, try publishing the page to the same space. For more information, see Space-announcements-banners. | |
Removing | When an announcement is no longer needed, remove the BMC Space Banner macro. | |
Translation | Localized spaces using the L10n Viewport theme must change the name of this page to Space announcements l10n. See Configuring-the-Scroll-ViewPort-theme-for-translated-spaces. | |
Usage | Choose one or none of the following BMC Space Banner macros. If your space requires another kind of announcement, you can use this page in coordination with your team lead and editors. | |
Step 8—Editing The profile’s load defaults
The Load Defaults Screen shown in the following figure is displayed when you select Option 3 from the RDX Profile Screen or you exit from Extract Defaults Screen in flow through mode. Use this screen to specify the load defaults for the current profile.
Load Defaults screen
COMMAND ===> TSOID01 Profile: FRSAMPQK
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 Enironment:
Default SQLID: ===> USER
SSID ===> DSN
Location ===>
Creator ===> TSOID01
Index name prefix value ===>
Index name suffix value ===> X
DB2 Load Method ===> SQL (DB2 OR SQL)
Auto Create Defaults for DB2 Objects:
Database ===>
Tablespace ===>
Implicit tablespace ===> Y (Y = Yes; N = No)
STOGROUP ===>
To modify the load defaults: | |
|---|---|
In this field… | Do the following: |
Default SQLID | Type USER or the SQLID you want to use when loading or deleting Db2 data. |
SSID | Type the ID of the Db2 subsystem you will use with this profile during training. |
Location | Leave blank, unless your File-AID/RDX FRSAMP training data will be loaded to a remote Db2 location. |
Creator | Type your creator ID to identify where the File-AID/RDX FRSAMP training data will be loaded during training. |
Index name prefix value | Leave blank. If you specify a value, any Db2 index created during the load will have this prefix by default. |
Index name suffix value | Type X. Unless changed during the load specification, all Db2 indexes created during the load with this profile will have this suffix, for example XDEPT1_X. |
DB2 Load Method | Type SQL. |
Database | Leave blank. |
Tablespace | Leave blank. |
Implicit tablespace | Type Y. |
STOGROUP | Leave blank. |
Press DOWN (PF8) | File-AID/RDX will scroll the display so you can edit more Load Defaults. |
Field Names and Descriptions
The following list describes the fields on this screen.
FIELD | DESCRIPTION |
|---|---|
Default SQLID | Specify the Db2 SQLID to be used during load or 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 is in the Db2 subsystem in the Db2 Subsystem 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 which prefix to add to the index names in the target environment. |
Index name suffix value | Specify which suffix to add to the index names in the target environment. 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 IBM Db2 Batch Load Utility. 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 IBM Db2 Batch Load Utility. |
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. Leave blank if the target database name should be the same as the source. |
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. |
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. |
STOGROUP | Specify the default target storage group for database, index, and tablespace creation. |
Step 8—Load Defaults Continued
The Load Defaults Screen shown in the following figure is displayed when you press DOWN on the screen as shown in Load Defaults Screen. Continue to specify the load defaults for the current profile.
Load Defaults Screen
COMMAND ===> TSOID01 Profile: FRSAMPQK
More: - +
STOGROUP ===>
Primary Quantity(K) ===> 20
Secondary Quantity(K) ===> 15
Freepage ===> 10
Pctfree ===> 10
Buffer Pool ===> BP0
Space recalculation ===> Y (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) LOCKED
Commit Every Nth Row ===> 200 (1 - 2002)
Maximum Rows to Discard ===> * (* for no maximum)
Save Discarded Rows ===> Y (Y = Yes; N = No)
....................Defaults for Load Method = DB2 Load........................
Existing Data Option:
To modify the load defaults: | |
|---|---|
In this field… | Do the following: |
Primary Quantity(K) | Type 20. |
Secondary Quantity(K) | Type 15. |
Freepage | Type 10. |
Pctfree | Type 10. |
Buffer Pool | Type BP0. |
Space recalculation | Type Y. |
Delete all rows | Type N. |
Replace matches | Type Y. |
Lock during load | Type N. |
Commit Every Nth Row | Type 200. |
Maximum Rows to Discard | Set to * for the training session. |
Save Discarded Rows | Type Y. |
Press DOWN (PF8) | File-AID/RDX will scroll the display so you can edit more Load Defaults. |
Field Names and Descriptions
The following list describes the fields on this screen.
FIELD | DESCRIPTION |
|---|---|
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 the default secondary quantity to indicate 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. |
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. |
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. |
Step 8—Load Defaults Continued
The Load Defaults Screen shown in the following figure is displayed when you press DOWN on the screen as shown in Load Defaults Screen. Continue to specify the load defaults for the current profile.
Load Defaults Screen
COMMAND ===> TSOID01 Profile: FRSAMPQK
More: - +
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 ===> TSOID01
File name suffix value ===> NEW
Space recalculation ===> Y (Y = Yes; N = No)
Storage Class ===>
Management Class ===>
Existing Data Options for MVS Objects:
Delete and Define ===> N (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)
To modify the load defaults: | |
|---|---|
In this field… | Do the following: |
Delete all rows | Type Y. |
Log Option | Type 1 to select the Db2 log option. |
High level qualifier | Type your user ID. |
File name suffix value | Type NEW. Unless changed during the load specification, all MVS objects created during the load with this profile will have this suffix, for example ORDERTAB.NEW. |
Space recalculation | Type Y. |
Storage Class | Leave blank. |
Management Class | Leave blank. |
Delete and Define | Type N. Press PF4 (TOGGLE) to lock this field from being changed during the online load specification. |
Replace Matches | Type Y. |
Press DOWN (PF8) | File-AID/RDX will scroll the display so you can edit more Load Defaults. |
Field Names and Descriptions
The following list describes the fields on this screen.
FIELD | DESCRIPTION |
|---|---|
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. |
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:
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. |
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, for example 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. |
Delete and 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. |
Step 8—Load Defaults Continued
The Load Defaults Screen shown in the following figure is displayed when you press DOWN on the screen as shown in Load Defaults Screen. Continue to specify the load defaults for the current profile.
Load Defaults Screen
COMMAND ===> TSOID01 Profile: FRSAMPQK
More: -
--------------------- 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;
F = Saved Request File)
Display Load Menu ===> Y (Y = display Load Menu
N = display first FLOW panel)
Load Menu Contents:
1 - Load Object Specification ===> SHOW Place the cursor on value and
2 - Source to Target Mapping ===> SHOW press TOGGLE to change value.
3 - Auto Create ===> SHOW SHOW = Include on extract menu.
4 - Existing Data Options ===> SHOW LOCK = Hide menu choice.
5 - Processing Options ===> SHOW FLOW = Include on extract menu
6 - Save Load Request ===> SHOW and pre-select the option
7 - View JCL ===> SHOW for flow mode navigation.
8 - Submit JCL ===> SHOW
To modify the load defaults: | |
|---|---|
In this field… | Do the following: |
Generate control datasets | Type N to NOT create Load Control Table (LCT) data sets and SORT data sets for objects which have zero rows extracted. |
First load panel | Type R to select the Load Reference List as the first load panel with this profile. |
Display Load Menu | Type Y to display the Load Menu. |
Load Menu contents | Leave all fields as SHOW. Use the TOGGLE key (PF4) to change the settings, if necessary. |
Press END (PF3) | File-AID/RDX will display the Disguise Defaults for you to edit the profile’s Disguise settings. |
Field Names and Descriptions
The following list describes the fields on this screen.
FIELD | DESCRIPTION |
|---|---|
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. Y File-AID/RDX generates LCT and SORT data sets and associated JCL steps for objects with zero rows extracted. N (default) Do not generate these data sets and JCL steps. |
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. |
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 (PF4) 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. |