What are the basic DB2 commands and knowledge for beginners of DB2? (1)

Source: Internet
Author: User

The following articles mainly introduce you to the basic DB2 commands and related knowledge that you must master as a beginner in DB2 database learning. We all know that you are in the DB2 database getting started course, some friends mentioned this question, and experts answered it and compiled it to help other friends learn and master it.

Common DB2 commands

Dasauto-automatically starts the DB2 Management Server

Dascrt-create a DB2 Management Server

Dasdrop-Remove DB2 Management Server

Dasmigr-migrate the DB2 Management Server

Dasupdt-update the DB2 Management Server

Db2_deinstall-uninstall DB2 products or functional components

Db2_install-install DB2

Db2admin-DB2 Management Server

Db2adutl-manage DB2 objects in TSM

Db2advis-DB2 design Advisor

Db2audit-Audit facility administrator tool

Db2batch-benchmark program tool

Db2bfd-file binding 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 the embedded Runtime library search path

Db2chgpath-change the embedded runtime 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-display the DAS level

Db2dclgn-declaration Generator

Db2diag-db2diag. log Analysis Tool

Db2drdat-DRDA tracking

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 the definition of the event monitor target table

Db2exfmt-table description

Db2exmig-migration instructions table commands

DB2 basic commands and Knowledge-db2expln-SQL and XQuery description

Db2extsec-set DB2 object permission

Db2flsn-search log number

Db2fm-DB2 Fault Monitor


Related Article

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.