IBM 866631Y Hardware Maintenance Manual - Page 98

Installing the database on OS/2, Activating the database

Page 98 highlights

Note: If your primary system is OS/2, refer to "Installing the database on OS/2". 1. Start a DB2 command window. Note: If it's not already running, start the DB2 database manager. 2. Type the following command: DB2 CREATE databasename ON d where v databasename is the name of the database v d is the drive where the database is created 3. Press Enter. 4. Next, you must configure the tables for ODBC database support so the tables can be configured. For information on configuring the database for ODBC, refer to "ODBC database configuration" on page 93. For information on creating the tables, refer to "Creating the Netfinity Manager tables" on page 94. 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: 88 Hardware Maintenance Manual: Netfinity 7100 - Type 8666

  • 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

Note:
If your primary system is OS/2, refer to “Installing the database on OS/2”.
1.
Start a DB2 command window.
Note:
If it’s not already running, start the DB2 database manager.
2.
Type the following command:
DB2 CREATE
databasename
ON
d
where
v
databasename
is the name of the database
v
d
is the drive where the database is created
3.
Press Enter.
4.
Next, you must configure the tables for ODBC database support so the tables
can be configured. For information on configuring the database for ODBC, refer
to “ODBC database configuration” on page 93. For information on creating the
tables, refer to “Creating the Netfinity Manager tables” on page 94.
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:
88
Hardware Maintenance Manual: Netfinity 7100 – Type 8666