PQ77437: SQLCODE204 ISSUED IF USER CUSTOMIZES SESSION TABLE NAME FROM SESSION(DEFAULT) TO ANOTHER TABLE NAME IN ADMIN CONSOLE.

 A fix is available

Obtain the fix for this APAR



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 SESSION
Problem 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 information
APAR number PQ77437
Reported component name WEBSPHERE FOR Z
Reported component ID 5655I3500
Reported release 500
Status CLOSED PER
PE NoPE
HIPER NoHIPER
Special Attention NoSpecatt
Submitted date 2003-08-13
Closed date 2003-09-17
Last modified date 2003-10-03

APAR is sysrouted FROM one or more of the following:

APAR is sysrouted TO one or more of the following:

Modules/Macros
BBOUBINF          

Publications Referenced

Fix information
Fixed component name WEBSPHERE FOR Z
Fixed component ID 5655I3500

Applicable component levels
R500 PSY UQ80305    UP03/09/25 P F309

  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


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