PK85227: A MESSAGING ENGINE THAT IS USING DB2 V9 FOR Z/OS FAILS TO START AND PRODUCES A CWSIS1530E ERROR.

Fixes are available

APAR status

Closed as program error.

Error description

The messaging engine fails to start with the following error
message when DB2 V9 for z/OS hosts its data store:
CWSIS0002E: The messaging engine encountered an exception while
starting. Exception:
com.ibm.ws.sib.msgstore.PersistenceException:
CWSIS1501E: The data source has produced an unexpected
exception: java.lang.IllegalStateException: CWSIS1530E: The data
type, -3, was found instead of the expected type, -4, for
column, DATA, in table, <Schema name>.SIB000.

Local fix

The fix for this APAR is to allow the URI column of the
SIB000 table in a data store on DB2 for z/OS to be of type
LONGVARBINARY instead of just VARBINARY.

Problem summary

****************************************************************
* USERS AFFECTED:  Users of the default messaging provider for *
*                  IBM WebSphere Application Server Version    *
*                  6.0, Version 6.1 or Version 7.0, using DB2  *
*                  for z/OS as the data store for messaging    *
*                  engines in a service integration bus        *
****************************************************************
* PROBLEM DESCRIPTION: A messaging engine may fail to start    *
*                      with a CWSIS1530E error message if      *
*                      the data store is hosted on DB2 for     *
*                      z/OS.                                   *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************
When a messaging engine that is using a data store is started,
it checks that the columns in the tables that make up the data
store are of the expected type.

When DB2 for z/OS is used to host the data store, character
and binary columns have been seen on certain systems to be
reported to the messaging engine by the DB2 JDBC driver as
being of type VARCHAR or VARBINARY instead of the expected
types LONGVARCHAR or LONGVARBINARY.

The unexpected type returned for the DATA column of the
SIB000 table causes the checks to fails and the messaging
engine fails to start, logging a CWSIS1530E entry in the JVM
logs of the server.

A similar issue was encountered in APAR PK74286 for the URI
column of the SIBCLASSMAP table.

Problem conclusion

The fix for this APAR updates the column checks performed
during messaging engine startup, when DB2 for z/OS is used
as a messaging engine data store.
All columns defined in the schema of the messaging engines
that are of type LONGVARBINARY are allowed to be reported as
type LONGVARBINARY or VARBINARY.
All columns of type LONGVARCHAR are allowed to be reported as
type LONGVARCHAR or VARCHAR

The fix for this APAR is currently targeted for inclusion in
fix pack 6.0.2.39, 6.1.0.29 and 7.0.0.7.  Please refer to the
Recommended Updates page for delivery information:
http://www.ibm.com/support/docview.wss?rs=180&uid=swg27004980

Temporary fix

This problem can be circumvented by adding the following line
to a sib.properties file in the properties subdirectory of all
profiles where servers that host messaging engines run:

sib.msgstore.jdbcPerformColumnChecks=false

This disables column checking, allowing the messaging engine
to start.
See the "Setting tuning properties by editing the
sib.properties file" section of the information center for
more information on the sib.properties file.

Comments

APAR Information

APAR number
PK85227
Reported component name
PLAT MSG COM
Reported component ID
620600101
Reported release
200
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2009-04-23
Closed date
2009-07-27
Last modified date
2009-10-26

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

PK99167

Fix information

Fixed component name
PLAT MSG COM
Fixed component ID
620600101

Applicable component levels

R200 PSY
UP

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEQTP","label":"WebSphere Application Server"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"6.1","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
29 December 2021

Tips

PK85227: A MESSAGING ENGINE THAT IS USING DB2 V9 FOR Z/OS FAILS TO START AND PRODUCES A CWSIS1530E ERROR.

Fixes are available

Subscribe

APAR status

Closed as program error.

Error description

Local fix

Problem summary

Problem conclusion

Temporary fix

Comments

APAR Information

APAR number

Reported component name

Reported component ID

Reported release

Status

PE

HIPER

Special Attention

Submitted date

Closed date

Last modified date

APAR is sysrouted FROM one or more of the following:

APAR is sysrouted TO one or more of the following:

Fix information

Fixed component name

Fixed component ID

Applicable component levels

R200 PSY

Document Information

Share your feedback

Need support?