SAP Note 370026 - DB2 V7.2 Parameter settings for SAP Releases 4.x/6.10/6.20

Component : Backoffice Service Delivery - DB2 Universal Database for Unix / NT

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 :

820473DB6: Snapshot function returns error or hangs
584952DB6: DB2 UDB Version 8 Standard Parameter Settings
490095DB6: Additional information on upgrading to SAP Web AS 6.20
369772DB6: MAXLOCKS settings - detailed information
169798DB2 UDB EEE: Performance on BW 2.0A
139173DB2 UDB: Performance BW 1.2B
101809DB6: Supported Fix Packs IBM DB2 for Linux,UNIX and Windows
99509DB6: Analyzing&Improving Buffer Pool Performance