IBM Support

IT26391: ERRORS FROM SQLPRECOVERYLSN IN CREATING LOG AT BACKUP FILE CAN LEAVE A TABLE SPACE UNABLE TO BE ROLLED FORWARD

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When an error with a table space is detected, under certain
    circumstances the table space is taken offline and placed in
    rollforward pending.  Examples of such circumstances can be:
    
    1. rollforward fails to replay a create table space operation
    due to a container issue
    2. rollforward fails to replay an alter table space operation
    due to a container issue
    3. crash recovery or rollforward fails to start a table space
    due to a container issue
    
    When doing so the recovery starting point information is stored
    in a log at backup file that normally is found under a directory
    such as /db1/NODE0000/SQL00001/SQLOGAB.  This file is needed for
    the ensuing table space rollforward and without it the
    rollforward will not succeed.  A failure such as:
    
       FUNCTION: DB2 UDB, database utilities,
    sqluBRLogAtBkpInfo::allocate, probe:107
       MESSAGE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not
    found."
                        DIA8411C A file "" could not be found.
       DATA #1 : String, 31 bytes
       BRLogAtBkp file does not exist!
         [1] 0x00007F1BB578C988
    _ZN18sqluBRLogAtBkpInfo8allocateERiP13SQLO_MEM_POOLPK18sqluBRLog
    AtBkpFile + 0xE8
         [2] 0x00007F1BB535C52B
    _Z19sqlbGetPoolLogAtBkpP12SQLB_POOL_CBPP18sqluBRLogAtBkpInfoP12S
    QLB_GLOBALS + 0xFB
         [3] 0x00007F1BB5FA0C0C
    _Z21sqlpGetTablespacesMRTP8sqeAgentPmPj + 0x7AC
         [4] 0x00007F1BB5FA13A9
    _Z11sqlpFindMRTP8sqeAgentP14sqlpMasterDbcbjPjPm + 0x459
         [5] 0x00007F1BB5F9B677
    _Z23sqlpInitForwardRecoveryP8sqeAgentP14sqlpMasterDbcbP9SQLP_LSN
    8PjPKc + 0x187
         [6] 0x00007F1BB5FA0428
    _Z19sqlpForwardRecoveryP8sqeAgenttPKcPiPjt + 0x1CD8
    
    can be found in the db2diag.log.
    
    In this case the table space cannot be rolled forward and a
    table space restore and roll forward will be necessary.
    

Local fix

  • Restore and roll forward table space.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to the latest fix pack.                              *
    ****************************************************************
    

Problem conclusion

  • Problem was first fixed in Db2 Version 11.1.4.4.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT26391

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2018-09-23

  • Closed date

    2018-12-02

  • Last modified date

    2018-12-02

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

    IT26388

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

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • RB10 PSN

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
02 December 2018