Solution : https://service.sap.com/sap/support/notes/1329179 (Connexion à SAP Service Marketplace requise)
Résumé :
Cette note SAP offre des directives sur la configuration des paramètres de la base de données DB2 et du gestionnaire de base de données, spécifiquement adaptées pour les systèmes exécutant SAP sur DB2 V9.7 dans les environnements Linux, UNIX et Windows. Le document propose des réglages de paramètres détaillés pour différents types de charges de travail système—OLTP et OLAP—et recommande de respecter ces réglages à moins qu'une déviation ne soit autorisée par le support global actif de SAP lors du dépannage. Il met en avant l'importance d'utiliser le gestionnaire de mémoire auto-ajustable (STMM) de DB2 pour une configuration optimale. Les paramètres discutés sont dynamiques et doivent se refléter immédiatement dans les connexions actives à la base de données. La note spécifie également les paramètres selon le système d'exploitation, le type de charge de travail et la version de DB2, assurant une optimisation personnalisée des performances de la base de données.
Mots Clés :
> 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>
Notes associées :
| 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 |