IBM Support

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

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

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

Problem conclusion

  • FIXED IN DB2 V9.5 FP5
    

Temporary fix

Comments

APAR Information

  • APAR number

    LI73797

  • Reported component name

    DB2 UDE ESE LIN

  • Reported component ID

    5765F4104

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2008-09-30

  • Closed date

    2009-12-16

  • Last modified date

    2009-12-16

  • APAR is sysrouted FROM one or more of the following:

    LI73792

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

Document Information

Modified date:
16 December 2009