PK00434: SHIP INTERNAL DEFECT FIXES FOR SERVICE LEVEL W502023.

 A fix is available

Obtain the fix for this APAR



APAR status
Closed as program error.

Error description
Ship internal defect fixes for Service Level W502023.
Local fix Problem summary
****************************************************************
* USERS AFFECTED: All users of WebSphere Application Server    *
*                 V5.0 for z/OS                                *
****************************************************************
* PROBLEM DESCRIPTION: APAR PK00434 addresses the following    *
*                      defect in WebSphere Application Server  *
*                      V5.0 for z/OS:                          *
*                                                              *
*                      (botp_246514) A JDBC Connection         *
*                      obtained from a WebSphere connection    *
*                      pool cannot be used to perform write    *
*                      operations (insert/update/delete) on a  *
*                      database.                               *
*                                                              *
*                      (MD20659) A java.sql.SQLException with  *
*                      an SQLCODE of -923 is thrown from DB2   *
*                      but is not getting mapped to a          *
*                      StaleConnectionException.               *
*                                                              *
*                      (MD20671) An update to the WebSphere    *
*                      Application Server for z/OS runtime is  *
*                      needed to support applications using    *
*                      J2C Java data beans.                    *
*                                                              *
*                      (MD20678) CORBA::MARSHAL exception      *
*                      encountered in either client, or        *
*                      servant (for server as client), when,   *
*                      in fact, the outbound login failed,     *
*                      and the oubound request was never       *
*                      actually invoked on the remote system.  *
*                                                              *
*                      (MD20682) wsadmin script may get        *
*                      message WASX7017E                       *
*                                                              *
*                      (MD20687) A WAS_HOME path name length   *
*                      longer than 39 characters can cause the *
*                      Post-Installer not to  execute.         *
*                                                              *
*                      (MD20689) The Post-Installer does not   *
*                      report an error when a Post-Install     *
*                      script is missing from the HFS.         *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************
APAR PK00434 addresses the following defect in WebSphere
Application Server V5.0 for z/OS:

(botp_246514) If an application changes the value of readOnly on
a JDBC Connection, the new value will stay in effect even when
the Connection is returned to the WebSphere connection pool and
later reused.  The most common symptom of this problem occurs
when one application sets readOnly on a Connection to true and
later users of the Connection are unable to perform write
operations (insert/update/delete) on the database.  An exception
similar to the following will be thrown to the application:

java.sql.SQLException: DB2JDBCSQLCompiler Received Error in
  Method compileSQL -> Insert/Update/Delete not honored.
  Database is readOnly
at COM.ibm.db2os390.sqlj.jdbc.DB2JDBCSQLCompiler.compileSQL
at COM.ibm.db2os390.sqlj.jdbc.DB2SQLJStatement.execute
at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.execute

The actual exception will vary depending on the underlying
JDBC driver being used with this particular JDBC Connection.

(MD20659) A java.sql.SQLException from DB2 with an SQLCODE of
-923 represents a permanent error condition on the JDBC
connection used to connect to DB2.  Currently, these exceptions
are being thrown to the application with no additional
processing.  These exceptions should be mapped to a
StaleConnectionException and the connection that received the
exception should be marked as stale so that pool purge
processing can be initiated.

This problem can be spotted by noticing that your application
is repeatedly receiving a java.sql.SQLException with an SQLCODE
of -923.  Receiving the exception numerous times may indicate
that the connection is not getting purged from the connection
pool.

(MD20671) An update of marshall.jar is needed.

(MD20678) The Marshalling exception encountered by the client:
 Exception data: java.rmi.MarshalException:
  CORBA MARSHAL 0x4942f8e2 No; nested exception is:
    org.omg.CORBA.MARSHAL: Read beyond end of input stream
    vmcid: IBM  minor code: 8E2  completed: No

This exception is accompanied by the following message in the
controller (shown either with ras_trace_detail=3,
or ras_trace_specific=0300A04C):

Trace: ... (0300A04C)
  Description: ...
  Return Area: ...
  +-----------------------
  |OSet| ...
  +----+------------------
  |0000|00000004 00000028
  +-----------------------

(MD20682) A customer may get the following message while running
a wsadmin script:

WASX7017E: Exception received while running file <script name>
WASX7082E: The creation of a <WebSphere Object name>
object requires that an attribute
name be specified, because more than one attribute exists
with the same type. Please specify one of the following
attribute names as a fourth parameter to the "create"
method:
-No fourth parameter options are given for above error.

(MD20687) A WAS_HOME path name length longer than 39 characters
can cause the Post-Installer to not execute. If this situation
is encountered, a similiar message to the following would appear
in the main Post-Installer log (applyPTF.out):

***********************************************************
Message Appears in this format in WebSphere Version 5.0:
***********************************************************
..
CEE3703I In HANC Control Block, the Eye Catcher is damaged.
CEE3704I Expected data at 25DE5018 : HANC.
 25DE4FF8: 00000000 00000000 00000000 00000000  00000000
 00000000 00000000 0000
 0000  |................................|
 25DE5018: C8C1D5C3 25D95810 25D95810 00000000  A5DE5018
 25DE5D10 00008000 0000 7308  |HANC.R...R......v.&............|
CEE0802C Heap storage control information was damaged.
        From entry point main at statement 95 at compile unit
        offset +0000012E at entry offset +0000012E at address
        25D80C76.
CEE3703I In HPCB Control Block, the Eye Catcher is damaged.
CEE3704I Expected data at 8439FC76 : HPCB.
 8439FC56: 1E531513 4740B6E6 18311E32 47B0B6E6  15354720
B6E61370 41A0F014 4580
B292  |..... .W.......W.....W....0....k|
 8439FC76: 15344740 B28A4780 B5C24154 60001515  4780B5B6
