SAP Note 584952 - DB6: DB2 UDB Version 8 Standard Parameter Settings

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

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 :

1493932DB6: How to choose the extent size of DB2 tablespaces
1493852DB6: Use of alternate page cleaning
1493587DB6: Use of infinite logging or secondary log files
1474404DB6: Poor database performance with DB2AUDIT
1329179DB6: DB2 9.7 Standard Parameter Settings
1308895DB6: File System for Transaction Log is Full
1293475DB6: Transaction Log Full
1250466DB6: Perform database administration, keeping SAP AS running
1086130DB6: DB2 9.5 Standard Parameter Settings
956214DB6: SQL0443N after upgrade to a new SAP release
940550DB6: Installing FixPak V8.1/V8.2 (up to FP8) on Windows
899322DB6: DB2 9.1 Standard Parameter Settings
820473DB6: Snapshot function returns error or hangs
819876DB6: Additional info about upgrade (based) on SAP NW AS 7.0
780546DB6: Use of new functions in DB2 V8.2
688647DB6: SAP BW and SAP NetWeaver BI Administration Tasks
679581DB6: Additional information on upgrading to BW 3.5
662191DB6: Additions to upgrade (based) on SAP Web AS 6.40
603981DB6: Installing V8.2 FixPaks (as of FP9) on Win NT/Win 2000
546262DB6:Administration & Performance on SAP BW, SAP SCM, SAP SEM
490095DB6: Additional information on upgrading to SAP Web AS 6.20
370026DB2 V7.2 Parameter settings for SAP Releases 4.x/6.10/6.20
369772DB6: MAXLOCKS settings - detailed information
101809DB6: Supported Fix Packs IBM DB2 for Linux,UNIX and Windows
99509DB6: Analyzing&Improving Buffer Pool Performance