Display Example: DBOC INQ=1.???,10.???

DBOC/DBIC: Monitoring Local Resources with Operational Commands › INQ=urt.table: Displaying Table-Level Options for URTs › Display Example: DBOC INQ=1.???,10.???

Display Example: DBOC INQ=1.???,10.???

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.

DBOC INQ=1.???,10.??? DELIM & (1) (2) (3) (4) (5) (6) (7) (8) URT 0001(STD OPEN AUTO ) ACTIVE=000 RESRVD=000 PRTY=07 TXNUD 0001 TABLE:PAY DBID:00001 UPDATE SYNONYM 0001 TABLE:PMF DBID:00001 UPDATE SYNONYM 0001 TABLE:POH DBID:00001 UPDATE SYNONYM 0001 TABLE:POL DBID:00001 UPDATE SYNONYM 0001 TABLE:PNC DBID:00001 UPDATE SYNONYM 0001 TABLE:PNM DBID:00001 UPDATE SYNONYM URT 0010(STD CLOSED AUTO ) PRTY=07 TXNUD=NO 0010 TABLE:ACT DBID:00010 UPDATE SYNONYM 0010 TABLE:CUS DBID:00010 UPDATE SYNONYM 0010 TABLE:DTL DBID:00010 UPDATE SYNONYM 0010 TABLE:ORD DBID:00010 UPDATE SYNONYM 0010 TABLE:ITM DBID:00010 UPDATE SYNONYM 0010 TABLE:NUM DBID:00010 UPDATE SYNONYM 0010 TABLE:RCP DBID:00010 UPDATE SYNONYM 0010 TABLE:SAL DBID:00010 UPDATE SYNONYM 0010 TABLE:SHP DBID:00010 UPDATE SYNONYM DC00380I TRANSACTION COMPLETED.

Field Descriptions

When you specify a table, CA Datacom CICS Services displays both the status of the URT listing the specified table (as described in Field Descriptions) and the status of the table itself, using the following status designators:

Field	Value	Description
(1)	nnnn	URT suffix specified or allowed by the entered command (see the System Reference Guide descriptions of the MAXURTS= and PREFIX= parameters for details about the nnnn 4-digit suffix).
(2)	TABLE: aaa	Value aaa is a CA Datacom/DB table defined in the corresponding URT, as allowed by the entered command. Table names appear in the order entered in the URT.
(3)	DBID: nnnnn	Value nnnnn is the CA Datacom/DB database ID for the corresponding table, as allowed by the entered command.
(4)	UPDATE	Indicates that this URT permits applications to update the named table.
(4)	UPDATE=NO	Indicates that update of the named table is not permitted using this URT.
(5)	SYNONYM	SYNONYM=YES is specified in the DBURTBL macro for this URT. All requests for this table must include the DBID in the Request Area.
(6)	BYPOPEN	Indicates that this table has been disabled either because BYPOPEN=YES was coded in its URT definition, a DBOC DISABLE=urt.tbl command has been processed, or the BYPOPEN value has been overridden on the DBEC I,TBL(nnnn) display. 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. Note: A blank in this field indicates that either BYPOPEN=NO (the default) was used in the corresponding URT definition for this table, that the table was enabled through the DBOC ENABLE= transaction (see ENABLE= Enabling Opening for Previously Bypassed Table), or that the table was enabled by overriding the BYOPEN value on the DBEC I,TBL(nnnn) display (see Overriding DBURTBL Parameter Values).
(7)	AUTODXC=NO	For this table, AUTODXC=NO was coded in the corresponding URT. Exclusive control for this table is not automatically dropped when a second command is issued from the same Request Area. A blank in this field indicates AUTODXC=YES.
(8)	ECWAIT=	Wait time for held record. An ECWAIT= value between 0001 and 7200 indicates exclusive control wait time (in seconds) as specified in the TIMEMIN= or TIMESEC= DBURSTR parameters. ECWAIT=0000 (or no value) means there is no limit on the time a task may wait for a record held under exclusive control.