INQ=urt/INQ=limiter--Displaying URT Information

Invoke the following transaction to display information on one or more specified URTs.
cadts150
Invoke the following transaction to display information on one or more specified URTs.
                         ┌─ , ───┐ ►►─┬─ DBOC ─┬─ INQuire= ─▼─ 
urt
 ─┴────────────────────────────────────────────►◄    └─ DBIC ─┘
  • DBOC/DBIC
    (Required)
     Specify a transaction ID valid with Operational commands used to monitor system resources. Select the transaction ID for which you are authorized. Leave a space between the transaction ID and the command.
  • INQuire=
    (Required)
     Command specifying a status display. You may shorten this command to INQ=.
  • urt
    (Required)
     Specify one or more URTs by the 4-digit suffix, with or without leading zeros, where the range of valid values is 0001 to the active MAXURTS= value. Use the wildcard symbol (?) to accept any valid value between 0 and 9 for any (or all) of the digits. To specify a series, separate the identifiers with commas.
    Example
    Description
    1
    URT 0001
    ?,20
    URTs 0001 through 0009, and 0020
    ?,1?,2?,30
    URTs 0001 through 0030
    ??
    URTs 0001 through 0099
    1??,20?,21?
    URTs 0100 through 0219
    ????
    All valid URTs
Contents
Limit Display to URTs of Specified Type
Invoke the following transaction to display information about all URTs of the specified URT type (SQL or DYN).
►►─┬─ DBOC ─┬─ INQuire= ─┬─ SQL ─┬────────────────────────────────────────────►◄    └─ DBIC ─┘            └─ DYN ─┘
  • DBOC/DBIC
    (Required)
     Specify a transaction ID valid with Operational commands used to monitor system resources. Select the transaction ID for which you are authorized. Leave a space between the transaction ID and the command.
  • INQuire=
    (Required)
     Command specifying a status display. You may shorten this command to INQ=.
  • SQL
    Type of URT available to programs issuing SQL commands, that is to say one defined with DBSQL=YES in the DBUREND macro.
  • DYN
    Type of URT created dynamically by a CA product. (Only those URT numbers up to the MAXURT= value which have no CSD entries are available for dynamic creation by CA products.)
Limit Display to URTs of Specified Status
Invoke the following transaction to display information about all URTs of either the specified URT status (OPENED or CLOSED) or all which show OPEN FAILED or CLOSE FAILED in the message area.
►►─┬─ DBOC ─┬─ INQuire= ─┬─ OPENED ─┬─────────────────────────────────────────►◄    └─ DBIC ─┘            ├─ CLOSED ─┤                          └─ FAIL ───┘
  • DBOC/DBIC
    (Required)
     Specify a transaction ID valid with Operational commands used to monitor system resources. Select the transaction ID for which you are authorized. Leave a space between the transaction ID and the command.
  • INQuire=
    (Required)
     Command specifying a status display. You may shorten this command to INQ=.
  • OPENED
    Status is OPENED.
  • CLOSED
    Status is CLOSED.
  • FAIL
    Status is that the last attempt to open or close failed.
Limit Display to URTs Having Specified Time for Opening
Invoke the following transaction to display information about all URTs having the specified time for opening (AUTO, DEFER, PLT).
►►─┬─ DBOC ─┬─ INQuire= ─┬─ AUTO ──┬──────────────────────────────────────────►◄    └─ DBIC ─┘            ├─ DEFER ─┤                          └─ PLT ───┘
  • DBOC/DBIC
    (Required)
     Specify a transaction ID valid with Operational commands used to monitor system resources. Select the transaction ID for which you are authorized. Leave a space between the transaction ID and the command.
  • INQuire=
    (Required)
     Command specifying a status display. You may shorten this command to INQ=.
  • AUTO
    To be opened automatically when an application program requiring its use begins processing, that is to say either defined through AUTO[n]= in the 
    CA Datacom® CICS Services
     Generation Options Table (DBCVTPR) or added through the DBOC AUTO= command.
  • DEFER
    To be opened only when requested through the DBOC OPEN= command, that is to say either defined through DEFER[n]= in the 
    CA Datacom® CICS Services
     Generation Options Table (DBCVTPR) or added through the DBOC DEFER= command.
  • PLT
    To be opened at CICS startup.
