IBM 6000R Hardware Maintenance Manual - Page 133

Activating the database, Installing the database on OS/2

Get IBM 6000R - Netfinity - 8682 PDF manuals and user guides
UPC - 087944534341
View all IBM 6000R manuals
Add to My Manuals
Save this manual to your list of manuals

Page 133 highlights

DB2 CREATE databasename ON d where • databasename is the name of the database • d is the drive where the database is created 3. Press Enter. 4. Next, you must configure the tables for ODBC database support. For information on configuring the database for ODBC, refer to "ODBC database configuration" on page 127. For information on creating the tables, refer to "Creating the Netfinity Manager tables" on page 127. 5. Finally, you must bind the database. For information on binding the database, refer to "Activating the database". Installing the database on OS/2: 1. Insert the Netfinity Manager CD into the CD-ROM drive (in this example, drive D; individual drive letters might be different). 2. Start an OS/2 window or full-screen session. 3. Make the CD-ROM drive the active drive. Type D: and then press Enter. 4. 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. 5. Press Enter. Activating the database The following information describes how to connect, bind, and grant privileges to the database. 1. Connecting to the Database a. Start a DB2 command window. b. Type the following command: DB2 CONNECT TO databasename where databasename is the name of the database as specified in the database installation step. c. Press Enter. 2. 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. Open a DB2 command window. b. 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. c. Press Enter. Netfinity Manager 121

  • 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
121
DB2 CREATE
databasename
ON
d
where
•
databasename
is the name of the database
•
d
is the drive where the database is created
3.
Press Enter.
4.
Next, you must configure the tables for ODBC data-
base support. For information on configuring the data-
base for ODBC, refer to “ODBC database
configuration” on page 127. For information on creating
the tables, refer to “Creating the Netfinity Manager
tables” on page 127.
5.
Finally, you must bind the database.
For information on
binding the database, refer to “Activating the data-
base”.
Installing the database on OS/2:
1.
Insert the Netfinity Manager CD into the CD-ROM drive
(in this example, drive D; individual drive letters might
be different).
2.
Start an OS/2 window or full-screen session.
3.
Make the CD-ROM drive the active drive.
Type
D:
and then press Enter.
4.
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.
5.
Press Enter.
Activating the database
The following information describes how to connect, bind,
and grant privileges to the database.
1.
Connecting to the Database
a.
Start a DB2 command window.
b.
Type the following command:
DB2 CONNECT TO
databasename
where
databasename
is the name of the database
as specified in the database installation step.
c.
Press Enter.
2.
Bind the package and the database
To prepare SQL statements stored in the bind file and
store the package in the database, perform the follow-
ing 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.
Open a DB2 command window.
b.
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.
c.
Press Enter.