A fix is available
APAR status
Closed as program error.
Error description
Customer had TPC4.1.1.66 installed on Windows 2008, and he reported that DB2 Heap size causes TPC crash SQLcode=-973 SQLSTATE=57011. In the server_xxxxxx.log file, there's shown the following eror: 2/28/10 4:39:44 AM SRV0044E: Unable to connect to repository database. Please ensure that the repository database is up and running. Driver: com.ibm.db2.jcc.DB2Driver@3560356 URL : jdbc:db2://localhost:50000/TPCDB SQLSTATE: 57011, Vendor error code: -973 DB2 SQL Error: SQLCODE=-973, SQLSTATE=57011, SQLERRMC=MON_HEAP_SZ, DRIVER=3.53.95 2/28/10 4:39:44 AM SRV0044E: Unable to connect to repository database. Please ensure that the repository database is up and running. Driver: com.ibm.db2.jcc.DB2Driver@3560356 URL : jdbc:db2://localhost:50000/TPCDB SQLSTATE: 57011, Vendor error code: -973 DB2 SQL Error: SQLCODE=-973, SQLSTATE=57011, SQLERRMC=MON_HEAP_SZ, DRIVER=3.53.95
Local fix
The workaround is to increase the DB2 MON_HEAP_SZ and restart the data server.
Problem summary
**************************************************************** * USERS AFFECTED: TPC 4.1.0 and 4.1.0 users * **************************************************************** * PROBLEM DESCRIPTION: See ERROR DESCRIPTION * **************************************************************** * RECOMMENDATION: * **************************************************************** DB2 parameter MON_HEAP_SZ was not sufficient.
Problem conclusion
Increased the MON_HEAP_SZ DB2 parameter setting to 512 for new installations. The fix for this APAR is targeted for the follow ing maintenance package: | fix pack | 4.1.1-TIV-TPC-FP0004 - target July 2010 http://www-01.ibm.com/support/docview.wss?&uid=swg21320822 The target dates for future fix packs do not represent a formal commitment by IBM. The dates are subject to change without notice.
Temporary fix
Comments
APAR Information
APAR number
IC66824
Reported component name
TPC FOR DATA
Reported component ID
5608TC300
Reported release
41W
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2010-03-04
Closed date
2010-05-27
Last modified date
2010-05-27
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
TPC FOR DATA
Fixed component ID
5608TC300
Applicable component levels
R41A PSY
UP
R41L PSY
UP
R41W PSY
UP
[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SS8JB5","label":"Tivoli Storage Productivity Center for Data"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"41W","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]
Document Information
Modified date:
27 May 2010