Fixes are available
APAR status
Closed as program error.
Error description
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
Local fix
The workaround is to unset DB2LOADREC.
Problem summary
RF after restore with load copy fails when trying to process load copy file.
Problem conclusion
The reason of the issue is because DB2LOADREC points to an empty file. First fixed in db2 v9.1 FP8
Temporary fix
The workaround is to unset DB2LOADREC.
Comments
APAR Information
APAR number
LI73792
Reported component name
DB2 UDE ESE LIN
Reported component ID
5765F4104
Reported release
910
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2008-09-22
Closed date
2009-11-16
Last modified date
2009-11-16
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
DB2 UDE ESE LIN
Fixed component ID
5765F4104
Applicable component levels
R910 PSY
UP
R950 PSY
UP
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"910","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
15 October 2021