Display LOCATION column in RC/Query Alias list
search cancel

Display LOCATION column in RC/Query Alias list

book

Article ID: 63589

calendar_today

Updated On:

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