Command Examples
Command
Result
DBIC INQ=9?,10?,110
Invokes the URT Inquiry display for URTs with suffixes in the range 0090 to 0110, that is to say the field labeled (1) on the following display example would contain only numbers between 0090 and 0110.
DBOC INQ=SQL
Invokes the URT Inquiry display for URTs of the SQL type. Only those entries with SQL in the Type field would appear. (See the field labeled (2) on the following display example.)
DBOC INQ=OPENED
Invokes the URT Inquiry display for open URTs. Only those entries with OPENED in the status field would appear. (See the field labeled (3) on the following display example.)
DBOC INQ=PLT
Invokes the URT Inquiry display for URTs that are not defined with AUTO= or DEFER=. Only those entries with a blank in the "when to open" field would appear. (See the field labeled (4) on the following display example.)
Display Example DBIC INQ=????
The following example illustrates the most comprehensive URT Inquiry display. You can limit the display to specified entries in the fields labeled 1 -- 5 (see Field Descriptions). Compare this display example with Display Example: DBEC I,URT(??).
For descriptions of the fields shown in these examples, see the Field Descriptions topic following Display Example: DBOC INQ=FAIL.
DBIC INQ=????                                                          DELIM &       (1)  (2)      (3)    (4)         (5)               (6)    (7)     (8) URT 0001(STD UNOPENED AUTO )                       PRTY=07 TXNUD URT 0002(STD UNOPENED AUTO )                       PRTY=07 TXNUD URT 0003(STD UNOPENED AUTO )                       PRTY=07 TXNUD=NO              URT 0004-0009                INVALID, DISABLED, NOT LINK EDITED OR SKIPLOAD      URT 0010(STD UNOPENED AUTO )                       PRTY=07 TXNUD                 URT 0011-0013                HAVE NO CSD ENTRIES                                 URT 0014(STD UNOPENED DEFER)                       PRTY=07 TXNUD                 URT 0015                     HAS NO CSD ENTRY                                    URT 0016(STD UNOPENED      ) OPEN  FAILED RC02 052 PRTY=07 TXNUD=NO              URT 0017-0019                HAVE NO CSD ENTRIES                                 URT 0020(SQL OPEN          ) ACTIVE=000 RESRVD=000 PRTY=07 TXNUD                 URT 0021-0024                HAVE NO CSD ENTRIES                                 URT 0025(STD UNOPENED DEFER)                       PRTY=07 TXNUD                 URT 0026-0034                HAVE NO CSD ENTRIES                                 URT 0035(STD UNOPENED DEFER)                       PRTY=08 TXNUD                 URT 0036                     INVALID, DISABLED, NOT LINK EDITED OR SKIPLOAD      URT 0037(STD UNOPENED DEFER)                       PRTY=07 TXNUD                 URT 0038-0050                HAVE NO CSD ENTRIES                                 URT 0051-0052                INVALID, DISABLED, NOT LINK EDITED OR SKIPLOAD      URT 0053-0100                HAVE NO CSD ENTRIES                                                                            ENTER = NEXT PAGE   CLEAR = END TRANS
Display Example DBIC INQ=1,2,3,7
The following example illustrates a limited URT Inquiry display, where the limitation is on the URT number.
DBIC INQ=1,2,3,7                                                       DELIM &        (1)  (2) (3)    (4)         (5)                 (6)     (7)     (8) URT 0001(STD UNOPENED AUTO )                       PRTY=07 TXNUD URT 0002(STD UNOPENED AUTO )                       PRTY=07 TXNUD URT 0003(STD UNOPENED AUTO )                       PRTY=07 TXNUD=NO            URT 0004-0009                INVALID, DISABLED, NOT LINK EDITED OR SKIPLOAD    DC00380I  TRANSACTION COMPLETED.
Display Example DBIC INQ=SQL
The following example illustrates a limited URT Inquiry display, where the limitation is on the URT type.
DBIC INQ=SQL                                                           DELIM &       (1)  (2) (3)      (4)         (5)                   (6)    (7)    (8) URT 0020(SQL OPEN          ) ACTIVE=000 RESRVD=000 PRTY=07 TXNUD DC00380I  TRANSACTION COMPLETED.
Display Example DBIC INQ=OPENED
The following example illustrates a limited URT Inquiry display, where the limitation is on the URT status.
DBIC INQ=OPENED                                                        DELIM &         (1)  (2) (3)     (4)          (5)                 (6)     (7)     (8) URT 0014(STD OPEN          ) ACTIVE=000 RESRVD=000 PRTY=07 TXNUD URT 0020(SQL OPEN          ) ACTIVE=000 RESRVD=000 PRTY=07 TXNUD URT 0037(STD OPEN          ) ACTIVE=000 RESRVD=000 PRTY=07 TXNUD URT 0067(STD OPEN          ) ACTIVE=000 RESRVD=000 PRTY=07 TXNUD URT 0101(STD OPEN          ) ACTIVE=000 RESRVD=000 PRTY=07 TXNUD DC00380I  TRANSACTION COMPLETED.
Display Example DBOC INQ=AUTO
The following example illustrates a limited URT Inquiry display, where the limitation is on the URT "when to open" specification.
 DBOC INQ=AUTO                                                         DELIM ;         (1)  (2)  (3)      (4)             (5)           (6)     (7)     (8)  URT 0001(STD OPEN     AUTO ) ACTIVE=000 RESRVD=001 PRTY=07 TXNUD  URT 0002(STD UNOPENED AUTO ) CLOSE FAILED RC02 052 PRTY=07 TXNUD  URT 0010(STD CLOSED   AUTO )                       PRTY=07 TXNUD=NO  URT 0101(STD UNOPENED AUTO )                       PRTY=07 TXNUD  DC00380I  TRANSACTION COMPLETED.
