|
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
|
 |
