DB2 system command and configuration parameters Daquan

Source: Internet
Author: User
Tags failover table definition time interval xquery

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.