IBM Support

LI73792: ROLLFORWARD AFTER A RESTORE WITH LOAD COPY FAILS WHEN PROCESSING LOAD FILE.THIS HAPPENS WHEN DB2LOADREC IS POINTING T0 EMPTY FILE

Fixes are available

DB2 Version 9.1 Fix Pack 8  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 9  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 10  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12  for Linux, UNIX and Windows

Subscribe

You can track all active APARs for this component.

 

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:
    

    
LI73797 IC64022
    

    • 



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":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"910","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
          

                    

        
        

        

      


      


        

            

            
Document Information


            

            


                        

            Modified date:
            

            16 November 2009
            

            
            
          

        


        

        


      


    


  





    

  



  
    
      

      
Page Feedback