IBM Support

IT23294: THE CAPTURE PROGRAM OF Q-REPLICATION TERMINATES WITH SQL2038N ONDB2 PURESCALE

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as fixed if next.

Error description

  • #  Problem description
    When running in DB2 pureScale environment, the capture program
    of Q replication terminates with error SQL2038N:
    
    
    # Diagnostic information
    In the capture log from Q replication, the following error
    messages are seen:
    
    2017-08-09-11.22.04.294755 <logrdDB2LUW::readTheLog> ASN8041D
    "Q Capture" : "PRD2DRP" : "LogrdThread" : db2LogRead API is
    sendi
    ng us backwards in theDB2 Log: First LSN is
    "0000:0007:05e9:5cff:0000:0159:b38c:6f4a" while Next Start LSN
    is "0000:0000:0000:00
    00:0000:0000:0000:0000"
    2017-08-09-11.22.04.294914 <logrdDB2LUW::readTheLog> ASN0552E
    "Q Capture" : "PRD2DRP" : "logrd" : The program encountered an
    SQL error. The server name is "PROD". The SQL request is
    "db2ReadLog". The table name is "". The SQLCODE is "-2038". The
    SQLSTATE is "     ". The SQLERRMC is "". The SQLERRP is
    "SQLPRLOG".
    SQL2038N  A database system error "" occurred during processing.
    
    In db2diag.log, A "checksum error" is reported for a parcitular
    transaction log. In this case, it's S0000091.LOG.
    
    2017-08-09-11.21.48.603790+540 I17348223A570        LEVEL: Info
    PID     : 22545070             TID : 2521457        PROC :
    db2sysc 0
    INSTANCE: db2prod               NODE : 000           DB   : PROD
    APPHDL  : 0-4084               APPID: *N0.db2prod.170809012214
    AUTHID  : db2prod               HOSTNAME: prodsrv01
    EDUID   : 2521457              EDUNAME: db2shred.1 (PROD) 0
    FUNCTION: DB2 UDB, recovery manager, sqlpshrEdu, probe:14000
    DATA #1 : <preformatted>
    Merging LFR scan flags after processing 16 pages.
    Ping extent flags: 842
    Pong extent flags: 3
    Merged flags:      843
    
    2017-08-09-11.22.03.947425+540 I17348794A505        LEVEL:
    Warning
    PID     : 22545070             TID : 2754963        PROC :
    db2sysc 0
    INSTANCE: db2prod               NODE : 000           DB   : PROD
    HOSTNAME: prodsrv01
    EDUID   : 2754963              EDUNAME: db2lfr.3 (PROD) 0
    FUNCTION: DB2 UDB, recovery manager, sqlplfrVerifyLogPages,
    probe:500
    DATA #1 : <preformatted>
    LFR Scan Num            = 749
    LFR Scan Caller's EDUID = 2753935
    Checksum error when reading page 32773 from log file
    S0000091.LOG
    
    The capture program of Q replication has to be restarted.
    Normally it does not encounters the error on this log file any
    more. After the incident, running db2cklog against the log
    S0000091.LOG returns success and no checksum error is found.
    
    This issue is a timing issue which could occur when Db2
    reads from remote log stream.  Last page can be read while
    written to, causing checksum error.
    

Local fix

  • Restarting the capture program of Q replication fixes the issue.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Restarting the capture program of Q replication fixes the    *
    * issue.                                                       *
    *                                                              *
    * Updating to fix pack 3 will reduce the likelihood of hitting *
    * the issue.                                                   *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    IT23294

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-11-27

  • Closed date

    2018-03-15

  • Last modified date

    2018-03-15

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

    IT22993

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

Fix information

Applicable component levels

  • RB10 PSN

       UP

  • RB10 PSY

       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:
15 March 2018