IBM Support

IC82217: ON IA32 PLATFORM(WINDOWS OR LINUX), DATABASE MARKED BAD DUE TO SQLP_BADLSN FOUND

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • On IA32 platforms, due to an internal non-atomic write of a 64
    bit value on 32-bit operating systems, an application may fail
    with the error "SQL1034C The database is damaged...".
    You can find SQLP_BADLSN error in db2diag.log. The following is
    a snippet of db2diag.log:
    
    2012-02-16-10.51.27.468000+060 I3684517H548       LEVEL: Severe
    
    PID     : 2464                 TID  : 5424        PROC :
    db2syscs.exe
    INSTANCE: DB2                  NODE : 000         DB   : SAMPLE
    
    APPHDL  : 0-26951              APPID:
    9.36.30.159.4691.120216094200
    AUTHID  : SAMPLE03
    
    EDUID   : 5424                 EDUNAME: db2agent (SAMPLE) 0
    
    FUNCTION: DB2 UDB, data protection services, sqlpgrlg,
    probe:9120
    DATA #1 : <preformatted>
    
    diff 47, count 47, fromptr 7F4BA03F, CharPtr 7F4BB171, pageLso
    
    1821066137532, LowPageLso 1821066133457
    
    
    
    2012-02-16-10.51.27.484000+060 I3685067H541       LEVEL: Severe
    
    PID     : 2464                 TID  : 5424        PROC :
    db2syscs.exe
    INSTANCE: DB2                  NODE : 000         DB   : SAMPLE
    
    APPHDL  : 0-26951              APPID:
    9.36.30.159.4691.120216094200
    AUTHID  : SAMPLE03
    
    EDUID   : 5424                 EDUNAME: db2agent (SAMPLE) 0
    
    FUNCTION: DB2 UDB, data protection services, sqlpgrlg,
    probe:9120
    DATA #1 : <preformatted>
    
    rc -2028994519, pageByteCount 4076, pageLso 1821066137532
    LookForLso
    1821066133504, Bp 7F4BA000
    
    
    
    2012-02-16-10.51.27.484000+060 I3685610H152       LEVEL: Severe
    
    PID:2464 TID:5424 NODE:000 Title: SQLP_LFPB
    
    Dump File: c:\DB2\2464.5424.000.dump.bin
    
    
    
    2012-02-16-10.51.27.515000+060 I3685764H1085      LEVEL: Error
    
    PID     : 2464                 TID  : 5424        PROC :
    db2syscs.exe
    INSTANCE: DB2                  NODE : 000         DB   : SAMPLE
    
    APPHDL  : 0-26951              APPID:
    9.36.30.159.4691.120216094200
    AUTHID  : SAMPLE03
    
    EDUID   : 5424                 EDUNAME: db2agent (SAMPLE) 0
    
    FUNCTION: DB2 UDB, data protection services, sqlpgrlg,
    probe:2510
    DATA #1 : <preformatted>
    
     -2028994519 when reading LSO 1821066133504 from log file
    S0090067.LOG
    dpsAgtCbFlags 0 setSkipOutputBuf 0
    
    CALLSTCK:
    
      [0] 0x6CD37526 pdLogPrintf + 0x2F8
    
      [1] 0x6F2A0C88
    
    _VInfreq_?sqlpgrlgYAHPAVsqeAgentI_KIPADPAUSQLO_MEM_POOLPAUSQLP_L
    RHPAPADZ
    + 0x24C
    
      [2] 0x6E146D9F sqlpReadLogForCC + 0x97
    
      [3] 0x6D72B35C sqldGetCurrentlyCommitted + 0x13E
    
      [4] 0x6EF49063 _VInfreq_?sqldReadNormYAHPAUSQLD_DFM_WORKHZ +
    0x56F
      [5] 0x6D728665 sqldfrd + 0xF09
    
      [6] 0x6D727859 sqldfrd + 0xFD
    
      [7] 0x6D6B560A sqldRowFetch + 0x358
    
      [8] 0x6E498B53 sqlritaSimplePerm + 0xAB
    
      [9] 0x6E495471 ?sqlriunn.@@YAHPAUsqlrr_cb@@PAUsqlri_stob@@@Z +
    0x23D
    
    
    2012-02-16-10.51.27.875000+060 I3686851H1026      LEVEL: Severe
    
    PID     : 2464                 TID  : 5424        PROC :
    db2syscs.exe
    INSTANCE: DB2                  NODE : 000         DB   : SAMPLE
    
    APPHDL  : 0-26951              APPID:
    9.36.30.159.4691.120216094200
    AUTHID  : SAMPLE03
    
    EDUID   : 5424                 EDUNAME: db2agent (SAMPLE) 0
    
    FUNCTION: DB2 UDB, data protection services, sqlpgrlg,
    probe:2510
    DATA #1 : <preformatted>
    
    HeadLsn 000001AA10530CBE, reqlso 1821066133504
    
    CALLSTCK:
    
      [0] 0x6CD37526 pdLogPrintf + 0x2F8
    
      [1] 0x6F2A0CDA
    
    _VInfreq_?sqlpgrlgYAHPAVsqeAgentI_KIPADPAUSQLO_MEM_POOLPAUSQLP_L
    RHPAPADZ
    + 0x29E
    
      [2] 0x6E146D9F sqlpReadLogForCC + 0x97
    
      [3] 0x6D72B35C sqldGetCurrentlyCommitted + 0x13E
    
      [4] 0x6EF49063 _VInfreq_?sqldReadNormYAHPAUSQLD_DFM_WORKHZ +
    0x56F
      [5] 0x6D728665 sqldfrd + 0xF09
    
      [6] 0x6D727859 sqldfrd + 0xFD
    
      [7] 0x6D6B560A sqldRowFetch + 0x358
    
      [8] 0x6E498B53 sqlritaSimplePerm + 0xAB
    
      [9] 0x6E495471 ?sqlriunn.@@YAHPAUsqlrr_cb@@PAUsqlri_stob@@@Z +
    0x23D
    
    2012-02-16-10.51.28.125000+060 I3696872H559       LEVEL: Severe
    PID     : 2464                 TID  : 5424        PROC :
    db2syscs.exe
    INSTANCE: DB2                  NODE : 000         DB   : SAMPLE
    APPHDL  : 0-26951              APPID:
    9.36.30.159.4691.120216094200
    AUTHID  : SAMPLE03
    EDUID   : 5424                 EDUNAME: db2agent (SAMPLE) 0
    FUNCTION: DB2 UDB, data management, sqldRowFetch, probe:666
    RETCODE : ZRC=0x87100029=-2028994519=SQLP_BADLSN "Invalid LSN
    value."
              DIA8538C An invalid log sequence number (LSN), the
    value was "".
    

Local fix

  • Set database parameter CUR_COMMIT to DISABLED
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Prior to DB2 V9.7 FP7                                        *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 V9.7 FP7                                      *
    ****************************************************************
    

Problem conclusion

  • First Fixed in DB2 V9.7 Fixpack 7
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC82217

  • 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

    2012-03-23

  • Closed date

    2012-10-25

  • Last modified date

    2012-10-25

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

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

    IC86709

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 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":"9.7","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
25 October 2012