Application Snapshot Application handle = 365 Application status = Compiling Status change time = 05/22/2008 10:39:24.277088 Application code page = 819 Application country/region code = 1 DUOW correlation token = *LOCAL.db2inst1.080522002829 Application name = db2bp Application ID = *LOCAL.db2inst1.080522002829 Sequence number = 00133 TP Monitor client user ID = TP Monitor client workstation name = TP Monitor client application name = TP Monitor client accounting string = Connection request start timestamp = 05/22/2008 02:28:29.650063 Connect request completion timestamp = 05/22/2008 02:28:29.650570 Application idle time = 1 second CONNECT Authorization ID = USERNAME Client login ID = USERNAME Configuration NNAME of client = foo.bar.baz Client database manager product ID = SQL09050 Process ID of client application = 12676 Platform of client application = LINUXAMD64 Communication protocol of client = Local Client Inbound communication address = *LOCAL.db2inst1 Database name = SOMEDB Database path = /data/db2/databases/db2inst1/NODE0000/SQL00003/ Client database alias = SOMEDB Input database alias = Last reset timestamp = Snapshot timestamp = 05/22/2008 10:39:25.826970 Authorization level granted = User authority: DBADM authority CREATETAB authority BINDADD authority CONNECT authority CREATE_NOT_FENC authority LOAD authority IMPLICIT_SCHEMA authority CREATE_EXT_RT authority QUIESCE_CONN authority Group authority: CREATETAB authority BINDADD authority CONNECT authority IMPLICIT_SCHEMA authority Coordinating database partition number = 0 Current database partition number = 0 Coordinator agent process or thread ID = 89 Current Workload ID = 1 Agents stolen = 0 Agents waiting on locks = 0 Maximum associated agents = 1 Priority at which application agents work = 0 Priority type = Dynamic Lock timeout (seconds) = -1 Locks held by application = 11 Lock waits since connect = 0 Time application waited on locks (ms) = 0 Deadlocks detected = 0 Lock escalations = 0 Exclusive lock escalations = 0 Number of Lock Timeouts since connected = 0 Total time UOW waited on locks (ms) = 0 Total sorts = 1180 Total sort time (ms) = 15021 Total sort overflows = 3 Buffer pool data logical reads = 289566148 Buffer pool data physical reads = 5494978 Buffer pool temporary data logical reads = 275826611 Buffer pool temporary data physical reads = 0 Buffer pool data writes = 89054 Buffer pool index logical reads = 103363411 Buffer pool index physical reads = 184065 Buffer pool temporary index logical reads = 0 Buffer pool temporary index physical reads = 0 Buffer pool index writes = 14366 Buffer pool xda logical reads = 0 Buffer pool xda physical reads = 0 Buffer pool temporary xda logical reads = 0 Buffer pool temporary xda physical reads = 0 Buffer pool xda writes = 0 Total buffer pool read time (milliseconds) = 9390114 Total buffer pool write time (milliseconds)= 460804 Time waited for prefetch (ms) = 3168420 Unread prefetch pages = 0 Direct reads = 7950 Direct writes = 0 Direct read requests = 1080 Direct write requests = 0 Direct reads elapsed time (ms) = 2446 Direct write elapsed time (ms) = 0 Number of SQL requests since last commit = 8263997 Commit statements = 144 Rollback statements = 0 Dynamic SQL statements attempted = 2250 Static SQL statements attempted = 107366703 Failed statement operations = 6759152 Select SQL statements executed = 6759593 Xquery statements executed = 0 Update/Insert/Delete statements executed = 48 DDL statements executed = 50 Inactive stmt history memory usage (bytes) = 0 Internal automatic rebinds = 0 Internal rows deleted = 0 Internal rows inserted = 31787322 Internal rows updated = 0 Internal commits = 1 Internal rollbacks = 0 Internal rollbacks due to deadlock = 0 Binds/precompiles attempted = 0 Rows deleted = 0 Rows inserted = 115686674 Rows updated = 0 Rows selected = 100608198 Rows read = 325394516 Rows written = 256695619 UOW log space used (Bytes) = 922324 Previous UOW completion timestamp = 05/22/2008 10:16:18.954018 Elapsed time of last completed uow (sec.ms)= 0.482214 UOW start timestamp = 05/22/2008 10:16:18.957981 UOW stop timestamp = UOW completion status = Open remote cursors = 0 Open remote cursors with blocking = 0 Rejected Block Remote Cursor requests = 156 Accepted Block Remote Cursor requests = 237 Open local cursors = 0 Open local cursors with blocking = 0 Total User CPU Time used by agent (s) = 10892.689184 Total System CPU Time used by agent (s) = 0.000000 Host execution elapsed time = 24930.354380 Package cache lookups = 107367402 Package cache inserts = 586 Application section lookups = 107368809 Application section inserts = 515 Catalog cache lookups = 187699855 Catalog cache inserts = 92 Catalog cache overflows = 0 Catalog cache high water mark = 0 Workspace Information Shared high water mark = 0 Total shared overflows = 0 Total shared section inserts = 0 Total shared section lookups = 0 Private high water mark = 0 Total private overflows = 0 Total private section inserts = 0 Total private section lookups = 0 Most recent operation = Execute Most recent operation start timestamp = 05/22/2008 10:39:24.277090 Most recent operation stop timestamp = 05/22/2008 10:39:24.277110 Agents associated with the application = 1 Number of hash joins = 0 Number of hash loops = 0 Number of hash join overflows = 0 Number of small hash join overflows = 0 Number of OLAP functions = 0 Number of OLAP function overflows = 0 Statement type = Static SQL Statement Statement = Execute Section number = 1 Application creator = FGR Package name = P1182604 Consistency Token = EAaSLICY Package Version ID = Cursor name = Statement database partition number = 0 Statement start timestamp = 05/22/2008 10:39:24.277090 Statement stop timestamp = 05/22/2008 10:39:24.277110 Elapsed time of last completed stmt(sec.ms)= 0.000020 Total Statement user CPU time = 0.000016 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 Buffer pool xda logical reads = 0 Buffer pool xda physical reads = 0 Buffer pool temporary xda logical reads = 0 Buffer pool temporary xda physical reads = 0 Blocking cursor = NO Statement type = Dynamic SQL Statement Statement = Execute Immediate Section number = 203 Application creator = NULLID Package name = SQLC2G13 Consistency Token = AAAAANGX Package Version ID = Cursor name = Statement database partition number = 0 Statement start timestamp = 05/22/2008 10:16:18.993471 Statement stop timestamp = Elapsed time of last completed stmt(sec.ms)= 0.000000 Total Statement user CPU time = 1137.767240 Total Statement system CPU time = 0.000000 SQL compiler cost estimate in timerons = 344921312 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 = 24922274 Rows written = 14953320 Rows deleted = 0 Rows updated = 0 Rows inserted = 4984440 Rows fetched = 0 Buffer pool data logical reads = 10450052 Buffer pool data physical reads = 37059 Buffer pool temporary data logical reads = 24922200 Buffer pool temporary data physical reads = 0 Buffer pool index logical reads = 20030324 Buffer pool index physical reads = 3249 Buffer pool temporary index logical reads = 0 Buffer pool temporary index physical reads = 0 Buffer pool xda logical reads = 0 Buffer pool xda physical reads = 0 Buffer pool temporary xda logical reads = 0 Buffer pool temporary xda physical reads = 0 Blocking cursor = NO Dynamic SQL statement text: INSERT INTO sche_util.import_view_1 SELECT * FROM sche_util.staging_table_1 Agent process/thread ID = 89 Memory usage for application: Memory Pool Type = Application Heap Current size (bytes) = 196608 High water mark (bytes) = 327680 Configured size (bytes) = 1048576 Agent process/thread ID = 89 Agent Lock timeout (seconds) = -1 Memory usage for agent: Memory Pool Type = Other Memory Current size (bytes) = 393216 High water mark (bytes) = 2424832 Configured size (bytes) = 4508876800