System commands

Use these commands to control the operation of your database system.

db2batch - Benchmark tool command
Reads SQL statements and XQuery statements from either a flat file or standard input, dynamically prepares and describes the statements, and returns an answer set.
db2cli - Db2 interactive CLI command
Starts the interactive call level interface (CLI) environment for design and prototyping in CLI.
db2drdat - DRDA trace command
Allows the user to capture the DRDA data stream exchanged between a DRDA Application Requestor (AR) and the Db2® DRDA Application Server (AS).
db2expln - SQL and XQuery Explain command
The db2expln tool describes the access plan selected for SQL and XQuery statements.
db2level - Show Db2 service level command
Shows the current Version and Service Level of the installed Db2 product. Output from this command goes to the console by default.
db2look - Db2 statistics and DDL extraction tool command
Extracts the Data Definition Language (DDL) statements to reproduce the database objects of a production database on a test database.
db2trc - Trace command
The db2trc command controls the trace facility of a Db2 instance or the Db2 Administration Server (DAS). When the db2trc command runs, the trace facility records information about operations and formats this information into readable form.