IBM Books

Administration Guide


Online Help

Online help is available with all DB2 components. The following table describes the various types of help. You can also access DB2 information through the Information Center. For information see "Information Center".
Type of Help Contents How to Access...
Command Help Explains the syntax of commands in the command line processor. From the command line processor in interactive mode, enter:

? command

where command is a keyword or the entire command.

For example, ? catalog displays help for all the CATALOG commands, while ? catalog database displays help for the CATALOG DATABASE command.

Control Center Help Explains the tasks you can perform in a window or notebook. The help includes prerequisite information you need to know, and describes how to use the window or notebook controls. From a window or notebook, click on the Help push button or press the F1 key.
Message Help Describes the cause of a message, and any action you should take. From the command line processor in interactive mode, enter:

? XXXnnnnn

where XXXnnnnn is a valid message identifier.

For example, ? SQL30081 displays help about the SQL30081 message.

To view message help one screen at a time, enter:

? XXXnnnnn | more

To save message help in a file, enter:

? XXXnnnnn > filename.ext

where filename.ext is the file where you want to save the message help.

SQL Help Explains the syntax of SQL statements. From the command line processor in interactive mode, enter:

help statement

where statement is an SQL statement.

For example, help SELECT displays help about the SELECT statement.

SQLSTATE Help Explains SQL states and class codes. From the command line processor in interactive mode, enter:

? sqlstate or ? class-code

where sqlstate is a valid five-digit SQL state and the class-code is first two digits of the SQL state.

For example, ? 08003 displays help for the 08003 SQL state, while ? 08 displays help for the 08 class code.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]