Headlines
Top News
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...
Learn More
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 LUW
V8 ManualsOracle
MetalinkHow can we help?
DBI would be please to assist you in any way we can.
Contact DBI