DB2 system commands and configuration parameters

Source: Internet
Author: User
Tags failover table definition xquery
DB2 system command dasauto-automatically start the DB2 Management Server dascrt-create the DB2 Management Server dasdrop-remove the DB2 Management Server dasmigr-migrate the DB2 Management Server dasupdt-update the DB2 Management Server db2_deinstall-uninstall the DB2 product or function component db2_install-install DB2 product db2admin-DB2 Management Server db2adutl-manage DB2 objects in TSM db2advis-DB2 design advisor db2audit-Audit facility administrator tool db2batch-benchmark program tool db2bfd-binding file description tool db2ca-start "configuration assistant" db2cap-cli/ODBC static package binding tool db2cat-system directory analysis db2cc-Start Control Center db2cfexp-connection configuration export tool db2cfimp-connection configuration Import tool db2chglibpath-Modify embedded Runtime library search path db2chgpath-change embedded runtime path db2ckbkp-check backup db2ckmig-database pre-migration tool db2ckrst-check incremental recovery Image Sequence db2cli-DB2 interactive CLI db2cmd-open the DB2 command window db2dart-database analysis and reporting tool db2daslevel-display the DAS level db2dclgn-declaration generator db2diag-db2diag. log Analysis Tool db2drdat-drda trace db2drvmp-DB2 database drive ing db2empfa-enable multi-page file allocation db2envar. bat-set the environment of the current command window db2eva-event analyzer db2evmon-event monitor productivity tool db2evtbl-generate event monitor target table definition db2exfmt-table-style db2exmig-migration instructions table command db2expln-SQL and XQuery description db2extsec-set DB2 object permission db2flsn-search log no. db2fm-DB2 Fault Monitor db2fs-Step 1 db2gcf-control DB2 instance db2gov-DB2 controller db2govlg-DB2 controller log query db2gpmap -obtain the distribution chart db2hc-start the running status center db2iauto-automatically start instance db2iclus-Microsoft Cluster Server db2icrt-create instance db2idrop-Remove instance db2ilist-list instance db2imigr-migrate instance db2inidb-initialize the Image Database db2inspf-format check result db2isetup-start instance Creation Interface db2iupdt-update instance db2jdbcbind-DB2 JDBC package binding program db2ldcfg-configure LDAP environment db2level-display DB2 service level db2licm-license management tool db2listvolumes- display guid db2logsforrfwd for all disk volumes-list the logs required for roll-forward recovery db2look-DB2 statistics and DDL Extraction Tool db2ls-List Installed DB2 products and features db2move-database movement Tool db2mqlsn-MQ listener db2msc-set windows failover utility db2mtrk-memory tracking program db2nchg-change database partition server configuration db2ncrt-add database partition server to instance db2ndrop-delete from instance database partition server db2osconf-utility for Kernel Parameter Value db2pd-monitors DB2 database and diagnoses it for fault db2pdcfg-configures DB2 database db2perfc for problem determination behavior-resets database performance value db2perfi-Performance counter registration utility db2perfr-Performance Monitor registration tool db2rbind-rebind all packages db2relocatedb-Relocate database db2rfpen-Reset roll-forward pending status db2rspgn-response file generator db2sampl-create Sample Database db2set- DB2 profile registry db2setup-install DB2 db2sql92-Compliance with sql92 SQL statement processor db2sqljbind-sqlj profile binding program db2sqljcustomize-sqlj profile file customization program db2sqljprint-sqlj profile Printing Program db2start-start DB2 db2stop-Stop DB2 db2support-problem analysis and environment collection tool db2swtch-switch the default DB2 copy db2sync-start DB2 synchronization db21_ray-start DB2 system taskbar db2tapemgr-manage log files on tape db2tbst- retrieve tablespace status db2trc-trace db2uiddl-unique index to convert to V5 semantics transformation db2undgp-Revoke execution privilege db2unins-uninstall DB2 database product db2untag-release container mark db2updv9-update database to version 9 current level db2xdbmig-migrate XSR object db2xprt-format trap file disable_mqfunctions-Disable WebSphere MQ function doce_deinstall-uninstall DB2 Information Center doce_install-install DB2 Information Center enable_mqfunctions-enable WebSphere MQ function installfixpack-Update install the DB2 product setup-install the DB2 sqlj-sqlj converter DB2 database manager configuration parameter agent_stack_sz-Agent Stack size agentpri-Agent priority aslheapsz-application support layer heap size audit_buf_sz -Audit buffer size Authentication-authentication type catalog_noauth-allows cataloguing, no permission required-client Kerberos plug-in clnt_pw_plugin-client user identification password plug-in comm_bandwidth-communication bandwidth conn_elapse-connection consumption time cpuspeed-CPU speed dft_account_str-default 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-Discovery Method discover_inst-Discovery Server instance fcm_num_buffers-FCM buffer number fcm_num_channels-FCM number of channels Configuration Parameter fed_noauth-bypass federated-the federated database system supports fenced_pool-Maximum number of protected processes group_plugin-group plug-in health_mon-Health Monitoring indexrec-index re-creation time instance_memory-instance memory intra_parallel-enable intra-partition concurrency java_heap_sz-maximum Java interpreter heap size jdk_path-Java software developer toolkit installation path keepfenced-keep protected process local_gssplugin-gss api plug-in for local instance-level Permissions max_connections-Maximum number of client connections-Number of node connection retries max_coordagents-Maximum number of coordinated proxy processes max_querydegree-maximum query concurrency max_time_diff-maximum time difference between nodes maxagents-Maximum number of agent processes maxcagents- maximum number of concurrent proxy processes maxtotfilop-Maximum number of opened files mon_heap_sz-database system monitor heap size nname-NetBIOS workstation name nodetype-machine node type policylevel-Notification level num_initagents-proxy in the pool initial number of processes num_initfenced-initial number of protected processes num_poolagents-Maximum number of proxy process pools numdb-Maximum number of databases simultaneously active on the host and iseries database query_heap_sz-query heap size release- configuration File release level resync_interval-transaction re-synchronization interval rqrioblk-client I/O BLOCK SIZE sheapthres-sorting heap threshold spm_log_file_sz-synchronization point Manager Log File Size spm_log_path-synchronization point Manager Log File path spm_max_resync-synchronization point manager re-synchronization proxy process restriction spm_name-synchronization point manager name srvcon_auth-Authentication Type srvcon_gssplugin_list of the local connection in the server-List of gss api plug-ins in the server- user identification and password plug-in srv_plugin_mode-server plug-in method start_stop_time-Start and Stop timeout svcename-TCP/IP service name sysadm_group-system management 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_allclets-trust all clients trust_clntauth-trusted client authentication util_impact_lim- instance Impact Policy DB2 database system configuration parameter alt_collate-Backup sorting order app_ctl_heap_sz-Application Control Heap size appgroup_mem_sz-maximum size of Application Group memory set applheapsz-application heap size archretrydelay-error occurred archive retry delay autonomic_switches-automatic maintenance switch autorestart-Enable Automatic Restart avg_appls-average number of active applications backup_pending-Backup hold indicator blk_log_dsk_ful-when the log disk is full, catalogcache_sz- directory cache size chngpgs_thresh-Modified PAGE threshold codePage-database code page codeset-database code set collate_info-sort information country/region-database region code database_consistent-database is consistent database_level- database Release level database_memory-database shared memory size db_mem_thresh-database memory threshold Configuration Parameter dbheap-database heap dft_degree-default degree dft_extent_sz-tablespace default extended data block size dft_loadrec_ses-load the restored session default number of partitions-Table type dft_prefetch_sz retained by default for optimized configuration parameters-default prefetch size dft_queryopt-default query optimization class dft_refresh_age-default refresh life dft_sqlmathwarn-continue discover_db when dlchktime-check the deadlock interval dyn_query_mgmt-dynamic SQL and XQuery query Management Configuration Parameter failarchpath-failover log archiving path groupheap_ratio-Application Group heap memory percentage hadr_db_role-hadr database role hadr_local_host- hadr local host name hadr_local_svc-hadr local service name hadr_remote_host-hadr remote host name hadr_remote_inst-hadr Instance name of the remote server hadr_remote_svc-hadr remote service name hadr_syncmode-hadr synchronization mode for log writing hadr_timeout-hadr timeout value jdk_64_path-64-bit Java software developer toolkit installation path das locklist-maximum storage of lock list locktimeout-lock timeout log_retain_status-Log Retention Status Indicator logarchmeth1-Primary log archiving method logarchmeth2-Auxiliary log archiving method logarchopt1-master log archiving option logarchopt2-Auxiliary log archiving option logbufsz-log buffer size logfilsiz-Log File Size loghead-the first active Log File logindexbuild-created logpath-location of log files logprimary-Number of Primary log files logretain-enable Log Retention logsecond-Number of auxiliary log files max_log-Maximum log of each transaction maxappls-number of active applications maxfilop-Maximum number of database files opened by each application maxlocks-maximum percentage of locked list before Upgrade min_dec_div_3-decimal division, decimal point: 3 mincommit-number of implementations for the group-mirror logpath-mirror Log Path multipage_alloc-enabled multi-page file allocation newlogpath-Change Database Log Path num_db_backups-Number of Database backups num_freqvalues-reserved high frequency value number of num_iocleaners-Number of asynchronous page purge programs num_ioservers-I/o servers Number of num_log_span-Number of log ranges num_quantiles-Number of quantile columns numarchretry-Number of retries when an error occurs numsegs-SMS container overflowlogpath-overflow Log Path pagesize-database default page size pckcachesz-package cache size rec_his_retentn-restoration history retention period restore_pending-restoration pending restrict_access-database access restriction Configuration Parameter rollfwd_pending- roll Forward temporarily mounting indicator self_tuning_mem-Self-tuning memory configuration parameter seqdetect-sequence Detection flag sheapthres_shr-Sort heap threshold value of shared sorting softmax-restoration range and soft checkpoint interval sortheap-Sort heap size stat_heap_sz- statistics heap size define theap-statement heap size territory-database region tpname-APPC transaction program name trackmod-enable 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_sn_auth-use SNA to authenticate user_exit_status-user exit Status Indicator userexit-Enable User exit util_heap_sz-utility heap size vendo DB2 Management Server (DAS) configure parameter Authentication-authentication type das contact_host-contact list location das_codepage-das code page das_territory-das region dasadm_group-das management permission group name db2system-DB2 server system name discover-das Discovery Method exec_exp_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-tool directory database toolscat_inst-tool directory database instance toolscat_schema-tool directory database mode

 

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.