Application Snapshot Application handle = 11 Application status = UOW Executing Status change time = 03/03/2010 10:38:31.090338 Application code page = 819 Application country/region code = 0 DUOW correlation token = *LOCAL.DB2.100227090417 Application name = db2lused Application ID = *LOCAL.DB2.100227090417 Sequence number = 00001 TP Monitor client user ID = TP Monitor client workstation name = TP Monitor client application name = TP Monitor client accounting string = Is this a System Application = YES Connection request start timestamp = 02/27/2010 10:04:14.566755 Connect request completion timestamp = 02/27/2010 10:04:14.567213 Application idle time = 4 days 38 minutes 51 seconds CONNECT Authorization ID = ARVINADM Client login ID = arvinadm Configuration NNAME of client = some.host Client database manager product ID = SQL09071 Process ID of client application = 13776 Platform of client application = LINUXAMD64 Communication protocol of client = Local Client Inbound communication address = Database name = SST2 Database path = /db2/data/1/db2inst1/NODE0000/SQL00001/ Client database alias = SST2 Input database alias = Last reset timestamp = Snapshot timestamp = 03/03/2010 10:43:05.059012 Authorization level granted = User authority: Group authority: Coordinating database partition number = 0 Current database partition number = 0 Coordinator agent process or thread ID = 69 Current Workload ID = 0 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) = 3 Locks held by application = 0 Lock waits since connect = 59 Time application waited on locks (ms) = 177077 Deadlocks detected = 0 Lock escalations = 0 Exclusive lock escalations = 0 Number of Lock Timeouts since connected = 59 Total time UOW waited on locks (ms) = 0 Total sorts = 0 Total sort time (ms) = 0 Total sort overflows = 0 Buffer pool data logical reads = 1182 Buffer pool data physical reads = 37 Buffer pool temporary data logical reads = 0 Buffer pool temporary data physical reads = 0 Buffer pool data writes = 0 Buffer pool index logical reads = 2218 Buffer pool index physical reads = 29 Buffer pool temporary index logical reads = 0 Buffer pool temporary index physical reads = 0 Buffer pool index writes = 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 Buffer pool xda writes = 0 Total buffer pool read time (milliseconds) = 368 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 = 0 Commit statements = 0 Rollback statements = 0 Dynamic SQL statements attempted = 0 Static SQL statements attempted = 0 Failed statement operations = 0 Select SQL statements executed = 0 Xquery statements executed = 0 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 = 1092 Internal rollbacks = 0 Internal rollbacks due to deadlock = 0 Binds/precompiles attempted = 0 Rows deleted = 0 Rows inserted = 0 Rows updated = 0 Rows selected = 0 Rows read = 0 Rows written = 744 UOW log space used (Bytes) = 0 Previous UOW completion timestamp = 02/27/2010 10:04:14.567213 Elapsed time of last completed uow (sec.ms)= 0.000000 UOW start timestamp = 02/27/2010 10:04:14.567213 UOW stop timestamp = 02/27/2010 10:04:14.567213 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) = 0.415952 Total System CPU Time used by agent (s) = 0.000000 Host execution elapsed time = 0.000000 Package cache lookups = 0 Package cache inserts = 0 Application section lookups = 0 Application section inserts = 0 Catalog cache lookups = 0 Catalog cache inserts = 0 Catalog cache overflows = 0 Catalog cache high water mark = 0 Workspace Information Most recent operation = None Most recent operation start timestamp = Most recent operation stop timestamp = 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 = Statement = Unknown Section number = 0 Application creator = Package name = Consistency Token = Cursor name = Statement database partition number = 0 Statement start timestamp = 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 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 Memory usage for application: Memory Pool Type = Application Heap Current size (bytes) = 196608 High water mark (bytes) = 196608 Configured size (bytes) = 1048576 Agent process/thread ID = 69 Agent Lock timeout (seconds) = 3 Memory usage for agent: Memory Pool Type = Other Memory Current size (bytes) = 196608 High water mark (bytes) = 196608 Configured size (bytes) = 202841575424