IBM Books

Reference material

Partial Table-of-Contents

  • Configuration Parameters
  • Database manager configuration parameters
  • 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)
  • Database and database manager configuration parameters
  • Object Name in DCE Namespace (dir_obj_name)
  • Index Re-creation Time (indexrec)
  • Configuration File Release Level (release)
  • Database configuration parameters
  • 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 ]