|
Problem IC73687
|
Status: Closed |
DB2 ACTIVITY MONITOR WILL FAIL TO DO ONLINE CHANGES TO THE DATAB ASE MANAGER CONFIGURATIONS LEADING TO SQL22405N ERRORS LATER ON. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
The db2 activity monitor (db2am) will fail to update database
manager configurations while db2 is online. Db2am reports will
give SQL22405N error until you restart db2.
Example:
In db2 activity monitor (db2am):
1. 'Introduction' - Select the DB.
2. Select the partition.
3. Select the monitored task.
4. The 'show command' which will show the following:
5. Click 'finish'
6. Select any report from the activity monitor GUI and it will
return the SQL22405N error. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All users that do this. *
****************************************************************
* PROBLEM DESCRIPTION: *
* The db2 activity monitor (db2am) will fail to update *
* database *
* manager configurations while db2 is online. Db2am reports *
* will *
* give SQL22405N error until you restart db2. *
* *
* *
* *
* Example: *
* *
* *
* *
* In db2 activity monitor (db2am): *
* *
* *
* *
* 1. 'Introduction' - Select the DB. *
* *
* *
* *
* 2. Select the partition. *
* *
* *
* *
* 3. Select the monitored task. *
* *
* *
* *
* 4. The 'show command' which will show the following: *
* *
* *
* *
* 5. Click 'finish' *
* *
* *
* *
* 6. Select any report from the activity monitor GUI and it *
* will *
* return the SQL22405N error. *
****************************************************************
* RECOMMENDATION: *
* If you restart db2 the database manager configuration *
* changes *
* will take effect and no longer will you get SQL22405N. *
* *
* Alternatively instead of restarting db2 you can run the *
* commands *
* yourself. Below is example of commands: *
* *
* *
* *
* ATTACH TO SAMPLE; *
* *
* UPDATE DBM CFG USING DFT_MON_SORT ON; *
* *
* UPDATE DBM CFG USING DFT_MON_LOCK ON; *
* *
* UPDATE DBM CFG USING DFT_MON_STMT ON; *
* *
* UPDATE DBM CFG USING DFT_MON_UOW ON; *
* *
* UPDATE DBM CFG USING DFT_MON_TIMESTAMP ON; *
* *
* UPDATE DBM CFG USING DFT_MON_BUFPOOL ON; *
* *
* CONNECT RESET; *
**************************************************************** |
| Local Fix: |
If you restart db2 the database manager configuration changes
will take effect and no longer will you get SQL22405N.
Alternatively instead of restarting db2 you can run the commands
yourself. Below is example of commands:
ATTACH TO SAMPLE;
UPDATE DBM CFG USING DFT_MON_SORT ON;
UPDATE DBM CFG USING DFT_MON_LOCK ON;
UPDATE DBM CFG USING DFT_MON_STMT ON;
UPDATE DBM CFG USING DFT_MON_UOW ON;
UPDATE DBM CFG USING DFT_MON_TIMESTAMP ON;
UPDATE DBM CFG USING DFT_MON_BUFPOOL ON;
CONNECT RESET; |
| available fix packs: |
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
|
| Solution |
Fixed from fixpack 5 of DB2 v9.7 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 06.01.2011
19.12.2011
19.12.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.5
|
 |
