home clear 64x64
en blue 200x116 de orange 200x116 info letter User
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 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 FixList