When inquiries are made at the table level, the display includes the number and status of each URT, similar to the URT status inquiry display. In addition, the table names and database IDs are displayed for each URT.
SYSID = CXDS CA Datacom CICS Services APPLID = A31ICXDS DBEX I,TBL(1),SYSID(*) SYS URT TYP STATUS TABLE DBID UPD BYP SYN AUT DBIDM SIDNAME MUF *LOC 0001 STD UNOPENED PAY 00001 YES NO YES YES DBSIDPR 01 PMF 00001 YES NO YES YES POH 00001 YES NO YES YES POL 00001 YES NO YES YES PNC 00001 YES NO YES YES PNM 00001 YES NO YES YES CBR2 0001 LINK TO SYSTEM IS OUT OF SERVICE CBR3 0001 LINK TO SYSTEM IS OUT OF SERVICE CCR2 0001 CICS SERVICE NOT INSTALLED CCR3 0001 STD OPEN PAY 00001 YES NO YES YES MUFW 01 PMF 00001 YES NO YES YES POH 00001 YES NO YES YES POL 00001 YES NO YES YES PNC 00001 YES NO YES YES CIDS 0001 STD OPEN PAY 00001 YES NO YES YES DBSIDPR 01 PMF 00001 YES NO YES YES POH 00001 YES NO YES YES POL 00001 YES NO YES YES PF3: RETURN PF7: BACKWARD PF8: FORWARD
When you specify TBL rather than URT in the command format, CA Datacom CICS Services presents a scrollable display containing thirteen columns of data. The first four columns and the last two columns repeat the SYS, URT, TYP, STATUS, SIDNAME, and MUF data which is displayed on the corresponding URT-Level inquiry. Data appears in these fields only once per URT. The remaining seven columns display information on the tables making up the URT definition.
Identifies the CICS system to which this display line refers. *LOC means local CICS or TOR.
Identifies the sequence number of the URT.
Indicates the type of URT.
URT for applications issuing CA Datacom/DB commands.
URT for applications issuing SQL statements.
URT dynamically built by another CA product.
Indicates the OPEN status of the URT with the following values:
Not yet opened by a program call or a DBEC or DBOC transaction.
Explicitly closed with a DBEC or DBOC CLOSE=.
Close requested by DBEC or DBOC CLOSE= command, but not yet closed pending completion of a read in progress or a transaction having exclusive control.
Opened by CA Datacom CICS Services but no transaction to close it has been issued.
Open requested by DBEC or DBOC OPEN= command, but not yet opened pending completion of the request in progress in the MUF or a connect to the MUF.
Name of the CA Datacom/DB table within the URT.
Number of the database which contains the table (as seen in the application request).
Specifies whether table updates are permitted using this URT.
Indicates that this URT permits applications to update the named table.
Indicates that update of the named table is not permitted using this URT.
Specifies whether the designated table is bypassed when the URT is opened.
When the URT is opened, the designated table is bypassed from the opening. Any attempt to access this table, using this URT, results in a CA Datacom/DB return code of 05.
When the URT is opened, the designated table is opened during the opening.
Identifies SYNONYM=.
Indicates that SYNONYM=YES is specified in the DBURTBL macro for this URT.
Indicates that SYNONYM=NO is specified in the DBURTBL macro for this URT.
Specifies whether exclusive control for a table is automatically dropped.
Indicates that CA Datacom/DB does not automatically drop exclusive control for this table when a second command is issued from the same Request Area.
Indicates that CA Datacom/DB automatically drops exclusive control for this table when a second command is issued from the same Request Area.
For a global URT using DBID remapping, this is the number of the database that contains the table to be accessed in the MUF and overrides the DBID specified in the request.
The name of the CA Datacom/DB DBSIDPR module associated with the MUF, as specified in the DBCSID macro or, in a single MUF environment, the name DBSIDPR.
The number of the MUF that contains the tables for this URT. In a single MUF environment, this number is always one.
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|