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

RESTORE INTO EXISTING DATABASE MAY FAIL WITH AMD1814E INVALID LOGPATH
DURING ROLLFORWARD

Produkt:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problembeschreibung:
When restoring into an existing database, currently only the 
logfiles are deleted, but the TAG file will be left untouched in 
the log path. This can lead to issues during a rollforward of 
the newly rerstored database later on. The following messages 
can be found in the db2diag.log file: 
 
2014-03-15-11.11.07.807357+000 E31795340A519 LEVEL: Error 
PID : 17760344 TID : 4113 PROC : db2sysc 0 
INSTANCE: xxxxxx NODE : 000 DB : yyy 
APPHDL : 0-8 APPID: *LOCAL.xxxxxx.140315111107 
AUTHID : xxxxxx HOSTNAME: zzzzzz 
EDUID : 4113 EDUNAME: db2agent (yyy) 0 
FUNCTION: DB2 UDB, data protection services, 
sqlpgUseCurrentPath, probe:2660 
MESSAGE : ADM1814E The current log path "/db2/yyy/log_dir/" is 
invalid. 
 
2014-03-15-11.11.07.807967+000 E31795860A573 LEVEL: Error 
PID : 17760344 TID : 4113 PROC : db2sysc 0 
INSTANCE: xxxxxx NODE : 000 DB : yyy 
APPHDL : 0-8 APPID: *LOCAL.xxxxxx.140315111107 
AUTHID : xxxxxx HOSTNAME: zzzzzz 
EDUID : 4113 EDUNAME: db2agent (yyy) 0 
FUNCTION: DB2 UDB, data protection services, 
sqlpgUseCurrentPath, probe:2960 
MESSAGE : ADM1811E DB2 will now switch to the default log path 
"/db2/yyy/xxxxxx/NODE0000/SQL00001/LOGSTREAM0000/". 
 
This APAR will delete the TAG file in addition to the log files, 
when these files belong to the database being overwritten by 
the restore. If these files do not belong to the overwritten 
database, an error will be returned instead.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 10.1 Fix Pack 5.                      * 
****************************************************************
Local-Fix:
Manually remove the TAG file from the log path.
Lösung
First fixed in DB2 Version 10.1 Fix Pack 5.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
23.05.2014
17.07.2015
17.07.2015
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.1.0.5 FixList