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 IC85491 Status: Geschlossen

SQLSTATE RETURNED FOR MISSING TABLE/VIEW IS INCORRECT ? RETURNS D42S22
(COLUMN NOT FOUND) INSTEAD OF D42S02 (TABLE NOT FOUND).

Produkt:
DB2 CONNECT / DB2CONNCT / 970 - DB2
Problembeschreibung:
In case of Informix Server (IDS) when trying through cli driver 
on a query of invalid table , scenarios like table no present 
when tried to drop table. When tried to create index on a table 
which is not present it should return error S0002 but it was 
returning error code S0022 which is for invalid columns in case 
of db2 .
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* When CLI driver is used against Informix Server.             * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* In case of Informix Server (IDS) when trying through cli     * 
* driver                                                       * 
* on a query of invalid table , scenarios like table no        * 
* present                                                      * 
* when tried to drop table. When tried to create index on a    * 
* table                                                        * 
* which is not present it should return error S0002 but it was * 
* returning error code S0022 which is for invalid columns in   * 
* case                                                         * 
* of db2 .                                                     * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V9.7 FP7 or later releases.                   * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
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 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
DB2 V9.7 Fix Pack 7 contains fix of this issue. After the fix, 
CLI driver returns correct error message.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
24.07.2012
30.08.2014
30.08.2014
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP7
Problem behoben lt. FixList in der Version
9.7.0.7 FixList