Display Example DBOC INQ=FAIL
The following example illustrates a limited URT Inquiry display, where the limitation is on the URTs with a failure on the last open or close.
 DBOC INQ=FAIL                                                         DELIM &         (1)  (2)     (3)    (4)            (5)             (6)      (7)      (8)  URT 0060(STD UNOPENED      ) CLOSE FAILED RC25 020 PRTY=07 TXNUD=NO  URT 0061(STD UNOPENED      ) CLOSE FAILED RC25 020 PRTY=07 TXNUD  URT 0062(STD UNOPENED      ) CLOSE FAILED RC25 020 PRTY=07 TXNUD  URT 0063(STD UNOPENED      ) CLOSE FAILED RC25 020 PRTY=07 TXNUD  URT 0064(STD UNOPENED      ) CLOSE FAILED RC25 020 PRTY=07 TXNUD  URT 0065(STD UNOPENED      ) CLOSE FAILED RC25 020 PRTY=07 TXNUD  URT 0066(STD UNOPENED      ) CLOSE FAILED RC25 020 PRTY=07 TXNUD  URT 0068(STD UNOPENED      ) CLOSE FAILED RC25 020 PRTY=07 TXNUD  URT 0069(STD UNOPENED      ) CLOSE FAILED RC25 020 PRTY=07 TXNUD  URT 0070(STD UNOPENED      ) CLOSE FAILED RC25 020 PRTY=07 TXNUD  URT 0072(STD UNOPENED      ) CLOSE FAILED RC25 020 PRTY=07 TXNUD  URT 0100(STD UNOPENED      ) CLOSE FAILED RC02 052 PRTY=07 TXNUD=NO  DC00380I  TRANSACTION COMPLETED.
