IBM Support

IC77929: RESTORE FAILS DUE TO NOT BEING ABLE TO OPEN A LOG FILE IN SQLPGRML() PROBE 80

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • During database restore customer receives SQLP_BADLOG "Log File
    cannot be used" DIA8414C Logging can not continue due to an
    error in sqlpgrml() probe 80
    
    2011-06-23-17.30.48.215465-240 E52154A491         LEVEL: Info
    PID     : 1024016              TID  : 3345        PROC : db2sysc
    505
    INSTANCE: odsint               NODE : 505         DB   : ODSINT
    APPHDL  : 505-54               APPID: *N505.odsint.110623213032
    AUTHID  : ODSINT
    EDUID   : 3345                 EDUNAME: db2agent (ODSINT) 505
    FUNCTION: DB2 UDB, database utilities, sqludPrintStartingMsg,
    probe:1349
    DATA #1 : <preformatted>
    Starting a full database restore.
    Agent EDU ID: 3345
    :
    :
    
    and then we get the log file errors:
    
    2011-06-23-18.15.41.875326-240 I107399A513        LEVEL: Error
    PID     : 1724578              TID  : 3345        PROC : db2sysc
    88
    INSTANCE: odsint               NODE : 088         DB   : ODSINT
    APPHDL  : 88-54                APPID: *N88.odsint.110623213042
    AUTHID  : ODSINT
    EDUID   : 3345                 EDUNAME: db2agent (ODSINT) 88
    FUNCTION: DB2 UDB, data protection services, sqlpgolf, probe:570
    DATA #1 : <preformatted>
    FileName /udblogs/odsint/NODE0088/S0269612.LOG have extent
    headers with Chk1 0 and 0
    
    2011-06-23-18.15.41.880955-240 I107913A165        LEVEL: Warning
    PID:1724578 TID:3345 NODE:088 Title: SQLPG_XHDR
    Dump File:/udbdiag/odsint/1724578.3345.088.dump.bin
    
    2011-06-23-18.15.41.896601-240 I108079A165        LEVEL: Warning
    PID:1724578 TID:3345 NODE:088 Title: SQLPG_XHDR
    Dump File:/udbdiag/odsint/1724578.3345.088.dump.bin
    
    2011-06-23-18.15.41.906417-240 I108245A465        LEVEL: Error
    PID     : 1724578              TID  : 3345        PROC : db2sysc
    88
    INSTANCE: odsint               NODE : 088         DB   : ODSINT
    APPHDL  : 88-54                APPID: *N88.odsint.110623213042
    AUTHID  : ODSINT
    EDUID   : 3345                 EDUNAME: db2agent (ODSINT) 88
    FUNCTION: DB2 UDB, data protection services, sqlpgrml, probe:80
    MESSAGE : Error deleting logpath1: '/udblogs/odsint/NODE0088/'
    
    2011-06-23-18.15.41.911588-240 I108711A538        LEVEL: Error
    PID     : 1724578              TID  : 3345        PROC : db2sysc
    88
    INSTANCE: odsint               NODE : 088         DB   : ODSINT
    APPHDL  : 88-54                APPID: *N88.odsint.110623213042
    AUTHID  : ODSINT
    EDUID   : 3345                 EDUNAME: db2agent (ODSINT) 88
    FUNCTION: DB2 UDB, data protection services, sqlpgrml, probe:80
    RETCODE : ZRC=0x8610000D=-2045771763=SQLP_BADLOG "Log File
    cannot be used"
              DIA8414C Logging can not continue due to an error.
    

Local fix

  • Delete (or move) all log files from the path referenced in the
    "sqlpgrml, probe 80" message, and try the restore again.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All DB2 V9.7 on LUW users.                                   *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 V9.7 Fix Pack 6 or higher.                    *
    ****************************************************************
    

Problem conclusion

  • Problem first fixed in DB2 V9.7 Fix Pack 6.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC77929

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-08-04

  • Closed date

    2013-06-24

  • Last modified date

    2013-06-24

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

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

    IC84331

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSY

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC77929

Modified date: 24 June 2013