Application Snapshot Application handle = 146 Application status = UOW Waiting Status change time = 08/10/2008 16:28:15.522825 Application code page = 1252 Application country/region code = 1 DUOW correlation token = *LOCAL.DB2.080810204539 Application name = db2bp.exe Application ID = *LOCAL.DB2.080810204539 Sequence number = 0001 TP Monitor client user ID = TP Monitor client workstation name = TP Monitor client application name = TP Monitor client accounting string = Connection request start timestamp = 08/10/2008 15:45:21.142988 Connect request completion timestamp = 08/10/2008 15:45:21.147141 Application idle time = CONNECT Authorization ID = SCOTT HAYES Client login ID = SCOTT HAYES Configuration NNAME of client = BROJANITOR Client database manager product ID = SQL08027 Process ID of client application = 5428 Platform of client application = NT Communication protocol of client = Local Client Inbound communication address = *LOCAL.DB2 Database name = PROD Database path = C:\DB2\NODE0000\SQL00002\ Client database alias = PROD Input database alias = PROD Last reset timestamp = Snapshot timestamp = 08/10/2008 16:28:15.518356 The highest authority level granted = Indirect SYSADM authority Indirect CREATETAB authority Indirect BINDADD authority Indirect CONNECT authority Indirect IMPLICIT_SCHEMA authority Coordinating database partition number = 0 Current database partition number = 0 Coordinator agent process or thread ID = 4288 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) = 30 Locks held by application = 10 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 = 0 Total sort time (ms) = 0 Total sort overflows = 0 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 = 2256114 Buffer pool data physical reads = 22 Buffer pool temporary data logical reads = 0 Buffer pool temporary data physical reads = 0 Buffer pool data writes = 0 Buffer pool index logical reads = 10000205 Buffer pool index physical reads = 7 Buffer pool temporary index logical reads = 0 Buffer pool temporary index physical reads = 0 Buffer pool index writes = 0 Total buffer pool read time (milliseconds) = 85 Total buffer pool write time (milliseconds)= 0 Time waited for prefetch (ms) = 0 Unread prefetch pages = 0 Direct reads = 0 Direct writes = 0 Direct read requests = 0 Direct write requests = 0 Direct reads elapsed time (ms) = 0 Direct write elapsed time (ms) = 0 Number of SQL requests since last commit = 1665459 Commit statements = 0 Rollback statements = 0 Dynamic SQL statements attempted = 1665459 Static SQL statements attempted = 0 Failed statement operations = 0 Select SQL statements executed = 1 Update/Insert/Delete statements executed = 0 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 = 0 Rows inserted = 0 Rows updated = 0 Rows selected = 1665454 Rows read = 1673216 Rows written = 0 UOW log space used (Bytes) = 0 Previous UOW completion timestamp = 08/10/2008 15:45:21.147141 Elapsed time of last completed uow (sec.ms)= 0.000000 UOW start timestamp = 08/10/2008 15:46:46.403653 UOW stop timestamp = UOW completion status = Open remote cursors = 0 Open remote cursors with blocking = 0 Rejected Block Remote Cursor requests = 1 Accepted Block Remote Cursor requests = 0 Open local cursors = 1 Open local cursors with blocking = 0 Total User CPU Time used by agent (s) = 54.796875 Total System CPU Time used by agent (s) = 20.265625 Host execution elapsed time = 0.000043 Package cache lookups = 2 Package cache inserts = 1 Application section lookups = 1665459 Application section inserts = 1 Catalog cache lookups = 18 Catalog cache inserts = 0 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 = 45290 Total private overflows = 0 Total private section inserts = 1 Total private section lookups = 1 Most recent operation = Fetch Cursor name = SQLCUR201 Most recent operation start timestamp = 08/10/2008 15:46:46.467942 Most recent operation stop timestamp = 08/10/2008 16:28:15.522823 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 Statement type = Dynamic SQL Statement Statement = Fetch Section number = 201 Application creator = NULLID Package name = SQLC2E07 Consistency Token = AAAAAcEU Package Version ID = Cursor name = SQLCUR201 Statement database partition number = 0 Statement start timestamp = 08/10/2008 15:46:46.467942 Statement stop timestamp = 08/10/2008 16:28:15.522823 Elapsed time of last completed stmt(sec.ms)= 0.000043 Total Statement user CPU time = 54.750000 Total Statement system CPU time = 20.265625 SQL compiler cost estimate in timerons = 4576267 SQL compiler cardinality estimate = 261029312 Degree of parallelism requested = 1 Number of agents working on statement = 0 Number of subagents created for statement = 1 Statement sorts = 0 Total sort time = 0 Sort overflows = 0 Rows read = 1673216 Rows written = 0 Rows deleted = 0 Rows updated = 0 Rows inserted = 0 Rows fetched = 1665454 Buffer pool data logical reads = 2256114 Buffer pool data physical reads = 22 Buffer pool temporary data logical reads = 0 Buffer pool temporary data physical reads = 0 Buffer pool index logical reads = 10000205 Buffer pool index physical reads = 7 Buffer pool temporary index logical reads = 0 Buffer pool temporary index physical reads = 0 Blocking cursor = NO Dynamic SQL statement text: select a.*, b.*, c.* from syscat.tables a, syscat.columns b, syscat.indexes c order by 2 desc Agent process/thread ID = 4288 Agent process/thread ID = 4288 Agent Lock timeout (seconds) = 30 Memory usage for agent: Memory Pool Type = Other Memory Current size (bytes) = 5750784 High water mark (bytes) = 7536640 Configured size (bytes) = 2145386496 Memory Pool Type = Application Control Heap Current size (bytes) = 16384 High water mark (bytes) = 16384 Configured size (bytes) = 704512 Memory Pool Type = Application Heap Current size (bytes) = 360448 High water mark (bytes) = 360448 Configured size (bytes) = 1277952 Application Snapshot Application handle = 1413 Application status = UOW Waiting Status change time = 08/10/2008 15:42:59.752123 Application code page = 1252 Application country/region code = 1 DUOW correlation token = *LOCAL.DB2.080810202926 Application name = db2bp.exe Application ID = *LOCAL.DB2.080810202926 Sequence number = 0004 TP Monitor client user ID = TP Monitor client workstation name = TP Monitor client application name = TP Monitor client accounting string = Connection request start timestamp = 08/10/2008 15:29:12.669121 Connect request completion timestamp = 08/10/2008 15:29:12.673890 Application idle time = 45 minutes 16 seconds CONNECT Authorization ID = SCOTT HAYES Client login ID = SCOTT HAYES Configuration NNAME of client = BROJANITOR Client database manager product ID = SQL08027 Process ID of client application = 5992 Platform of client application = NT Communication protocol of client = Local Client Inbound communication address = *LOCAL.DB2 Database name = PROD Database path = C:\DB2\NODE0000\SQL00002\ Client database alias = PROD Input database alias = PROD Last reset timestamp = Snapshot timestamp = 08/10/2008 16:28:15.518356 The highest authority level granted = Indirect SYSADM authority Indirect CREATETAB authority Indirect BINDADD authority Indirect CONNECT authority Indirect IMPLICIT_SCHEMA authority Coordinating database partition number = 0 Current database partition number = 0 Coordinator agent process or thread ID = 2968 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) = 30 Locks held by application = 0 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 = 5 Total sort time (ms) = 2 Total sort overflows = 0 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 = 107 Buffer pool data physical reads = 3 Buffer pool temporary data logical reads = 0 Buffer pool temporary data physical reads = 0 Buffer pool data writes = 0 Buffer pool index logical reads = 10 Buffer pool index physical reads = 2 Buffer pool temporary index logical reads = 0 Buffer pool temporary index physical reads = 0 Buffer pool index writes = 0 Total buffer pool read time (milliseconds) = 40 Total buffer pool write time (milliseconds)= 0 Time waited for prefetch (ms) = 9 Unread prefetch pages = 0 Direct reads = 32 Direct writes = 0 Direct read requests = 2 Direct write requests = 0 Direct reads elapsed time (ms) = 14 Direct write elapsed time (ms) = 0 Number of SQL requests since last commit = 0 Commit statements = 3 Rollback statements = 0 Dynamic SQL statements attempted = 13 Static SQL statements attempted = 3 Failed statement operations = 0 Select SQL statements executed = 3 Update/Insert/Delete statements executed = 0 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 = 0 Rows inserted = 0 Rows updated = 0 Rows selected = 614 Rows read = 617 Rows written = 0 UOW log space used (Bytes) = 0 Previous UOW completion timestamp = 08/10/2008 15:30:55.632542 Elapsed time of last completed uow (sec.ms)= 0.016685 UOW start timestamp = 08/10/2008 15:42:59.735428 UOW stop timestamp = 08/10/2008 15:42:59.752113 UOW completion status = Committed - Commit Statement Open remote cursors = 0 Open remote cursors with blocking = 0 Rejected Block Remote Cursor requests = 0 Accepted Block Remote Cursor requests = 3 Open local cursors = 0 Open local cursors with blocking = 0 Total User CPU Time used by agent (s) = 0.000000 Total System CPU Time used by agent (s) = 0.000000 Host execution elapsed time = 0.000020 Package cache lookups = 7 Package cache inserts = 2 Application section lookups = 13 Application section inserts = 2 Catalog cache lookups = 15 Catalog cache inserts = 1 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 = 22317 Total private overflows = 0 Total private section inserts = 2 Total private section lookups = 3 Most recent operation = Static Commit Most recent operation start timestamp = 08/10/2008 15:42:59.751492 Most recent operation stop timestamp = 08/10/2008 15:42:59.751512 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 Statement type = Static SQL Statement Statement = Static Commit Section number = 0 Application creator = Package name = Consistency Token = Cursor name = Statement database partition number = 0 Statement start timestamp = 08/10/2008 15:42:59.751492 Statement stop timestamp = 08/10/2008 15:42:59.751512 Elapsed time of last completed stmt(sec.ms)= 0.000020 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 = 1 Number of agents working on statement = 0 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 Agent process/thread ID = 2968 Agent Lock timeout (seconds) = 30 Memory usage for agent: Memory Pool Type = Other Memory Current size (bytes) = 5472256 High water mark (bytes) = 7585792 Configured size (bytes) = 2145386496 Memory Pool Type = Application Control Heap Current size (bytes) = 16384 High water mark (bytes) = 16384 Configured size (bytes) = 704512 Memory Pool Type = Application Heap Current size (bytes) = 212992 High water mark (bytes) = 212992 Configured size (bytes) = 1277952 Application Snapshot Application handle = 28 Application status = UOW Waiting Status change time = 08/10/2008 16:20:51.506178 Application code page = 1252 Application country/region code = 1 DUOW correlation token = *LOCAL.DB2.080810172815 Application name = dbievm.exe Application ID = *LOCAL.DB2.080810172815 Sequence number = 0032 TP Monitor client user ID = TP Monitor client workstation name = TP Monitor client application name = TP Monitor client accounting string = Connection request start timestamp = 08/10/2008 12:28:13.758777 Connect request completion timestamp = 08/10/2008 12:28:13.763939 Application idle time = 7 minutes 24 seconds CONNECT Authorization ID = DB2V82 Client login ID = SYSTEM Configuration NNAME of client = BROJANITOR Client database manager product ID = SQL08027 Process ID of client application = 3004 Platform of client application = NT Communication protocol of client = Local Client Inbound communication address = *LOCAL.DB2 Database name = PROD Database path = C:\DB2\NODE0000\SQL00002\ Client database alias = PROD Input database alias = PROD Last reset timestamp = Snapshot timestamp = 08/10/2008 16:28:15.518356 The highest authority level granted = Direct DBADM authority Direct CREATETAB authority Direct BINDADD authority Direct CONNECT authority Direct CREATE_NOT_FENC authority Direct LOAD authority Direct IMPLICIT_SCHEMA authority Direct CREATE_EXT_RT authority Direct QUIESCE_CONN authority Indirect SYSADM authority Indirect CREATETAB authority Indirect BINDADD authority Indirect CONNECT authority Indirect IMPLICIT_SCHEMA authority Coordinating database partition number = 0 Current database partition number = 0 Coordinator agent process or thread ID = 2988 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) = 30 Locks held by application = 0 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 = 0 Total sort time (ms) = 0 Total sort overflows = 0 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 = 37 Buffer pool data physical reads = 0 Buffer pool temporary data logical reads = 0 Buffer pool temporary data physical reads = 0 Buffer pool data writes = 0 Buffer pool index logical reads = 53 Buffer pool index physical reads = 0 Buffer pool temporary index logical reads = 0 Buffer pool temporary index physical reads = 0 Buffer pool index writes = 0 Total buffer pool read time (milliseconds) = 0 Total buffer pool write time (milliseconds)= 0 Time waited for prefetch (ms) = 0 Unread prefetch pages = 0 Direct reads = 52 Direct writes = 2 Direct read requests = 26 Direct write requests = 1 Direct reads elapsed time (ms) = 3 Direct write elapsed time (ms) = 0 Number of SQL requests since last commit = 0 Commit statements = 31 Rollback statements = 0 Dynamic SQL statements attempted = 51 Static SQL statements attempted = 31 Failed statement operations = 0 Select SQL statements executed = 23 Update/Insert/Delete statements executed = 0 DDL statements executed = 2 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 = 0 Rows inserted = 0 Rows updated = 0 Rows selected = 23 Rows read = 28 Rows written = 4 UOW log space used (Bytes) = 0 Previous UOW completion timestamp = 08/10/2008 16:06:51.662276 Elapsed time of last completed uow (sec.ms)= 0.001625 UOW start timestamp = 08/10/2008 16:20:51.504543 UOW stop timestamp = 08/10/2008 16:20:51.506168 UOW completion status = Committed - Commit Statement Open remote cursors = 0 Open remote cursors with blocking = 0 Rejected Block Remote Cursor requests = 0 Accepted Block Remote Cursor requests = 23 Open local cursors = 0 Open local cursors with blocking = 0 Total User CPU Time used by agent (s) = 0.015625 Total System CPU Time used by agent (s) = 0.000000 Host execution elapsed time = 0.000019 Package cache lookups = 30 Package cache inserts = 7 Application section lookups = 51 Application section inserts = 5 Catalog cache lookups = 8 Catalog cache inserts = 0 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 = 16284 Total private overflows = 0 Total private section inserts = 5 Total private section lookups = 27 Most recent operation = Static Commit Most recent operation start timestamp = 08/10/2008 16:20:51.505545 Most recent operation stop timestamp = 08/10/2008 16:20:51.505564 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 Statement type = Static SQL Statement Statement = Static Commit Section number = 0 Application creator = Package name = Consistency Token = Cursor name = Statement database partition number = 0 Statement start timestamp = 08/10/2008 16:20:51.505545 Statement stop timestamp = 08/10/2008 16:20:51.505564 Elapsed time of last completed stmt(sec.ms)= 0.000019 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 = 1 Number of agents working on statement = 0 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 Agent process/thread ID = 2988 Agent Lock timeout (seconds) = 30 Memory usage for agent: Memory Pool Type = Other Memory Current size (bytes) = 5406720 High water mark (bytes) = 7520256 Configured size (bytes) = 2145386496 Memory Pool Type = Application Heap Current size (bytes) = 212992 High water mark (bytes) = 212992 Configured size (bytes) = 1277952 Memory Pool Type = Application Control Heap Current size (bytes) = 16384 High water mark (bytes) = 16384 Configured size (bytes) = 704512 Application Snapshot Application handle = 26 Application status = UOW Waiting Status change time = 08/10/2008 15:06:51.645966 Application code page = 1252 Application country/region code = 1 DUOW correlation token = *LOCAL.DB2.080810172813 Application name = dbievm.exe Application ID = *LOCAL.DB2.080810172813 Sequence number = 0013 TP Monitor client user ID = TP Monitor client workstation name = TP Monitor client application name = TP Monitor client accounting string = Connection request start timestamp = 08/10/2008 12:28:12.254983 Connect request completion timestamp = 08/10/2008 12:28:12.415685 Application idle time = 1 hour 21 minutes 24 seconds CONNECT Authorization ID = DB2V82 Client login ID = SYSTEM Configuration NNAME of client = BROJANITOR Client database manager product ID = SQL08027 Process ID of client application = 3004 Platform of client application = NT Communication protocol of client = Local Client Inbound communication address = *LOCAL.DB2 Database name = PROD Database path = C:\DB2\NODE0000\SQL00002\ Client database alias = PROD Input database alias = PROD Last reset timestamp = Snapshot timestamp = 08/10/2008 16:28:15.518356 The highest authority level granted = Direct DBADM authority Direct CREATETAB authority Direct BINDADD authority Direct CONNECT authority Direct CREATE_NOT_FENC authority Direct LOAD authority Direct IMPLICIT_SCHEMA authority Direct CREATE_EXT_RT authority Direct QUIESCE_CONN authority Indirect SYSADM authority Indirect CREATETAB authority Indirect BINDADD authority Indirect CONNECT authority Indirect IMPLICIT_SCHEMA authority Coordinating database partition number = 0 Current database partition number = 0 Coordinator agent process or thread ID = 3484 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) = 30 Locks held by application = 0 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 = 0 Total sort time (ms) = 0 Total sort overflows = 0 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 = 84 Buffer pool data physical reads = 23 Buffer pool temporary data logical reads = 0 Buffer pool temporary data physical reads = 0 Buffer pool data writes = 0 Buffer pool index logical reads = 112 Buffer pool index physical reads = 58 Buffer pool temporary index logical reads = 0 Buffer pool temporary index physical reads = 0 Buffer pool index writes = 0 Total buffer pool read time (milliseconds) = 0 Total buffer pool write time (milliseconds)= 0 Time waited for prefetch (ms) = 0 Unread prefetch pages = 0 Direct reads = 62 Direct writes = 2 Direct read requests = 20 Direct write requests = 1 Direct reads elapsed time (ms) = 30 Direct write elapsed time (ms) = 30 Number of SQL requests since last commit = 0 Commit statements = 12 Rollback statements = 0 Dynamic SQL statements attempted = 13 Static SQL statements attempted = 12 Failed statement operations = 0 Select SQL statements executed = 4 Update/Insert/Delete statements executed = 0 DDL statements executed = 2 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 = 0 Rows inserted = 0 Rows updated = 0 Rows selected = 4 Rows read = 33 Rows written = 4 UOW log space used (Bytes) = 0 Previous UOW completion timestamp = 08/10/2008 14:31:55.106547 Elapsed time of last completed uow (sec.ms)= 0.001698 UOW start timestamp = 08/10/2008 15:06:51.644255 UOW stop timestamp = 08/10/2008 15:06:51.645953 UOW completion status = Committed - Commit Statement Open remote cursors = 0 Open remote cursors with blocking = 0 Rejected Block Remote Cursor requests = 0 Accepted Block Remote Cursor requests = 4 Open local cursors = 0 Open local cursors with blocking = 0 Total User CPU Time used by agent (s) = 0.015625 Total System CPU Time used by agent (s) = 0.000000 Host execution elapsed time = 0.000019 Package cache lookups = 11 Package cache inserts = 7 Application section lookups = 13 Application section inserts = 5 Catalog cache lookups = 9 Catalog cache inserts = 7 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 = 16284 Total private overflows = 0 Total private section inserts = 5 Total private section lookups = 8 Most recent operation = Static Commit Most recent operation start timestamp = 08/10/2008 15:06:51.645282 Most recent operation stop timestamp = 08/10/2008 15:06:51.645301 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 Statement type = Static SQL Statement Statement = Static Commit Section number = 0 Application creator = Package name = Consistency Token = Cursor name = Statement database partition number = 0 Statement start timestamp = 08/10/2008 15:06:51.645282 Statement stop timestamp = 08/10/2008 15:06:51.645301 Elapsed time of last completed stmt(sec.ms)= 0.000019 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 = 1 Number of agents working on statement = 0 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 Agent process/thread ID = 3484 Agent Lock timeout (seconds) = 30 Memory usage for agent: Memory Pool Type = Other Memory Current size (bytes) = 5570560 High water mark (bytes) = 7684096 Configured size (bytes) = 2145386496 Memory Pool Type = Application Heap Current size (bytes) = 212992 High water mark (bytes) = 212992 Configured size (bytes) = 1277952 Memory Pool Type = Application Control Heap Current size (bytes) = 16384 High water mark (bytes) = 16384 Configured size (bytes) = 704512