Troubleshooting Guide

Conventions

You will find this book easier to use if you look for these conventions:

• Information is provided for all platforms currently supported by DB2. Unless information is identified as being particular to one or more platforms, it is applicable to all.
• The panels, screens, and menus shown are only examples and may not exactly match what you see on your workstation.
• The format for date and time, and the characters used as separators for date and time, are intended for a system that is configured to use the United States national language format. These may be different on your display, depending on the national language format used by your system.
• This book uses the following highlighting conventions:
  • Boldface type indicates the name of an item on your screen; for example, a field, folder, icon, or menu. It is also used to indicate a command name, a utility name, and to emphasize important words or phrases.
  • Monospace type indicates an example or a command as you should type it.
  • Italic type is used for book titles and configuration variables. When used in command strings, it indicates a variable value that you should replace with your value.

How to Read the Syntax Diagrams

Throughout this book, syntax is described using syntax diagrams.

Read the syntax diagrams from left to right and top to bottom, following the path of the line.

The >>--- symbol indicates the beginning of a statement.

The ---> symbol indicates that the statement syntax is continued on the next line.

The >--- symbol indicates that a statement is continued from the previous line.

The -->< symbol indicates the end of a statement.

Required items appear on the horizontal line (the main path).

>>-STATEMENT--required item------------------------------------><
 

Optional items that are part of the syntax appear below the main path.

>>-STATEMENT----+----------------+-----------------------------><
                '-optional item--'
 

If an optional item appears above the main path, that item has no effect on the execution of the statement and is used only for readability.

                .-optional item--.
>>-STATEMENT----+----------------+-----------------------------><
 

If you can choose from two or more items, they appear in a stack.

If you must choose one of the items, one item of the stack appears on the main path.

>>-STATEMENT----+-required choice1-+---------------------------><
                '-required choice2-'
 

If the statement is complete without any of the items, the entire stack appears below the main path.

>>-STATEMENT----+------------------+---------------------------><
                +-optional choice1-+
                '-optional choice2-'
 

If one of the items is the default, it appears above the main path and the remaining choices are shown below.

                .-default choice--.
>>-STATEMENT----+-----------------+----------------------------><
                +-optional choice-+
                '-optional choice-'
 

An arrow returning to the left, above the main line, indicates an item that can be repeated. In this case, repeated items must be separated by one or more blanks.

                .--------------------.
                V                    |
>>-STATEMENT-------repeatable item---+-------------------------><
 

If the repeat arrow contains a comma, you must separate repeated items with a comma.

                .-,------------------.
                V                    |
>>-STATEMENT-------repeatable item---+-------------------------><
 

A repeat arrow above a stack indicates that you can make more than one choice from the stacked items or repeat a single choice.

Keywords appear in uppercase (for example, FROM). They must be spelled exactly as shown. Variables appear in lowercase (for example, column-name). They represent user-supplied names or values in the syntax.

If punctuation marks, parentheses, arithmetic operators, or other such symbols are shown, you must enter them as part of the syntax.

Placeholder variables, such as path, appear in italics. Replace them with the appropriate value when you key the syntax.

Sometimes a single variable represents a set of several parameters. For example, in the following diagram, the variable parameter-block can be replaced by any of the interpretations of the diagram that is headed parameter-block:

>>-STATEMENT----| parameter-block |----------------------------><
 

 
parameter-block
 
|--+-parameter1-----------------+-------------------------------|
   '-parameter2--+-parameter3-+-'
                 '-parameter4-'
 

Adjacent segments occurring between "large bullets" (*) may be specified in any sequence.

>>-STATEMENT--item1--*--item2--*--item3--*--item4--------------><
 

The above diagram shows that item2 and item3 may be specified in either order. Both of the following are valid:

STATEMENT item1 item2 item3 item4
STATEMENT item1 item3 item2 item4