DL/I Call IWAIT Summary


The DL/I Call IWAIT Summary report contains additional information about DL/I call IWAIT events.

Column totals appear at the end of the report.

DL/I Call IWAIT Summary report

+-------------------------+                         
                        ≠ DL/I CALL IWAIT SUMMARY ≠
                        ≠                         ≠
                        ≠     PCBNAME=DBIHD01     ≠
                        +-------------------------+

REF CALL LOW SEGMENT        DL/I CALLS IWAITS/    NOT IWAIT TIME      
NO. FUNC LEV NAME    SC         TOTAL   CALL         AVG            TOTAL
--  ---- --- ------- --  ------------- ------  ----------  --------------
  1  ISRT  01 DB#AASEG II  ......6,889   1.20       2.102      14,479.388
  4  ISRT  01 DB#AASEG     ........303   2.38       2.064         625.353
  9  GU    01 DB#AASEG     ..........1   2.00        .814            .814
 10  DLET  01 DB#AASEG     ..........1   4.00       6.719           6.719
 14  GU    01 DB#AASEG GE  ........276    .68        .379         104.573
 15  DLET  01 DB#AASEG DJ  ........276   0.00        .004           1.207
  2  GU    03 DB#CASEG     ........423    .81        .450         190.237
  3  REPL  03 DB#CASEG     ........423    .03       4.911       2,077.159
 11  ISRT  03 DB#CASEG     ..........2   6.00       6.076          12.152
 18  ISRT  03 DB#CASEG II  .........92    .50        .274          25.229
  5  GU    02 DB#BASEG     ..........5   1.80        .720           3.599
  6  DLET  02 DB#BASEG     ..........5   3.60       4.319          21.595
 12  ISRT  02 DB#BASEG     ..........1   1.00        .629            .629
 19  ISRT  02 DB#BASEG II  .........46   1.09        .610          28.053
  7  GU    02 DB#BBSEG     ..........1   1.00        .497            .497
  8  DLET  02 DB#BBSEG     ..........1   4.00       8.049           8.049
 13  ISRT  02 DB#BBSEG     ..........1   6.00       2.270           2.270
 20  ISRT  02 DB#BBSEG II  .........46   0.00        .115           5.312
 16  GU    00          GE  .........46    .98        .464          21.356
 17  DLET  00          DJ  .........46   0.00        .005            .215

                      TOTAL  ....8,884   1.10       1.983      17,614.406

The DL/I Call IWAIT Summary report includes the following information:

REF NO.

The number used to relate events between associated reports. In addition, the reference number is used to report the chronological order in which each new call type was detected. A call type is identified by its call function, the lowest level retrieved, the segment name retrieved, and the status code. For this reason, the reference numbers may not occur in sequential order in the report.

CALL FUNC

The current type of DL/I call.

LOW LEV

The lowest level reached in the database during call execution. It is the same as the value reported in the database PCB.

SEGMENT NAME

The segment name returned in the database PCB when a call completes.

SC

The status code associated with a DL/I call. Refer to the IBM manual Application Programming: DL/I Calls for a complete listing of the status codes.

On this report, the SC (status code) field contains a blank to indicate successful retrieval of a segment. Status codes that IMS could have issued include GA, GE, GK, and blank.

DL/I CALLS TOTAL

The total number of DL/I calls for this call type detected.

IWAITS/CALL

The average number of IWAITs per call detected for this call type.

NOT IWAIT TIME AVG

The call elapsed time minus any IWAIT time, in milliseconds. This time includes execution time as well as any suspensions caused by non IMS events.

NOT IWAIT TIME TOTAL

The total elapsed time, in milliseconds, for all the calls of this type when the call was not in an IWAIT state. This time includes execution time as well as any suspensions caused by non IMS events.

TOTAL

The totals for the column. If the column represents a count, the total value at the end of the report is the sum of the values in the column. If the column represents an average, the total value at the end of report is the average of the values in the column.

Related topic

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC AMI Application Restart Control for Db2, IMS and VSAM 4.2