|
Problem IC65322
|
Status: Closed |
JCC CONNECTION TO A NON-EXISTENT DATABASE SOMETIMES GETS SQLSTATE 08001 INSTEAD OF SQLSTATE 08004 |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
An attempt to connect to a non-existing database using JCC type
4 connection sometimes gets SQL error -4499 with SQL state 08001
instead of SQL state 08004.
SQL state 08001 is misleading here as it indicates a general
communication issue:
08001 The application requester is unable to establish the
connection.
08004 The application server rejected establishment of the
connection.
This APAR will address transparent error handling and ensure SQL
state 08004 is returned. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All using JCC type 4 connectivity *
****************************************************************
* PROBLEM DESCRIPTION: *
* An attempt to connect to a non-existing database using *
* JCCtype4 connection sometimes gets SQL error -4499 with SQL *
* state08001instead of SQL state 08004.SQL state 08001 is *
* misleading here as it indicates a generalcommunication *
* issue:08001 The application requester is unable to establish *
* theconnection.08004 The application server rejected *
* establishment of theconnection.This APAR will address *
* transparent error handling and ensureSQLstate 08004 is *
* returned. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 version 9.7 FP2 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
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 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
First fixed in DB2 version 9.7 FP2 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 05.01.2010
31.05.2010
31.05.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP2
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.2
|
 |
