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

SQLCODE -204 REPORTED BY DB2 ZOS WHEN WRONG SCHEMA IS USED AND CONNECTION
CONCENTRATOR IS ENABLED ON DB2 CONNECT SERVER

Produkt:
DB2 CONNECT / DB2CONNCT / 910 - DB2
Problembeschreibung:
SQLCODE -204 is reported by DB2 for zOS because of the missing 
schema on the new unit of work. If an application sends a commit 
request without any SQL request, the next new unit of work can 
report sqlcode -204 because DB2 Connect does not send a special 
register including schema name  to zDB2 server. 
 
This problem can only happen if connection concentrator is 
enabled on DB2 Connect server.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* DB2 Connect                                                  * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* SQLCODE -204 is reported by DB2 for zOS because of           * 
* themissingschema on the new unit of work. If an application  * 
* sends acommitrequest without any SQL request, the next new   * 
* unit of workcanreport sqlcode -204 because DB2 Connect does  * 
* not send aspecialregister including schema name  to zDB2     * 
* server.This problem can only happen if connection            * 
* concentrator isenabled on DB2 Connect server.                * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade db2 version v9.1.9 or higher.                        * 
****************************************************************
Local-Fix:
Disable connection concentrator.
verfügbare FixPacks:
DB2 Version 9.1 Fix Pack 9  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 10  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12  for Linux, UNIX and Windows

Lösung
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
18.12.2009
15.04.2010
15.04.2010
Problem behoben ab folgender Versionen (IBM BugInfos)
9.1.9
Problem behoben lt. FixList in der Version
9.1.0.9 FixList