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 52.
Cataloging the database in the managing system
If the manager is using a remote database, catalog 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.”
1. Start a DB2 command window.
2. Type
DB2 DROP DATABASE
databasename
where
databasename is the name of the database as specified during the
database installation.
3. Press Enter.
Deleting the database on OS/2
1. Insert the
Netfinity Manager CD-ROM into the database server CD-ROM drive
(in this example, the CD-ROM drive is E).
2. Start an OS/2 window or full-screen session.
3. Make the CD-ROM drive the active drive.
Chapter 9. Netfinity Manager database support
49
Summary of Contents for NETFINITY 4000R
Page 1: ...IBM IBM Netfinity 4000R User s Handbook...
Page 2: ......
Page 3: ...IBM IBM Netfinity 4000R User s Handbook...
Page 12: ...2 Netfinity 4000R User s Handbook...
Page 32: ...22 Netfinity 4000R User s Handbook...
Page 38: ...28 Netfinity 4000R User s Handbook...
Page 48: ...38 Netfinity 4000R User s Handbook...
Page 76: ...66 Netfinity 4000R User s Handbook...
Page 81: ...Section 3 Appendixes Copyright IBM Corp 1999 71...
Page 82: ...72 Netfinity 4000R User s Handbook...
Page 86: ...76 Netfinity 4000R User s Handbook...
Page 88: ...78 Netfinity 4000R User s Handbook...
Page 98: ...88 Netfinity 4000R User s Handbook...
Page 102: ...IBM Part Number 00N9106 Printed in U S A N91 6...