Problem Description: RF after restore with load copy fails when
trying to process load copy file.
Entries in db2diag.log look like the following:
2008-09-08-15.57.08.878811-240 I1825398E392 LEVEL: Warning
PID : 31378 TID : 183046802080PROC :
db2agent (ADAENG) 0
INSTANCE: test NODE : 000 DB : SAMPLE
APPHDL : 0-912 APPID:
*LOCAL.nytit024.080908195325
AUTHID : MSDB2
FUNCTION: DB2 UDB, database utilities, sqludcpy, probe:1128
MESSAGE : Load copy restore terminated.
2008-09-08-15.57.08.879032-240 E1825791E429 LEVEL: Warning
PID : 31378 TID : 183046802080PROC :
db2agent (ADAENG) 0
INSTANCE: test NODE : 000 DB : Sample
APPHDL : 0-912 APPID:
*LOCAL.nytit024.080908195325
AUTHID : MSDB2
FUNCTION: DB2 UDB, data protection services, sqlufrol,
probe:8180
MESSAGE : ADM1611W The rollforward recovery phase has been
completed.
2008-09-08-15.57.09.323714-240 E1826221E418 LEVEL: Warning
PID : 31378 TID : 183046802080PROC :
db2agent (ADAENG) 0
INSTANCE: test NODE : 000 DB : SAMPLE
APPHDL : 0-912 APPID:
*LOCAL.nytit024.080908195325
AUTHID : MSDB2
FUNCTION: DB2 UDB, data protection services, sqlufrol, probe:980
MESSAGE : ADM1602W Rollforward recovery has been initiated.
.........
2008-09-08-15.57.38.331618-240 E1852238E418 LEVEL: Warning
PID : 31378 TID : 183046802080PROC :
db2agent (ADAENG) 0
INSTANCE: test NODE : 000 DB : SAMPLE
APPHDL : 0-912 APPID:
*LOCAL.nytit024.080908195325
AUTHID : MSDB2
FUNCTION: DB2 UDB, data protection services, sqlufrol, probe:980
MESSAGE : ADM1602W Rollforward recovery has been initiated.
2008-09-08-15.57.38.331800-240 I1852657E446 LEVEL: Severe
PID : 31378 TID : 183046802080PROC :
db2agent (ADAENG) 0
INSTANCE: test NODE : 000 DB : SAMPLE
APPHDL : 0-912 APPID:
*LOCAL.nytit024.080908195325
AUTHID : MSDB2
FUNCTION: DB2 UDB, database utilities, sqludcpy, probe:491
MESSAGE : DIA0001E An internal error occurred. Report the
following error code
: "".
.......
2008-09-08-15.57.38.334580-240 I1874155E419 LEVEL: Warning
PID : 31378 TID : 183046802080PROC :
db2agent (ADAENG) 0
INSTANCE: test NODE : 000 DB : SAMPLE
APPHDL : 0-912 APPID:
*LOCAL.nytit024.080908195325
AUTHID : MSDB2
FUNCTION: DB2 UDB, database utilities, sqludcpy, probe:906
MESSAGE : Terminating EDUs - load copy restore terminated by
caller
2008-09-08-15.57.38.334674-240 I1874575E387 LEVEL: Warning
PID : 31378 TID : 183046802080PROC :
db2agent (ADAENG) 0
INSTANCE: test NODE : 000 DB : SAMPLE
APPHDL : 0-912 APPID:
*LOCAL.nytit024.080908195325
AUTHID : MSDB2
FUNCTION: DB2 UDB, database utilities, sqludcpy, probe:914
MESSAGE : Load copy restore failed.
.............
2008-09-08-15.57.38.347673-240 I1875774E416 LEVEL: Warning
PID : 10577 TID : 183046802080PROC :
db2redom (ADAENG) 0
INSTANCE: test NODE : 000 DB : SAMPLE
APPHDL : 0-912 APPID:
*LOCAL.nytit024.080908195325
AUTHID : MSDB2
FUNCTION: DB2 UDB, recovery manager, sqlpRFWppl, probe:870
MESSAGE : Tablespaces taken offline due to failed load recovery.
2008-09-08-15.57.38.348534-240 I1876191E415 LEVEL: Warning
PID : 10577 TID : 183046802080PROC :
db2redom (ADAENG) 0
INSTANCE: test NODE : 000 DB : SAMPLE
APPHDL : 0-912 APPID:
*LOCAL.nytit024.080908195325
AUTHID : MSDB2
FUNCTION: DB2 UDB, recovery manager, sqlpRFWppl, probe:870
DATA #1 : <preformatted>
Tablespace 5 in restore pending state.
===============================================
The reason of the issue is because DB2LOADREC points to an
empty file.
Found in db2 v9.1 fp5 |
