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

WHEN STATEMENTCONCENTRATOR IS SET ALONG WITH SQL_ATTR_PARAMOPT_A TOMIC=0,
CLI APP ERRORS OUT AGAINST DB2 Z/OS(-20186,-215, -312)

product:
DB2 CONNECT / DB2CONNCT / 970 - DB2
Problem description:
Issues fixed through this APAR: 
 
- WHEN STATEMENTCONCENTRATOR IS ENABLED ALONG WITH 
SQL_ATTR_PARAMO PT_ATOMIC=0, CLI APPLICATION RECEIVES -20186 
AGAINST DB2 Z/OS 
 
- SQL0104N error when statement concetrator and EXTENDED 
INDICATORS is enabled 
 
- when an insert statement with non-array inserts is executed 
with statement concentrator enabled, server would throw -215 
back to client. 
 
- -312 error when statement concentrator is enabled and insert 
statement is retried. 
 
When Statementconcentrator is enabled along with 
SQL_ATTR_PARAMOPT_ATOMIC=0, CLI application receives SQLCODE 
=-20186 against DB2 z/OS 
 
Message=[IBM][CLI Driver][DB2] SQL0969N  There is no message 
text  corresponding to SQL error "-20186" in the message file on 
this  workstation.  The error was returned from module "DSNXEDP 
"  with  original tokens "".  SQLSTATE=07501 
 
 
Trace snippet: 
21827   entry DB2 UDB call level interface SQLSetStmtAttrW api 
(1.3.42.534.3)^M 
        pid 5056 tid 5092 cpid -1 node -1 sec 142 nsec 
88846766^M 
^M 
        bytes 24^M 
^M 
        Data1   (PD_CLI_TYPE_HSTMT,4) Statement Handle:^M 
        hStmt=1:1^M 
        Hex:^M 
        0100 0100                                  ....^M 
^M 
        Data2   (PD_CLI_TYPE_STMT_ATTR,4) Statement Attribute:^M 
        SQL_PARAMOPT_ATOMIC^M 
        Hex:^M 
        EC04 0000                                  ....^M 
^M 
 
 
DB2 trace DRDA buffer: 
21988    data DB2 UDB DRDA Communication Manager sqljcSend fnc 
(3.3.54.5.0.1177) 
    pid 5056 tid 5092 cpid -1 node -1 sec 52324 nsec 781463286 
probe 1177 
    bytes 248 
 
    SEND BUFFER(AR): 
 
            EXCSQLIMM RQSDSS                 (ASCII) 
(EBCDIC) 
         0 1 2 3 4 5 6 7  8 9 A B C D E F   0123456789ABCDEF 
0123456789ABCDEF 
  0000  0053D0510001004D 200A004421134445   .S.Q...M ..D!.DE 
..}....(........ 
  0010  565F445354312020 2020202020202020   V_DST1 
.^.............. 
  0020  4E554C4C49442020 2020202020202020   NULLID 
+.<<............ 
  0030  2020535953534832 3030202020202020     SYSSH200 
................ 
  0040  202020205359534C 564C303100410005       SYSLVL01.A.. 
.......<.<...... 
  0050  2105F1                              !.. 
..1 
 
            SQLATTR OBJDSS                   (ASCII) 
(EBCDIC) 
         0 1 2 3 4 5 6 7  8 9 A B C D E F   0123456789ABCDEF 
0123456789ABCDEF 
  0000  0058D05300010052 245000000000484E   .X.S...R$P....HN 
..}......&.....+ 
  0010  4F542041544F4D49 4320434F4E54494E   OT ATOMIC CONTIN 
!....!(....!+..+ 
  0020  5545204F4E205351 4C45584345505449   UE ON SQLEXCEPTI 
...!+...<....&.. 
  0030  4F4E20434F4E4345 4E54524154452053   ON CONCENTRATE S 
!+..!+..+....... 
  0040  544154454D454E54 532057495448204C   TATEMENTS WITH L 
....(.+........< 
  0050  49544552414C53FF                    ITERALS. 
.....<.. 
 
            SQLSTT OBJDSS                    (ASCII) 
(EBCDIC) 
         0 1 2 3 4 5 6 7  8 9 A B C D E F   0123456789ABCDEF 
0123456789ABCDEF 
  0000  002DD04300010027 2414000000001D53   .-.C...'$......S 
..}............. 
  0010  4554204355525245 4E542053514C4944   ET CURRENT SQLID 
........+....<.. 
  0020  203D202740543030 31323027FF          = '@xxxxxx'. 
.... ........
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* CLI application users against DB2 Zos                        * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V9.7 FP10 or higher                           * 
****************************************************************
Local Fix:
Remove SQL_PARAMOPT_ATOMIC=0 from the application or 
SQL_PARAMOPT_ATOMIC=1
Solution
First fixed in DB2 V9.7 FP 10
Workaround
not known / see Local fix
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC99455 IC99456 IC99457 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
19.11.2013
17.11.2014
17.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
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.