DB2 system command and configuration parameters Daquan

The main consists of 4 parts, namely:

DB2 system Commands
DB2 Database Manager Configuration Parameters
DB2 Database System Configuration Parameters
DB2 Management Server (DAS) configuration parameters
DB2 system Commands
Dasauto-Automatically start the DB2 Management Server
DASCRT-Create DB2 Management Server
Dasdrop-Removing the DB2 Management Server
DASMIGR-Migrating the DB2 Management Server
DASUPDT-Update the DB2 Management Server
Db2_deinstall-Uninstalling DB2 products or features
Db2_install-Installing DB2 Products
DB2ADMIN-DB2 Management Server
DB2ADUTL-Managing DB2 objects within TSM
DB2ADVIS-DB2 Design Consultant Program
Db2audit-Audit Facility Administrator Tools
Db2batch-Benchmark Program tools
DB2BFD-Binding File Description tool
DB2CA-Start the configuration assistant
DB2CAP-CLI/ODBC Static Package Binding tool
Db2cat-System Catalog Analysis
DB2CC-Start Control center
Db2cfexp-Connection Configuration Export tool
Db2cfimp-Connection Configuration Import Tool
Db2chglibpath-Modify the embedded run-time Library search Path
Db2chgpath-Change the embedded run-time path
DB2CKBKP-Check Backup
Db2ckmig-Database Pre-migration Tool
Db2ckrst-Check the incremental recovery image sequence
DB2CLI-DB2 Interactive CLI
Db2cmd-Open the DB2 command window
Db2dart-database analysis and reporting tools
Db2daslevel-Show DAS level
DB2DCLGN-Claim Builder
Db2diag-db2diag.log Analysis Tools
Db2drdat-drda Tracking
DB2DRVMP-DB2 Database Drive Mappings
DB2EMPFA-Enable multi-page file allocation
Db2envar.bat-Setting the environment for the current command window
Db2eva-Event Analyzer
Db2evmon-Event Monitor productivity tool
DB2EVTBL-Generate Event monitor target table definition
DB2EXFMT-Description Table format
DB2EXMIG-Migration Instructions Table command
Db2expln-sql and XQuery Instructions
Db2extsec-Set permissions for DB2 objects
DB2FLSN-Find the log sequence number
DB2FM-DB2 Fault Monitor
DB2FS-The first step
DB2GCF-Control DB2 instances
DB2GOV-DB2 Controller
DB2GOVLG-DB2 Controller Log Query
Db2gpmap-Get distribution map
DB2HC-Start the health center
Db2iauto-Auto-launch instance
Db2iclus-microsoft Cluster Server
DB2ICRT-Creating an instance
Db2idrop-Removing instances
Db2ilist-Listing instances
DB2IMIGR-Migrating instances
DB2INIDB-Initializing the mirrored database
DB2INSPF-Formatting Check results
Db2isetup-launch Instance creation interface
DB2IUPDT-Update Instance
DB2JDBCBIND-DB2 JDBC Package Binding Program
DB2LDCFG-Configuring the LDAP environment
Db2level-Show DB2 service levels
DB2LICM-License Management tools
Db2listvolumes-Displays the GUID of all disk volumes
DB2LOGSFORRFWD-Log required to roll forward recovery
DB2LOOK-DB2 statistical information and DDL extraction tools
DB2LS-List installed DB2 products and features
Db2move-Database Mobility Tool
DB2MQLSN-MQ Listener
Db2mscs-Setting up the Windows failover utility
DB2MTRK-Memory Tracker
DB2NCHG-Changing the database partition server configuration
DB2NCRT-Adding a database partition server to an instance
Db2ndrop-Remove the database partition server from the instance
db2osconf-Utility for kernel parameter values
DB2PD-Monitor the DB2 database and troubleshoot it
DB2PDCFG-Configuring the DB2 database for problem determination behavior
DB2PERFC-Reset Database performance values
Db2perfi-Performance Counter registration utility
DB2PERFR-Performance Monitor Registration tool
Db2rbind-Rebind All packages
Db2relocatedb-Relocate the database
Db2rfpen-Reset roll forward suspend status
DB2RSPGN-Response File Generator
Db2sampl-Create a sample database
DB2SET-DB2 Profile Registration Form
Db2setup-Installation DB2
DB2SQL92-SQL92 compliant SQL statement processor
DB2SQLJBIND-SQLJ Profile Binding Program
DB2SQLJCUSTOMIZE-SQLJ Profile Customization Program
DB2SQLJPRINT-SQLJ Profile Printing Program
Db2start-Start DB2
Db2stop-Stop DB2
Db2support-Problem analysis and environment collection tools
Db2swtch-Toggle the default DB2 copy
Db2sync-Start the DB2 synchronizer
Db2systray-Start the DB2 system taskbar
Db2tapemgr-Managing log files on tapes
DB2TBST-Get Table space status
DB2TRC-Tracking
DB2UIDDL-a unique index transformation to prepare for conversion to V5 semantics
DB2UNDGP-Revoke execution privileges
Db2unins-Uninstalling the DB2 database product
Db2untag-Release Container markers
DB2UPDV9-Update the database to the current level of version 9
Db2xdbmig-Migrating XSR objects
DB2XPRT-Formatting trap files
Disable_mqfunctions-Disabling WebSphere MQ functions
Doce_deinstall-Uninstalling the DB2 Information Center
Doce_install-Installing the DB2 Information Center
Enable_mqfunctions-Enable WebSphere MQ functions
Installfixpack-Update installed DB2 products
Setup-Install DB2
SQLJ-SQLJ Conversion Program

