January 2005
Beginner to intermediate
928 pages
22h 14m
English
The following real-life example shows how you can solve problems by reviewing the running DB2 processes of a system.
One afternoon, an AIX database server encountered a general slow-down in query response time. A DB2 list applications command did not show anything out of the ordinary running at the time. Before taking DB2 snapshots, we looked at the DB2 processes running on this AIX machine and found that the db2rebal process was running. This process performs a rebalancing of the data across containers when a container is added to a DMS table space. The DBA realized that earlier that day he had added one container to a table space containing a 40GB table. No action was required; ...
Read now
Unlock full access