This site will undergo a maintenance outage on Saturday, 13 September beginning at 2:30 AM Central/1 PM IST for a platform upgrade. The downtime will be ~three hours.

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.

When should I use a space announcement banner?

Use the space organization announcement after you change the content from a book-like organization (such as User Manual, Configuration Manual, and Administration Guide) to the product model.

Use the latest version announcement to push traffic to later versions. You do not need to add this to every previous version, but if you have a specific reason that you want users to be aware—for example, Google searches show content for an obsolete version—use the banner to help users find a relevant version.

When an announcement is no longer needed, remove the BMC Space Banner macro.

Space announcement This documentation space provides the same content as before, but the organization of the content has changed. The content is now organized based on logical branches instead of legacy book titles. We hope that the new structure will help you quickly find the content that you need.

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

 File-AID/RDX ------------------  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/
Resumption, and 12, Save Extract Request. Leave slash in front of option 5, Selection Criteria.

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.
Current Values displays Layouts=n, Xref=n, Topaz Visualizer File=n, where n is either N or Y.

Important

Creating a Topaz Extract Visualizer file requires batch extract execution; interactive (online) extract execution is not available.

10 - Checkpoint/
Resumption

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.
Current Values displays None or Checkpoint/Resumption Enabled.

Important

  1. Option “10- Checkpoint/Resumption” is not available for interactive (online) extract execution (see also  MODE).
  2. Option “10- Checkpoint/Resumption” is not available when the extract request includes the “Continue With Load” option (see also 11 - Continue with load).
  3. Option “10- Checkpoint/Resumption” is not available when the extract request includes multiple selection criteria sets (see also 5 - Selection Criteria).
  4. When specifying both “Checkpoint/Resumption” and “Data Privacy Specification”, you must save the Extract Request before submitting it. You must use the same Extract Request file for the Extract Checkpoint and Extract Resumption jobs. The pre-disguise extract file generated during the extract with Data Privacy process 'hlq.EXTRACT.Dyymmdd.Thhmmss’ must also be retained when “Checkpoint/Resumption” is specified; it will only be deleted after the resumption completed the whole extract process and retention is not specified (see also Retain pre-disguise file).

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.
Current Values displays Yes or No.

Important

  1. If the current value is set to Yes, but you no longer want your extract to continue with load, simply type No over the Yes and press Enter. The current value changes to No and is display only again.
  2. Continue with Load is not available for interactive (online) extract execution.
  3. Continue with Load is not available for Option “10- Checkpoint/Resumption”.
  4. Continue with Load is not available for a Db2 single table extract with selective column / delimited extract file format.
  5. The ALL primary command does not select the Continue With Load option.

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.
Current Values displays NO or the name of the extract request file.

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.
Current Values displays the status Unavailable when some required items for the extract request are still missing or incomplete. Revisit some or all extract menu options and provide acceptable extract criteria.

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.
Current Values displays the status Unavailable when some required items for the extract request are still missing or incomplete. Revisit some or all extract menu options and provide acceptable extract criteria.

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.

Important

  1. INTERACTIVE (online) extract is an installation option and is only available if specifically installed at your site.
  2. The following options are not available for interactive execution:
    1. “Checkpoint/Resumption” (see here).
    2. “Continue with Load” (see Continue).
    3. “Extract from Image Copy” (see Extract from image copy).
    4. “Disguise Extract File” (see Disguise).
  3. If the extract file is a GDS, it must already exist, therefore (0) or (-n) are valid while (+n) is not allowed.

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:

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*