Advanced DBA Certification Guide and Reference for DB2 Universal Database v8 for Linux, UNIX, and Windows

This section provides information about the system commands that can be entered at an operating system command prompt, or in a shell script, to access and maintain the database manager. Appendix A also explains how to invoke and use the command line processor (CLP) and describes CLP options. The CLP is used to execute database utilities, SQL statements, and online help. The CLP offers a variety of command options and can be started in:

• Interactive input mode, characterized by the db2 => input prompt

• Command mode, where each command must be prefixed by db2

• Batch mode, which uses the “f file input option.