|
Problem IC63952
|
Status: Closed |
INSTANCE CRASHES DUE TO STMM SHUT DOWN WITH AUTHENTICATION ERROR. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
Instance Crashes due to STMM shuts down with authentication
error.
The following message is logged in the db2diag.log
2007-11-19-23.47.30.596000+060 I2449552H876 LEVEL: Severe
PID : 2428 TID : 4632 PROC :
db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : DWHHUBT
APPHDL : 0-30074 APPID: *LOCAL.DB2.071119214744
AUTHID : DB2DWHP
EDUID : 4632 EDUNAME: db2agent (idle)
FUNCTION: DB2 UDB, Self tuning memory manager,
stmmAlterBufferPool,
probe:142
MESSAGE : ZRC=0x8005006D=-2147155859=SQLE_CA_BUILT
"SQLCA has been built and saved in component specific
control
block."
DATA #1 : String, 239 bytes
The self tuning memory manager has received a terminate signal
and was
not able to re-establish its connection to the database. As a
result, it
will be shut down and will not be restarted until the database
is
deactivated and re-activated.
DATA #2 : Sqlcode, PD_TYPE_SQLCODE, 4 bytes
-1060 |
| Problem Summary: |
INSTANCE CRASHES DUE TO STMM SHUT DOWN WITH AUTHENTICATION
ERROR. |
| Local Fix: |
|
| available fix packs: |
DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 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 10 for Linux, UNIX, and Windows
|
| Solution |
This issue is first fixed in V97 Fixpak 1 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 22.10.2009
16.12.2009
16.12.2009 |
| 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.1
|
 |
