IBM Support

IT27455: RELAX DB2DIAG.LOG MESSAGE IN SQLSFETCHNEXTTEMPRECORD PROBE 504

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • The following message might occur in the db2diag.log:
    
    2018-11-04-14.31.24.723658+060 I33277E1181 LEVEL: Error
    PID : 5344 TID : 140030047676160 PROC : db2sysc 0
    INSTANCE: db2jkl NODE : 000 DB : JKL
    APPHDL : 0-63133 APPID: *LOCAL.db2jkl.181104133129
    AUTHID : DB2JKL HOSTNAME: server
    EDUID : 401 EDUNAME: db2agnts (JKL) 0
    FUNCTION: DB2 UDB, sort/list services, sqlsFetchNextTempRecord,
    probe:504
    MESSAGE : ZRC=0x80130003=-2146238461=SQLS_INTRP "Interrupt. User
    Cancel."
    DIA8003C The interrupt has been received.
    DATA #1 : Codepath, 8 bytes
    1
    DATA #2 : ZRC, PD_TYPE_ZRC, 4 bytes
    0x80130003
    DATA #3 : SQLS_MBUFS, PD_TYPE_SQLS_MBUFS, 1728 bytes
    SQLS_MBUFS: Address:0x7f5be2c761d8, Size:x6c0, Size:1728
    x0688 pValues 0x7f5be2c6c6f0
    x0690 recptr 0x7f5be2c6b3f0
    x06B0 records 28334
    x0698 recordBuffer 0x7f5be2c671a0
    x06A0 iNumBufferedRecords 303
    x06A8 mergeFlags x00000002
    - SQLS_CALLED_FETCH_NEXT_TEMP_REC
    x06B8 sortNum 0
    x06BC bufferedFetchRC
    
    This APAR will relax the level of the message.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 11.1.4.5 or later                             *
    ****************************************************************
    

Problem conclusion

  • Upgrade to Db2 11.1.4.5 or later
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT27455

  • 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-12-20

  • Closed date

    2019-10-31

  • Last modified date

    2019-10-31

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

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

    IT30799

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:
31 October 2019