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


Display Example: DBEC I,URT(??)

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

Field Descriptions
A

The only valid entry in Column A is S, which selects the URT to display at the Table-level. 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 is in progress by CA Datacom CICS Services.

W

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

P

(PLT) Specifies the URT is opened 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

The TXNUNDO= value in DBURSTR macro generating this URT, where:

Y

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

N

(NO) Indicates transaction backout is not operational.

MIN*

The TIMEMIN= value 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=). Leading or trailing blanks are not allowed. When entering values into this field that are shorter than the field length, the remainder of the field can be cleared by using the EOF key at the end of the entered value.

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

SEC*

The TIMESEC= value 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=). Leading and trailing blanks are not allowed. When entering values into this field that are shorter than the field length, the remainder of the field can be cleared by using the EOF key at the end of the entered value.

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

*If you alter either the MIN or SEC field, the value you specify is converted (if necessary) to seconds before storing in the URT. When redisplayed, if the value in seconds is greater than 60 and is evenly divisible by 60 (that is to say, the remainder is zero), the value is displayed in the MIN field; otherwise, it is shown in the SEC field.

CONDITIONS

The following can appear:

ACT=xxx RES=xxx

Value for ACTIVE is the total number of tasks using this URT. Value for RES is the number that currently have a record locked, deleted, added or updated.

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.

OPEN RC=xx.yyy

The last open request for this URT failed for the reason indicated by CA Datacom/DB return code xx and the 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 the internal return code yyy.

UNKNOWN MUF

The global URT module has been determined to require a MUF that has not been defined by a DBCSID macro in the DBCVTPR module.

A global URT, beginning with r10, is a CA Datacom/DB URT that either has multiple MUF support or DBID remapping support, that is to say, either the DBURSTR macro uses the SIDNAME= parameter or the DBURTBL macro uses the DBIDMUF= parameter.

URT DELETED

The URT module has been deleted by the user.

URT DELETED/SKIPPED

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

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

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