PQ68617: GET SQLCODE -553 TRYING TO CONNECT TO DB2 | |||||||||||||||||||||||||||||||||||||||||
![]() |
|||||||||||||||||||||||||||||||||||||||||
![]() 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 is sysrouted FROM one or more of the following: APAR is sysrouted TO one or more of the following: Modules/Macros
|
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
(C) Copyright IBM Corporation 2000, 2006. All Rights Reserved.