DB2 FOR LUW / DB2FORLUW / A50 - DB2

The crash can happen under the following conditions:
1. Db2 registry variable  DB2_WORKLOAD=ANALYTICS is set
2. dbm cfg parameter INTRA_PARALLEL is set to no (default)
3. Application is running loosely coupled XA transaction.
Application running on window using MSDTC as transaction manger
by default uses Loosely Coupled XA transaction.

The issue is applicable if all of three conditions are true.

On crash, stack trace back may contain the following functions :

12       sqlrrMapZrc
13       sqlrrcom_dps
14       sqlrr_xcommit
15       sqljsSyncCommitted
16       sqljs_ddm_syncctl
17       sqljsParseRdbAccessed
18       sqljsParse
19       sqljsSqlam
20       sqljsDriveRequests
21       sqljsDrdaAsInnerDriver
22       sqljsDrdaAsDriver
23       sqeAgent::RunEDU
24       sqzEDUObj::EDUDriver
25       sqloEDUEntry
26       start_thread

In the db2diag.log you might see an error like this:


FUNCTION: DB2 UDB, data management, sqldEndGlobalTran,
probe:1376
RETCODE : ZRC=0x8704002F=-2029780945=SQLD_PARM "PARAMETER ERROR"
          DIA8544C An invalid data type was encountered, the
value was "".


FUNCTION: DB2 UDB, data protection services, sqlpEndUowRuntime,
probe:700
MESSAGE : ZRC=0x8704002F=-2029780945=SQLD_PARM "PARAMETER ERROR"
          DIA8544C An invalid data type was encountered, the
value was "".
DATA #1 : db2LogStreamIDType, PD_TYPE_DB2_LOG_STREAM_ID, 2 bytes
0
DATA #2 : SQLP_TENTRY, PD_TYPE_SQLP_TENTRY, 11824 bytes
pSuccTid = 0x7f1698da4c80
pPrevTid = 0x7f1698d99280
succ_lsn = 0
pre_lsn = 0
succ_undoLsn = 0
pre_undoLsn =0
logSpace = 0
ICushionContribution = 0
logSpaceSaved = 0
extraReserved = 0
totalReservedLogSpace = 304
mrtPenlist Address = (nil)
Pending List Address = (nil)
Pending List End Address = (nil)

...


FUNCTION: DB2 UDB, data protection services, sqlpxcm1,
probe:2380
MESSAGE : ZRC=0x8704002F=-2029780945=SQLD_PARM "PARAMETER ERROR"
          DIA8544C An invalid data type was encountered, the
value was "".

****************************************************************
* USERS AFFECTED:                                              *
* all                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Update to v10.5fp10 or above                                 *
****************************************************************

Enable explicitly intra_parallel to yes, along with
DB2_WORKLOAD=analytics
db2 update dbm cfg using INTRA_PARALLEL YES

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

11.05.2018
20.11.2018
20.11.2018