Display LOCATION column in RC/Query Alias list

Products

• RC/Query for DB2 for z/OS

Issue/Introduction

Display the LOCATION column on the RC/Query Alias List screen when generating an Alias List (DB2 Object = A, Option = L).

Environment

Release: R20
Component: RCQ

Cause

Resolution

The LOCATION column displays the Location name of the object for the Alias defined on a remote object. This column can be displayed by performing one of the following options:

1. QUALIFYON or QUALIFYOFF primary command
   
   

   The QUALIFYON (or QO) command turns on the optional creator columns.  For the object dependency reports, it turns on the object creator columns.

   For other reports, it turns on the CREATEDBY and BOUNDBY columns.

   The QUALIFYON and QUALIFYOFF commands are active only for the current report.  You can change the default value of the Qualify feature on the RC/QUERY Profile Variables screen.

   RQAL          --------------- RC/Q Alias List --------------- yyyy/mm/dd hh:mm
   COMMAND ===>QUALIFYON                                         SCROLL ===> CSR
   
    DB2 Object ===> A                       Option  ===> L    Where => N
    Alias Name ===> *                     > Creator ===> authid1                >
     Qualifier ===> *                     > N/A     ===> *                      >
   Loc: LOCAL ---------- SSID: ssid ----------authid1 -      LINE 001 OF 123    >
   CMD      NAME                CREATOR   REF_NAME            REF_CREATOR
   ________ IPLIST              authid1   IPLIST              SYSIBM
   ________ IPNAMES             authid1   IPNAMES             SYSIBM
   ________ LOCATIONS           authid1   LOCATIONS           SYSIBM
   ________ LULIST              authid1   LULIST              SYSIBM
   ________ LUMODES             authid1   LUMODES             SYSIBM
   ________ LUNAMES             authid1   LUNAMES             SYSIBM
   ________ MODESELECT          authid1   MODESELECT          SYSIBM

   This field is not shown when the QUALIFYOFF primary command is issued. The QUALIFYOFF (or QF) command turns off the optional creator columns.
   For the object dependency reports, it turns off the object creator columns. This command is active only for the current report.

   *** Note that the QUALIFYON and QUALIFYOFF command affects different columns in other report types.

2. PROFILE primary command
   
   This field is shown when issuing the PROFILE primary command and selecting Option 2 - RC/Q Profile Variables. The QUALIFIERS processing option controls the display of the optional creator columns. For the object dependency reports, it turns on or off the display of the object creator columns. Setting this parameter to
   'Y' will display the LOCATION column. Use of this option has no correlation to the QUALIFYON or QUALIFYOFF command.
   
   *** The user should be aware that the PROFILE QUALIFIERS option
   *** affects different columns in other report types.
   
   

            ----------------- RC/QUERY Profile Variables ----------------
   COMMAND ===>
   
   
   PRINT PARAMETERS:     (For Printing Query Report being viewed)
     PRINT SQL PAGE      ==> N   (Y/N; SQL Page N/A if Printline Size < 41)
   
   PROCESSING OPTIONS:   (For Query Reports)
     VIEW LEVELS         ==> ALL          - For Object Dependency Report.
     QUALIFIERS          ==> Y    (Y/N)   - For Obj. Dep. and some Ver. 2.1 cols.
     MAX LINES           ==> ALL          - For List and Detail reports.
     FULL DETAIL         ==> Y    (Y/N)   - For reports based on multiple tables.
     OMIT ORDER BY       ==> N    (Y/N)   - For List and Detail reports.
     UTILITIES           ==> N    (Y/N)   - To use our Utilities.
     SAVED REPORTS       ==> Y    (Y/N)   - To use customized reports.
     MATCHCASE           ==> ON   (ON,    - Enables matchcase.
                                   OFF,   - Disables matchcase. ( SQL Intensive )
                                   CAPS)  - Force object names to uppercase.
     CAPNATS             ==> N    (Y/N)   - Capitalize National Characters.
     ALL LOCATIONS       ==> Y    (Y/N)   - For searches in Plan/Package Report.
     UNDERSCORE WILDCARD ==> ON   (ON/OFF)- To process underscore as wildcard.
     SHOW/HIDE OPTIONS   ==> OFF  (ON/OFF)- To show or hide options/notifications.
     PREFILL COMMAND     ==> Y    (Y/N)   - Prefill command line for utility.
     ISOLATION LEVEL     ==> UR   (Blank  - Global Level ISOLATION value.
                                   CS,    - Cursor Stability.
                                   UR)    - Uncommitted Read.
     UTILITY OBJECT      ==> 1            - Number of objects per step in
     COUNT IN 1 STEP                        utility processing JCL.

   OUTPUT RESULT:
   
   RQAL          --------------- RC/Q Alias List --------------- yyyy/mm/dd hh:mm
   COMMAND ===>                                                  SCROLL ===> CSR
   
    DB2 Object ===> A                       Option  ===> L    Where => N
    Alias Name ===> *                     > Creator ===> authid1                >
     Qualifier ===> *                     > N/A     ===> *                      >
   Loc: LOCAL ---------- SSID: ssid ----------authid1 -      LINE 001 OF 123    >
   CMD      NAME                CREATOR   LOCATION          REF_NAME
   ________ IPLIST              authid1   SSIDLOC1          IPLIST
   ________ IPNAMES             authid1   SSIDLOC1          IPNAMES
   ________ LOCATIONS           authid1   SSIDLOC1          LOCATIONS
   ________ LULIST              authid1   SSIDLOC1          LULIST
   ________ LUMODES             authid1   SSIDLOC1          LUMODES
   ________ LUNAMES             authid1   SSIDLOC1          LUNAMES
   ________ MODESELECT          authid1   SSIDLOC1          MODESELECT

Additional Information

Alias Reports

Configure Your Product Profile