PQ77437: SQLCODE204 ISSUED IF USER CUSTOMIZES SESSION TABLE NAME FROM SESSION(DEFAULT) TO ANOTHER TABLE NAME IN ADMIN CONSOLE. | |||||||||||||||||||||||||||||||||||||||||||
![]() |
|||||||||||||||||||||||||||||||||||||||||||
![]() APAR status Closed as program error. Error description Customer defines a session table name in the admin console under Servers>Application Servers>Web Container>Custom Properties>SessionTableName and specifies a table name of BB5SESDB.JSEE3. This value is accepted in the admin console and is populated to server.xml successfully. When the application is run the customer receives an sqlcode-204 sqlcode204 on S05DTSA.SESSION. This is the sysadmin.the default table name of SESSION.Local fix Use the default table name of SESSIONProblem summary **************************************************************** * USERS AFFECTED: All users of WebSphere Application Server * * V5.0 for z/OS * **************************************************************** * PROBLEM DESCRIPTION: Customer is receiving a DB2 SQL Code * * of -204 when specifying a different DB2 * * tablename value other than the default * * "SESSION". The DB2 table name is * * configurable via the administrative * * console, but the configurable table * * name is not recognized and defaults to * * "SESSION". * **************************************************************** * RECOMMENDATION: * **************************************************************** The configurable table name value is obtained from the WebContainer Customer properties in the server.xml file. An iteration occurs until it finds the name of the field otherwise it defaults to "SESSION" as the table name. The setting of the default table name was occurring in the loop instead of outside of the loop which was causing the configurable value to be over-written with the default value.Problem conclusion SMSessionContextParameters.getTableNameValue() was modified to check to see if the table value is null and if so, set it to the default value of "SESSION". Otherwise, use the configurable value. APAR PQ77437 is associated with SERVICE LEVEL W501000 of WebSphere Application Server V5.0 for z/OS.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
Publications Referenced
|
Document Information |
Current web document: swg1PQ77437.html
Product categories: Software > Application Servers >
Distributed Application & Web Servers > WebSphere Application
Server for z/OS
Operating system(s):
Software version: 500
Software edition:
Reference #: PQ77437
IBM Group: Software Group
Modified date: Oct 3, 2003
(C) Copyright IBM Corporation 2000, 2009. All Rights Reserved.