112
Hardware Maintenance Manual: Netfinity 7600 – Type 8665 Models 1RY, 2RY
— Microsoft SQL Server (using the Visigenic driver provided with Microsoft
SQL Server)
or
— IBM DB2
For detailed information about supported ODBC platforms, see Table 18 on page
114 and Table 19 on page 115.
Note:
The ODBC database name must not be longer than 8 characters.
ODBC database configuration
This section describes the procedures you must complete before Netfinity Manager
can create the Netfinity Database Tables using ODBC.
1.
Define the NETFIN ID so the Netfinity Database Administration can create the
Netfinity Database tables with a table qualifier of NETFIN.
Attention:
NETFIN is a restricted user ID. The password is not retained by
Netfinity Database Administration after use. Do not use this ID for
exports.
Notes:
a.In OS/2 and Windows 95, NETFIN must either be the owner of the database or
must be given administrator authority.
b.In Windows NT, when exporting to DB2, NETFIN must either be the owner of
the database or be defined as a system administrator through the NT User
Manager for Domains or the NT User Manager.
In Windows NT, when exporting to MS SQL, NETFIN must be the owner of
the database or be given table create rights.
2.
Create the database with the appropriate relationship with the NETFIN ID.
3.
Make a database ODBC source either using the ODBC tools shipped with the
operating system or the database.
4.
On Windows NT, configure the Netfinity Support Program to export data using
the ODBC database.
a.
Open Services from the Control Panel.
b.
Click Netfinity Support Program from the Services field, then click Startup.
c.
Click Automatic in the Startup Type button group.
d. Click This Account in the Log On As field group. Enter in the This Account
field the user name of the account that made this database an ODBC source.
e.
Click OK.
Note:
If the Event Scheduler or Alert Manager will be used to export data using
ODBC, continue to have the ID which made the database an ODBC source
logged on during the time Event Scheduler will be exporting data.
Creating the Netfinity Manager tables
To create the tables needed to enable Netfinity Manager to export data:
1.
Open the Netfinity Manager Database Administration service.
The Netfinity Manager Database Administration service is found in the Netfinity
Manager folder or Netfinity Manager program group. Double-click this icon to
open the Netfinity Manager Database Administration window.
Summary of Contents for 86655RY - Netfinity 7600 - 8665
Page 1: ...IBM Hardware Maintenance Manual Netfinity 7600 Type 8665 Models 1RY 2RY ...
Page 2: ......
Page 3: ...IBM Hardware Maintenance Manual Netfinity 7600 Type 8665 Models 1RY 2RY ...
Page 10: ...viii Hardware Maintenance Manual Netfinity 7600 Type 8665 Models 1RY 2RY ...
Page 52: ...42 Hardware Maintenance Manual Netfinity 7600 Type 8665 Models 1RY 2RY ...
Page 104: ...94 Hardware Maintenance Manual Netfinity 7600 Type 8665 Models 1RY 2RY ...
Page 148: ...138 Hardware Maintenance Manual Netfinity 7600 Type 8665 Models 1RY 2RY ...
Page 252: ...242 Hardware Maintenance Manual Netfinity 7600 Type 8665 Models 1RY 2RY ...
Page 270: ...260 Hardware Maintenance Manual Netfinity 7600 Type 8665 Models 1RY 2RY ...
Page 271: ...Related service information 261 ...
Page 272: ...262 Hardware Maintenance Manual Netfinity 7600 Type 8665 Models 1RY 2RY ...
Page 273: ...Related service information 263 ...
Page 274: ...264 Hardware Maintenance Manual Netfinity 7600 Type 8665 Models 1RY 2RY ...
Page 284: ...274 Hardware Maintenance Manual Netfinity 7600 Type 8665 Models 1RY 2RY ...
Page 285: ...Related service information 275 ...
Page 292: ...282 Hardware Maintenance Manual Netfinity 7600 Type 8665 Models 1RY 2RY ...
Page 293: ......