Solution : https://service.sap.com/sap/support/notes/1692571 (Connexion à SAP Service Marketplace requise)
Résumé :
Ce document SAP fournit des instructions sur la configuration des paramètres de la base de données DB2 et du gestionnaire de base de données pour les systèmes SAP utilisant DB2 10.1 sous Linux, UNIX et Windows. Il concerne les classes de charge de travail OLTP et OLAP, mettant en avant l'utilisation du "Self-Tuning Memory Manager" (STMM) pour optimiser les paramètres de mémoire de la base de données. Des recommandations détaillées et des marqueurs (par exemple, [STMM=OUI], [OS=WINDOWS], [BI=NON]) indiquent des configurations spécifiques adaptées à différents types de charge de travail et configurations. Les paramètres obsolètes et ceux spécifiques à des fonctionnalités de DB2 comme pureScale et DPF sont également discutés. Les améliorations en gestion de la mémoire incluent des conseils pour régler certains paramètres de la base de données sur AUTOMATIQUE sous STMM pour faciliter une utilisation optimale de la mémoire. L'utilisation du STMM doit suivre des directives d'activation précises fournies dans la note pour maintenir la performance du système.
Mots Clés :
[cust]> sysadm_group = db<dbsid>adm> sysctrl_group = db<dbsid>ctl> sysmaint_group = db<dbsid>mnt> sysmon_group = db<dbsid>mon [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]> alternate_auth_enc = not_specified [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]> 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=, ]> dbheap = automatic> catalogcache_sz >= 2560> 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 =, > 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_target_list = [cust]> hadr_syncmode = nearsync [cust]> hadr_spool_limit = 0 [cust]> hadr_replay_delay = 0 [cust]> hadr_peer_window = 0 [cust]> logarchmeth1 =, [cust]> mon_locktimeout = without_hist [cust]> mon_deadlock = without_hist [cust]> mon_lockwait = without_hist [cust]> mon_lw_thresh = 300000000 [cust]> mon_pkglist_sz = 32 [cust]> mon_lck_msg_lvl = 1 [cust]> smtp_server = [cust]> sql_ccflags = [cust]> section_actuals =, > federated_async = 0> 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]> cf_mem_sz = automatic [pscale=, [cust]> dft_extent_sz = 2 [cust]> maxappls = automatic> avg_appls = automatic> maxfilop >= 61440 [cust]> logfilsiz = 20000 [cust]> logprimary = 60 [cust]> logsecond = 0note, > 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]> 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
Notes associées :
| 1700631 | DB6: Using DB2 10.1 with SAP Applications |
| 1645684 | DB6: Upgrade to Version 10.1 of DB2 for LUW |
| 1598074 | DB6: Adjusting parameter check |
| 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 |
| 1132282 | DB6: Use of Self Tuning Memory Manager (STMM) for SAP NW BW |
| 1075118 | SAP on HP-UX: FAQ |