NEW - DB2 object filter


The NEW - Db2 Object Filter screen shown in the following figure is displayed when you:

Use this screen to specify a Db2 object filter to add Db2 objects to your initial object list.

NEW - DB2 Object Filter

 File-AID/RDX -------------  NEW - DB2 Object Filter  --------------------------
-----
 Command ===>                                              

 Primary commands: MVS object filter

 DB2 Objects Filter:
   SSID         ===> DSN
   Location     ===>                      (* or pattern for selection list)
   Creator      ===> FRSAMP               (* or pattern for selection list)
   Table Name   ===> *                    (* or pattern for selection list)

 Object List Content:
   Object source     ===> R        (C = MVS Catalog; R = Relationship File)
   Relationship File . .: FRSAMP.RELATION 

After entering the information for the new Db2 object filter, press ENTER to proceed to the ObjectIn Preview.

DB2 Objects Filter Area

Use the fields in this area to specify the Db2 objects to be included in your initial object list for specifying disguise criteria. When specifying patterns in the fields, File-AID/RDX searches the Db2 catalog and/or the relationship file to find matches.

SSID

Displays the current Db2 subsystem ID. Type over this field to connect to a new Db2 subsystem. If you leave the Location field blank, the objects you specify must exist in the Db2 subsystem displayed here.

Location

Specify the location of the objects you want to include in the object list if it resides in a remote Db2 subsystem. The location you enter must be defined in the Db2 system catalog table, SYSIBM.LOCATIONS.

Leave this field blank if the objects you want included are in the Db2 subsystem in the SSID field.

Creator

Specify the authorization ID of the owner of the objects that you want to include in the object list. Enter a pattern in this field if you want to include objects from more than one creator. Valid pattern characters are %, _, and * (see  Pattern Characters ).

Table Name

Specify a pattern for the object names you want to include in the object list. Valid pattern characters are %, _, and * (see  Pattern Characters ).

Object List Content

This section provides information about the following fields:

Object Source

Specify whether to search for matching objects to be added to the initial object list in the relationship file or in the Db2 catalog.

C

Catalog. File-AID/RDX searches the Db2 catalog to find matching objects.

R

Relationship. File-AID/RDX searches only the relationship file to find matching objects.

Relationship File

Specify the name of the file that contains the referential integrity and application relationship information you want to use for the object list. In the object list, File-AID/RDX identifies related objects based only on the relationship definition found in the relationship file.

Primary Command

The following File-AID/RDX-specific primary command is valid on this screen:

MVS (M)

Switches to the NEW - MVS Object Filter panel prefilled with the applicable information from your profile.

 

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

BMC AMI DevX File-AID/RDX 23.01