EEE-GUYTM by Database-GUYS Inc.

Enterprise Examination & Enrichment for IBM DB2 UDB

Report Prepared: Mon May 5 07:01:01 EDT 2003, Auto-Refresh=120 Seconds

DatabaseStatusConnection Summary
PERFDB ALIVE Connections: 1, Executing: 0, Waiting: 1

Nodes sorted by: dt_reads
Node CPU
Busy %
VM
MB
Avg
Read
ms
Sorts Sort
Over-
flows
BP
Phys
Data
Reads
BP
Phys
Index
Reads
Hash
Joins
Wise-GUY
Freshness
Timestamp
Performance
Details
3 68 % 560 6 ms 36 0 159 11 0 2002-12-30:17:19:09 DB ,Tables ,TblSpcs ,BP
0 20 % 538 5 ms 0 0 34 47 0 2002-12-30:17:37:39 DB ,Tables ,TblSpcs ,BP
1 96 % 560 10 ms 0 0 14 0 0 2002-12-30:17:19:03 DB ,Tables ,TblSpcs ,BP
2 1 % 569 8 ms 0 0 13 0 0 2002-12-30:17:14:12 DB ,Tables ,TblSpcs ,BP


db2diag.log Alert Analysis

File: /dbhome/dbmsi1/sqllib/db2dump/db2diag.log

Alert Action Log
Search StringThreshold CountActual CountAction
full50 0No Action Required
No start database manager0 0No Action Required
No start database manager0 0No Action Required
sqlcode -91120 8No Action Required
sqlcode -91120 8No Action Required

File: /webdata/dginst/sqllib/db2dump/db2diag.log

Alert Action Log
Search StringThreshold CountActual CountAction
full50 0No Action Required
No start database manager0 0No Action Required
No start database manager0 0No Action Required
sqlcode -91120 0No Action Required
sqlcode -91120 0No Action Required


Legends

Actual Count
Threshold Count Not Reached Threshold Count Triggered, Action Considered

Action
No Action Considered Action Taken: Successful Action: Warning Message Only Action Taken: Command Failed


Key Links

Database-GUYS Inc.  |  International DB2 Users Group  |  IBM DB2 Home

EEE-GUY(TM) is a licensed program product provided by Database-GUYS Inc.
Use of this program is subject to confidentiality and license agreements.


Copyright © 2001 Database-GUYS Inc. Spencerport, New York, 14559 USA. All Rights Reserved.