DBEC/DBEX: Monitoring Remote System Resources with Enhanced Commands › Displaying Table-Level Processing Options

Displaying Table-Level Processing Options

To display options for CA Datacom/DB tables accessible through URTs from a specified CICS system, or all CICS systems, issue an Enhanced INQUIRE command.

If you issue the INQ command with the DBEX transaction ID, or its substitute, you are not able to update any fields on the scrollable display. If you issue the command with DBEC, or its substitute, you may make entries in certain fields to override table options specified in the URT definition.

The following is an example of a URT definition. A URT begins with a DBURSTR macro, contains one or more DBURTBL macros, each defining a particular CA Datacom/DB table, and ends with a DBUREND macro. The values for the bold-faced parameters in this example are displayed on the Table-level inquiry.

URT            TITLE 'ONLINE URT FOR REQUESTS USING MULTI-USER FACILITY'
DBURSTR        MULTUSE=YES,WRITE=NO,
               CBSIO=0,PRTY=7,TXNUNDO=YES,TIMEMIN=5,TIMESEC=0
DBURTBL        TBLNAME=PAY,DBID=004,
               AUTODXC=YES,BYPOPEN=NO,SYNONYM=YES,UPDATE=YES
DBUREND        DBSQL=YES,USRINFO=CAICICS
END

Invoke the following transaction to display how TBLNAM=, DBID= or DBIDUSER= and DBIDMUF=, AUTODXC=, BYPOPEN=, SYNONYM=, and UPDATE= parameters are defined by DBURTBL macros for all tables within specified URT.

Displaying Table-Level Processing Options

►►─┬─ DBEC ─┬─ INQuire,TBL(nnnn) ─┬────────────┬─ ,SYSid(aaaa) ───────────────►
   └─ DBEX ─┘                     └─ ,limiter ─┘

 ►─┬──────────────────────┬───────────────────────────────────────────────────►◄
   └─ ,SIDname(xxxxxxxx) ─┘

DBEC/DBEX

(Required) Specify a transaction ID valid with Enhanced commands used to monitor URTs. Select the transaction ID for which you are authorized. Leave a space between the transaction ID and the command.

INQuire,

(Required) Specifies that CA Datacom CICS Services is to perform an Inquiry. (INQ and I are valid abbreviations.)

TBL(nnnn)

(Required) TBL specifies the inquiry is to invoke the Table-level display. The value within the parentheses identifies the suffix of the URT.

nnnn

Specifies that you want to display only the URT with the specific 4-digit suffix nnnn.

Alternately, instead of using the nnnn suffix to specify only a specific URT, you can use the wildcard symbol ? (a question mark) to accept any digit 0 through 9 for any (or all) of the four digits of the suffix.

See Command Examples.

,limiter

(Optional) Limits the inquiry to URTs of designated type, status, how defined for opening or those with no CICS System Definition data set (CSD) entry. The following are the values for designating limiters of each type:

Type

DYN

URTs dynamically built by a CA product.

SQL

URTs for applications issuing SQL statements.

Status

CLOSE

URTs explicitly closed through a DBOC CLOSE= command, a DBEC PERform,URT(nnnn),CLOSE, or an entry of C in the Action column of a DBEC INQ,URT(nnnn) display.

CLOSING

URTs with a close in progress, where close is invoked at the completion of the current read or update.

OPEN

URTs which are currently open.

OPENING

URTs with an open in progress, where open status is set at the completion of the current open in the MUF.

UNOpened

URTs defined as AUTO or DEFER which have not been opened by a program call or a DBOC/DBEC transaction. (UNO is a valid abbreviation.)

When

AUTO

URTs defined to be opened when required by a program.

DEFer

URTs defined to be opened only by an explicit DBOC/DBEC command. (DEF is a valid abbreviation.)

PLT

URTs opened at CA Datacom CICS Services startup, that is to say those not defined for AUTO or DEFER.

Condition

NOCSD

URTs have no CICS System Definition data set (CSD) entry. Such URTs are available for dynamic creation by a CA product.

,SYSid(aaaa)

(Required) For an MRO environment, the value within the parentheses determines whether the inquiry is for a single remote CICS system or for all CICS systems. Valid values follow:

aaaa

Four-character CICS identifier for a single remote CICS system, as defined in the CICS connection table.

*

All attached CICS systems, beginning with the local system.

(SYS is a valid abbreviation.)

,SIDname(xxxxxxxx)

(Optional) Specify one specific SID name to which the URT inquiry applies by MUF (see the DBURSTR macro SIDNAME= parameter in the CA Datacom/DB Database and System Administration Guide and the DBCSID macro SIDNAME= parameter in the System Reference Guide) or any number of leading characters of SID names, followed by an asterisk (*) to specify a range of SID names to which the URT inquiry applies by MUFs. Omitting the SIDNAME(xxxxxxxx) limiter results in the command being applied to all MUFs in the remote systems. (SID is a valid abbreviation.)