DB2 Database Manager Configuration Parameters
AGENT_STACK_SZ-Agent Stack size
Agentpri-The priority of the agent
ASLHEAPSZ-Application support layer heap size
AUDIT_BUF_SZ-Audit Buffer size
Authentication-Authentication Type
Catalog_noauth-Allows cataloging without permission
Clnt_krb_plugin-Client Kerberos plug-in
Clnt_pw_plugin-Client User ID password plugin
Comm_bandwidth-Communication bandwidth
Conn_elapse-Connection Elapsed time
CPUSPEED-CPU speed
DFT_ACCOUNT_STR-Default Offset payment account
Dft_monswitches-default database System Monitor switch
Dftdbpath-Default database path
Diaglevel-Diagnostic error capture level
Diagpath-Diagnostic Data Directory path
Dir_cache-Directory Cache support
Discover-Discover the way
Discover_inst-Discovering server instances
FCM_NUM_BUFFERS-FCM Number of Buffers
FCM_NUM_CHANNELS-FCM Channel number configuration parameters
Fed_noauth-Bypassing joint authentication
Federated-Federated Database system support
Fenced_pool-Maximum number of protected processes
Group_plugin-Group Plugins
Health_mon-Health Monitoring
Indexrec-Index re-creation time
Instance_memory-Instance Memory
Intra_parallel-Enable intra-partition parallelism
JAVA_HEAP_SZ-Maximum Java interpreter heap Size
Jdk_path-java Software Developer Toolkit installation path
Keepfenced-Maintain protected process
Local_gssplugin-GSS API plug-in for local instance-level permissions
Max_connections-Maximum number of client connections
Max_connretries-node Connection retry count
Max_coordagents-Maximum number of coordinated agent processes
Max_querydegree-Maximum query parallelism
Max_time_diff-The maximum time difference between nodes
Maxagents-Maximum number of agent processes
Maxcagents-Maximum number of concurrent agent processes
Maxtotfilop-The maximum number of open files
MON_HEAP_SZ-Database System Monitor Heap size
Nname-netbios Workstation Name
NodeType-Machine Node type
NOTIFYLEVEL-Notification level
Num_initagents-Initial number of agent processes in the pool
num_initfenced-Initial number of shielded processes
Num_poolagents-Agent process Pool size
Numdb-Maximum number of simultaneous active databases, including hosts and iSeries databases
QUERY_HEAP_SZ-Query Heap size
Release-configuration file release level
Resync_interval-Transaction resynchronization interval
RQRIOBLK-Client I/O block size
Sheapthres-Sorting heap thresholds
SPM_LOG_FILE_SZ-Sync Point manager log file size
Spm_log_path-Synchronization Point manager log file path
Spm_max_resync-Synchronization Point manager resynchronization Agent process limit
Spm_name-Sync Point manager name
Srvcon_auth-authentication type for incoming connections in the server
Srvcon_gssplugin_list-List of incoming GSS API plug-ins in the server
Srvcon_pw_plugin-the User ID password plug-in for incoming connections in the server
Srv_plugin_mode-server plug-in mode
Start_stop_time-Start and stop timeouts
SVCENAME-TCP/IP Service Name
Sysadm_group-System Administrative Permission Group name
Sysctrl_group-System CONTROL permission Group name
Sysmaint_group-System Maintenance Permission Group name
Sysmon_group-System Monitoring permission group name
Tm_database-transaction Manager database name
Tp_mon_name-transaction Processor monitor name
Trust_allclnts-Trusting all clients
Trust_clntauth-Trusted Client Authentication
Util_impact_lim-Instance Impact policy

