home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC97678 Status: Geschlossen

HANG ON DATABASE DEACTIVATION ON STANDBY DATABASE

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
Database deactivation might hang on a Standby Database with the 
following symptoms: 
 
There is one agent on the following stack: 
 
Stack: 
 ====================== 
 
 0x0900000008F96754 sqloWaitEDUWaitPost + 0x21C 
  0x0900000008DB967C 
sqlbDestroyPageCleanerGroup__FP20SQLB_CLNR_GROUP_INFOP12SQLB_GLO 
BALS + 0x36C 
  0x09000000090A69F8 sqlbDestroyAllCleaners__FP12SQLB_GLOBALS + 
0x64 
  0x09000000090A6888 sqlbterm_async_edus__FP12SQLB_GLOBALS + 
0x150 
  0x09000000090A61C8 sqlbCleanupBeforeTerm__FP12SQLB_GLOBALS + 
0x260 
  0x0900000008DD4D6C 
TermDbConnect__16sqeLocalDatabaseFP8sqeAgentP5sqlcai + 0x68 
  0x0900000008DD33AC 
AppStopUsing__14sqeApplicationFP8sqeAgentUcP5sqlca + 0xC84 
  0x0900000008DCE8A0 @72@sqleIndDBConnTerm__FP8sqeAgentP5sqlcai 
+ 0x2C 
  0x0900000008DCE73C @72@sqleIndCoordTerm__FP8sqeAgentP5sqlcaiT3 
+ 0x94 
  0x0900000008DCEAD0 sqleIndCoordProcessRequest__FP8sqeAgent + 
0xF4 
  0x0900000008DBD714 RunEDU__8sqeAgentFv + 0x178 
  0x0900000008DB8C8C EDUDriver__9sqzEDUObjFv + 0xD8 
  0x0900000008DDCB9C sqloEDUEntry + 0x260 
 
 
and the page cleaners are on  db2pclnr: 
 
0x090000000048AAB0 _p_nsleep + 0x10 
  0x090000000005A6E0 nsleep + 0xB0 
  0x090000000010D7AC nanosleep + 0x140 
  0x0900000002181420 ossSleep + 0x80 
  0x0900000008CD7548 sqlorest + 0x64 
  0x0900000007D11184 sqlorest@glue85D + 0x78 
  0x090000000CE3973C 
.sqlpflog.fdpr.clone.2291__FP16sqeLocalDatabaseP9SQLP_LSN8 + 
0x2B4 
  0x0900000008F79A4C sqloLioReadWriteNBlocks + 0x610 
  0x0900000008F96774 sqloWaitEDUWaitPost + 0x23C 
 
this problem is likely to happen as a result of hitting APAR 
IC97372 HADR STANDBY DATABASE MARKED BAD WITH SQLPREPLAYMASTER, 
PROBE:2500  SQLP_TRECOVF
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 and Fix Pack 10                   * 
****************************************************************
Local-Fix:
Lösung
Problem was first fixed in DB2 Version 9.7 and Fix Pack 10
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
14.11.2013
10.11.2014
10.11.2014
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.
Problem behoben lt. FixList in der Version
9.7.0.10 FixList