DB2 - Problembeschreibung
Problem IC98629 | Status: Geschlossen |
ROLLFORWARD DATABASE RETURNS SQL1774N ON HADR DATABSE AFTER SNAPSHOT RESTORE AND DB2INIDB AS MIRROR | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 | |
Problembeschreibung: | |
Starting with DB2 v10.1 FP2 usage of an external snapshot backup image to restore a HADR (primary) database will not longer work. After restore and 'db2inidb as mirror' any rollforward database command will result in error SQL1774N. SQL1774N Table space restore or rollforward cannot be issued on an HADR primary or HADR standby database. In the db2diag.log you will see message: 2014-01-08-18.53.15.710102+060 I330298E636 LEVEL: Error PID : 6640 TID : 48006090975552 PROC : db2sysc 0 INSTANCE: db2hadr3 NODE : 000 DB : HADRDB APPHDL : 0-10 APPID: *LOCAL.db2hadr3.140108175315 AUTHID : DB2HADR3 HOSTNAME: DB2HADR1 EDUID : 19 EDUNAME: db2agent (HADRDB) 0 FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrCheckDb, probe:18000 MESSAGE : ZRC=0xFFFFF912=-1774 SQL1774N Table space restore or rollforward cannot be issued on an HADR primary or HADR standby database. Following sequence will reproduce the behaviour: - setup HADR primary and standby database - on HADR primary - db2 set write suspend for database - backup local/system db directory and db container files using external tools (e.g. tar) - db2 set write resume for database - db2stop on HADR primary database server - restore database from external backup (e.g. tar archive) - db2start - db2inidb <DBNAME> as mirror -> any db2rollforward command will receive SQL1774N This APAR will ensure 'db2inidb as mirror' resets the HADR database role to STANDARD. With database role STANDARD it's allowed to perform the rollforward operation. Afterwards HADR needs to be configured again. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * All * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 10.1 FixPack 4. * **************************************************************** | |
Local-Fix: | |
Following sequence is a valid workaround to restore HADR primary database from external backup: - restore snapshot backup - db2inidb <DBNAME> as standby (which will reset HADR database role to standard) - rollforward db to end of logs - start hadr on db as primary (by force if there is standby configured and active) | |
verfügbare FixPacks: | |
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows | |
Lösung | |
First fixed in DB2 Version 10.1 FixPack 4. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC99052 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 09.01.2014 03.06.2014 03.06.2014 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.1.0.4 |