2597381 - Problems with SHEAPTHRES_SHR and and SORTHEAP in SWPM (SQL5130N) | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2597381 - Problems with SHEAPTHRES_SHR and and SORTHEAP in SWPM (SQL5130N)

Symptom

SWPM stops because it wants to set SHEAPTHRES_SHR = 0 and SORTHEAP = 0.

You see similar errors:

sapinst_dev.log

ERROR 2018-01-26 11:26:37.297 (root/sapinst) (startInstallation) [CInstallerCallBackImpl.cpp:259] id=dbmoddb6.generic errno=MDB-01999 CInstallerCallBackImpl::abortInstallation()
Error occured, first error is: <SQL5130N The value specified for the configuration parameter "sheapthres_shr" >

update_db_cfg.log

UPDATE DB CFG USING DATABASE_MEMORY AUTOMATIC
DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully.

UPDATE DB CFG USING SHEAPTHRES_SHR 0
SQL5130N The value specified for the configuration parameter "sheapthres_shr"
is not in the valid range of "250" to "2147483647".

UPDATE DB CFG USING SORTHEAP 0
SQL5130N The value specified for the configuration parameter "sortheap" is
not in the valid range of "16" to "-1".

UPDATE DB CFG USING UTIL_HEAP_SZ 50000 AUTOMATIC
DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully.


Read more...

Environment

IBM DB2 9.7 and above

Keywords

System copy, System Refresh , KBA , BC-DB-DB6-INS , Installation SAP System with DB2 Universal Database , BC-INS , Inst.Tools - Use subcomponents; SAP Note 1669327 , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.