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 IT34140 Status: Closed

SQL20569N WITH REASON CODE "4" DURING LOADING LZ4 COMPRESSED

product:
DB2 FOR LUW / DB2FORLUW / B50 - DB2
Problem description:
Traces shows Failure while decompressing.

Root Cause: Decompress logic while storing C block found that C
block present in current frame is less than CblockSize hence it
request for more source to decode and write to output buffer. In
this process the dest buffer was new and decompress will not
write anything and ask for next source buffer to complete
processing.
In caller we have a check for verifying that decompress logic
will not ask for more source when it is last buffer but the last
buffer check has not been done. The current check only checks
for source byte read and bytes written to output buffer.

To validate please repro failed ET command with
db2trc on -l 32M -m "*.*.EXTBL,SQLZ.*.*"

Either of the following two errors are indicative of the
problem:
===== 1 =====

452815      extblTransportFillMsgBufFile entry
452816      | sqlzLz4DeCompressStream entry
452817      | sqlzLz4DeCompressStream exit [rc = 0x870F01F2 =
-2029059598 = SQLO_COMPRESSION_FAILED]

        bytes 16

        Data1   (PD_TYPE_UINT,8) unsigned integer:
        0

452818      | ExtblController::setExtblRc entry
452819      | ExtblController::setExtblRc exit
452820      | ExtblController::setShutdownJobRc entry
452821      | | ExtblController::setExtblRc entry
452822      | | ExtblController::setExtblRc exit
452823      | ExtblController::setShutdownJobRc exit
452832      extblTransportFillMsgBufFile error [probe 2443] [
ZRC = 0x00000004 = 4]

===== 2 =====
9           sqlzBuildInstanceTopology entry [eduid 26857 eduname
db2agent]
10          sqlzBuildInstanceTopology exit
263         sqlzeMapZrc entry [eduid 26857 eduname db2agent]
264         | sqlzGetZRCInfo entry [eduid 26857 eduname
db2agent]
265         | sqlzGetZRCInfo exit [rc = 0x00000064 = 100 =
SQLUDI_RC_RECORD_WARNING]
266         sqlzeMapZrc errtrans [probe 40] [ ZRC = 0x80040001 =
-2147221503 = SQLD_NOREC -->  SQL0100  ]
267         sqlzeMapZrc error [probe 50] [ ZRC = 0x80040001 =
-2147221503 = SQLD_NOREC]
Problem Summary:
****************************************************************
* USERS AFFECTED:                                              *
* all                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Db2 11.5.5.0 or higher                            *
****************************************************************
Local Fix:
File is *NOT* corrupt, the problem is with reading code.
No workaround available.
Solution
Workaround
****************************************************************
* USERS AFFECTED:                                              *
* all                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Db2 11.5.5.0 or higher                            *
****************************************************************
Comment
Upgrade to Db2 11.5.5.0 or higher
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
08.09.2020
20.11.2020
20.11.2020
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)