HP and DBI announce partnership!
... This partnership pairs DBI's revolutionary database monitoring, tuning, and trending tools with HP's outstanding customer relationships to bring a truly powerful DB2 database support solution to the market. Under this partnership, HP will offer DBI's tools as part of its managed services customer outsourcing agreements to accelerate value for HP clients and, for non-outsourced clients, HP will be a DBI authorized reseller...
To have these monitor switches active at all times, run the command:
db2 "update dbm cfg using DFT_MON_BUFPOOL on DFT_MON_SORT on DFT_MON_TABLE on DFT_MON_UOW on DFT_MON_TIMESTAMP on"
If you are unable to run the monitors on by default, then they should be turned on manually at the command prompt (for each session):
db2 "update monitor switches using sort on bufferpool on table on timestamp on uow on"
If you are having locking issues and have turned on the LOCK monitor switch, then:
Instead of scrolling through the snapshot information with the more command, many DBAs prefer to direct the output to a file and view it with their favorite editor. For example:
IBM DB2 UDB LUWV8 Manuals
How can we help?
DBI would be please to assist you in any way we can.