[z/OS]

Fixing storage allocation error caused by DB2 Universal JDBC Driver on z/OS

When using DB2® Universal JDBC type 2 driver on z/OS®, the messaging engine fails to start. This is a known issue and can be solved by tuning the JDBC driver.

About this task

In the address space of Control Region Adjunct (CRA), you might see text "Storage Allocation Error", for example, in
BBOO0220E: [SB6NLA1:SB6NLA1.server1-SB6NLA1] CWSIP0002E: An internal messaging error occurred in com.ibm.ws.sib.p
 rocessor.impl.MessageProcessor, 1:1469:1.365, com.ibm.ws.sib.msgstore.MessageStoreRuntimeException: com.ibm.ws.sib.msgstore.Persiste
 nceException: CWSIS1501E: The data source has produced an unexpected exception: com.ibm.db2.jcc.t2zos.y: [IBM/DB2][T2zos/2.5.48]T2zo
 sPreparedStatement.readPrepareDescribeOutput_:processDescribeOutput:1563:Storage Allocation Error at com.ibm.ws.sib.msgstore.cache.l
 inks.AbstractItemLink.readDataFromPersistence(AbstractItemLink.java:2487) at com.ibm.ws.sib.msgstore.cache.links.AbstractItemLink._r
 estoreItem(AbstractItemLink.java:639) 

Procedure

  1. You can avoid this error by performing one of the following steps:
    1. Set the JDBC driver customer property fullyMaterializeLobData to false. You can do this in the administrative console: Resources > JDBC Providers > Your JDBC provider -> Data sources -> Your data source > Custom properties > fullyMaterializeLobData.
    2. Use the Universal JDBC provider of type 4 driver.
  2. Restart the application server.



In this information ...


IBM Redbooks, demos, education, and more

(Index)

Use IBM Suggests to retrieve related content from ibm.com and beyond, identified for your convenience.

This feature requires Internet access.

Task topic Task topic    

Terms and conditions for information centers | Feedback

Last updatedLast updated: Aug 31, 2013 2:56:59 AM CDT
http://www14.software.ibm.com/webapp/wsbroker/redirect?version=pix&product=was-nd-dist&topic=tjm0299
File name: tjm0299_.html