Solution : https://service.sap.com/sap/support/notes/584952 (SAP Service marketplace login required)
Key words :
> fenced_pool >= 5> 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]note, ]> fcm_num_buffers = 4096 [cust]> fcm_num_rqb = automatic [cust]> fcm_num_connect = automatic [cust]> fcm_num_anchors = automatic [cust]> conn_elapse = 10 [cust]> max_connretries = 5 [cust]> max_time_diff = 60 [cust]> start_stop_time = 10 [cust] database configuration parameters, [cust]> sysadm_group = db<dbsid>adm> sysctrl_group = db<dbsid>ctl> sysmaint_group = db<dbsid>mnt> authentication = server_encrypt [cust]> catalog_noauth =, ]> applheapsz >= 3072> pckcachesz >= 5120> stat_heap_sz >= 15000> dlchktime = 10000 [cust]> maxlocks = 90 [cust]> locktimeout = 3600 [cust]> chngpgs_thresh = 20 [cust]> num_iocleaners >= 1note, jdk> [cust]> diaglevel = 3> notifylevel = 3> diagpath = /db2/<dbsid>/db2dump [os=unix] diagpath = <drive>, > dft_refresh_age = 0> dft_mttb_types = system> num_freqvalues = 10> num_quantiles = 20> dl_expint = 60> dl_wt_iexpint = 60> dl_num_copies = 1> dl_time_drop = 1> dl_upper =, > indexrec = restart> dft_loadrec_ses = 1 [cust]> num_db_backups = 12 [cust]> rec_his_retentn = 60 [cust]note, [cust]> tp_mon_name = <empty> [cust]> dft_account_str = <empty> [cust]> jdk_path = <path, > instance_memory = automatic> backbufsz = 1024 [cust]> restbufsz = 1024 [cust]> agent_stack_sz >= 64 [os=windows], > aslheapsz = 16> rqrioblk = 65000> query_heap_sz >= 2000> util_impact_lim = 10 [cust]> agentpri = system> maxagents >= 1024> num_poolagents = <
Related Notes :
| 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 |
| 1086130 | DB6: DB2 9.5 Standard Parameter Settings |
| 956214 | DB6: SQL0443N after upgrade to a new SAP release |
| 940550 | DB6: Installing FixPak V8.1/V8.2 (up to FP8) on Windows |
| 899322 | DB6: DB2 9.1 Standard Parameter Settings |
| 820473 | DB6: Snapshot function returns error or hangs |
| 819876 | DB6: Additional info about upgrade (based) on SAP NW AS 7.0 |
| 780546 | DB6: Use of new functions in DB2 V8.2 |
| 688647 | DB6: SAP BW and SAP NetWeaver BI Administration Tasks |
| 679581 | DB6: Additional information on upgrading to BW 3.5 |
| 662191 | DB6: Additions to upgrade (based) on SAP Web AS 6.40 |
| 603981 | DB6: Installing V8.2 FixPaks (as of FP9) on Win NT/Win 2000 |
| 546262 | DB6:Administration & Performance on SAP BW, SAP SCM, SAP SEM |
| 490095 | DB6: Additional information on upgrading to SAP Web AS 6.20 |
| 370026 | DB2 V7.2 Parameter settings for SAP Releases 4.x/6.10/6.20 |
| 369772 | DB6: MAXLOCKS settings - detailed information |
| 101809 | DB6: Supported Fix Packs IBM DB2 for Linux,UNIX and Windows |
| 99509 | DB6: Analyzing&Improving Buffer Pool Performance |