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 7—Adding an unrelated object
File-AID/RDX allows you to add Db2 and MVS objects to the list of objects to extract data from, even when they are not related to any of the related objects.
You use Option 3, Unrelated Objects, from Extract Menu to specify the unrelated Db2 and MVS objects to be included in the extract and Option 10, Checkpoint/Resumption to identify where the batch execution of the extract should be stopped in a controlled manner.
Extract Menu
Option ===> Scroll ===> CSR
TSOID01 Profile: SAMPMENU
Primary commands: menu-number, ALL, REFerence, REQuest, MODE SSID: DSN
Line commands: S or / to create flow through selected options.
Description ===> DB2-FRSAMP.ORDER_TABLE WITH PROFILE SAMPMENU
Current Values
1 Driving Object DB2-FRSAMP.ORDER_TABLE
2 Extract Scope and Dir=Y, Par=Y, Sib=N, Ind=Y, Cycles=*
Detailed Extract Views 9 of 12 Relationships Active
S 3 Unrelated Objects None
_ 4 Input Key File None
/ 5 Selection Criteria Specified for Driving Object
6 Output Key File There are no KEY Relationships defined
S 7 Extract File TSOID01.FRSAMP.EXTMENU
_ 8 Data Privacy DISGUISED DCF: TSOID01.FRSAMP.DISGUISE
_ 9 Supporting Files Layouts=Y, Xref=Y, Topaz Visualizer File=Y
S 10 Checkpoint/Resumption None
11 Continue with load No
S 12 Save Extract Request TSOID01.FRSAMP.EXTCRIT(EXTMENU)
_ 13 View JCL
_ 14 Submit JCL
To add unrelated objects to the extract request: | |
---|---|
In this field… | Do the following: |
Option Selection | Blank out the slashes in front of options 1, Driving Object, and 2, Extract Scope. Type an S or / in front of options 3, Unrelated Objects, 7, Extract File, 10, Checkpoint/ |
Press Enter | File-AID/RDX proceeds to the Unrelated Object Definition screen. |
Field Names and Descriptions
The following list describes all of the fields on this screen.
FIELD | DESCRIPTION | |
---|---|---|
USER Profile or SITE Profile | Displays the name of the current profile that provides the profile settings for this extract request. To change the profile, return to the “Primary Option Menu”. | |
SSID | Displays the current Db2 subsystem ID you are connected to. Only displays when File-AID/RDX is installed with the Db2 option and the current extract request includes one or more Db2 object. | |
Description | Displays a short description for the current extract request. If you are modifying a previous request it is prefilled. When creating a new request, File-AID/RDX fills this description field with the name and object type of the driving object. Using this description is a helpful way to document your extract criteria. To change the description select Option 12, Save Extract Request. |
Menu Options
Enter the option number (1 - 14) to select the desired option or enter ALL to step through all options in sequence. Alternatively, you may also select one or more options with the S or / line command.
The Current Values column are display fields only and are updated upon return from each of the extract menu options to reflect the current status and value for the option. A status of Attention is displayed when the option requires further attention, before the extract can be submitted.
The following lists the options you can select from this screen.
OPTION | DESCRIPTION |
---|---|
1 - Driving Object | Displays either the “DB2 Driving Object” or “MVS Driving Object” panel depending on the driving object’s object type. The MVS panel also includes layout and XREF information. Current Values shows the full name of driving object for this extract request. |
2 - Extract Scope and Detailed Extract Views | Displays the Extract Scope panel where you specify global navigation and sampling controls. From this panel you access the Extract Scope Detailed View panels where you can specify the navigation and sampling controls for individual objects and relationships from the extract. Current Values shows the settings of the global navigation controls, the global Cycles sampling control, how many of the driving object’s relationships are active (included) for the extract, and that an extract from Db2 Image Copy has been requested. |
3 - Unrelated Objects | Displays the Unrelated Object Definition panel when unrelated objects have yet to be added for the extract request or the Unrelated Object Specification panel when unrelated objects are already part of the extract request. Current Values displays the number of unrelated Db2 or MVS objects in the request. |
4 - Input Key File | Displays the Input Key File Specification panel where you can identify whether the extract uses a key file as selection criteria input for the driving object. The driving object can be a Db2 or MVS object. Input Key File used to be called External Key File in previous releases. Current Values displays None or the name of the Input Key file. |
5 - Selection Criteria | Displays the Object Selection Criteria panel where you can specify selection criteria for any of the objects included in the extract request. Current Values displays None or Specified (but not) for Driving Object, Delimited, Selective Columns. |
6 - Output Key Files | If the extract request includes relationships to an Output Key file, File-AID/RDX displays the Output Key File Definition panel where you specify the Output Key file for each KEY relationship. If the Output Key files are for IMS data, you can also specify that the BMC Compuware File-AID for IMS extract using the Output Key files is to be executed as a step following the File-AID/RDX extract. Current Values displays the message “There are no Output Key files defined”, or “n of n Key Files“ or “n of n Key Files - Execute n IMS Extract”. |
7 - Extract File | Specify the output file for your extract request on the Extract File Specification panel. File-AID/RDX will store all extracted records in this file and create its corresponding extract summary file. Current Values displays the name of the extract file. |
8 - Data Privacy | Select the Data Privacy option in the “Data Privacy Specification” screen, if you also want the extracted data disguised by applying the disguise criteria rules as defined in the DCF: Disguise Control File or the DPR: Dynamic Privacy Rules Project. Current Values displays None, the name of the DCF: Disguise Control File, or the DPR: Dynamic Privacy Rules Project. The DISGUISED indicator is displayed when data in the extract file is to be disguised. |
9 - Supporting Files | Optionally, you can request in the “Supporting File Specification” screen that File-AID/RDX creates a record layout file for all Db2 objects included in the extract, a BMC Compuware File-AID/MVS XREF for the extract file, and/or a Topaz Extract Visualizer file. |
10 - Checkpoint/ | Specify whether you want to enable Checkpoint/Resumption for your extract request. With Checkpoint/Resumption Enabled you can stop and resume the extract after a specified extract step number, a specified time interval, or a z/OS Operator command. When you select this option, File-AID/RDX presents the “Checkpoint/Resumption” panel where you identify your checkpoint options and data sets. Use this functionality when you anticipate a long running extract that might not be completed within your site’s constraints or when you want to tune highly complex extracts. After you submit an extract request with Checkpoint/resumption Enabled and the extract completed up to the checkpoint, the extract is ready to be continued. When submitting the extract request again, File-AID/RDX prompts you to continue the extract execution from the checkpoint or cancel the resumption. If you don’t resume the extract, the partial extract file is NOT USABLE as it lacks important trailer records. |
11 - Continue with load | Specify whether extract request should be a combined extract and load (YES) or just an extract. When YES, File-AID/RDX presents the Continue with Load Menu where you identify all your load options and parameters. |
12 - Save Extract Request | Specify whether to save this extract request in a file. File-AID/RDX presents the Save Extract Request panel where you identify the extract request file to save your request to. Once you save your extract request it will be added to the “Extract Reference List” at that time. |
13 - View JCL | Select this option to view the JCL for this extract request. File-AID/RDX shows the Generated JCL panel where you review and modify the extract JCL. |
14 - Submit JCL | Submits the JCL for this extract request. Watch for the message that the job has been submitted and later for the completion message. |
Primary Commands
The following list identifies the primary commands that are available from this screen. For details on each command, see File-AID/Related Data XPERT Reference.
COMMAND | DESCRIPTION |
---|---|
ALL | Selects all available extract menu options for you to step through in sequence. ALL does not include option 14 - Submit JCL. To submit the extract JCL, select option “14 - Submit JCL separately or enter the SUBMIT command in the View JCL panel. |
MODE | Enter the MODE command in the Command field to execute the extract request online. Extract Menu options 13 - View JCL and 14 - Submit JCL will change to “13 - View REXX” and “14 - Execute REXX” to show that the extract will be executed online when selecting Option “14 - Execute REXX”. MODE acts as a toggle switch. |
REFERENCE (REF) | Returns to your extract reference list to start a new extract request. |
REQUEST (REQ) | Returns to a saved extract request file. You also use the REQUEST command to open extract criteria files created with File-AID/RDX prior to Release 3.0. |
Line Commands
The following list identifies the line commands that are available from this screen. For details on each command, see File-AID/Related Data XPERT Reference.
COMMAND | DESCRIPTION |
---|---|
S | Selects a menu option. |
/ | Selects a menu option. |
This section provides information about the following topics: