Previous Topic: Command ExamplesNext Topic: Displaying Table-Level Processing Options


Display Example: DBEX I,URT(00??),SYSID(CVDS)

SYSID = CYDS CA Datacom CICS Services APPLID = A31ICYDS DBEX I,URT(00??),SYSID(CVDS) A SYS URT TYP STATUS W REL CBSIO PR U MIN SEC CONDITIONS SIDNAME MUF CVDS 0001 STD UNOPENED A 100 000000 07 Y 000 000 DBDVM5 01 CVDS 0002 STD OPENED P 100 000000 07 Y 000 000 ACT=000 RES=000 DBDVM5 01 CVDS 0003 STD UNOPENED A 100 000000 07 N DBDVM5 01 CVDS 0004 NO CSD ENTRY CVDS 0005 NO LOAD MODULE CVDS 0006 NO CSD ENTRY CVDS 0007 NO CSD ENTRY CVDS 0008 NO CSD ENTRY CVDS 0009 NO CSD ENTRY CVDS 0010 STD UNOPENED A 100 000000 07 Y 000 000 DBDVM5 01 CVDS 0011 NO CSD ENTRY CVDS 0012 NO CSD ENTRY CVDS 0013 NO CSD ENTRY CVDS 0014 STD UNOPENED A 90 000000 07 Y 000 000 DBDVM5 01 CVDS 0015 NO CSD ENTRY CVDS 0016 STD UNOPENED A 100 000000 07 N 000 000 DBDVM5 01 CVDS 0017 NO CSD ENTRY CVDS 0018 NO CSD ENTRY CVDS 0019 NO CSD ENTRY PF1: REFRESH PF3: RETURN/END PF7: BACKWARD PF8: FORWARD

Field Descriptions

The only valid entry in Column A is S, which selects the URT to display at the Table-level.

A

Action to perform with DBEX:

S

Select and begin browse display at table level.

SYS

Identifies the CICS system to which this display line refers. *LOC means local CICS or TOR.

URT

Identifies sequence number of the URT.

TYP

Indicates the type of URT:

STD

URT for applications issuing CA Datacom/DB commands.

SQL

URT for applications issuing SQL statements.

DYN

URT dynamically built by another CA product.

STATUS

Indicates the OPEN status of the URT:

UNOPENED

Not yet opened by a program call or a DBEC or DBOC transaction.

CLOSED

Explicitly closed with a DBEC or DBOC CLOSE=.

CLOSING

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.

OPEN

Opened by CA Datacom CICS Services but no transaction to close it has been issued.

OPENING

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.

W

(WHEN) Indicates when CA Datacom CICS Services opens the URT:

P

(PLT) Specifies the URT is open by CA Datacom CICS Services at startup time.

A

(AUTO) Specifies the URT is automatically opened by CA Datacom CICS Services when an application request needs this URT.

D

(DEFER) Specifies the URT can only be opened with an explicit DBEC or DBOC command.

REL

If the URT was assembled with a release of the macros at CA Datacom/DB r10 or earlier, REL indicates the CA Datacom/DB release level of the macro used to generate the URT. Beginning with CA Datacom/DB r11 and for all following releases, the value for REL is a URT compatibility indicator and displays as 100.

CBSIO

The value specified in URT generation for I/O limit interrupt for all SELxx commands except SELPR.

PR

Indicates the priority level for requests processed using this URT, where nn is between 01 and 15; 01 is low, 07 is the default (specified with PRTY= in the DBURSTR macro used in generating this URT).

U

Value for TXNUNDO= in the DBURSTR macro generating this URT, where:

YES

Indicates transaction backout is dynamically invoked for update requests issued by a program using this URT when an abend occurs.

NO

Indicates transaction backout is not operational.

MIN

Value for TIMEMIN= in the DBURSTR macro generating this URT, where the number between 1 and 120 is the limit in minutes to wait for a record held under exclusive control by another request (alternative to TIMESEC=).

Note: MIN=0 with SEC=0 means unlimited wait time; MIN=0 with SEC=1 means no wait time.

SEC

Value for TIMESEC= in the DBURSTR macro generating this URT, where the number between 1 and 120 is the limit in seconds to wait for a record held under exclusive control by another request (alternative to TIMEMIN=).

Note: MIN=0 with SEC=0 means unlimited wait time; MIN=0 with SEC=1 means no wait time.

CONDITIONS

ACT=xxx,RES=xxx

The value for ACT (ACTIVE) is the total number of tasks using this URT. The value for RES is the number of tasks which have read a record for update.

NO CSD ENTRY

The CICS System Definition data set (CSD) does not contain an entry for this URT.

NO LOAD MODULE

The URT module is not in the library.

CSD DISABLED

The entry for this URT in the CICS System Definition data set (CSD) has been disabled.

URT DELETED/SKIPPED

The user has deleted the URT module or this URT was not loaded because it was specified in a SKIPLOAD range.

UNKNOWN MUF

This global URT is associated with a MUF that is not defined with a DBCSID macro in the DBCVTPR.

OPEN RC=xx.yyy

The last open request for this URT failed for the reason indicated by CA Datacom/DB return code xx and internal return code yyy.

CLOS RC=xx.yyy

The last close request for this URT failed for the reason indicated by CA Datacom/DB return code xx and internal return code yyy.

SIDNAME

The value specified in the relative DBCSID macro of the DBCVTPR generation for the name of the DBSIDPR macro generated module to be loaded and used for this MUF.

MUF

The number of the MUF that contains the tables for this URT. In a single MUF environment, this number is always one.