Solution : https://service.sap.com/sap/support/notes/899322 (Connexion à SAP Service Marketplace requise)
Résumé :
Cette note SAP détaille les directives de configuration pour les paramètres de la base de données DB2 V9.1, applicables à toutes les versions SAP sur les plateformes Linux, UNIX et Windows. Elle spécifie les réglages des paramètres pour les classes de charges de travail OLTP et OLAP et fournit des détails de configuration marqués pour le gestionnaire de mémoire auto-ajustable (STMM) de DB2 et basés sur le système d'exploitation, la version en bits de la base de données et les niveaux de Fix Pack de DB2. Le STMM est recommandé pour la configuration automatique de la mémoire dans les systèmes à partition unique. Des modifications dans des paramètres tels que DISCOVER_DB, les recommandations de logs et les seuils de mémoire sont également documentés. Les utilisateurs sont conseillés de ne pas modifier ces paramètres à moins que cela ne soit nécessaire et de consulter le support global actif de SAP pour des déviations temporaires afin de résoudre des problèmes spécifiques.
Mots Clés :
[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=
Notes associées :
| 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 |