IBM 6000R Hardware Maintenance Manual - Page 139

ODBC database configuration, Creating the Netfinity Manager tables, Attention, Notes, Services

Page 139 highlights

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. Netfinity Manager 127

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
  • 77
  • 78
  • 79
  • 80
  • 81
  • 82
  • 83
  • 84
  • 85
  • 86
  • 87
  • 88
  • 89
  • 90
  • 91
  • 92
  • 93
  • 94
  • 95
  • 96
  • 97
  • 98
  • 99
  • 100
  • 101
  • 102
  • 103
  • 104
  • 105
  • 106
  • 107
  • 108
  • 109
  • 110
  • 111
  • 112
  • 113
  • 114
  • 115
  • 116
  • 117
  • 118
  • 119
  • 120
  • 121
  • 122
  • 123
  • 124
  • 125
  • 126
  • 127
  • 128
  • 129
  • 130
  • 131
  • 132
  • 133
  • 134
  • 135
  • 136
  • 137
  • 138
  • 139
  • 140
  • 141
  • 142
  • 143
  • 144
  • 145
  • 146
  • 147
  • 148
  • 149
  • 150
  • 151
  • 152
  • 153
  • 154
  • 155
  • 156
  • 157
  • 158
  • 159
  • 160
  • 161
  • 162
  • 163
  • 164
  • 165
  • 166
  • 167
  • 168
  • 169
  • 170
  • 171
  • 172
  • 173
  • 174
  • 175
  • 176
  • 177
  • 178
  • 179
  • 180
  • 181
  • 182
  • 183
  • 184
  • 185
  • 186
  • 187
  • 188
  • 189
  • 190
  • 191
  • 192
  • 193
  • 194
  • 195
  • 196
  • 197
  • 198
  • 199
  • 200
  • 201
  • 202
  • 203
  • 204
  • 205
  • 206
  • 207
  • 208
  • 209
  • 210
  • 211
  • 212
  • 213
  • 214
  • 215
  • 216
  • 217
  • 218
  • 219
  • 220
  • 221
  • 222
  • 223
  • 224
  • 225
  • 226
  • 227
  • 228
  • 229
  • 230
  • 231
  • 232
  • 233
  • 234
  • 235
  • 236
  • 237
  • 238
  • 239
  • 240
  • 241
  • 242
  • 243
  • 244
  • 245
  • 246
  • 247
  • 248
  • 249
  • 250
  • 251
  • 252

Netfinity Manager
127
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 Man-
ager.
In Windows NT, when exporting to MS SQL, NET-
FIN 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 data-
base.
4.
On Windows NT, configure the Netfinity Support Pro-
gram to export data using the ODBC database.
a.
Open
Services
from the Control Panel.
b.
Click
Netfinity Support Program
from the
Ser-
vices
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.