Data Sets Used by Thread

This panel shows data set I/O activity for the DB2 objects used by the selected thread.


 ________________ ZIIO     VTM     O2       V540.#P DA41 11/05/13 12:03:55   2
> Help PF1                                                            Back PF3
                                                                              
>       THREAD INFORMATION:  Enter a selection letter on the top line.        
                                                                              
> A-THREAD DETAIL B-LOCK COUNTS C-LOCK WAITS     D-LOCKS OWNED  E-GLOBAL LOCKS
> F-CURRENT SQL   G-SQL COUNTS  H-DISTRIBUTED    I-BUFFER POOL  J-GROUP BP    
> K-PACKAGES      L-RES LIMIT   M-PARALLEL TASKS N-UTILITY      O-OBJECTS     
> P-CANCEL THREAD Q-DB2 CONSOLE *-DSN ACTIVITY   S-APPL TRACE   T-ENCLAVE     
> U-LONG NAMES                  W-ACCEL ACTIVITY                              
==============================================================================
>                                THREAD DETAIL                                
 PLAN                                                                         
+ Thread:  Plan=DSNESPRR  Connid=TSO      Corrid=MIS          Authid=MIS      
+ Attach:  TSO            Userid=MIS                          Region asid= 224
+ Package: DSNTIAP                        Collection=DSNTIAP                  
+ Luwid=DEIBMIPS.IPSATA41.CC37C45A9FDC=1761                                   
                                                                              
>    place a 'T' in front of command to view by tablespace, 'D' by database   
                                                                              
 iio                                                                          
+                                                 --Synch I/O--  -Asynch I/O--
+ Dataset Name                                    Delay  Count   Delay  Count 
+ --------------------------------------------    ------ ------  ------ ------
+ DSNA41.DSNDBC.DSNDB06.DSNADH01.I0001.A001          1.2      8      .0      1
+ DSNA41.DSNDBC.DSNDB06.DSNAGH01.I0001.A001          2.5      6     1.0      1
+ DSNA41.DSNDBC.DSNDB06.DSNDCX01.I0001.A001          2.9     71     4.7     50
+ DSNA41.DSNDBC.DSNDB06.DSNDDH01.I0001.A001          1.2      7      .0      0
+ DSNA41.DSNDBC.DSNDB06.DSNDFX01.I0001.A001          2.0      4      .0      0
+ DSNA41.DSNDBC.DSNDB06.DSNDPX01.I0001.A001           .9     11     1.0      1
+ DSNA41.DSNDBC.DSNDB06.DSNDPX03.I0001.A001          1.1     11      .0      1
+ DSNA41.DSNDBC.DSNDB06.DSNDSX01.I0001.A001          2.0      8     1.0      1
+ DSNA41.DSNDBC.DSNDB06.DSNDTX01.I0001.A001          2.1     23     3.4      7
+ DSNA41.DSNDBC.DSNDB06.DSNDTX05.I0001.A001          1.2     18     3.6      6
+ DSNA41.DSNDBC.DSNDB06.DSNDYX01.I0001.A001           .8      5      .0      0
+ DSNA41.DSNDBC.DSNDB06.DSNODX01.I0001.A001        131.4      5      .0      0
+ DSNA41.DSNDBC.DSNDB06.DSNPDX01.I0001.A001          2.5      4      .0      0
+ DSNA41.DSNDBC.DSNDB06.DSNSRX01.I0001.A001          1.0      9     6.6      3
+ DSNA41.DSNDBC.DSNDB06.SYSGPAUT.I0001.A001          2.8      7    10.0      3
+ DSNA41.DSNDBC.DSNDB06.SYSSEQ2.I0001.A001           1.1     12     3.8      5
+ DSNA41.DSNDBC.DSNDB06.SYSTSCOL.I0001.A001          1.4     10     4.7     49
+ DSNA41.DSNDBC.DSNDB06.SYSTSDAT.I0001.A001          8.0      3      .0      0
+ DSNA41.DSNDBC.DSNDB06.SYSTSDBA.I0001.A001          2.2      5     9.6      5
+ DSNA41.DSNDBC.DSNDB06.SYSTSDBU.I0001.A001          4.0     15     1.0      1 
+ DSNA41.DSNDBC.DSNDB06.SYSTSFLD.I0001.A001          3.0      2      .0      0 
+ DSNA41.DSNDBC.DSNDB06.SYSTSPEN.I0001.A001          1.0      2      .0      0 
+ DSNA41.DSNDBC.DSNDB06.SYSTSSYN.I0001.A001          5.0      5    10.5      4 
+ DSNA41.DSNDBC.DSNDB06.SYSTSTAB.I0001.A001          1.7     29     4.0     27 
+ DSNA41.DSNDBC.DSNDB06.SYSTSTPT.I0001.A001          1.5     12    11.8      7 
+ DSNA41.DSNDBC.DSNDB06.SYSTSTSP.I0001.A001          1.6     13     4.0     11 
===============================================================================

