Symptom

You have deployed IBM DB2 for z/OS Version 9.1 on WebSphere Application Server Version 6.1 for z/Linux. You are using application server JDBC connection pools. After you upgrade to DB2 Connect 9.5, you cannot save certain types of records, for example, access groups and application rules. Here's an example of the error message:

** Save failed: problem encountered when reading ruleset versions from the database: code: -4470 SQLState: <none> Message: [jcc][10120][11936][3.53.95] Invalid operation: Lob is closed. ERRORCODE=-4470, SQLSTATE=null

Certain custom properties for the JDBC Providers of the PegaRULES data sources need to be specified in the application server administrative console.

Solution

1. In the WebSphere Application Server administrative console, go to JDBC Providers > Pega - UDB JDBC Driver > Data sources > PegaRULES > Custom properties > New.
2. Specify the following custom properties for the DB2 UDB Connection Pool:

   fullyMaterializeLobData=true

   fullyMaterializeInputStreams=true

   progressiveStreaming=2

   progressiveLocators=2

3. Restart the application server.

Related Topic

What custom properties are required for the DB2 UDB Connection Pool in the z/OS mainframe environment?