4740B6E6 41404004 18A4
1806  |... .....B..-........ .W.  ..u..|
CEE0802C Heap storage control information was damaged.
         The traceback information could not be determined.
---------------------------------------------------------------
Returned from the Multi-Product PTF Installer, Return code: 137
---------------------------------------------------------------
...

***********************************************************
Message Appears in this format in WebSphere Version 5.1.0:
***********************************************************
...
CEE3703I In HANC Control Block, the Eye Catcher is damaged.
CEE3704I Expected data at 25DE5018 : HANC.
 25DE4FF8: 00000000 00000000 00000000 00000000  00000000
 00000000 00000000 0000
 0000  |................................|
 25DE5018: C8C1D5C3 25D95810 25D95810 00000000  A5DE5018
 25DE5D10 00008000 0000 7308  |HANC.R...R......v.&............|
CEE0802C Heap storage control information was damaged.
        From entry point main at statement 95 at compile unit
        offset +0000012E at entry offset +0000012E at address
        25D80C76.
CEE3703I In HPCB Control Block, the Eye Catcher is damaged.
CEE3704I Expected data at 8439FC76 : HPCB.
 8439FC56: 1E531513 4740B6E6 18311E32 47B0B6E6  15354720
B6E61370 41A0F014 4580
B292  |..... .W.......W.....W....0....k|
 8439FC76: 15344740 B28A4780 B5C24154 60001515  4780B5B6
4740B6E6 41404004 18A4
1806  |... .....B..-........ .W.  ..u..|
CEE0802C Heap storage control information was damaged.
         The traceback information could not be determined.
WAS_HOME/applyPTF.sh  - End - Return Code = 137, Thu Jan 27
15:10:55 EST 2005

(MD20689) The Post-Installer does not report an error when a
Post-Install script is missing from the HFS. If any
Post-Installer file is missing the Post-Installer should halt
and report the error.  A similiar message would appear in the
main Post-Installer log file (applyPTF.out):

...
<<< 
PQ99310.sh -  Begin -  Action=apply, Backup directory= /Web
Sphere/V5R0M0/AppServer/properties/service/backup/W502022/

PQ99310, Thu Jan 27 18:35:44 EST 2005/WebSphere/V5R0M0/
AppServer/properties/service/bin/PQ99310.sh: /WebSphere/V5R0M0/
AppServer/bin/applyPTFUtil.sh 75: FSUM7351 not found>>> PQ9931
0.sh - End - Return Code = 127, Action=apply, Backup directory
=/WebSphere
...

Even though this message appears in the log, it does not
effect Post-Install processing. At service level W502022,
the above warning message appears in the W502022.log and
can be safely ignored.
Problem conclusion
APAR PK00434 fixes the following defect in WebSphere Application
Server V5.0 for z/OS.

(botp_246514) WebSphere has been modified so that when a JDBC
Connection gets returned to the connection pool, the value of
readOnly is reset to the original value that was set at the time
the connection was created.

(MD20659) WebSphere now properly maps java.sql.SQLExceptions
with an SQLCODE of -923 received from DB2 to a
StaleConnectionException, and the connection that received the
exception is marked as stale.

(MD20671) Updated marshall.jar to allow users to run a J2EE
application using a J2C Java data bean in a WebSphere
Application Server for z/OS server.

(MD20678) A COMM_FAILURE exception with the minor code
C9C21355 is thrown to notify the caller (in the client or in
the servant), that the remote request could not be invoked.

The following publication was revised as a result of defect
MD20678, delivered in APAR PK00434 :
________________________________________________________________
WebSphere Application Server V5 for z/OS
Messages and Codes
GA22-7915-01
________________________________________________________________
This APAR requires changes to documentation.

NOTE: Periodically, we refresh the documentation on our
Web site, so the changes might have been made before you
read this text. To access the latest on-line
documentation, go to the product library page at:

www.ibm.com/software/webservers/appserv/zos_os390/library.html
________________________________________________________________
Chapter 3, pg. 125 (new minor code)

C9C21355

Explanation: The redrive count for invoking an outbound request
             was exceeded.

User Response: Check the error log for a communication failure
               error message.

(MD20682) A change in the handling of subtype info was made to
correct this problem.

This is a rollup of WebSphere Distributed APAR 
PQ77508.

(MD20687) Allow any WAS_HOME path name defined in the
Customization Dialog to work with the Post-Installer code.

(MD20689) Update the Post-Installer code to issue a message to
the console if a Post-Installer script is missing. This will
prevent future occurances of missing Post-Install script files.
In addition file W502022.sh has been update to remove the
reference to file 
PQ99310.sh.

APAR PK00434 is associated with SERVICE LEVEL W502023 of
WebSphere Application Server V5.0 for z/OS.
Temporary fix Comments
APAR information
APAR number PK00434
Reported component name WEBSPHERE FOR Z
Reported component ID 5655I3500
Reported release 500
Status CLOSED PER
PE NoPE
HIPER NoHIPER
Special Attention YesSpecatt / CST
Submitted date 2005-02-02
Closed date 2005-02-07
Last modified date 2005-04-18

APAR is sysrouted FROM one or more of the following:

APAR is sysrouted TO one or more of the following:
UK00329

Modules/Macros
BBOOREQ BBOUBINF BBOZ1514 BBOZ1524 BBOZ1533 BBOZ1537
BBOZ1548 BBOZ1555 BBOZ1571 BBOZ1585 BBOZ1586 BBOZ15
***This field was truncated. To obtain
the full apar record, please contact
your local support center.***    

Publications Referenced
GA22791501        

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

Applicable component levels
R500 PSY UK00329    UP05/02/11 P F502

  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: swg1PK00434.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 #: PK00434
IBM Group: Software Group
Modified date: Apr 18, 2005