DB2 commands

Use the DB2® for z/OS® and related commands to execute database administrative functions.

These topics provide detailed reference information for DB2 and related commands, including the environment in which each command is issued, the privileges and authorities that are required to issue each command, syntax and option descriptions, usage information, and examples.

Syntax diagrams for commands

For information about the conventions for syntax diagrams in IBM® documentation, see How to read syntax diagrams.

Privileges and authorization IDs for DB2 commands
A command can be issued by an individual user, by a program that runs in batch mode, or by an IMS™ or CICS® transaction. The term process describes any of these initiators.
Types of commands
DB2 supports several different types of commands that you can use to complete database administration tasks.
Syntax rules for DB2 commands
Standard syntax rules apply to DB2 commands.
Syntax rules for DSN subcommands
The syntax rules for DSN subcommands conform to standard TSO command parsing conventions.
Scope of commands in data sharing
In a data sharing environment, the scope of a command is the breadth of its impact.
Output from DB2 commands
Several factors affect the amount of output you can receive from a DB2 command.
Command line processor
The command line processor is a program that runs under z/OS UNIX System Services. You can use the command line processor to execute SQL statements, bind DBRMs that are stored in HFS files into packages, call stored procedures, and perform XML schema repository operations.
DB2 command text is recorded in the DB2 recovery log
All DB2 commands issued after DB2 restart and before DB2 shutdown are logged by DB2.
DB2 and related commands
The references topics for commands contain syntax diagrams, semantic descriptions, rules, and usage examples of commands. They are organized alphabetically by command name.

Related information

DB2 and related commands