PQ77246: WEBSPHERE APPLICATION SERVER ZOS V5 DB2 TABLE FOR SESSION PERSISTENCE GETTING SQL CODE = -302 ON MEDIUMCOLSIZE VARCHAR

 A fix is available

Obtain the fix for this APAR



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 information
APAR number PQ77246
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-07
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: 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