IBM Support

IT23033: DB2 MIGHT TRY TO READ LOG RECORDS THAT DO NO LONGER EXIST AFTER LOG FILE TRUNCATION

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • It may happen that Db2 wants to perform a rollback with the use
    of log records that no longer exist:
    
    2017-09-21-10.30.43.537525+000 I73458A13104         LEVEL: Error
    PID     : 9175218              TID : 105437         PROC :
    db2sysc 0
    INSTANCE: db2jkl               NODE : 000           DB   : JKL
    APPHDL  : 0-37321              APPID:
    165.131.135.142.29701.170921103031
    AUTHID  : SAPR3                HOSTNAME: server
    EDUID   : 105437               EDUNAME: db2agent (JKL) 0
    FUNCTION: DB2 UDB, data protection services, sqlptudo,
    probe:1010
    MESSAGE : ZRC=0x87100048=-2028994488=SQLP_BADLSO "Invalid LSO
    value."
              DIA8546C An invalid log sequence offset (LSO), the
    value was "".
    DATA #1 : String, 34 bytes
    undolso / TEntryp / agtCB / dpsAcb
    DATA #2 : unsigned integer, 8 bytes
    108027041854878
    DATA #3 : SQLP_TENTRY, PD_TYPE_SQLP_TENTRY, 11856 bytes
    pSuccTid = a000204af104280
    pPrevTid = a000204af01ba80
    succ_lsn = 0
    pre_lsn = 0
    succ_undoLsn = 0
    pre_undoLsn =0
    logSpace = 1736
    ICushionContribution = 0
    logSpaceSaved = 0
    extraReserved = 18264
    totalReservedLogSpace = 246943
    mrtPenlist Address = 0
    Pending List Address = 0
    Pending List End Address = 0
    First Pending list entry for update MRT = 0
    tsp_to_repair = 0
    tsp_repaired = 0
    Table Space List Address = 0
    Transaction Entry State = 6: SQLP_TSAVEPOINT
    tflag = 00000000
    tflag2 = 00000200
    
    The root cause for this issue is unknown. This APAR will add
    debugging code that provide additional information for future
    root cause analysis.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All users.                                                   *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 11.1 Mod 3 Fixpack 3.                         *
    ****************************************************************
    

Problem conclusion

  • See Problem Description above.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT23033

  • 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

    2017-11-03

  • Closed date

    2018-03-16

  • Last modified date

    2018-03-16

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

    IT23032

  • 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":"BU048","label":"IBM Software"},"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:
16 March 2018