Performance

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

• Database System Monitor Heap Size (mon_heap_sz)
• UDF Shared Memory Set Size (udf_mem_sz)
• Default Backup Buffer Size (backbufsz)
• Default Restore Buffer Size (restbufsz)
• Audit Buffer Size (audit_buf_sz)
• Sort Heap Threshold (sheapthres)
• Directory Cache Support (dir_cache)
• Agent Stack Size (agent_stack_sz)
• Minimum Committed Private Memory (min_priv_mem)
• Private Memory Threshold (priv_mem_thresh)
• Maximum Java Interpreter Heap Size (java_heap_sz)
• Application Support Layer Heap Size (aslheapsz)
• Query Heap Size (query_heap_sz)
• DRDA Heap Size (drda_heap_sz)
• Client I/O Block Size (rqrioblk)
• DOS Requester I/O Block Size (dos_rqrioblk)
• Transaction Resync Interval (resync_interval)
• Sync Point Manager Log File Size (spm_log_file_sz)
• Sync Point Manager Name (spm_name)
• Sync Point Manager Resync Agent Limit (spm_max_resync)

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 ]