IBM Books

Database configuration parameters

Partial Table-of-Contents

  • ADSTAR Distributed Storage Manager Management Class (adsm_mgmtclass)
  • ADSTAR Distributed Storage Manager Node Name (adsm_nodename)
  • ADSTAR Distributed Storage Manager Owner Name (adsm_owner)
  • ADSTAR Distributed Storage Manager Password (adsm_password)
  • Application Control Heap Size (app_ctl_heap_sz)
  • Application Heap Size (applheapsz)
  • Auto Restart Enable (autorestart)
  • Average Number of Active Applications (avg_appls)
  • Buffer Pool Size (buffpage)
  • Catalog Cache Size (catalogcache_sz)
  • Changed Pages Threshold (chngpgs_thresh)
  • Copy Protection Enable (copyprotect)
  • Database Heap (dbheap)
  • Default Degree (dft_degree)
  • Default Extent Size of Table Spaces (dft_extent_sz)
  • Default Number of Load Recovery Sessions (dft_loadrec_ses)
  • Default Prefetch Size (dft_prefetch_sz)
  • Default Query Optimization Class (dft_queryopt)
  • Continue upon Arithmetic Exceptions (dft_sqlmathwarn)
  • Discover Database (discover_db)
  • Time Interval for Checking Deadlock (dlchktime)
  • Extended Storage Memory Segment Size (estore_seg_sz)
  • Index Sort Flag (indexsort)
  • Maximum Storage for Lock List (locklist)
  • Lock Timeout (locktimeout)
  • Log Buffer Size (logbufsz)
  • Size of Log Files (logfilsiz)
  • Number of Primary Log Files (logprimary)
  • Log Retain Enable (logretain)
  • Number of Secondary Log Files (logsecond)
  • Maximum Number of Active Applications (maxappls)
  • Maximum Database Files Open per Application (maxfilop)
  • Maximum Percent of Lock List Before Escalation (maxlocks)
  • Number of Commits to Group (mincommit)
  • Change the Database Log Path (newlogpath)
  • Number of Extended Storage Memory Segments (num_estore_segs)
  • Number of Frequent Values Retained (num_freqvalues)
  • Number of Asynchronous Page Cleaners (num_iocleaners)
  • Number of I/O Servers (num_ioservers)
  • Number of Quantiles for Columns (num_quantiles)
  • Package Cache Size (pckcachesz)
  • Recovery History Retention Period (rec_his_retentn)
  • Sequential Detection Flag (seqdetect)
  • Recovery Range and Soft Checkpoint Interval (softmax)
  • Sort Heap Size (sortheap)
  • Statistics Heap Size (stat_heap_sz)
  • Statement Heap Size (stmtheap)
  • User Exit Enable (userexit)
  • Utility Heap Size (util_heap_sz)
  • Backup Pending Indicator (backup_pending)
  • Code Page for the Database (codepage)
  • Codeset for the Database (codeset)
  • Collating Information (collate_info)
  • Country code for the Database (country)
  • Database is Consistent (database_consistent)
  • Database Release Level (database_level)
  • Log Retain Status Indicator (log_retain_status)
  • Log Head Identification (loghead)
  • Location of Log Files (logpath)
  • MultiPage File Allocation Enabled (multipage_alloc)
  • Next Active Log (nextactive)
  • Default Number of SMS Containers (numsegs)
  • Restore Pending (restore_pending)
  • Roll Forward Pending Indicator (rollfwd_pending)
  • Territory for the Database (territory)
  • User Exit Status Indicator (user_exit_status)

    • [ Top of Page | Table of Contents | Glossary | Index ]

    [ DB2 List of Books | Search the DB2 Books ]