IBM Support

IT31714: ON RARE OCCASION, DATA CORRUPTION MIGHT BE INDUCED BY FAILURE TOPANIC THE DATABASE ON ENCRYPTION ERROR.

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

  • On rare occasion, db2 might report ECF_CRYPT_UNEXPECTED_ERROR
    and/or SQLEX_UNEXPECTED_SYSERR when doing page IOs with the
    following stack for an encrypted database, these errors in this
    code path are severe enough to panic the system right away,
    however, db2 continues on page IOs which results in corrupted
    data pages.
    
    2020-01-27-19.24.05.875563-300 I112139129A2028      LEVEL: Error
    PID     : 64684174             TID : 9768           PROC :
    db2sysc 0
    INSTANCE: XXXXXX            NODE : 000           DB   : XXXXX
    HOSTNAME: XXXXX
    EDUID   : 9768                 EDUNAME: db2pclnr (TDSCCD01) 0
    FUNCTION: DB2 Common, Cryptography, cryptDigestHP, probe:725
    MESSAGE : ECF=0x90000403=-1879047165=ECF_CRYPT_UNEXPECTED_ERROR
              Unexpected cryptographic error
    DATA #1 : Hex integer, 4 bytes
    0xFFFFFFFE
    CALLSTCK: (Static functions may not be resolved correctly, as
    they are resolved to the nearest symbol)
      [0] 0x0900000014CDCEC4 pdOSSeLoggingCallback + 0x59C
      [1] 0x090000000DED36FC oss_log__FP9OSSLogFacUiN32UlN26iPPc +
    0x1BC
      [2] 0x090000000DED3500 ossLog + 0xA0
      [3] 0x0900000016D14B38 cryptLogICCError + 0x180
      [4] 0x0900000017C14E4C cryptDigestHP + 0x380
      [5] 0x0900000017BCAE20
    cryptGenerateIVFromData__FPUcUiPCUcN32PvT7 + 0x1F4
      [6] 0x09000000140D0358
    sqlexGetDatabaseDEKCipherInfo__FP16sqeLocalDatabasePPC20cryptBlo
    ckCipherInfoPUcUlT3PvT6 + 0xD8
      [7] 0x0900000015096494
    sqlbCommonWriteSetup__FP12SQLB_GLOBALSP8SQLB_BPDP9SQLB_PAGEP11SQ
    LO_IO_REQP15SQLB_RANGE_INFOP21SqlbLocalOpenFileInfobUsP14SQLB_P
    + 0xE8
      [8] 0x0900000015061DC4
    sqlbCommonWriteSetup__FP12SQLB_GLOBALSP8SQLB_BPDP9SQLB_PAGEP11SQ
    LO_IO_REQP15SQLB_RANGE_INFOP21SqlbLocalOpenFileInfobUsP14SQLB_P
    + 0x194C
      [9] 0x090000001506C138
    sqloDispatchNBlocks__20SQLO_LIO_HANDLE_DATAFPP11SQLO_IO_REQUlPC2
    2SQLO_LIO_CALLBACK_INFOP24SQLO_LIO_DISPATCH_STATUS16SQLO_LIO_OP
    + 0x8D8
      [10] 0x0900000014F23194 sqlbClnrEntryPoint__FP12sqbPgClnrEdu +
    0x1220
      [11] 0x0900000014F23194 sqlbClnrEntryPoint__FP12sqbPgClnrEdu +
    0x1220
      [12] 0x0900000014F2135C sqlbClnrEntryPoint__FP12sqbPgClnrEdu +
    0x974
    
    2020-01-27-19.24.06.076678-300 I112830460A525       LEVEL:
    Severe
    PID     : 64684174             TID : 9768           PROC :
    db2sysc 0
    INSTANCE: XXXXX             NODE : 000           DB   : XXXXX
    HOSTNAME: XXXXX
    EDUID   : 9768                 EDUNAME: db2pclnr (TDSCCD01) 0
    FUNCTION: DB2 UDB, bsu security, sqlexGetDatabaseDEKCipherInfo,
    probe:1328
    MESSAGE : ZRC=0x875C00CD=-2024013619=SQLEX_UNEXPECTED_SYSERR
              "Unexpected System Error"
    DATA #1 : unsigned integer, 4 bytes
    2415920131
    
    2020-01-27-19.24.06.077032-300 I112830986A1846      LEVEL: Error
    PID     : 64684174             TID : 9768           PROC :
    db2sysc 0
    INSTANCE: XXXXX             NODE : 000           DB   : XXXXX
    HOSTNAME: XXXXX
    EDUID   : 9768                 EDUNAME: db2pclnr (TDSCCD01) 0
    FUNCTION: DB2 Common, Cryptography, cryptEncryptBufferHP,
    probe:3318
    MESSAGE : ECF=0x90000403=-1879047165=ECF_CRYPT_UNEXPECTED_ERROR
              Unexpected cryptographic error
    DATA #1 : Hex integer, 4 bytes
    0xFFFFFFFE
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * using encryption                                             *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * upgrade to version 11.1 mod 4 Fix Pack 6                     *
    ****************************************************************
    

Problem conclusion

  • First fixed in version 11.1 mod 4 Fix Pack 6
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT31714

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2020-01-31

  • Closed date

    2021-03-15

  • Last modified date

    2021-03-29

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

    IT31687

  • 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

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

Document Information

Modified date:
31 March 2021