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

"GET SNAPSHOT FOR LOCKS" COMMAND CAN LEAD TO ERRONEOUS WARNING
MESSAGE "APPLICATION IN ROLLBACK" IN THE DB2DIAG.LOG

Produkt:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problembeschreibung:
"GET SNAPSHOT FOR LOCKS" command can lead to erroneous warning 
messages "APPLICATION IN ROLLBACK" in the db2diag.log.  The 
application could be in rollback or commit. 
 
db2daig.log 
 
2010-09-03-11.14.11.597855+120 I122299A514        LEVEL: Warning 
PID     : 20757                TID  : 920         PROC : db2sysc 
0 
INSTANCE: db2inst1             NODE : 000 
APPHDL  : 0-58904              APPID: 
*LOCAL.db2inst1.100903163726 
AUTHID  : DB2INST3 
EDUID   : 920                  EDUNAME: db2agent (instance) 0 
FUNCTION: DB2 UDB, database monitor, sqm_snap_appl_locks, 
probe:10 
MESSAGE : Snapshot cannot obtain lock information for 
application with app 
          handle 49657. Application in rollback.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All Platforms                                                * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* "GET SNAPSHOT FOR LOCKS" command can lead to                 * 
* erroneouswarningmessages "APPLICATION IN ROLLBACK" in the    * 
* db2diag.log.  Theapplication could be in rollback or         * 
* commit.db2daig.log2010-09-03-11.14.11.597855+120 I122299A514 * 
*        LEVEL:WarningPID    : 20757                TID  : 920 * 
*        PROC :db2sysc0INSTANCE: db2inst1            NODE :    * 
* 000APPHDL  : 0-58904                                         * 
* APPID:*LOCAL.db2inst1.100903163726AUTHID  : DB2INST3EDUID  : * 
* 920                  EDUNAME: db2agent (instance) 0FUNCTION: * 
* DB2 UDB, database monitor,                                   * 
* sqm_snap_appl_locks,probe:10MESSAGE : Snapshot cannot obtain * 
* lock information forapplication with apphandle 49657.        * 
* Application in rollback.                                     * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 v9.5 Fixpak 7 or higher                       * 
****************************************************************
Local-Fix:
Workaround: 
 
set DIAGLEVEL to 2
verfügbare FixPacks:
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
First Fixed in DB2 v9.5 Fixpak 7
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC71490 IC71491 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
09.09.2010
15.11.2010
15.11.2010
Problem behoben ab folgender Versionen (IBM BugInfos)
9.5.
Problem behoben lt. FixList in der Version
9.1.0.7 FixList
9.5.0.7 FixList