PQ77246: WEBSPHERE APPLICATION SERVER ZOS V5 DB2 TABLE FOR SESSION PERSISTENCE GETTING SQL CODE = -302 ON MEDIUMCOLSIZE VARCHAR | |||||||||||||||||||||||||||||||||||||||||||
![]() |
|||||||||||||||||||||||||||||||||||||||||||
![]() APAR status Closed as program error. Error description After configuring DB2 Persistent Sessiontable per the documentation under 'Creating a DB2 table for session persistence'. Recieved DB2 SQL code = -302 : BossLog: { 0180} 2003/07/25 03:53:40.756 01 SYSTEM=ZSW2 SERVER=MKSRV1 PID=0X01020071 TID=0X2A02B9D0 0X000017 c=UNK ./bborjtr.cpp+812 ... BBOO0223I Exception is: com.ibm.db2.jcc.DB2SQLException: DB2JDBCSection Received Error in Method execute:SQLCODE==> -302 SQLSTATE ==> 22001 Error Tokens ==> <<DB2 7.1 SQLJ/JDBC>> 002 at COM.ibm.db2os390.sqlj.jdbc.DB2SQLJJDBCSection. setError(DB2SQLJJDBCSection.java:1552) . This is an issue on the setting for mediumcolsize variable from the DB2 create table setting of : MEDIUM VARCHAR(28869) FOR BIT DATA ,Local fix Problem summary **************************************************************** * USERS AFFECTED: All users of WebSphere Application Server * * V5.0 for z/OS * **************************************************************** * PROBLEM DESCRIPTION: Customer is receiving a DB2SQLException * * Error in Method execute:SQLCODE==> -302 * * SQLSTATE ==> 22001 (session table * * layout is not synchronized) when * * executing a Session servlet when DB2 is * * enabled. * **************************************************************** * RECOMMENDATION: * **************************************************************** Customer created a DB2 table defining the size of the Medium column size to 28869 according to the example given in the WebSphere Application Server Version 5 - Administering section of the documentation. The constant size in the code is set to 32700 which is common with WebSphere Distributed. So, if the Session Data is larger than 28869 but less than 32700 an exception will be thrown because the session table table layout is not synchronized.Problem conclusion Support was modified to change the constant size from 32700 to 28869. The value for the constant is now the same as the value used when setting the Medium column size for the DB2 table. Also verified that the Small and Large column size is the same as what is specified in the WebSphere Application Server Version 5 documentation for zOS. APAR PQ77246 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: swg1PQ77246.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 #: PQ77246
IBM Group: Software Group
Modified date: Oct 3, 2003
(C) Copyright IBM Corporation 2000, 2009. All Rights Reserved.