Accounting thread detail—long report (BTHACDTL)

1                       BTHACDTL: ACCNTG THRD DETAIL, LONG                               11/18/10 15:56:04    PAGE     4

    DB2 SSID : DEFF 10.1      Location : DEFF                 Threads :        3
    ----------------------------------------------------------------------------
 +  --------------------------THREAD IDENTIFICATION-----------------------------
    Acctg time : 11/16/10 13:36:48.06 LUWID     : USBMCN01.DEFFLU.C6E4042BE06F
    Begin time : 11/16/10 12:46:13.24 Token     :
    End   time : 11/16/10 13:36:48.06 Requester : DEFF
    Auth : RDAMSL   Oper : RDAMSL     ThreadTyp : ALLIED
    Plan : ACT101DM Corr : MSL$EXEC     ConnTyp : DB2CALL
    Conn : DB2CALL                    ProductID : DSN10015     Version  : 10
    Term : NORMAL DEALLOCATION        Programs  :        6     Parallel : NONE
    End Workstation name :
    End User        name :
    End application name :
     |-----------------------------------+-------------------------------------|
     |CCCCCCCCCCCCCCCCCCCCCIIIIIIIIIIIIIRRRS???????????????????????????????????|
     +----------------DISTRIBUTION OF DB2 ELAPSED TIME (CLASS 2)---------------+
                  APPL TIME        % OF          DB2  TIME       % OF   GRAPH
                  (Class 1)     APPL ELAP        (Class 2)     DB2 ELAP SYMBOL
    Elapsed     0:50:34.820705                 0:00:00.124472
    CPU         0:00:04.883176     0.2  %      0:00:00.035057   28.2  %  (C)
     TCB        0:00:04.883176     0.2  %      0:00:00.035057   28.2  %
     TCB-STPROC 0:00:00.000000     0.0  %      0:00:00.000000    0.0  %
    Not accounted          N/A     N/A         0:00:00.060648   48.7  %  (?)

    ---------------------SUSPEND EVENTS AND TIME (Class 3)----------------------
       EVENTS   AVG TIME/EVENT   SUSPEND TYPE    TOTAL TIME
           48   0:00:00.000454   Sync IO       0:00:00.021812   17.5  %  (I)
   *        0              N/P   Lock          0:00:00.000000    0.0  %  (L)
            6   0:00:00.000800   Other read    0:00:00.004803    3.9  %  (R)
            0              N/P   Other write   0:00:00.000000    0.0  %  (W)
            1   0:00:00.002151   Serv tasks    0:00:00.002152    1.7  %  (S)
            0              N/P   Archive                  N/P    0.0  %  (A)
            0              N/P   Archive rd               N/P    0.0  %  (V)
            0              N/P   Claim rlse               N/P    0.0  %  (E)
            0              N/P   Drain lock               N/P    0.0  %  (D)
            0              N/P   Page latch    0:00:00.000000    0.0  %  (P)
            0              N/P   Notify msgs # 0:00:00.000000    0.0  %  (N)
            0              N/P   Global cont # 0:00:00.000000    0.0  %  (G)
            0              N/P   Stored proc # 0:00:00.000000    0.0  %  (T)
            0              N/P   TCP/IP Lob    0:00:00.000000    0.0  %  ( )
            0              N/P   Log io wait # 00:00:00
                                 Latch wait    00:00:00
           55   0:00:00.000523   Total cl 3    0:00:00.028766   23.1  %

          689              N/A   DB2 Ent/Exit             N/A    N/A
            0              N/A   STP Ent/Exit#            N/A    N/A

    DML ACTIVITY                   TOTAL  DML ACTIVITY                   TOTAL
    -------------------------   --------  -------------------------   --------
    SELECT                            16  OPEN                              85
    INSERT                             0  CLOSE                             85
    UPDATE                             0  PREPARE                            1
    DELETE                             0  DESCRIBE                           0
    FETCH                            405  DESCRIBE TABLE                     0
    PREPARES WITH INDEX RESTR          0

    OTHER ACTIVITY                 TOTAL  RID POOL ACTIVITY              TOTAL
    -------------------------   --------  -------------------------   --------
