DB2 FOR LUW / DB2FORLUW / 970 - DB2

When an activity event monitor is created, a user can specify 
the target table schemas and names. The db2caem tool takes 
activity event monitor name as input. If the user has created 
the activity event monitor this way, db2caem fails with -204.

**************************************************************** 
* USERS AFFECTED:                                              * 
* N/A                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* When an activity event monitor is created, a user can        * 
* specify the target table schemas and names. The db2caem tool * 
* takes activity event monitor name as input. If the user has  * 
* created the activity event monitor this way, db2caem fails   * 
* with -204.                                                   * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to V97FP5 and above releases.                        * 
****************************************************************

The workaround for this would be to create public aliases for 
the event monitor tables which match the default names the event 
monitor would generate. E.g. if your activity table in your 
activity event monitor (called mymon) is called act1, you would 
create a public alias for act1 called activity_mymon. Similarly 
if your activitystmt table is actstmt2, you would create alias 
for actstmt2 with activitystmt_mymon. Same should be done for 
your activityvals table, if your activityvals table has name 
actvals3, you would create alias for actvals3 with 
activityvals_mymon.

DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

In V97FP5, db2caem -d <db> -actevm -appid -uowid -actid will 
support the activity event monitor with user specified table 
names and schemas.

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

20.04.2011
07.12.2011
07.12.2011

9.7.FP5