Performance

Use the Performance page of the Configure Database notebook to view and change the configuration parameters that affect the performance of the database. Parameters that affect the database performance are:

• Database Heap (dbheap)
• Catalog Cache Size (catalogcache_sz)
• Log Buffer Size (logbufsz)
• Utility Heap Size (util_heap_sz)
• Buffer Pool Size (buffpage)
• Package Cache Size (pckcachesz)
• Maximum Storage for Lock List (locklist)
• Extended Storage Memory Segment Size (estore_seg_sz)
• Number of Extended Storage Memory Segments (num_estore_segs)
• Sort Heap Size (sortheap)
• Statement Heap Size (stmtheap)
• Application Heap Size (applheapsz)
• Statistics Heap Size (stat_heap_sz)
• Application Control Heap Size (app_ctl_heap_sz)
• Changed Pages Threshold (chngpgs_thresh)
• Number of Asynchronous Page Cleaners (num_iocleaners)
• Number of I/O Servers (num_ioservers)
• Sequential Detection Flag (seqdetect)
• Default Prefetch Size (dft_prefetch_sz)
• Index Sort Flag (indexsort)
• Default Number of SMS Containers (numsegs)
• Default Extent Size of Table Spaces (dft_extent_sz)
• MultiPage File Allocation Enabled (multipage_alloc)

Controls

• Parameters
• Parameter filters
• Value
• Hint
• Custom columns
• Find
• OK
• Defaults
• Cancel

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

[ DB2 List of Books | Search the DB2 Books ]