Requests for information on URT resources are issued with the DBEC or the DBEX transaction followed by the INQUIRE operand. The options enable you to invoke a display of all URTs or a limited set of URTs.
If you issue the command with the DBEX transaction ID, you cannot update any information on the resulting scrollable display. The only allowable entry is an S in the Action field which toggles to the Table-level display beginning with the URT for the row containing your entry. If you issue the command with DBEC, you can alter certain fields on the panel. (Any alterations made take effect immediately and are valid only during the life of the CICS session.)
The following is an example of a URT. 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 URT-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 inquiry as shown following to display the status of CA Datacom/DB URTs.
►►─┬─ DBEC ─┬─ INQuire,URT(nnnn) ─┬──────────────────────┬────────────────────► └─ DBEX ─┘ └─ ,SIDname(xxxxxxxx) ─┘ ►─┬────────────┬─────────────────────────────────────────────────────────────►◄ └─ ,limiter ─┘
(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.
(Required) Requests a scrollable display of URTs. (INQ and I are valid abbreviations.)
(Required) URT specifies the inquiry is to invoke the URT-level display. The value within the parentheses identifies the suffix of the URT.
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—9 for any (or all) of the four digits of the suffix.
(Optional) Limits the inquiry to a specific MUF by the SID name associated with that 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 limits the inquiry to a range of MUFs by specifying any number of leading characters of the SID name, followed by an asterisk (*). Omitting the SIDname(xxxxxxxx) limiter results in URTs in all MUFs being displayed. (SID is a valid abbreviation.)
(Optional) Limits the inquiry to URTs of designated type, status, how defined for opening or those with no CSD entry. The following are the values for designating limiters of each type:
URTs dynamically built by a CA product.
URTs for applications issuing SQL statements.
URTs explicitly closed through a DBOC/DBEC command.
URTs with a close in progress, where close is invoked at the completion of the current read or update.
URTs which are currently open.
Open requested by DBEC or DBOC OPEN= command, or a request requires an AUTO open but request has not completed in CA Datacom/DB.
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.)
URTs defined to be opened when required by a program.
URTs defined to be opened only by an explicit DBOC/DBEC command. (DEF is a valid abbreviation.)
URTs opened at CA Datacom CICS Services startup, that is to say those not defined for AUTO or DEFER.
Condition
URTs have no CICS System Definition data set (CSD) entry. Such URTs are available for dynamic creation by a CA product.
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|