PQ68617: GET SQLCODE -553 TRYING TO CONNECT TO DB2

 A fix may be available

Obtain the fix for this APAR



APAR status
Closed as program error.

Error description
Customer migrated across service level w401400 and is now
having difficulty connecting to db2.  They see sqlcode -553 in
the server region for the application server.  -553 means an id
attempting to do a SET SQLID is not authorized to do so.
.
The customer does not specify a value for the SQLID field on the
J2EE Resource object in the SM EUI nor is the customer
attempting to use the SQLID functionality.  A set sqlid should
only occur if the field is set in the SM EUI.  The identity
shown as being unauthorized is the identity of the server region
for the app server.  WebSphere has incorrectly replaced the
identity on the thread with the server region's identity where
the identity that could have been on the thread was another
identity, such as the caller's identity, if "Enable Setting OS
Thread Identity to RunAs" (syncToOSThread) is set for the
server.  The SET SQLID is then attempted with the server's
identity.
Local fix Problem summary
****************************************************************
* USERS AFFECTED: All users of WebSphere Application Server    *
*                 V4.0.1 for z/OS and OS/390.                  *
****************************************************************
* PROBLEM DESCRIPTION: SQLID on current connection may not be  *
*                      set correctly. This can result in       *
*                      receiving a SQL error -553 trying to    *
*                      connect to DB2.                         *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************
When caching connections across transactions or when a server
allows SynchToThread, the SQLID may not be set correctly.
Problem conclusion
Support has been modified such that when SynchToThread is
enabled caching is forced to be In-Trans. Also, support now
ensures the connection obtained from DB2 has the proper
SQLID (default is server Id).

APAR PQ68617 is associated with SERVICE LEVEL W401408 of
WebSphere Application Server V4.0.1 for z/OS and OS/390.
Temporary fix Comments
APAR information
APAR number PQ68617
Reported component name WASKBASE
Reported component ID 5655A9801
Reported release 401
Status CLOSED PER
PE NoPE
HIPER NoHIPER
Submitted date 2002-11-26
Closed date 2003-01-21
Last modified date 2003-02-05

APAR is sysrouted FROM one or more of the following:

APAR is sysrouted TO one or more of the following:

Modules/Macros
BBOUBINF          

Fix information
Fixed component name WASKBASE
Fixed component ID 5655A9801

Applicable component levels
R401 PSY UQ73459    UP03/01/28 P F301

  Fix is available
Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.


Document Information


Product categories: Software > Application Servers > Distributed Application & Web Servers > WebSphere Application Server for z/OS
Operating system(s):
Software version: 401
Software edition:
Reference #: PQ68617
IBM Group: Software Group
Modified date: Feb 5, 2003