Solution : https://service.sap.com/sap/support/notes/899322 (SAP Service marketplace login required)
Summary :
This SAP Note outlines configuration guidelines for DB2 V9.1 database parameters, applicable to all SAP releases on Linux, UNIX, and Windows platforms. It specifies parameter settings for both OLTP and OLAP workload classes and provides setup details marked for DB2's Self Tuning Memory Manager (STMM) and based on the operating system, database bit version, and DB2 Fix Pack levels. STMM is recommended for automatic memory configuration in single partition systems. Modifications in parameters such as DISCOVER_DB, log settings, and memory thresholds are also documented. Users are advised not to alter these parameters unless necessary and to consult SAP Active Global Support for temporary deviations to resolve specific issues.
Key words :
[cust]> sysadm_group = db<dbsid>adm> sysctrl_group = db<dbsid>ctl> sysmaint_group = db<dbsid>mnt> sysmon_group = [cust]> clnt_pw_plugin = [cust]> clnt_krb_plugin = [cust]> group_plugin = [cust]> local_gssplugin = [cust]> srv_plugin_mode = unfenced [cust]> srvcon_gssplugin_list = [cust]> srvcon_pw_plugin = [cust]> srvcon_auth = not_specified [cust]> authentication = server_encrypt [cust]> catalog_noauth =, > fenced_pool >= 10> num_initfenced = 0> indexrec = restart> tm_database = 1st_conn [cust]> resync_interval = 180 [cust]> spm_name = [cust]> spm_log_file_sz = 256 [cust]> spm_max_resync = 20 [cust]> spm_log_path = [cust]> nname = [os=windows]> svcename = sapdb2<dbsid> [cust]note, > hadr_local_host = [cust]> hadr_local_svc = [cust]> hadr_remote_host = [cust]> hadr_remote_svc = [cust]> hadr_remote_inst = [cust]> hadr_timeout = 120 [cust]> hadr_syncmode = nearsync [cust]> logarchmeth1 =, ]> fcm_num_buffers = automatic> fcm_num_channels = automatic> conn_elapse = 10 [os=unix]> max_connretries = 5 [os=unix]> max_time_diff = 60 [os=unix]> start_stop_time = 10 [cust] database configuration parameters, > dft_loadrec_ses = 1 [cust]> num_db_backups = 12 [cust]> rec_his_retentn = 60 [cust]> tsm_mgmtclass = [cust]> tsm_nodename = [cust]> tsm_owner = [cust]> tsm_password = [cust]> auto_maint =, ]> applheapsz >= 4096> stat_heap_sz >= 15000> dlchktime = 10000 [cust]> locktimeout = 3600 [cust]> chngpgs_thresh = 20 [cust]> num_iocleaners = automatic [cust]> num_ioservers = automatic [cust]> indexsort =, [cust]> dft_extent_sz = 2 [cust]> maxappls = automatic> avg_appls = automatic> maxfilop = 1950> logfilsiz = 16380 [cust]> logprimary = 60 [cust]> logsecond = 0note, [cust]> logarchopt2 = [cust]> failarchpath = [cust]> numarchretry = 5 [cust]> archretrydelay = 20 [cust]> vendoropt = [cust]note, jdk> [cust]> diaglevel = 3> notifylevel = 3> diagpath = /db2/<dbsid>/db2dump [os=unix] diagpath = <drive>, > catalogcache_sz >= 2560> logbufsz >= 1024> util_heap_sz >= 50000> buffpage >= 10000> appgroup_mem_sz = 40000 [bit=32]> appgroup_mem_sz = 128000 [bit=64]> groupheap_ratio = 25> app_ctl_heap_sz = 1600> stmtheap >= 5120 [bi=
Related Notes :
| 1493932 | DB6: How to choose the extent size of DB2 tablespaces |
| 1493852 | DB6: Use of alternate page cleaning |
| 1493587 | DB6: Use of infinite logging or secondary log files |
| 1474404 | DB6: Poor database performance with DB2AUDIT |
| 1429324 | Improvement of the runtime behavior of RC1PHDEL |
| 1329179 | DB6: DB2 9.7 Standard Parameter Settings |
| 1308895 | DB6: File System for Transaction Log is Full |
| 1293475 | DB6: Transaction Log Full |
| 1250466 | DB6: Perform database administration, keeping SAP AS running |
| 1156578 | DB6: Slow reporting performance, especially on DataStore |
| 1132282 | DB6: Use of Self Tuning Memory Manager (STMM) for SAP NW BW |
| 1119493 | DB6: Stack information on FMP processes in db2diag.log |
| 1086130 | DB6: DB2 9.5 Standard Parameter Settings |
| 1004920 | DB6: Supplements for upgrades based on SAP Basis 710 |
| 930487 | DB6: Using DB2 V9.1 with SAP Software |
| 688647 | DB6: SAP BW and SAP NetWeaver BI Administration Tasks |
| 584952 | DB6: DB2 UDB Version 8 Standard Parameter Settings |
| 546262 | DB6:Administration & Performance on SAP BW, SAP SCM, SAP SEM |