Field Descriptions
The URT Inquiry panel displays one row of information per URT, where URTs are listed in ascending order by URT-suffix. Information includes URT characteristics such as type, status, and when to open, pertinent messages such as the number of active tasks for an open URT, and how the URT is defined in its DBURSTR macro.
Field
URT Characteristic
Value
Description
URT
URT
Identifier that this is a URT.
(1)
Number
0001-nnnn
4-digit suffix of the URT name. For details about the 4-digit suffix, see the descriptions of the DBCVTPR macro parameters MAXURTS= and PREFIX= in Specifying Generation Options (DBCVTPR).
(2)
Type
STD
URT assembled for applications issuing
CA Datacom®/DB
commands.
(2)
Type
SQL
URT assembled for applications issuing SQL statements.
(2)
Type
DYN
URT dynamically built by another CA product, such as CA Dataquery.
(3)
Status
UNOPENED
Not yet opened through a DBOC OPEN= transaction or invoked by an application request.
(3)
Status
CLOSED
Closed by
CA Datacom® CICS Services
.
(3)
Status
CLOSING
Specified with a
CA Datacom® CICS Services
CLOSE command, but not yet closed pending completion transaction having exclusive control.
(3)
Status
OPENED
Opened by
CA Datacom® CICS Services
.
(4)
When to Open
Blank
This URT has not been specified for delayed opening. It is opened during
CA Datacom® CICS Services
startup when the PLT is processed.
(4)
When to Open
AUTO
URT is defined with the AUTO= parameter. It is opened automatically when initially required by an application request.
(4)
When to Open
DEFER
URT is defined with the DEFER= parameter. Its opening is deferred until opened through the DBOC OPEN= command.
(5)
Message
ACTIVE=
Number of active tasks using this URT.
(5)
Message
RESRVD=
Number of tasks which have read a record for update using this URT.
(5)
Message
INVALID, DISABLED, NOT LINK EDITED, OR SKIPLOAD
Reasons are the following:
The corresponding load module is not a valid online URT.
Its CSD entry has been disabled.
Its load module is not in the load library.
The URT has been specified in a SKIPLOAD macro in the DBCVTPR as not be loaded at STARTUP.
(5)
Message
OPEN FAILED RC
nn
The last open failed for this URT. The reason for this failure is indicated by
CA Datacom®/DB
return code
nn
.
(5)
Message
CLOSE FAILED RC
nn
The last close failed for this URT. The reason for this failure is indicated by
CA Datacom®/DB
return code
nn
.
(5)
Message
HAS NO CSD ENTRY
HAVE NO CSD ENTRIES
No entry for this URT in the CSD.
(6)
Job priority
PRTY=
nn
Priority level for requests processed using this URT, where nn is between 01 and 15. 01 is low, 07 is the default.
(7)
Transaction backout
TXNUD
TXNUNDO=YES is specified in the DBURSTR macro defining this URT. Transaction backout is enabled for all update transactions against all tables declared in this URT.
(7)
Transaction backout
TXNUD=NO
Transaction backout is not operational for tasks using this URT.
(8)
Wait time for held record
ECWAIT=
ECWAIT= value from 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.
Interpreting Displayed Data
Use the following guidelines to interpret the display. URT characteristics are labeled by fields as they were on the report. See the information about online URTs in Coding the URT Macros.
  • (1)
    The range of numbers which can appear as URT suffixes is limited by the MAXURTS= value specified in the System Option Table (DBCVTPR).
  • (2)
    The origin of the Type characteristic is the DBUREND macro parameter DBSQL= in the URT definition. If DBSQL=YES, SQL appears. If DBSQL=NO and you defined a URT with the displayed number, STD appears. If DBSQL is NO and you have not defined a URT with a number within the range 0001-nnnn, that URT number is eligible for use by a CA product for dynamic generation. If so used, DYN appears. If not so used, HAVE NO CSD ENTRIES appears in the Usage/Reason Not Used field.
    For more information about the DBSQL= parameter, see the topic about defining a URT, see Defining the User Environment.
  • (3)
    The only Status characteristic controlled by a definition is UNOPENED. Only a URT defined with AUTO= or DEFER= can exist in UNOPENED status. Once a URT is open, it remains open until 
    CA Datacom® CICS Services
     is shut down unless explicitly closed through a DBOC or DBEC CLOSE= command.
  • (4)
    Except for URTs specified for delayed opening, 
    CA Datacom® CICS Services
     opens all URTs at system startup. In the DBCVTPR macro, two lists of URTs may be identified for delayed opening with AUTO= and DEFER= respectively, those to open automatically when required by an application for its processing and those to defer opening until requested by a DBOC or DBEC OPEN= command.
    To add to the list of URTs which open automatically, see AUTO= Setting URTs for Automatic Opening. To add to the list of URTs which only open when a DBOC OPEN= command is issued, see DEFER= Setting URTs for Deferred Opening. To return URTs to their original automatic open or deferred open state (as specified in DBCVTPR), see RESTART= Returning URTs to Initial Status.
  • (5)
    If the table is open, its current usage can be determined by examining the ACTIVE= and RESRVD= data.
    The presence of an OPEN FAILED or CLOSE FAILED entry indicates a processing failure. Take the action suggested in the for the displayed 
    CA Datacom®/DB
     return code.
    If INVALID, recompile the module to create a valid online URT.
    If NOT LINK EDITED, either remove this URT name from the CICS System Definition data set (CSD) or link edit the assembled URT macros to produce a load module which resides in the searched load library.
    INVALID, DISABLED, NOT LINK EDITED, or SKIPLOAD and HAVE NO CSD ENTRIES (or HAS NO CSD ENTRY) appear when the following conditions apply:
    • you have disabled a CSD entry
    • the load module is not in the DFHRPL
    • the URT has been specified in a SKIPLOAD macro in the DBCVTPR as not to be loaded
    • no entry in the CICS System Definition data set (CSD) for these or this URT is not within the MAXURTS= range
    This message is for information only.
    Example:
     DBOC INQ=FAIL                                                         DELIM &          1   2       3      4             5               6       7        8  URT 0014(STD UNOPENED AUTO )                       PRTY=07 TXNUD=NO  URT 0015          HAS NO CSD ENTRY     URT 0016(STD UNOPENED AUTO )                       PRTY=07 TXNUD=NO  URT 0017-0019     HAVE NO CSD ENTRIES   
  • (6) (7) (8)
    The DBURSTR macro parameters PRTY=, TXNUNDO=, and TIMEMIN= or TIMESEC= can be changed by altering values and reassembling and relinking the URT. A low priority task (PRTY=1) which has a resource under exclusive control could tie up that resource indefinitely, the avoidance of which is a good reason to specify TIMEMIN= or TIMESEC= in DBURSTR rather than accepting the default of zero. If the default is used for this URT, no entry appears for ECWAIT=. A low priority task with transaction backout specified (TXNUNDO=YES), can force checkpointing in the Log Area(s).
    For more information, see Defining the User Environment.