User manual IBM NETFINITY 4000R

[. . . ] M B I IBM® Netfinity® 4000R User's Handbook IBM IBM® Netfinity® 4000R User's Handbook Note Before using this information and the product it supports, be sure to read the general information under Appendix C, "Product warranties and notices" on page 79. First Edition (September 1999) The following paragraph does not apply to the United Kingdom or any country where such provisions are inconsistent with local law: INTERNATIONAL BUSINESS MACHINES CORPORATION PROVIDES THIS PUBLICATION "AS IS" WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE. Some states do not allow disclaimer of express or implied warranties in certain transactions, therefore, this statement may not apply to you. This publication could include technical inaccuracies or typographical errors. Changes are periodically made to the information herein; these changes will be incorporated in new editions of the publication. [. . . ] If support for ODBC database export is being installed, see "ODBC database support" on page 52. DB2 database support Support for DB2 database export is automatically configured during installation of the Netfinity Manager. A raw data dump to a file is also available and will run without a database. System requirements The minimum requirements for Netfinity Manager database export are: Netfinity Manager for OS/2: ­ DB2 Client Version (refer to Table 2 on page 55) ­ DB2 Version (refer to Table 2 on page 55) Netfinity Manager for Windows 95: ­ DB2 Client for Windows 95 (refer to Table 2 on page 55) ­ DB2 Version (refer to Table 2 on page 55) © Copyright IBM Corp. 1999 45 Netfinity Manager for Windows NT: ­ DB2 Client for Windows NT (refer to Table 2 on page 55) ­ DB2 Version (refer to Table 2 on page 55) Attention: Using Netfinity Manager database support with systems running unsupported versions of DB2 or the DB2 Client might cause unpredictable results and might halt the system. See the DB2 Installation Guide for general requirements and supported protocols. Installing and configuring the database The following information describes the steps to install and configure the DB2 database. Note: If your primary system is OS/2, refer to "Installing the database on OS/2. " 1. Note: If it's not already running, start the DB2 database manager. Type the following command: DB2 CREATE databasename ON d where databasename is the name of the database d is the drive where the database is created 3. Next, you must configure the tables for ODBC database support so the tables can be configured. For information on configuring the database for ODBC, refer to, "ODBC database configuration" on page 52. For information on creating the tables, refer to, "Creating the Netfinity tables" on page 53. For information on binding the database, refer to, "Activating the database" on page 47. Installing the database on OS/2 Note: OS/2 is not supported on the IBM Netfinity 4000R. Insert the Netfinity Manager CD into the CD-ROM drive (in this example, drive D; individual drive letters might be different). Type the following command at the OS/2 prompt: NETFINDB CREATE /DBNAME=databasename /DRIVE=d where databasename is the name of the database and d is the drive where the database will be located. Note: If any part of the database already exists, the utility program will create only the portions of the database that are missing. 46 Netfinity® 4000R User's Handbook 5. Press Enter. Activating the database The following information describes how to connect, bind, and grant privileges to the database. Type the following command: DB2 CONNECT TO databasename where databasename is the name of the database as specified in the database installation step. Bind the package and the database To prepare SQL statements stored in the bind file and store the package in the database, perform the following steps from a system on which Netfinity Manager for OS/2, Netfinity Manager for Windows 95, or Netfinity Manager for Windows NT has been installed: a. In the DB2 command window, type the following command: DB2 BIND x:\directory\DB2SQLC0. bnd where x:\directory is the name of the drive and directory where Netfinity Manager is installed. Press Enter. Granting and revoking database privileges The following information describes how to grant and revoke database privileges. Note: If your primary system is OS/2, refer to "Database privileges on OS/2 systems" on page 48. If you are not connected to the DB2 Netfinity database now connect to the database. Type the following command: DB2 GRANT privilegecode ON TABLE tablename TO userid where privilegecode is one of the following privilege codes: ­ ALL ­ ALL PRIVILEGES Note: Grants all the appropriate privileges, except CONTROL, on the database. [. . . ] However, software from other companies might come with this IBM PC product. You should contact the software developers directly if you wish to verify readiness, understand limitations, or look for any software updates. To learn more about IBM PC products and the Year 2000, visit our Web site at http://www. ibm. com/pc/year2000. The information and tools there can help you with your Year 2000 transition plan, especially if you have multiple IBM PCs. [. . . ]