SAP Knowledge Base Article - Preview

2529175 - SWPM (Software Provisioning Manager) failed with SQL5130N error

Symptom

Following SQL5130N errors can be seen in sapinst_dev.log.

  • Found Error, error_codes[6] = <UPDATE DBM CFG USING INTRA_PARALLEL YES
    SQL5130N The value specified for the configuration parameter "num_initfenced"
    is not in the valid range of "0" to "64000".>
    TRACE <Tiemstamp and date> (root/sapinst)
    During execution of <update_dbm_cfg.sql>, <7> errors occurred.
    ERROR  <Tiemstamp and date>  (root/sapinst) [CInstallerCallBackImpl.cpp:259] id=dbmoddb6.generic errno=MDB-01999
    Error occurred, first error is: <SQL5130N The value specified for the configuration parameter "restbufsz" is > "

  • SQL5130N The value specified for the configuration parameter "spm_log_file_sz" is not in the valid range of "4" to "1000".>
  • SQL5130N The value specified for the configuration parameter "num_initfenced" is not in the valid range of "0" to "64000".>
  • SQL5130N The value specified for the configuration parameter "restbufsz" is not in the valid range of "8" to "16384".>
  • SQL5130N The value specified for the configuration parameter "backbufsz" is not in the valid range of "8" to "16384".
  • SQL5130N The value specified for the configuration parameter "spm_max_resync" is not in the valid range of "10" to "256".>
  • SQL5130N The value specified for the configuration parameter "agent_stack_sz" is not in the valid range of "256" to "32768".
  • SQL5130N The value specified for the configuration parameter "locklist" is not in the valid range of "4" to "524288".
  • SQL5130N The value specified for the configuration parameter "maxfilop" is not in the valid range of "64" to "61440".
  • SQL5130N The value specified for the configuration parameter "sortheap" is not in the valid range of "16" to "-1".>
  • SQL5130N The value specified for the configuration parameter "sheapthres_shr" is not in the valid range of "250" to "2147483647".>


Read more...

Environment

IBM Db2 => 9.7 and above.

Keywords

Backup, System copy, System Refresh, Slow Backup, Performance, Slow system, Configuration, DBM, CFG, Parameters, Sandbox, updatecfg , KBA , BC-DB-DB6-INS , Installation SAP System , BC-INS , Installation Tools (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 for Me (Login required).

Search for additional results

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