|
Problem IC97157
|
Status: Closed |
DURING DATABASE ACTIVATION BACKGROUND AGENTS & DB2STMM MAY NOT GET STARTED. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
During database activation background agents & db2stmm may not
get started. This can lead to various issues including increase
memory
utilization.
The problem it timing dependent and occurs when rollforward or
crash recovery is in progress in one connection, whilst another
another session is starting a regular connection
and waits until the crash or rollforward recovery completes.
You can check if db2stmm is running using the following:
db2pd -edu | grep db2stmm | grep <database>
The following agents may be impacted by this depending on the
configuration:
Self Tuning Memory (db2stmm)
ABP (db2taskd)
fast writer (db2fwX) |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All Platforms *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 LUW v9.7 Fixpack 10 or Later. *
**************************************************************** |
| Local Fix: |
WORKAROUND:
- deactivate database/activate database
or
- restart the instance |
| Solution |
First fixed in DB2 LUW v9.7 Fixpack 10. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 24.10.2013
17.11.2014
17.11.2014 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP10
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.10
|
 |
