IBM 6000R Hardware Maintenance Manual - Page 135
Deleting the database, Cataloging the database in the managing, system
UPC - 087944534341
View all IBM 6000R manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 135 highlights
DB2 CONNECT RESET and then press Enter. 3. Use the NETFINDB GRANT command to grant (or revoke) database privileges. To grant or revoke table privileges on OS/2: a. Insert the Netfinity Manager CD into the CD-ROM drive (in this example, drive D; individual drive letters might be different). b. Make the CD-ROM drive the active drive. Type D: and then press Enter. c. Type the following command: NETFINDB GRANT /ID=id PUBLIC /DBNAME=databasename /PRIV=privilegecode where • id is the user ID to be granted access • databasename is the name of the database as specified during NETFINDB execution • privilegecode is one of the following privilege codes: - ALL - ALTER - CONTROL - DELETE - INDEX - INSERT - REFERENCES - SELECT - UPDATE d. Press Enter to execute the command. Note: Use PUBLIC or authorize only a specific ID or group name. Netfinity Manager update programs use the DB2SQLC0 package and do not require specific table privileges. To revoke privileges, substitute REVOKE for GRANT in the command line. To configure Netfinity Manager to discontinue export data through ODBC for use on DB2, refer to "ODBC database support" on page 126. Cataloging the database in the managing system: If the manager is using a remote database, cata- log the node the database resides on and then catalog the database to that node. Once this step has been completed, the name of the Netfinity Manager database will appear in the System Information Tools Database Selection window. Deleting the database The following information describes how to delete the database for all supported operating systems. Note: If your operating system is OS/2, refer to "Deleting the database on OS/2" on page 124. 1. Start a DB2 command window. 2. Type DB2 DROP DATABASE databasename Netfinity Manager 123