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

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

product:
DB2 CONNECT / DB2CONNCT / 910 - DB2
Problem description:
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 Summary:
**************************************************************** 
* 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.
available fix packs:
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

Solution
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
18.12.2009
15.04.2010
15.04.2010
Problem solved at the following versions (IBM BugInfos)
9.1.9
Problem solved according to the fixlist(s) of the following version(s)
9.1.0.9 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.