Solution : https://service.sap.com/sap/support/notes/370026 (SAP Service marketplace login required)
Key words :
dft_mon_bufpool ondft_mon_lock ondft_mon_sort ondft_mon_stmt ondft_mon_table ondft_mon_uow onsysadm_group db<sapsid>admsysctrl_group db<sapsid>ctlauthentication server_encryptsheapthres 20000, rec_his_retentn 366seqdetect yessoftmax 300sortheap 2048stat_heap_sz 4384stmtheap 4096tsm_mgmtclasstsm_nodenametsm_ownertsm_passworduserexit onutil_heap_sz 10000dbm parameter recommendation note----------------------------------------------------------------------agent_stack_sz 64, discover_db enabledl_expint 60dl_num_copies 1dl_time_drop 1dl_token mac0dl_upper nodlchktime 300000dyn_query_mgmt disableindexrec restartindexsort yeslocklist 10000, db parameter recommendation note---------------------------------------------------------------------app_ctl_heap_sz 1536applheapsz 15000autorestart onavg_appls 30buffpage, max_querydegree 1intra_parallel noudf_mem_sz 128registry variable recommendation note ----------------------------------------------------------------------db2_rr_to_rs ondb2_reduced_optimization 4, dft_degree 1dft_extent_sz 8dft_loadrec_ses 1dft_prefetch_sz 32dft_queryopt 5dft_refresh_age 0dft_sqlmathwarn nodir_obj_name, 15000stmtheap 10000avg_appls 3 database manager configuration parameters agent_stack_sz 128--, aslheapsz 16rqrioblk 65000query_heap_sz 2000agentpri systemmaxagents 768, diaglevel 3diagpath /db2/<sapsid>/db2dump, registry variable requires boolean values
Related Notes :
| 820473 | DB6: Snapshot function returns error or hangs |
| 584952 | DB6: DB2 UDB Version 8 Standard Parameter Settings |
| 490095 | DB6: Additional information on upgrading to SAP Web AS 6.20 |
| 369772 | DB6: MAXLOCKS settings - detailed information |
| 169798 | DB2 UDB EEE: Performance on BW 2.0A |
| 139173 | DB2 UDB: Performance BW 1.2B |
| 101809 | DB6: Supported Fix Packs IBM DB2 for Linux,UNIX and Windows |
| 99509 | DB6: Analyzing&Improving Buffer Pool Performance |