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

JCC PROPERTIES SUCH AS CURRENTSCHEMA ARE SOMETIMES IGNORED. A POSSIBLE
SYMPTOM IS AN SQLEXCEPTION WITH SQLCODE=-204

Produkt:
DB2 DATA SRVR D / DB2DSDRVR / A50 - DB2
Problembeschreibung:
Properties of the IBM Data Server Driver for JDBC and SQLJ 
driver (also known as the JCC driver) which define special 
register values are sometimes ignored. 
Such JCC driver properties include currentDegree, 
currentFunctionPath, currentMaintainedTableTypesForOptimization, 
currentPackagePath and currentSchema. 
 
The problem only happens when the application is connected to a 
DB2 on z/OS sysplex or a DB2 for Linux, UNIX and Windows 
pureScale cluster and the JCC driver property enableSysplexWLB 
is set to true. And it only happens after the JCC driver as part 
of the getConnection() processing has checked for the existence 
of a DB2 Connect license on the database server. 
The JCC driver typically caches the result of successful license 
validation on the client machine and this cache expires after 7 
days, so the the JCC driver does not check for the existence of 
a DB2 Connect license on the database server for up to 7 days 
after a successful result is cached on the client. For that 
reason the error might appear every 7 days. 
 
What error occurs depends on which JCC driver property is 
ignored. 
When the currentSchema property is ignored it might cause an 
SQLException with DB2 SQL Error: SQLCODE=-204 to be thrown when 
an SQL statement is executed that includes the name of a 
database object which exists in the schema specified by the 
currentSchema property yet the SQL statement does not explicitly 
include the schema name.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All users of IBM Data Server Driver for JDBC and SQLJ        * 
* shipped with DB2 10.5 releases earlier than DB2 10.5 Fixpack * 
* 4                                                            * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* Refer Error Description.                                     * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 10.5 Fixpack 4                                * 
****************************************************************
Local-Fix:
The problem only happens after the application has called 
getConnection() to connect to a database and then called 
commit() or rollback() without first executing any SQL statement 
for the connection. 
As a workaround you can make sure that the application does not 
call commit() or rollback() for the connection before it 
executes any SQL statement for the connection.
Lösung
Upgrade to DB2 10.5 Fixpack 4
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
19.06.2014
08.09.2014
08.09.2014
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.5.0.4 FixList