Configure Instance -- 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)
• Sync Point Manager Log File Path (spm_log_path)

Fields and controls

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