Date: 
March 02, 2006

Patch: 
3.0.0-TIV-OMXEDUD-IF0017

Component: 
IBM Tivoli OMEGAMON XE for DB2 Universal Database, Version 3.0.0 

General description:
This patch contains fixes for APARs IY68944, IY67791, 
OA11914, IY69524, IY74787, IY77723, and IY82151 related to the 
IBM(R) Tivoli(R) OMEGAMON(R) XE for DB2 agent.  

This is a cumulative maintenance patch for the IBM Tivoli 
OMEGAMON XE for DB2 Universal Database agent on AIX operating 
systems. This patch contains the fix for the agent not 
showing some values such as the following: agent id holding 
the lock, log files size continues to increase, lock type, 
lock object, agent usr cpu time, and agent sys cpu time in 
the Tivoli Enterprise(TM) Portal, previously called the CandleNet 
Portal(R). This patch also contains the fix for the agent showing 
the SQL1428N error in the logs, the incorrect DB2 version, and sort 
overflows pct in the workspaces. In addition, a new attribute named 
Free Pages Percentage has been added to the Tablespace Summary 
workspace.

Problems fixed: 
New fixes in the following:
- 3.0.0-TIV-OMXEDUD-IF0017

Symptoms: 
This monitoring agent does not show some values 
such as the following: agent id holding the lock, 
agent usr cpu time, agent sys cpu time, 
log files size continues to increase, lock type, 
lock object, and DB2 version not showing correct values in 
Tivoli Enterprise Portal. The agent shows the SQL1428 error 
in the logs. The Free Pages Percentage attribute does 
not appear in the Tablespace Summary workspace.
The sort overflows pct is same as the sort overflows.

Architecture: 
Windows 2000, XP, 2003

Patches superceded by this patch: 
None

Dependencies: 
Install the 04r1m4 CD image or fixpack 3.0.0-TIV-OMXEDUD-IF0007
before applying this fix pack.

Database changes and special considerations: 
Install the 04r1m4 CD image before applying this fix pack.

Files replaced or added by the patch 
(for all supported values of $INTERP):
<candle_home>\CMA\kudcma.exe

Patch contents: 
This README file: 3.0.0-TIV-OMXEDUD-IF0017.README

Applying the patch:
For agent fix 3.0.0-TIV-OMXEDUD-IF0017:

1. Copy the fix pack to the $CANDLEHOME directory.

2. Stop the agent.

3. Remove the instance.

4. Enter the following command from the $CANDLEHOME directory:
   3.0.0-TIV-OMXEDUD-IF0017 -o -d CMA\*.* 

5. Create a new instance.

6. Start the agent.

Known defects: 
None