DB2 - Problem description
Problem IC98210 | Status: Closed |
CLI APPLICATION CRASHES DUE TO ARRAY INPUT FLAG FAILS TO RESET IN CLI LAYER WHILE CLI APPLICATION PERFORMS ARRAY INPUT. | |
product: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problem description: | |
Array input flag fails to reset in CLI_SQLExecute function while doing array insert, resulting in trap for sqljrGenFdoOff() for the subsequent non-array input scenario. CLI application using array inputs for compound SQL crashes with following stack: 0 Id: 17b0.1474 Suspend: 1 Teb: 00000000`7efdb000 Unfrozen ChildEBP RetAddr Args to Child 0039ecec 6c14eadf 02fc2480 00000000 00000018 db2app!__intel_new_memcpy+0x1e7 0039ed1c 6c5546b1 02fc1fa0 045df628 00000000 db2app!sqljrGenFdoOff+0xb3 0039eda0 6c131afd 045df628 00000000 00000000 db2app!_VInfreq_?sqljrGenSqlDtaYAHPAUdb2UCinterfaceIZ+0x127 0039edd4 6c30c899 045df628 00000000 0486b598 db2app!sqljrDrdaArExecute+0xd5 0039ee34 6c242593 0486b440 0486b44c 0039ee50 db2app!?CLI_sqlExecute.@@YAFPAUCLI_STATEMENTINFO@@PAUCLI_ERRORHE ADERINFO@@@Z+0x373 [clisql.C @ 5193] 0039eea0 6c241bda 54c93d89 074234d0 0039eec4 db2app!?SQLExecute2.@@YAFPAUCLI_STATEMENTINFO@@PAUCLI_ERRORHEADE RINFO@@@Z+0x6f3 0039ef0c 59536f57 00020006 25180a9f 0741e588 db2app!SQLExecute+0x2da [cliexec.C @ 13939] In db2trace from client 115526 23.141122642 | | | | | | sqljcWriteUint16At entry 115527 23.141122984 | | | | | | | sqljcWriteFindPosition entry 115528 23.141123326 | | | | | | | sqljcWriteFindPosition exit 115529 23.141123669 | | | | | | sqljcWriteUint16At exit 115530 23.141124011 | | | | | | sqljcWriteUint16At entry 115531 23.141124353 | | | | | | | sqljcWriteFindPosition entry 115532 23.141124353 | | | | | | | sqljcWriteFindPosition exit 115533 23.141124695 | | | | | | sqljcWriteUint16At exit 115534 23.141125037 | | | | | | sqljrGenFdoOff entry | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All DB2 V9.7 users. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 V9.7 Fix Pack 10 or higher. * **************************************************************** | |
Local Fix: | |
Solution | |
First fixed in DB2 V9.7 Fix Pack 10. | |
Workaround | |
not known / see Local fix | |
BUG-Tracking | |
forerunner : APAR is sysrouted TO one or more of the following: IC98799 IC98803 follow-up : | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 09.12.2013 13.11.2014 13.11.2014 |
Problem solved at the following versions (IBM BugInfos) | |
9.7.FP10 | |
Problem solved according to the fixlist(s) of the following version(s) | |
9.7.0.10 |