The DB2 Universal Database library consists of online help, books (PDF and HTML), and sample programs in HTML format. This section describes the information that is provided, and how you can access it.
To access product information online, you can use the Information Center. For more information, see Accessing Information with the Information Center. You can view task information, DB2 books, troubleshooting information, sample programs, and DB2 information on the Web.
The following table divides the DB2 books into four categories:
The installation manuals, release notes, and tutorials are viewable in HTML directly from the product CD-ROM. Most books are available in HTML on the product CD-ROM for viewing and in Adobe Acrobat (PDF) format on the DB2 publications CD-ROM for viewing and printing. You can also order a printed copy from IBM; see Ordering the Printed Books. The following table lists books that can be ordered.
On OS/2 and Windows platforms, you can install the HTML files under the sqllib\doc\html directory. DB2 information is translated into different languages; however, all the information is not translated into every language. Whenever information is not available in a specific language, the English information is provided
On UNIX platforms, you can install multiple language versions of the HTML files under the doc/%L/html directories, where %L represents the locale. For more information, refer to the appropriate Quick Beginnings book.
You can obtain DB2 books and access information in a variety of ways:
Notes:
| Language | Identifier |
|
|
| Brazilian Portuguese | b |
|
|
| Bulgarian | u |
|
|
| Czech | x |
|
|
| Danish | d |
|
|
| Dutch | q |
|
|
| English | e |
|
|
| Finnish | y |
|
|
| French | f |
|
|
| German | g |
|
|
| Greek | a |
|
|
| Hungarian | h |
|
|
| Italian | i |
|
|
| Japanese | j |
|
|
| Korean | k |
|
|
| Norwegian | n |
|
|
| Polish | p |
|
|
| Portuguese | v |
|
|
| Russian | r |
|
|
| Simp. Chinese | c |
|
|
| Slovenian | l |
|
|
| Spanish | z |
|
|
| Swedish | s |
|
|
| Trad. Chinese | t |
|
|
| Turkish | m |
|
|
If you prefer to have printed copies of the books, you can print the PDF files found on the DB2 publications CD-ROM. Using the Adobe Acrobat Reader, you can print either the entire book or a specific range of pages. For the file name of each book in the library, see Table 144.
You can obtain the latest version of the Adobe Acrobat Reader from the Adobe Web site at http://www.adobe.com.
The PDF files are included on the DB2 publications CD-ROM with a file extension of PDF. To access the PDF files:
x:\doc\language directory, where x represents the CD-ROM drive and language represent the two-character country code that represents your language (for example, EN for English).
/cdrom/doc/%L directory on the CD-ROM, where /cdrom represents the mount point of the CD-ROM and %L represents the name of the desired locale.
You can also copy the PDF files from the CD-ROM to a local or network drive and read them from there.
You can order the printed DB2 books either individually or as a set (in North America only) by using a sold bill of forms (SBOF) number. To order books, contact your IBM authorized dealer or marketing representative, or phone 1-800-879-2755 in the United States or 1-800-IBM-4YOU in Canada. You can also order the books from the Publications Web page at http://www.elink.ibmlink.ibm.com/pbl/pbl.
Two sets of books are available. SBOF-8935 provides reference and
usage information for the DB2 Warehouse Manager. SBOF-8931 provides
reference and usage information for all other DB2 Universal Database products
and features. The contents of each SBOF are listed in the following
table:
Table 145. Ordering the printed books
| SBOF Number | Books Included | |
|---|---|---|
| SBOF-8931 |
|
|
| SBOF-8935 |
|
|
Online help is available with all DB2 components. The following
table describes the various types of help.
| 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 represents 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. | ||
|
Client Configuration Assistant Help
Command Center Help
Control Center Help
Data Warehouse Center Help
Event Analyzer Help
Information Catalog Manager Help
Satellite Administration Center Help
Script Center Help
| Explains the tasks you can perform in a window or notebook. The help includes overview and prerequisite information you need to know, and it describes how to use the window or notebook controls. | From a window or notebook, click 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 represents 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 represents 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 represents 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 represents a valid five-digit SQL state and class code represents the 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. |
The books included with this product are in Hypertext Markup Language (HTML) softcopy format. Softcopy format enables you to search or browse the information and provides hypertext links to related information. It also makes it easier to share the library across your site.
You can view the online books or sample programs with any browser that conforms to HTML Version 3.2 specifications.
To view online books or sample programs:
INSTHOME/sqllib/doc/%L/html/index.htm
where %L represents the locale name.
sqllib\doc\html\index.htm
The path is located on the drive where DB2 is installed.
If you have not installed the Information Center, you can open the page by double-clicking the DB2 Information icon. Depending on the system you are using, the icon is in the main product folder or the Windows Start menu.
If you do not already have a Web browser installed, you can install Netscape from the Netscape CD-ROM found in the product boxes. For detailed instructions on how to install it, perform the following:
The Information Center provides quick access to DB2 product information. The Information Center is available on all platforms on which the DB2 administration tools are available.
You can open the Information Center by double-clicking the Information Center icon. Depending on the system you are using, the icon is in the Information folder in the main product folder or the Windows Start menu.
You can also access the Information Center by using the toolbar and the Help menu on the DB2 Windows platform.
The Information Center provides six types of information. Click the appropriate tab to look at the topics provided for that type.
When you select an item in one of the lists, the Information Center launches a viewer to display the information. The viewer might be the system help viewer, an editor, or a Web browser, depending on the kind of information you select.
The Information Center provides a find feature, so you can look for a specific topic without browsing the lists.
For a full text search, follow the hypertext link in the Information Center to the Search DB2 Online Information search form.
The HTML search server is usually started automatically. If a search in the HTML information does not work, you may have to start the search server using one of the following methods:
Refer to the release notes if you experience any other problems when searching the HTML information.
| Note: | The Search function is not available in the Linux, PTX, and Silicon Graphics IRIX environments. |
Wizards help you complete specific administration tasks by taking you through each task one step at a time. Wizards are available through the Control Center and the Client Configuration Assistant. The following table lists the wizards and describes their purpose.
| Note: | The Create Database, Create Index, Configure Multisite Update, and Performance Configuration wizards are available for the partitioned database environment. |
By default, the DB2 information is installed on your local system. This means that each person who needs access to the DB2 information must install the same files. To have the DB2 information stored in a single location, perform the following steps:
For information about how you can serve the DB2 Universal Database online documentation files from a central machine, refer to the NetQuestion Appendix in the Installation and Configuration Supplement.
To find information in the HTML files, use one of the following methods: