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 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.