Solution : https://service.sap.com/sap/support/notes/1329179 (SAP Service marketplace login required)
Summary :
This SAP Note provides guidance on configuring DB2 database and database manager parameters, specifically tailored for systems running SAP on DB2 V9.7 across Linux, UNIX, and Windows platforms. The document offers detailed parameter settings for different system workloads—OLTP and OLAP—and advises adhering to these settings unless deviation is authorized by SAP Active Global Support during troubleshooting. Importantly, it emphasizes the use of DB2's Self-Tuning Memory Manager (STMM) for optimal configuration. Parameters discussed are dynamic and should reflect immediately in active database connections. The note also specifies settings based on the operating system, workload type, and DB2 version, ensuring tailored database performance optimization.
Key words :
> 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]> svcename = sapdb2<dbsid> [cust]> discover = search [cust]> discover_inst = enable [cust]> ssl_svr_keydb = [cust]> ssl_svr_stash = [cust]> ssl_svr_label = [cust]> ssl_svcename = [cust]> ssl_cipherspecs = [cust]> ssl_versions = [cust]> ssl_clnt_keydb = [cust]> ssl_clnt_stash = [cust]> max_querydegree = 1 [bi=, [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]> cluster_mgr = [cust]> authentication = server_encrypt [cust]> catalog_noauth =, > dbheap = automatic> catalogcache_sz >= 8000> logbufsz >= 1024> util_heap_sz >= 50000> buffpage >= 10000> stmtheap = automatic> applheapsz = automatic> appl_memory = automatic> stat_heap_sz = automatic> dlchktime = 10000 [cust]> locktimeout = 3600 [cust]> chngpgs_thresh = 20 [cust]> num_iocleaners = automatic [cust]> num_ioservers = automatic [cust]> indexsort =, [depr]> 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]> hadr_peer_window = 0 [cust]> logarchmeth1 =, > aslheapsz = 15> rqrioblk = 65000> util_impact_lim = 10 [cust]> agentpri = system> num_poolagents = automatic> num_initagents = 5 [cust]> max_coordagents = automatic> max_connections = automatic> keepfenced =, [cust]> dft_extent_sz = 2 [cust]> maxappls = automatic> avg_appls = automatic> maxfilop >= 61440 [cust]> logfilsiz = 16380 [cust]> logprimary = 60 [cust]> logsecond = 0note, [cust]> logarchopt2 = [cust]> failarchpath = [cust]> numarchretry = 5 [cust]> archretrydelay = 20 [cust]> vendoropt = [cust]note, [cust]> dftdbpath = /db2/<dbsid> [cust]> mon_heap_sz = automatic> java_heap_sz = 2048 [cust]> audit_buf_sz >= 0note, [cust]> tsm_mgmtclass = [cust]> tsm_nodename = [cust]> tsm_owner = [cust]> tsm_password = [cust]> auto_maint =, jdk> [cust]> diaglevel = 3> notifylevel = 3> diagpath = /db2/<dbsid>/db2dump [os=unix] diagpath = <drive>
Related Notes :
| 1724557 | Inst. Systems Based on NW 7.0 incl. EHPs: Windows DB2 LUW |
| 1724554 | Inst. Systems Based on NW 7.0 incl. EHPs: UNIX DB2 for LUW |
| 1598074 | DB6: Adjusting parameter check |
| 1590491 | |
| 1523227 | DB6: Use of BLOCKNONLOGGED database configuration parameter |
| 1514016 | DB6: DB2 LUW isolation levels used by AS ABAP |
| 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 |
| 1486779 | DB6: CUR_COMMIT=ON with 6.40 SAP kernel |
| 1474404 | DB6: Poor database performance with DB2AUDIT |
| 1351160 | DB6: Using DB2 9.7 with SAP Software |
| 1332109 | DB6: Upgrade to Version 9.7 of DB2 |
| 1225540 | DB6: 'Out of memory failure ' for STMM on DB2 LUW 9.5 |
| 1175547 | DB6: DATABASE_MEMORY=AUTOMATIC on SOLARIS |
| 1156578 | DB6: Slow reporting performance, especially on DataStore |
| 1132282 | DB6: Use of Self Tuning Memory Manager (STMM) for SAP NW BW |
| 1075118 | SAP on HP-UX: FAQ |
| 1056697 | DB6: SAP System Inst. with DB2 V9 only - Windows |
| 1056695 | DB6: SAP System Inst. with DB2 V9 only - UNIX |
| 584952 | DB6: DB2 UDB Version 8 Standard Parameter Settings |
| 1598376 | DB6: BACK GROUND SYSTEM APPS GET SQL1226N |
| 1605140 | SAP HANA 1.0: Central Note - SAP LT Replication Server |
| 101809 | DB6: Supported Fix Packs IBM DB2 for Linux,UNIX and Windows |
| 1138549 | DB6: Installation of Fix Packs for DB2 V9.5 (UNIX & Linux) |
| 1138550 | DB6: Installing Fix Packs for DB2 V9.5 (Windows) |
| 899322 | DB6: DB2 9.1 Standard Parameter Settings |
| 1086130 | DB6: DB2 9.5 Standard Parameter Settings |