1                       BTHACDTL: ACCNTG THRD DETAIL, LONG                               11/18/10 15:56:04    PAGE     5

    DB2 SSID : DEFF 10.1      Location : DEFF                 Threads :        3
    ----------------------------------------------------------------------------
    Commit                            90  Successful                         0
    Rollback                           0  Not used - no storage              0
    Incremental bind                   2  Not used - max limit               0

    STORED PROCEDURE ACTIVITY      TOTAL  STORED PROCEDURE ACTIVITY      TOTAL
    -------------------------   --------  -------------------------   --------
    CALLs executed            #        0  Procedures abended        #        0
    CALLs rejected            #        0  Procedures timed out      #        0

    LOCKING ACTIVITY              TOTAL   LOCKING ACTIVITY              TOTAL
    -------------------------   --------  -------------------------   --------
    Timeout                            0  Lock   request                   320
    Deadlock                           0  Unlock request                   110
    Suspension (total)                 0  Query  request                     0
    Suspension (lock  only)            0  Change request                    10
    Suspension (latch only)            0  Other  request                     0
    Suspension (other)                 0  Claim  request                   242
    Max page or row locks              1  Claim  request - failed            0
    Lock escalation (shared)           0  Drain  request                     0
    Lock escalation (exclus)           0  Drain  request - failed            0

    DATA SHARING LOCKING           TOTAL  DATA SHARING LOCKING           TOTAL
    -------------------------   --------  -------------------------   --------
    Lock   request            #      N/P  Suspension - IRLM         #      N/P
    Change request            #      N/P  Suspension - XES          #      N/P
    Unlock request            #      N/P  Suspension - false        #      N/P
    Lock   request - XES      #      N/P  Incompatible request      #      N/P
    Change request - XES      #      N/P  Notify sent               #      N/P
    Unlock request - XES      #      N/P

    PARALLEL ACTIVITY              TOTAL  PARALLEL ACTIVITY              TOTAL
    -------------------------   --------  -------------------------   --------
    Maximum degree                     0  Fallback - cursor                  0
    Groups executed                    0  Fallback - no ESA sort             0
    Planned degree                     0  Fallback - no buffer               0
    Reduced degree                     0  Fallback - no enclave     #      N/P
    RLF limited parallelism   # NONE

    DDL ACTIVITY                  CREATE      DROP     ALTER
    -------------------------   --------  --------  --------
    TABLE                              0         1         0
    INDEX                              0         0         0
    TABLESPACE                         0         0         0
    STOGROUP                           0         0         0
    DATABASE                           0         0         0
    SYNONYM                            0         0       N/A
    VIEW                               0         0         0
    ALIAS                              0         0       N/A
    PACKAGE                          N/A         0       N/A
    SEQUENCES                          0         0         0
    TRUSTED CONTEXT                    0         0         0
    ROLE                               0         0
    PERMIT/MASK                        0         0         0
    JAR                                                    0

    LABEL ON                           0
1                       BTHACDTL: ACCNTG THRD DETAIL, LONG                               11/18/10 15:56:04    PAGE     6

    DB2 SSID : DEFF 10.1      Location : DEFF                 Threads :        3
    ----------------------------------------------------------------------------
    COMMENT ON                         0
    TRUNCATE TABLE                     0
    RENAME INDEX                       0
    MERGE TABLE                        0
    DCL ACTIVITY                   TOTAL  DCL ACTIVITY                   TOTAL
    -------------------------   --------  -------------------------   --------
    LOCK TABLE                         0  CONNECT (type 1)                   0
    GRANT                              0  CONNECT (type 2)                   2
    REVOKE                             0  RELEASE                            0
    SET CURRENT SQLID                  0  SET CONNECTION                     0
    SET HOST VARIABLE                  0  SET CURRENT DEGREE                 0
                                          SET CURRENT RULES                  0
    RESOURCE LIMIT    TABLE ID SERV UNITS   CPU SECONDS  HIGHEST CPU SECS
    ----------------- -------- ----------  ------------- ----------------
    None                              N/A       N/A           N/A

    ZIIP RELATED  TIMES
    ----------------------------------------------------------------------------
    Accumlated Cpu time consumed on an IBM ZIIP on all environments   0.000000
    Accumlated Cpu time consumed in DB2 while executing on a ZIIP     0.000000
    Accumlated Cpu time consumed in Triggers while executing on ZIIP  0.000000
    Accumlated Cpu on a standard CP for ZIIP eligible work            0.000000
    Accumlated Cpu on a ZIIP executing stored procedures              0.000000
    Accumlated Elapsed time(CLass1,2) executing Stored procedures     0.000000
    Accumlated Cpu time (Class1,2)    executing Stored procedures     0.000000

    BUFFER POOL BP0                TOTAL  HIPERPOOL BP0                  TOTAL
    -------------------------   --------  -------------------------   --------
    Getpage/Sync read IO              13  Total reads                        0
    Getpage request                  604    Successful                     N/P
    Synchronous read                  48    Unsuccessful                   N/P
    Synchronous write                  0
    Sequential prefetch                0  Total writes                       0
    List prefetch                      1    Successful                     N/P
    Dynamic prefetch                  23    Unsuccessful                   N/P
    Pages read asynchronously         43
    Buffer update (system)             0  Pages moved from HP to VP        N/P
    Unsuccessful cond getpage          0

    BUFFER POOL BP8K0              TOTAL  HIPERPOOL BP8K0                TOTAL
    -------------------------   --------  -------------------------   --------
    Getpage/Sync read IO             106  Total reads                        0
    Getpage request                  106    Successful                     N/P
    Synchronous read                   0    Unsuccessful                   N/P
    Synchronous write                  0
    Sequential prefetch                0  Total writes                       0
    List prefetch                      0    Successful                     N/P
    Dynamic prefetch                   9    Unsuccessful                   N/P
    Pages read asynchronously          0
    Buffer update (system)             0  Pages moved from HP to VP        N/P
    Unsuccessful cond getpage          0

1                       BTHACDTL: ACCNTG THRD DETAIL, LONG                               11/18/10 15:56:04    PAGE     7

    DB2 SSID : DEFF 10.1      Location : DEFF                 Threads :        3
    ----------------------------------------------------------------------------
    BUFFER POOL BP32K              TOTAL  HIPERPOOL BP32K                TOTAL
    -------------------------   --------  -------------------------   --------
    Getpage/Sync read IO             330  Total reads                        0
    Getpage request                  330    Successful                     N/P
    Synchronous read                   0    Unsuccessful                   N/P
    Synchronous write                  0
    Sequential prefetch                0  Total writes                       0
    List prefetch                      0    Successful                     N/P
    Dynamic prefetch                   1    Unsuccessful                   N/P
    Pages read asynchronously          0
    Buffer update (system)           324  Pages moved from HP to VP        N/P
    Unsuccessful cond getpage          0