监控 DB2 活动之捕获事件监控数据
事件监控器生产力工具生成的输出结果
Reading C:\mondata\00000000.EVT ...
--------------------------------------------------------------------------
Webjx.Com
EVENT LOG HEADER
Event Monitor name: CONN_EVENTS
Server Product ID: SQL09000
网页教学网
Version of event monitor data: 8
Byte order: LITTLE ENDIAN
Number of nodes in db2 instance: 1
Codepage of database: 1208
Webjx.Com
Territory code of database: 1
Webjx.Com
Server instance name: DB2
--------------------------------------------------------------------------
网页教学网
--------------------------------------------------------------------------
网页教学网
Database Name: SAMPLE
Database Path: C:\DB2\NODE0000\SQL00002\
First connection timestamp: 06/22/2006 00:56:40.086671
Event Monitor Start time: 06/22/2006 00:56:40.662668
--------------------------------------------------------------------------
3) Connection Header Event ... Webjx.Com
Appl Handle: 55
Webjx.Com
Appl Id: *LOCAL.DB2.060622045634 网页教学网
Appl Seq number: 00001
DRDA AS Correlation Token: *LOCAL.DB2.060622045634
Program Name : db2bp.exe
Authorization Id: RSANDERS
Execution Id : RSANDERS Webjx.Com
Codepage Id: 1252
Webjx.Com
Territory code: 0
Client Process Id: 1992
Client Database Alias: SAMPLE
Webjx.Com
Client Product Id: SQL09000
Client Platform: Unknown
Client Communication Protocol: Local
Client Network Name: rsanders-lxp 网页教学网
Connect timestamp: 06/22/2006 00:56:40.086671
Webjx.Com
4) Connection Event
Appl Handle: 55
Appl Id: *LOCAL.DB2.060622045634
Appl Seq number: 00003
Record is the result of a flush: FALSE Webjx.Com
Application Status: SQLM_DISCONNECTPEND
网页教学网
Lock Statistics:
Lock Waits: 0 Webjx.Com
Total time waited on locks (milliseconds): 0
Deadlocks: 0 Webjx.Com
Lock escalations: 0
X lock escalations: 0 Webjx.Com
Lock timeouts: 0
Sort Statistics: 网页教学网
Sorts: 0
Webjx.Com
Total sort time (milliseconds): 0
Sort overflows: 0
Hash Statistics:
Hash Joins: 0
Hash Loops: 0
Hash Join Small Overflows: 0
Hash Join Overflows: 0 网页教学网
Buffer Pool Statistics:
Buffer pool data logical page reads: 0
Buffer pool data physical page reads: 0
Buffer pool temporary data logical page reads: 0
Buffer pool temporary data physical page reads: 0
Buffer pool data page writes: 0
Buffer pool index logical page reads: 0
Webjx.Com
Buffer pool index physical page reads: 0
Buffer pool temporary index logical page reads: 0
Buffer pool temporary index physical page reads: 0
网页教学网
Buffer pool index page writes: 0
Buffer pool xda logical page reads: 0
Buffer pool xda physical page reads: 0
Buffer pool temporary xda logical page reads: 0
Buffer pool temporary xda physical page reads: 0
Buffer pool xda page writes: 0
Buffer pool read time (milliseconds): 0
Buffer pool write time (milliseconds): 0
Time spent waiting for a prefetch: 0 milliseconds
Webjx.Com
Unread prefetch pages: 0
Workspace Statistics:
Shared workspace high water mark: 0
Total shared workspace overflows: 0
Total shared workspace section lookups: 0 网页教学网
Total shared workspace section inserts: 0
Webjx.Com
Private workspace high water mark: 0
Total private workspace overflows: 0
Total private workspace section lookups: 0
网页教学网
Total private workspace section inserts: 0
Webjx.Com
Direct I/O Statistics:
Sectors read directly: 0
Sectors written directly: 0
Direct read requests: 0 网页教学网
Direct write requests: 0
Direct read time: 0 Webjx.Com
Direct write time: 0
SQL Statement counts Webjx.Com
Commit SQL statements: 1 Webjx.Com
Rollback SQL statements: 0
Dynamic SQL statements: 1
Static SQL stmts: 1
Webjx.Com
Failed SQL statements: 0 Webjx.Com
Select SQL statements: 0 Webjx.Com
Xquery statements: 0
Data Definition Language SQL statements: 0
Update/Insert/Delete SQL statements: 0 Webjx.Com
Internal counts
Internal auto rebinds: 0
Internal rows deleted: 0
网页教学网
Internal rows updated: 0
Webjx.Com
Internal rows inserted: 0 网页教学网
Internal commits: 0
Internal rollbacks: 0
Internal rollbacks due to deadlock: 0
Row counts
Rows deleted: 0 网页教学网
Rows inserted: 0
Rows updated: 0
Rows selected: 0
网页教学网
Rows read: 0 网页教学网
Rows written: 0
Binds/Precompiles: 0 网页教学网
Rejected block cursor requests: 0
网页教学网
Accepted block cursor requests: 0
网页教学网
Package Cache Statistics
Package Cache Lookups: 1
Package Cache Inserts: 0
Section Lookups: 1
Section Inserts: 0
Catalog Cache Statistics
Catalog Cache Overflows: 0
Catalog Cache High Water Mark: 0
Catalog Cache Lookups: 0
Catalog Cache Inserts: 0
CPU times
User CPU time: 0.000000 seconds
System CPU time: 0.000000 seconds
Memory usage:
Memory Pool Type: Other Memory
Current size (bytes): 458752
High water mark (bytes): 720896
Configured size (bytes): 2145386496
Memory Pool Type: Application Heap
网页教学网
Current size (bytes): 196608
Webjx.Com
High water mark (bytes): 196608 Webjx.Com
Configured size (bytes): 1245184 网页教学网
Memory Pool Type: Application Control Heap 网页教学网
Current size (bytes): 65536 Webjx.Com
High water mark (bytes): 65536
Configured size (bytes): 655360 网页教学网
Disconnection Time: 06/22/2006 00:56:47.496766 网页教学网
5) Connection Header Event ...
Appl Handle: 57
Appl Id: *LOCAL.DB2.060622045641
Appl Seq number: 00001
DRDA AS Correlation Token: *LOCAL.DB2.060622045634 Webjx.Com
Program Name : db2taskd 网页教学网
Authorization Id: RSANDERS
Execution Id : RSANDERS
网页教学网
Codepage Id: 1252 Webjx.Com
Territory code: 0 Webjx.Com
Client Process Id: 1992
Client Database Alias: SAMPLE
Client Product Id: SQL09000
Client Platform: Unknown
Client Communication Protocol: Local
Client Network Name: rsanders-lxp
Connect timestamp: 06/22/2006 00:56:40.650597 Webjx.Com
6) Connection Header Event ...
Appl Handle: 56
Appl Id: *LOCAL.DB2.060622045640
Appl Seq number: 00001 Webjx.Com
DRDA AS Correlation Token: *LOCAL.DB2.060622045634
Program Name : db2stmm
Authorization Id: RSANDERS
Execution Id : RSANDERS
Codepage Id: 1252 Webjx.Com
Territory code: 0
Client Process Id: 1992
Webjx.Com
Client Database Alias: SAMPLE 网页教学网
Client Product Id: SQL09000
网页教学网
Client Platform: Unknown
Client Communication Protocol: Local
Client Network Name: rsanders-lxp 网页教学网
Connect timestamp: 06/22/2006 00:56:40.640740
Webjx.Com
7) Connection Event
Appl Handle: 57 Webjx.Com
Appl Id: *LOCAL.DB2.060622045641 Webjx.Com
Appl Seq number: 00001 Webjx.Com
Record is the result of a flush: FALSE
Application Status: SQLM_COMMIT_ACT
Lock Statistics: 网页教学网
Lock Waits: 0
Total time waited on locks (milliseconds): 0
Webjx.Com
Deadlocks: 0
Lock escalations: 0
网页教学网
X lock escalations: 0
Lock timeouts: 0
Sort Statistics: 网页教学网
Sorts: 0 Webjx.Com
Total sort time (milliseconds): 0
Sort overflows: 0
Hash Statistics: Webjx.Com
Hash Joins: 0
Hash Loops: 0
Hash Join Small Overflows: 0
Hash Join Overflows: 0 网页教学网
Buffer Pool Statistics: Webjx.Com
Buffer pool data logical page reads: 0
Buffer pool data physical page reads: 0
Buffer pool temporary data logical page reads: 0
Webjx.Com
Buffer pool temporary data physical page reads: 0
Buffer pool data page writes: 0 Webjx.Com
Buffer pool index logical page reads: 0
Buffer pool index physical page reads: 0
Buffer pool temporary index logical page reads: 0 网页教学网
Buffer pool temporary index physical page reads: 0
Buffer pool index page writes: 0
Buffer pool xda logical page reads: 0 Webjx.Com
Buffer pool xda physical page reads: 0
Buffer pool temporary xda logical page reads: 0
Buffer pool temporary xda physical page reads: 0
Webjx.Com
Buffer pool xda page writes: 0
Buffer pool read time (milliseconds): 0
Buffer pool write time (milliseconds): 0
Time spent waiting for a prefetch: 0 milliseconds
Unread prefetch pages: 0
Workspace Statistics:
Webjx.Com
Shared workspace high water mark: 0
Total shared workspace overflows: 0
Total shared workspace section lookups: 0
Total shared workspace section inserts: 0
Private workspace high water mark: 0
Total private workspace overflows: 0
Total private workspace section lookups: 0
Total private workspace section inserts: 0
网页教学网
Direct I/O Statistics: 网页教学网
Sectors read directly: 0
Sectors written directly: 0
Direct read requests: 0
Direct write requests: 0
Direct read time: 0
Direct write time: 0
SQL Statement counts 网页教学网
Commit SQL statements: 0
Rollback SQL statements: 0
Dynamic SQL statements: 0
Static SQL stmts: 0
Failed SQL statements: 0
Select SQL statements: 0
网页教学网
Xquery statements: 0 Webjx.Com
Data Definition Language SQL statements: 0
Update/Insert/Delete SQL statements: 0
Internal counts
Internal auto rebinds: 0
Internal rows deleted: 0
Internal rows updated: 0 Webjx.Com
Internal rows inserted: 0
Webjx.Com
Internal commits: 1
Internal rollbacks: 0 网页教学网
Internal rollbacks due to deadlock: 0
Row counts
Rows deleted: 0 Webjx.Com
Rows inserted: 0
Rows updated: 0 网页教学网
Rows selected: 0
Rows read: 0
Webjx.Com
Rows written: 0
Binds/Precompiles: 0
Rejected block cursor requests: 0 Webjx.Com
Accepted block cursor requests: 0
Package Cache Statistics 网页教学网
Package Cache Lookups: 0
Package Cache Inserts: 0
Webjx.Com
Section Lookups: 0
Section Inserts: 0
Catalog Cache Statistics
Catalog Cache Overflows: 0 Webjx.Com
Catalog Cache High Water Mark: 0
网页教学网
Catalog Cache Lookups: 0
Catalog Cache Inserts: 0
CPU times
User CPU time: 0.000000 seconds
System CPU time: 0.000000 seconds Webjx.Com
Memory usage:
Memory Pool Type: Application Heap
网页教学网
Current size (bytes): 65536
Webjx.Com
High water mark (bytes): 65536
Configured size (bytes): 1245184
Memory Pool Type: Other Memory 网页教学网
Current size (bytes): 65536 网页教学网
High water mark (bytes): 65536
Configured size (bytes): 2145386496
Webjx.Com
Memory Pool Type: Application Control Heap
Current size (bytes): 65536
High water mark (bytes): 65536
Configured size (bytes): 655360
Disconnection Time: 06/22/2006 00:56:47.514160 网页教学网
--------------------------------------------------------------------------
Webjx.Com
Database Name: SAMPLE
Database Path: C:\DB2\NODE0000\SQL00002\
Webjx.Com
First connection timestamp: 06/22/2006 00:56:53.123490
Event Monitor Start time: 06/22/2006 00:56:53.522110
--------------------------------------------------------------------------
-------------------------------------------------------------------------- Webjx.Com
Database Name: SAMPLE
Database Path: C:\DB2\NODE0000\SQL00002\
First connection timestamp: 06/22/2006 00:57:36.727014
Event Monitor Start time: 06/22/2006 00:57:37.223404
--------------------------------------------------------------------------
文章评论
共有 0 位网友发表了评论 查看完整内容