Application Snapshot Application handle = 782 Application status = UOW Executing Status change time = 2007-06-05 13.02.13.084686 Application code page = 819 Application country/region code = 45 DUOW correlation token = C0A8D1C6.ID10.01FC05041304 Application name = dtexec.exe Application ID = C0A8D1C6.ID10.01FC05041304 Sequence number = 0011 TP Monitor client user ID = TP Monitor client workstation name = TP Monitor client application name = TP Monitor client accounting string = Connection request start timestamp = 2007-06-05 06.09.44.043236 Connect request completion timestamp = 2007-06-05 06.09.44.043514 Application idle time = CONNECT Authorization ID = FOO Client login ID = FOO Configuration NNAME of client = BARHOST Client database manager product ID = SQL08025 Process ID of client application = 5484 Platform of client application = NT Communication protocol of client = TCP/IP Inbound communication address = 0.1.2.3 11715 Database name = DBNAME Database path = /home/db2inst1/db2inst1/NODE0000/SQL00001/ Client database alias = DBNAME Input database alias = Last reset timestamp = Snapshot timestamp = 2007-06-05 13.04.12.703620 The highest authority level granted = Direct CREATETAB authority Direct BINDADD authority Direct CONNECT authority Direct IMPLICIT_SCHEMA authority Indirect CREATETAB authority Indirect BINDADD authority Indirect CONNECT authority Indirect LOAD authority Coordinating database partition number = 0 Current database partition number = 0 Coordinator agent process or thread ID = 2089138 Agents stolen = 0 Agents waiting on locks = 0 Maximum associated agents = 14 Priority at which application agents work = 0 Priority type = Dynamic Lock timeout (seconds) = -1 Locks held by application = 33 Lock waits since connect = 0 Time application waited on locks (ms) = 0 Deadlocks detected = 0 Lock escalations = 15 Exclusive lock escalations = 15 Number of Lock Timeouts since connected = 0 Total time UOW waited on locks (ms) = 0 Total sorts = 2748 Total sort time (ms) = Not Collected Total sort overflows = 76 Data pages copied to extended storage = 0 Index pages copied to extended storage = 0 Data pages copied from extended storage = 0 Index pages copied from extended storage = 0 Buffer pool data logical reads = 15624404 Buffer pool data physical reads = 132464 Buffer pool temporary data logical reads = 229050 Buffer pool temporary data physical reads = 0 Buffer pool data writes = 892 Buffer pool index logical reads = 25587457 Buffer pool index physical reads = 9226626 Buffer pool temporary index logical reads = 0 Buffer pool temporary index physical reads = 0 Buffer pool index writes = 1068 Total buffer pool read time (milliseconds) = 21850564 Total buffer pool write time (milliseconds)= 3456 Time waited for prefetch (ms) = 7315802 Unread prefetch pages = 0 Direct reads = 3520 Direct writes = 822 Direct read requests = 900 Direct write requests = 137 Direct reads elapsed time (ms) = 742 Direct write elapsed time (ms) = 1310 Number of SQL requests since last commit = 532946 Commit statements = 10 Rollback statements = 0 Dynamic SQL statements attempted = 636352 Static SQL statements attempted = 1735 Failed statement operations = 0 Select SQL statements executed = 276 Update/Insert/Delete statements executed = 319659 DDL statements executed = 0 Inactive stmt history memory usage (bytes) = 0 Internal automatic rebinds = 0 Internal rows deleted = 0 Internal rows inserted = 0 Internal rows updated = 0 Internal commits = 1 Internal rollbacks = 0 Internal rollbacks due to deadlock = 0 Binds/precompiles attempted = 0 Rows deleted = 418303 Rows inserted = 653675 Rows updated = 231692 Rows selected = 344 Rows read = 610251186 Rows written = 1535539 UOW log space used (Bytes) = 344984450 Previous UOW completion timestamp = 2007-06-05 07.35.22.407057 Elapsed time of last completed uow (sec.ms)= 997.319165 UOW start timestamp = 2007-06-05 07.35.22.888082 UOW stop timestamp = UOW completion status = Open remote cursors = 0 Open remote cursors with blocking = 0 Rejected Block Remote Cursor requests = 0 Accepted Block Remote Cursor requests = 0 Open local cursors = 0 Open local cursors with blocking = 0 Total User CPU Time used by agent (s) = 1032.704511 Total System CPU Time used by agent (s) = 162.303621 Host execution elapsed time = 0.020854 Package cache lookups = 10628 Package cache inserts = 164 Application section lookups = 646357 Application section inserts = 810 Catalog cache lookups = 1754 Catalog cache inserts = 18 Catalog cache overflows = 0 Catalog cache high water mark = 0 Workspace Information Shared high water mark = 81719660 Total shared overflows = 0 Total shared section inserts = 152 Total shared section lookups = 1243 Private high water mark = 2921295 Total private overflows = 0 Total private section inserts = 658 Total private section lookups = 9382 Most recent operation = Run statistics Most recent operation start timestamp = 2007-06-05 13.02.13.084691 Most recent operation stop timestamp = Agents associated with the application = 13 Number of hash joins = 138 Number of hash loops = 0 Number of hash join overflows = 0 Number of small hash join overflows = 0 Statement type = Non-SQL Statement Statement = Run statistics Section number = 0 Application creator = Package name = Consistency Token = Cursor name = Statement database partition number = 0 Statement start timestamp = 2007-06-05 13.02.13.084691 Statement stop timestamp = Elapsed time of last completed stmt(sec.ms)= 0.000000 Total Statement user CPU time = 0.000000 Total Statement system CPU time = 0.000000 SQL compiler cost estimate in timerons = 0 SQL compiler cardinality estimate = 0 Degree of parallelism requested = 0 Number of agents working on statement = 0 Number of subagents created for statement = 0 Statement sorts = 0 Total sort time = 0 Sort overflows = 0 Rows read = 0 Rows written = 0 Rows deleted = 0 Rows updated = 0 Rows inserted = 0 Rows fetched = 0 Buffer pool data logical reads = 0 Buffer pool data physical reads = 0 Buffer pool temporary data logical reads = 0 Buffer pool temporary data physical reads = 0 Buffer pool index logical reads = 0 Buffer pool index physical reads = 0 Buffer pool temporary index logical reads = 0 Buffer pool temporary index physical reads = 0 Blocking cursor = NO Statement type = Static SQL Statement Statement = Execute Section number = 25 Application creator = IPA Package name = P5255481 Consistency Token = lB3ZPJCX Package Version ID = Cursor name = Statement database partition number = 0 Statement start timestamp = 2007-06-05 13.02.13.084340 Statement stop timestamp = Elapsed time of last completed stmt(sec.ms)= 0.000000 Total Statement user CPU time = 0.000084 Total Statement system CPU time = 0.000021 SQL compiler cost estimate in timerons = 1 SQL compiler cardinality estimate = 1 Degree of parallelism requested = 1 Number of agents working on statement = 1 Number of subagents created for statement = 1 Statement sorts = 0 Total sort time = 0 Sort overflows = 0 Rows read = 0 Rows written = 0 Rows deleted = 0 Rows updated = 0 Rows inserted = 0 Rows fetched = 0 Buffer pool data logical reads = 0 Buffer pool data physical reads = 0 Buffer pool temporary data logical reads = 0 Buffer pool temporary data physical reads = 0 Buffer pool index logical reads = 0 Buffer pool index physical reads = 0 Buffer pool temporary index logical reads = 0 Buffer pool temporary index physical reads = 0 Blocking cursor = NO Statement type = Dynamic SQL Statement Statement = Execute Section number = 10 Application creator = NULLID Package name = SYSSH200 Consistency Token = SYSLVL01 Package Version ID = Cursor name = SQL_CURSH200C10 Statement database partition number = 0 Statement start timestamp = 2007-06-05 13.00.57.512976 Statement stop timestamp = Elapsed time of last completed stmt(sec.ms)= 0.000000 Total Statement user CPU time = 0.000000 Total Statement system CPU time = 0.000000 SQL compiler cost estimate in timerons = 1 SQL compiler cardinality estimate = 1 Degree of parallelism requested = 1 Number of agents working on statement = 1 Number of subagents created for statement = 1 Statement sorts = 0 Total sort time = 0 Sort overflows = 0 Rows read = 0 Rows written = 0 Rows deleted = 0 Rows updated = 0 Rows inserted = 0 Rows fetched = 0 Buffer pool data logical reads = 0 Buffer pool data physical reads = 0 Buffer pool temporary data logical reads = 0 Buffer pool temporary data physical reads = 0 Buffer pool index logical reads = 0 Buffer pool index physical reads = 0 Buffer pool temporary index logical reads = 0 Buffer pool temporary index physical reads = 0 Blocking cursor = NO Dynamic SQL statement text: CALL IPA.SP_SNIT5_PROCESS(?) Agent process/thread ID = 2089138 Agent Lock timeout (seconds) = -1 Memory usage for agent: Memory Pool Type = Application Heap Current size (bytes) = 344064 High water mark (bytes) = 344064 Configured size (bytes) = 4423680 Memory Pool Type = Statistics Heap Current size (bytes) = 16384 High water mark (bytes) = 16384 Configured size (bytes) = 18120704 Agent process/thread ID = 811066 Agent Lock timeout (seconds) = -1 Memory usage for agent: Memory Pool Type = Application Heap Current size (bytes) = 196608 High water mark (bytes) = 196608 Configured size (bytes) = 4423680 Agent process/thread ID = 3346446 Agent Lock timeout (seconds) = -1 Memory usage for agent: Memory Pool Type = Application Heap Current size (bytes) = 196608 High water mark (bytes) = 196608 Configured size (bytes) = 4423680 Agent process/thread ID = 2736138 Agent Lock timeout (seconds) = -1 Memory usage for agent: Memory Pool Type = Application Heap Current size (bytes) = 196608 High water mark (bytes) = 196608 Configured size (bytes) = 4423680 Agent process/thread ID = 1286348 Agent Lock timeout (seconds) = -1 Memory usage for agent: Memory Pool Type = Application Heap Current size (bytes) = 196608 High water mark (bytes) = 196608 Configured size (bytes) = 4423680 Agent process/thread ID = 3006586 Agent Lock timeout (seconds) = -1 Memory usage for agent: Memory Pool Type = Application Heap Current size (bytes) = 196608 High water mark (bytes) = 196608 Configured size (bytes) = 4423680 Agent process/thread ID = 3322022 Agent Lock timeout (seconds) = -1 Memory usage for agent: Memory Pool Type = Application Heap Current size (bytes) = 196608 High water mark (bytes) = 196608 Configured size (bytes) = 4423680 Agent process/thread ID = 852044 Agent Lock timeout (seconds) = -1 Memory usage for agent: Memory Pool Type = Application Heap Current size (bytes) = 196608 High water mark (bytes) = 196608 Configured size (bytes) = 4423680 Agent process/thread ID = 507960 Agent Lock timeout (seconds) = -1 Memory usage for agent: Memory Pool Type = Application Heap Current size (bytes) = 196608 High water mark (bytes) = 196608 Configured size (bytes) = 4423680 Agent process/thread ID = 2400306 Agent Lock timeout (seconds) = -1 Memory usage for agent: Memory Pool Type = Application Heap Current size (bytes) = 196608 High water mark (bytes) = 196608 Configured size (bytes) = 4423680 Agent process/thread ID = 1585194 Agent Lock timeout (seconds) = -1 Memory usage for agent: Memory Pool Type = Application Heap Current size (bytes) = 196608 High water mark (bytes) = 196608 Configured size (bytes) = 4423680 Agent process/thread ID = 3330070 Agent Lock timeout (seconds) = -1 Memory usage for agent: Memory Pool Type = Application Heap Current size (bytes) = 278528 High water mark (bytes) = 278528 Configured size (bytes) = 4423680 Agent process/thread ID = 3301418 Agent Lock timeout (seconds) = -1 Memory usage for agent: Memory Pool Type = Application Heap Current size (bytes) = 196608 High water mark (bytes) = 196608 Configured size (bytes) = 4423680 ===================================================================================== Application Lock Snapshot Snapshot timestamp = 2007-06-05 13.03.41.242138 Application handle = 782 Application ID = C0A8D1C6.ID10.01FC05041304 Sequence number = 0011 Application name = dtexec.exe CONNECT Authorization ID = FOO Application status = UOW Executing Status change time = 2007-06-05 13.02.13.084686 Application code page = 819 Locks held = 33 Total wait time (ms) = 0 List Of Locks Lock Name = 0x0000024C0000001500017A0056 Lock Attributes = 0x00000000 Release Flags = 0x40000000 Lock Count = 1 Hold Count = 0 Lock Object Name = 0 Object Type = Internal Variation Lock Mode = S Lock Name = 0x0000024C0000001400017A0056 Lock Attributes = 0x00000000 Release Flags = 0x40000000 Lock Count = 1 Hold Count = 0 Lock Object Name = 0 Object Type = Internal Variation Lock Mode = S Lock Name = 0x000002820000000100012F0056 Lock Attributes = 0x00000000 Release Flags = 0x40000000 Lock Count = 2 Hold Count = 0 Lock Object Name = 0 Object Type = Internal Variation Lock Mode = S Lock Name = 0x000001D6000000010001890056 Lock Attributes = 0x00000000 Release Flags = 0x40000000 Lock Count = 3 Hold Count = 0 Lock Object Name = 0 Object Type = Internal Variation Lock Mode = S Lock Name = 0x000001D9000000010001E40056 Lock Attributes = 0x00000000 Release Flags = 0x40000000 Lock Count = 4 Hold Count = 0 Lock Object Name = 0 Object Type = Internal Variation Lock Mode = S Lock Name = 0x00000174000000010001A50056 Lock Attributes = 0x00000000 Release Flags = 0x40000000 Lock Count = 3 Hold Count = 0 Lock Object Name = 0 Object Type = Internal Variation Lock Mode = S Lock Name = 0x0000013A000000010001530056 Lock Attributes = 0x00000000 Release Flags = 0x40000000 Lock Count = 4 Hold Count = 0 Lock Object Name = 0 Object Type = Internal Variation Lock Mode = S Lock Name = 0x00000132000000010001E90056 Lock Attributes = 0x00000000 Release Flags = 0x40000000 Lock Count = 3 Hold Count = 0 Lock Object Name = 0 Object Type = Internal Variation Lock Mode = S Lock Name = 0x0000000200001E056CE7AF2043 Lock Attributes = 0x00000000 Release Flags = 0x40000000 Lock Count = 255 Hold Count = 0 Lock Object Name = 0 Object Type = Internal Catalog Cache Lock Mode = X Lock Name = 0x00010000000000006CE7AF2043 Lock Attributes = 0x00000000 Release Flags = 0x40000000 Lock Count = 255 Hold Count = 0 Lock Object Name = 0 Object Type = Internal Catalog Cache Lock Mode = X Lock Name = 0x000000020000BD056CF08A9043 Lock Attributes = 0x00000000 Release Flags = 0xC0000000 Lock Count = 255 Hold Count = 0 Lock Object Name = 0 Object Type = Internal Catalog Cache Lock Mode = X Lock Name = 0x00010000000000006CF08A9043 Lock Attributes = 0x00000000 Release Flags = 0xC0000000 Lock Count = 255 Hold Count = 0 Lock Object Name = 0 Object Type = Internal Catalog Cache Lock Mode = X Lock Name = 0x50353235353438319C49698A41 Lock Attributes = 0x00000000 Release Flags = 0x40000000 Lock Count = 1 Hold Count = 0 Lock Object Name = 0 Object Type = Internal Plan Lock Mode = S Lock Name = 0x00000054000000076CE75AE043 Lock Attributes = 0x00000000 Release Flags = 0x40000000 Lock Count = 53 Hold Count = 1 Lock Object Name = 0 Object Type = Internal Catalog Cache Lock Mode = S Lock Name = 0x0000024C0000000200017A0056 Lock Attributes = 0x00000000 Release Flags = 0x40000000 Lock Count = 1 Hold Count = 0 Lock Object Name = 0 Object Type = Internal Variation Lock Mode = S Lock Name = 0x000001F9000000010001340056 Lock Attributes = 0x00000000 Release Flags = 0x40000000 Lock Count = 2 Hold Count = 0 Lock Object Name = 0 Object Type = Internal Variation Lock Mode = S Lock Name = 0x535953534832303028EFECDC41 Lock Attributes = 0x00000000 Release Flags = 0x40000000 Lock Count = 1 Hold Count = 0 Lock Object Name = 0 Object Type = Internal Plan Lock Mode = S Lock Name = 0x00090210000000000000000054 Lock Attributes = 0x00000002 Release Flags = 0x40000000 Lock Count = 54 Hold Count = 0 Lock Object Name = 528 Object Type = Table Tablespace Name = S_IPA Table Schema = IPA Table Name = T_SNIT5_DIAGN Mode = X Lock Name = 0x00090206000000000000000054 Lock Attributes = 0x00000002 Release Flags = 0x40000000 Lock Count = 54 Hold Count = 0 Lock Object Name = 518 Object Type = Table Tablespace Name = S_IPA Table Schema = IPA Table Name = T_SNIT5_IMP_HELP Mode = X Lock Name = 0x0009020B000000000000000054 Lock Attributes = 0x00000002 Release Flags = 0x40000000 Lock Count = 54 Hold Count = 0 Lock Object Name = 523 Object Type = Table Tablespace Name = S_IPA Table Schema = IPA Table Name = T_SNIT5_IMP_SLUTF Mode = X Lock Name = 0x00000002000000000000000054 Lock Attributes = 0x00000002 Release Flags = 0xC0000000 Lock Count = 255 Hold Count = 0 Lock Object Name = 2 Object Type = Table Tablespace Name = SYSCATSPACE Table Schema = SYSIBM Table Name = SYSTABLES Mode = X Lock Name = 0x00090211000000000000000054 Lock Attributes = 0x00000002 Release Flags = 0x40000000 Lock Count = 54 Hold Count = 0 Lock Object Name = 529 Object Type = Table Tablespace Name = S_IPA Table Schema = IPA Table Name = T_SNIT5_TILKD Mode = X Lock Name = 0x00000003000000000000000054 Lock Attributes = 0x00000012 Release Flags = 0x40000000 Lock Count = 255 Hold Count = 0 Lock Object Name = 3 Object Type = Table Tablespace Name = SYSCATSPACE Table Schema = SYSIBM Table Name = SYSCOLUMNS Mode = X Lock Name = 0x0009020C000000000000000054 Lock Attributes = 0x00000002 Release Flags = 0x40000000 Lock Count = 1 Hold Count = 0 Lock Object Name = 524 Object Type = Table Tablespace Name = S_IPA Table Schema = IPA Table Name = T_SNIT5_KILDEFIL Mode = X Lock Name = 0x00090207000000000000000054 Lock Attributes = 0x00000002 Release Flags = 0xC0000000 Lock Count = 255 Hold Count = 0 Lock Object Name = 519 Object Type = Table Tablespace Name = S_IPA Table Schema = IPA Table Name = T_SNIT5_IMP_PKONT Mode = X Lock Name = 0x00000004000000000000000054 Lock Attributes = 0x00000012 Release Flags = 0x40000000 Lock Count = 210 Hold Count = 0 Lock Object Name = 4 Object Type = Table Tablespace Name = SYSCATSPACE Table Schema = SYSIBM Table Name = SYSINDEXES Mode = X Lock Name = 0x00090208000000000000000054 Lock Attributes = 0x00000002 Release Flags = 0x40000000 Lock Count = 54 Hold Count = 0 Lock Object Name = 520 Object Type = Table Tablespace Name = S_IPA Table Schema = IPA Table Name = T_SNIT5_IMP_BETOP Mode = X Lock Name = 0x0009020E000000000000000054 Lock Attributes = 0x00000002 Release Flags = 0xC0000000 Lock Count = 108 Hold Count = 0 Lock Object Name = 526 Object Type = Table Tablespace Name = S_IPA Table Schema = IPA Table Name = T_SNIT5_PKONT Mode = X Lock Name = 0x00090209000000000000000054 Lock Attributes = 0x00000002 Release Flags = 0x40000000 Lock Count = 54 Hold Count = 0 Lock Object Name = 521 Object Type = Table Tablespace Name = S_IPA Table Schema = IPA Table Name = T_SNIT5_IMP_DIAGN Mode = X Lock Name = 0x0009020F000000000000000054 Lock Attributes = 0x00000002 Release Flags = 0x40000000 Lock Count = 54 Hold Count = 0 Lock Object Name = 527 Object Type = Table Tablespace Name = S_IPA Table Schema = IPA Table Name = T_SNIT5_BETOP Mode = X Lock Name = 0x0000001A000000000000000054 Lock Attributes = 0x00000000 Release Flags = 0x40000000 Lock Count = 105 Hold Count = 0 Lock Object Name = 26 Object Type = Table Tablespace Name = SYSCATSPACE Table Schema = SYSIBM Table Name = SYSCOLDIST Mode = IX Lock Name = 0x00090205000000000000000054 Lock Attributes = 0x00000002 Release Flags = 0x40000000 Lock Count = 54 Hold Count = 0 Lock Object Name = 517 Object Type = Table Tablespace Name = S_IPA Table Schema = IPA Table Name = T_SNIT5_IMP_START Mode = X Lock Name = 0x0009020A000000000000000054 Lock Attributes = 0x00000002 Release Flags = 0x40000000 Lock Count = 54 Hold Count = 0 Lock Object Name = 522 Object Type = Table Tablespace Name = S_IPA Table Schema = IPA Table Name = T_SNIT5_IMP_TILKD Mode = X