Improved default settings for DB2 in portal.properties

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 5.1 EE SP4 (5.1.7), 5.2 EE SP2 (5.2.6)
• Fix Version/s: 5.1 EE SP5 (5.1.8), 5.2 EE SP3 (5.2.7)
• Component/s: Environments > Databases
• Labels:
  • 5.2_release_notes
• Environment: DB2

The default value of jdbc.default.url for DB2 in portal.properties has been changed to

jdbc.default.url=jdbc:db2://localhost:50000/lportal:deferPrepares=false;fullyMaterializeInputStreams=true;fullyMaterializeLobData=true;progresssiveLocators=2;progressiveStreaming=2;

The previous default URL left out a lot of necessary tuning needed for DB2.