home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
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
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC62782 Status: Geschlossen

CLI APPLICATION RECEIVES CLI0002W INSTEAD OF SQLSTATE=01003 FOR A QUERY
AGAINST DB2 FOR Z/OS.

Produkt:
DB2 CONNECT / DB2CONNCT / 970 - DB2
Problembeschreibung:
A CLI application may receive a CLI0002W "Data Truncated" 
warning message when executing a query against DB2 for z/OS, 
when the expected warning is SQLSTATE=01003 "Null values were 
eliminated from the argument of a column function." 
 
When this warning is returned, DB2 for z/OS updates the 
SQLWARN[1] field in the SQLCA to either an "N" (for 
non-scrollable cursors) or "S" (for scrollable cursors).   The 
DB2 CLI driver does not expect a value for SQLWARN[1], and if it 
does, it makes the assumption that data was truncated. 
 
SQLSTATE=01003 will be returned when the query uses an aggregate 
function like MAX() and the column contains NULL values.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* A CLI application may receive a CLI0002W "Data               * 
* Truncated"warning message when executing a query against DB2 * 
* for z/OS,when the expected warning is SQLSTATE=01003 "Null   * 
* valueswere eliminated from the argument of a column          * 
* function."When this warning is returned, DB2 for z/OS        * 
* updates theSQLWARN[1] field in the SQLCA to either an "N"    * 
* (fornon-scrollable cursors) or "S" (for scrollable           * 
* cursors).The DB2 CLI driver does not expect a value for      * 
* SQLWARN[1],and if it does, it makes the assumption that data * 
* wastruncated.                                                * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 v9.7 FP2                                      * 
****************************************************************
Local-Fix:
On DB2 for z/OS there is a parameter called DISABSCL.  If this 
parameter is set to YES, and the cursor specified is a 
non-scrollable cursor, then DB2 for z/OS will not return "N" 
in SQLWARN[1].  So, setting DISABSCL=YES might workaround the 
issue. 
 
The db2cli.ini keyword IGNOREWARNINGS=1 can be used as well to 
suppress all warnings, including the CLI0002W message.
verfügbare FixPacks:
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
First fixed in DB2 UDB Version 9.7 FixPack 2
Workaround
On DB2 for z/OS there is a parameter called DISABSCL.  If this 
parameter is set to YES, and the cursor specified is a 
 
 
non-scrollable cursor, then DB2 for z/OS will not return "N"
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC62916 IC62917 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
26.08.2009
25.05.2010
25.05.2010
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP2
Problem behoben lt. FixList in der Version
9.7.0.2 FixList