4.2. The Command Line Tools

All DB2 operations are invoked by DB2 commands or SQL statements. For example, to back up a database, you use the BACKUP DATABASE command. To create a table, you use the CREATE TABLE SQL statement. All of these commands and SQL statements can be entered using the command line tools.

The command line tools consist of the Command Line Processor (CLP), the Command Window (Windows platform only), and the Command Editor. Since they are command driven, you must have some knowledge of DB2 commands and SQL statements to use them.


In this chapter we use DB2 commands to refer to both types of commands: DB2 system commands and DB2 CLP commands. When a section is only applicable to a given type of command, it will be explicitly ...

Get Understanding DB2®: Learning Visually with Examples now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.