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

ADM1823E MESSAGES TRUNCATE THE APPLICATION HANDLE HOLDING THE TRANSACTION
LOGS

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
ADM1823E messages in the  db2diag.log  truncate the application 
handle  which holds  the transaction logs. 
 
Example message  : 
 
2013-06-03-00.01.00.992248-240 E1595A587          LEVEL: Error 
PID     : 315458               TID  : 49165       PROC : db2sysc 
0 
INSTANCE: <inst-name>             NODE : 000         DB   : 
<db-name> 
APPHDL  : 0-50721              APPID: <application-id> 
AUTHID  : ITMUSER 
...skipping... 
EDUID   : 49165                EDUNAME: db2agent (TDWDB) 0 
FUNCTION: DB2 UDB, data protection services, sqlpgResSpace, 
probe:2860 
MESSAGE : ADM1823E  The active log is full and is held by 
application handle 
          "10..".  Terminate this application by COMMIT, 
ROLLBACK or FORCE 
          APPLICATION. 
 
The  application is shown as "10.."   instead of the real 
application handle
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All users.                                                   * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Users can upgrade to DB2 Version 9.7 fix pack 9 or higher to * 
* avoid this defect                                            * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
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
First fixed in DB2 Version 9.7 fix  pack 9
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
14.06.2013
16.12.2013
16.12.2013
Problem behoben ab folgender Versionen (IBM BugInfos)
9.0.,
9.7.,
9.7.FP9
Problem behoben lt. FixList in der Version
9.7.0.9 FixList
9.7.0.9 FixList