Basic DB2 commands and knowledge, dedicated for beginners (1)

As a newcomer to the DB2 database, I am very interested in the basic commands and knowledge of DB2. Some experts have answered this question when I started the DB2 database course, the editor has organized it to help other friends learn and grasp it. The following describes the specific solution and hopes it will help you in your future study.

Basic DB2 commands and Knowledge-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

DB2 basic commands and knowledge: 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

Db2fs-Step 1

Db2gcf-control DB2 instances

Db2gov-DB2 Controller

Db2govlg-DB2 controller log query

Db2gpmap-Get distribution chart

Db2hc-start the health center

Db2iauto-automatically start the instance

Db2iclus-Microsoft Cluster Server

Db2icrt-create an instance