DB2 Database System Configuration Parameters
Alt_collate-Alternate collating order
APP_CTL_HEAP_SZ-Application Control Heap Size
APPGROUP_MEM_SZ-Maximum size of the application group memory set
Applheapsz-Application Heap Size
Archretrydelay-Archive Retry delay when an error occurs
Autonomic_switches-Automatic Maintenance switch
AutoRestart-Enable automatic restart
Avg_appls-average number of active applications
Backup_pending-Backup Suspend indicator
Blk_log_dsk_ful-Hangs when log disk is full
CATALOGCACHE_SZ-Directory Cache Size
Chngpgs_thresh-page thresholds that have changed
CodePage-code page for the database
CodeSet-code set for the database
Collate_info-Organizing information
Country/region-Database Geography code
Database_consistent-the database is consistent
Database_level-Database Release level
Database_memory-Database Shared memory size
Db_mem_thresh-Database memory threshold configuration parameters
Dbheap-Database Heap
Dft_degree-Default Degree
DFT_EXTENT_SZ-Default extended chunk size for table spaces
Dft_loadrec_ses-Default number of mounted recovery sessions
Dft_mttb_types-table type reserved for optimization configuration parameters by default
DFT_PREFETCH_SZ-Default prefetch size
DFT_QUERYOPT-Default Query optimization class
Dft_refresh_age-Default Refresh Life
Dft_sqlmathwarn-Continue when an arithmetic exception occurs
discover_db-Discovery Database
Dlchktime-time interval for checking for deadlocks
DYN_QUERY_MGMT-Dynamic SQL and XQuery query management configuration parameters
Failarchpath-Failover Log Archive path
Groupheap_ratio-Percentage of memory in the application group heap
Hadr_db_role-hadr Database Roles
Hadr_local_host-hadr Local Host Name
Hadr_local_svc-hadr Local Service Name
HADR_REMOTE_HOST-HADR Remote Host Name
Hadr_remote_inst-The HADR instance name of the remote server
HADR_REMOTE_SVC-HADR Remote Service Name
Hadr_syncmode-Log Write HADR synchronization mode in peer state
Hadr_timeout-hadr Timeout value
jdk_64_path-64-bit Java Software Developer Toolkit installation path DAS
Locklist-Maximum storage of locked lists
Locktimeout-Lock Timeout
Log_retain_status-Log Retention status indicator
Logarchmeth1-Master Log archiving method
LOGARCHMETH2-Auxiliary Log archiving method
LOGARCHOPT1-Primary Log archiving option
LOGARCHOPT2-Secondary log archiving options
Logbufsz-Log buffer size
Logfilsiz-Size of log file
Loghead-First activity log file
Logindexbuild-the Log index page that was created
LogPath-Location of log files
Logprimary-Number of primary log files
Logretain-Enable log retention
Logsecond-Number of secondary log files
Max_log-Maximum log per transaction
MAXAPPLS-Maximum number of active applications
Maxfilop-Maximum number of database files opened per application
Maxlocks-Maximum percentage of locked list before upgrade
Min_dec_div_3-Decimal division, 3 digits
Mincommit-Number of implementation for groups
Mirrorlogpath-Mirror Log path
MULTIPAGE_ALLOC-enabled multi-page file allocation
Newlogpath-Changing the database log path
Num_db_backups-Number of database backups
Num_freqvalues-Number of high-frequency values reserved
Num_iocleaners-Number of async page cleanup programs
NUM_IOSERVERS-I/O Number of servers
Num_log_span-numbered Log range
Num_quantiles-Number of bits in a column
Numarchretry-Number of retries when an error occurs
Default number of numsegs-sms containers
Overflowlogpath-Overflow Log path
PageSize-Database Default page size
Pckcachesz-Package Cache size
REC_HIS_RETENTN-recovery History retention period
Restore_pending-Recovery suspend
Restrict_access-Restricted database access configuration parameters
Rollfwd_pending-Roll forward pending indicator
Self_tuning_mem-Self-tuning memory configuration parameters
Seqdetect-Sequential detection flag
Sheapthres_shr-Sort heap threshold for shared sort
Softmax-recovery range and soft checkpoint interval
Sortheap-Sort Heap Size
STAT_HEAP_SZ-Statistical information heap Size
STMTHEAP-Statement Heap Size
Territory-Database Geography
TPNAME-APPC Transaction Program Name
Trackmod-Enable tracking of modified pages
Tsm_mgmtclass-tivoli Storage Manager Management class
Tsm_nodename-tivoli Storage Manager node name
Tsm_owner-tivoli Storage Manager owner name
Tsm_password-tivoli Storage Manager Password
Use_sna_auth-Using SNA Authentication
User_exit_status-User Exit status indicator
UserExit-Enable user exit
UTIL_HEAP_SZ-Utility Heap Size
Vendoropt-Provider Options

DB2 Management Server (DAS) configuration parameters
Authentication-Authentication Type DAS
Contact_host-Location of the contact list
Das_codepage-das code page
Das_territory-das Region
Dasadm_group-das Administrative Permission Group name
Name of the DB2SYSTEM-DB2 server system
Discover-das Discovery Method
Exec_exp_task-Performing an expired task
Jdk_path-java Software Developer Toolkit installation path DAS
Sched_enable-Scheduler Mode
Sched_userid-Scheduler User ID
SMTP_SERVER-SMTP Server
TOOLSCAT_DB-Tools Catalog Database
Toolscat_inst-Tools Catalog DB instance
Toolscat_schema-Tool Catalog Database schema

DB2 system command and configuration parameters Daquan