Solution : https://service.sap.com/sap/support/notes/1086130 (SAP Service marketplace login required)
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]> cluster_mgr = [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]> svcename = sapdb2<dbsid> [cust]> discover = search [cust]> discover_inst = enable [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 =, [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 =, ]> 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] database configuration parameters, > aslheapsz = 16> 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> 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>, [cust]> dftdbpath = /db2/<dbsid> [cust]> mon_heap_sz = automatic> java_heap_sz = 2048 [cust]> audit_buf_sz >= 0note
Related Notes :
| 1523227 | DB6: Use of BLOCKNONLOGGED database configuration parameter |
| 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 |
| 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 |
| 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 |
| 1138550 | DB6: Installing Fix Packs for DB2 V9.5 (Windows) |
| 1138549 | DB6: Installation of Fix Packs for DB2 V9.5 (UNIX & Linux) |
| 1132282 | DB6: Use of Self Tuning Memory Manager (STMM) for SAP NW BW |
| 1089578 | DB6: Using DB2 Version 9.5 with SAP Software |
| 1056697 | DB6: SAP System Inst. with DB2 V9 only - Windows |
| 1056695 | DB6: SAP System Inst. with DB2 V9 only - UNIX |
| 899322 | DB6: DB2 9.1 Standard Parameter Settings |
| 584952 | DB6: DB2 UDB Version 8 Standard Parameter Settings |