IBM Books

Database manager configuration parameters

Partial Table-of-Contents

  • Agent Stack Size (agent_stack_sz)
  • Priority of Agents (agentpri)
  • Application Support Layer Heap Size (aslheapsz)
  • Authentication Type (authentication)
  • Default Backup Buffer Size (backbufsz)
  • Communications Bandwidth (comm_bandwidth)
  • Connection Elapse Time (conn_elapse)
  • CPU Speed (cpuspeed)
  • Default Charge-Back Account (dft_account_str)
  • Default Client Adapter Number (dft_client_adpt)
  • Default Client Communication Protocol (dft_client_comm)
  • Default Database System Monitor Switches (dft_monswitches)
  • Default Database Path (dftdbpath)
  • Diagnostic Error Capture Level (diaglevel)
  • Diagnostic Data Directory Path (diagpath)
  • Directory Cache Support (dir_cache)
  • Directory Path Name in DCE Namespace (dir_path_name)
  • Directory Services Type (dir_type)
  • Discovery Mode (discover)
  • Search Discovery Communications Protocols (discover_comm)
  • Discover Server Instance (discover_inst)
  • DOS Requester I/O Block Size (dos_rqrioblk)
  • DRDA Heap Size (drda_heap_sz)
  • Number of FCM Message Anchors (fcm_num_anchors)
  • Number of FCM Buffers (fcm_num_buffers)
  • Number of FCM Connection Entries (fcm_num_connect)
  • Number of FCM Request Blocks (fcm_num_rqb)
  • IPX/SPX File Server Name (fileserver)
  • IPX/SPX Socket Number (ipx_socket)
  • Maximum Java Interpreter Heap Size (java_heap_sz)
  • Java Development Kit 1.1 Installation Path (jdk11_path)
  • Keep DARI Process Indicator (keepdari)
  • Maximum Number of Agents (maxagents)
  • Maximum Number of Concurrent Agents (maxcagents)
  • Node Connection Retries (max_connretries)
  • Maximum Number of Coordinating Agents (max_coordagents)
  • Maximum Number of DARI Processes (maxdari)
  • Maximum Time Difference Among Nodes (max_time_diff)
  • Maximum Total Files Open per Application (maxtotfilop)
  • Maximum Query Degree of Parallelism (max_querydegree)
  • Minimum Committed Private Memory (min_priv_mem)
  • Database System Monitor Heap Size (mon_heap_sz)
  • NetBIOS Workstation Name (nname)
  • Maximum Number of Concurrently Active Databases (numdb)
  • Initial Number of Agents in Pool (num_initagents)
  • Agent Pool Size (num_poolagents)
  • IPX/SPX DB2 Server Object Name (objectname)
  • Enable Intra-Partition Parallelism (intra_parallel)
  • Private Memory Threshold (priv_mem_thresh)
  • Query Heap Size (query_heap_sz)
  • Default Restore Buffer Size (restbufsz)
  • Audit Buffer Size (audit_buf_sz)
  • Transaction Resync Interval (resync_interval)
  • Routing Information Object Name (route_obj_name)
  • Client I/O Block Size (rqrioblk)
  • Sort Heap Threshold (sheapthres)
  • Sync Point Manager Name (spm_name)
  • Sync Point Manager Resync Agent Limit (spm_max_resync)
  • Sync Point Manager Log File Size (spm_log_file_sz)
  • LOGON Required for DB2START/DB2STOP (ss_logon)
  • Start and Stop Timeout (start_stop_time)
  • TCP/IP Service Name (svcename)
  • System Administration Authority Group Name (sysadm_group)
  • System Control Authority Group Name (sysctrl_group)
  • System Maintenance Authority Group Name (sysmaint_group)
  • Transaction Manager Database Name (tm_database)
  • Transaction Processor Monitor Name (tp_mon_name)
  • APPC Transaction Program Name (tpname)
  • Trust All Clients (trust_allclnts)
  • Trusted Clients Authentication (trust_clntauth)
  • UDF Shared Memory Set Size (udf_mem_sz)
  • Machine Node Type (nodetype)

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

    [ DB2 List of Books | Search the DB2 Books ]