Appendix A. Useful DB2 Commands


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.



Advanced DBA Certification Guide and Reference for DB2 UDB v8 for Linux, Unix and Windows
Advanced DBA Certification Guide and Reference for DB2 Universal Database v8 for Linux, UNIX, and Windows
ISBN: 0130463884
EAN: 2147483647
Year: 2003
Pages: 121

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net