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 IC69960 Status: Geschlossen

DB2STOP HANGS AFTER A TRAP HAS BEEN SUSTAINED.

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
In the event that a DB2 ESE instance has encountered a 
sustainable trap, subsequent issuance of db2stop or db2stop 
force may fail or hang. 
 
Issuing db2stop may result in the following message: 
 
SQL1025N  The database manager was not stopped because databases 
are still active. 
 
Issuing db2stop force will result in a hang. 
 
A user can check the db2diag.log for the message ADM14013C to 
determine if , prior to issuing db2stop, a sustained trap has 
 
occurred. 
 
Alternatively, to detect if there was any trap suspended db2 
agent, run 
the command: 
 
db2pdcfg -trapresilience 
 
or 
 
db2pdcfg -tra 
 
Example output from this command is as follows: 
 
db2pdcfg -trapresilience 
DB2 trap resilience is enabled. 
   Current threshold setting:    0 ( disabled ) 
   Number of traps sustained:   1 
 
 
If "Number of traps sustained" is greater than zero then the 
Local Fix supplied should be used to stop the instance or the 
fix to this APAR should be applied to the system.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* V9.7 GA, V9.7 FP1, V9.7 FP2                                  * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* In the event that a DB2 ESE instance has encountered a       * 
*                                                              * 
* sustainable trap, subsequent issuance of db2stop or db2stop  * 
*                                                              * 
* force may fail or hang.                                      * 
*                                                              * 
*                                                              * 
*                                                              * 
* Issuing db2stop may result in the following message:         * 
*                                                              * 
*                                                              * 
*                                                              * 
* SQL1025N  The database manager was not stopped because       * 
* databases                                                    * 
* are still active.                                            * 
*                                                              * 
*                                                              * 
*                                                              * 
* Issuing db2stop force will result in a hang.                 * 
*                                                              * 
*                                                              * 
*                                                              * 
* A user can check the db2diag.log for the message ADM14013C   * 
* to                                                           * 
* determine if , prior issuing db2stop, a sustained trap has   * 
*                                                              * 
* occurred.                                                    * 
*                                                              * 
*                                                              * 
*                                                              * 
* Alternatively, to detect if there was any trap suspended,    * 
* run                                                          * 
* the command:                                                 * 
*                                                              * 
*                                                              * 
*                                                              * 
* db2pdcfg -trapresilience                                     * 
*                                                              * 
*                                                              * 
*                                                              * 
* or                                                           * 
*                                                              * 
*                                                              * 
*                                                              * 
* db2pdcfg -tra                                                * 
*                                                              * 
*                                                              * 
*                                                              * 
* Example output from this command is as follows:              * 
*                                                              * 
*                                                              * 
*                                                              * 
* db2pdcfg -trapresilience                                     * 
*                                                              * 
* DB2 trap resilience is enabled.                              * 
*                                                              * 
*   Current threshold setting:    0 ( disabled )               * 
*                                                              * 
*   Number of traps sustained:  1                              * 
*                                                              * 
*                                                              * 
*                                                              * 
*                                                              * 
* If "Number of traps sustained" is greater than zero then the * 
*                                                              * 
* Local Fix supplied should be used to stop the instance or    * 
* the                                                          * 
* fix to this APAR should be applied to the system.            * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Local fix or upgrade to V97 FP3                              * 
****************************************************************
Local-Fix:
Issue the command db2stop -kill
verfügbare FixPacks:
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 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

Lösung
V9.7 FP3
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
15.07.2010
11.11.2010
11.11.2010
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP3
Problem behoben lt. FixList in der Version
9.7.0.3 FixList
9.7.0.3 FixList