Display the LOCATION column on the RC/Query Alias List screen when generating an Alias List (DB2 Object = A, Option = L).
Release: R20
Component: RCQ
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:
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.
----------------- 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