Navigation

You can scroll through the information using F7 and F8.

For additional information about

related topics, select one of the options at the top of the panel.
other topics, use the PF keys.

Fields

Thread identifier: This information identifies the thread to which the information in this panel applies.

Plan: The Db2 plan name of the active thread.
Connid: The Db2 connection identifier of the active thread.
Corrid: The Db2 correlation identifier of the active thread. If the correlation is not set, N/A is displayed.
Authid: The Db2 authorization identifier of the active thread.
Attach: Depending on the type of connection, the appropriate information is displayed.; Attach information is displayed only if the thread is a distributed allied thread (not for distributed database access threads).

Connection Type

Batch

The MVS jobname and ASID.

Note: For threads from remote Db2, the MVS job name is N/A.

CICS®

The CICS jobname, task name, task number, terminal ID, and thread type. The thread type is:

Pool: The thread in use is a pool thread.
Entry: The thread in use is a nonprotected entry thread.
Prot: The thread in use is a protected thread. Protected threads are defined in an RCT entry definition using the THRDS operand.

IMS

The IMS region number, transaction name, region name, and terminal ID (LTERM).

RRSAF

The MVS job name and ASID.

Note: For threads from remote Db2, the MVS job name is N/A.

System

The originating Db2 job name and the resource manager that is the source of the thread. An additional line below the Attach line identifies the user thread, if any, being served by the system thread.

TSO

The TSO user ID and region ASID.

Utility

No additional information.

Db2

The Db2 subsystem identifier.

MVS

The MVS system identifier.

ORIGAUTH

The original (primary) Db2 authorization identifier of the thread. This field displays only when the original identifier is different from the Authid.

Package identifier: This information identifies the package to which the information in this panel applies.

Package: The Db2 package name of the active thread. Up to 18 characters of the package name are returned.
Collection: The package collection identifier. This field is displayed only if a package is being used.

Database

The name of the database for which thread activity has occurred.

Spacenam

The name of the table space for which thread activity has occurred.

Dsn

The name of the data set for which thread activity has occurred.

Sync I/O delay

The average I/O delay (in milliseconds) for synchronous I/O.

Sync I/O count

The number of synchronous reads made by the thread.

Async I/O delay

The average I/O delay (in milliseconds) for asynchronous I/O.

Async I/O count

The number of asynchronous read requests made by the thread.

Usage with Remote Threads (DSG)

To retrieve I/O data from remote threads, the following conditions must be met:

XCF must be active. To activate XCF, update RKD2PAR(OMPEOPTS) and add option XCFMODE=ACTIVE.
An OMEGAMON® XE server must be running on every LPAR in the Data Sharing Group.
All OMEGAMON XE servers must use the same XCF group name.
The remote Db2 I/O access must be activated. To activate Db2 remote I/O, update RKD2PAR(OMPEOPTS) and add option DB2REMIO=YES.

The maximum number for retrieving data sets for remote threads is 695. If this number is exceeded, the list of data sets is preceeded by a message indicating the total number that is allocated.