suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IT31716 Status: Closed

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

product:
DB2 FOR LUW / DB2FORLUW / B50 - DB2
Problem 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
Problem Summary:
****************************************************************
* USERS AFFECTED:                                              *
* ALL                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Db2 v11.5 Mod 2 Fix Pack 0 or higher              *
****************************************************************
Local Fix:
Solution
Workaround
not known / see Local fix
BUG-Tracking
forerunner  : IT31687 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
31.01.2020
18.02.2020
18.02.2020
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)