IBM 8658 User Guide - Page 108

Activating, database, Granting, revoking, privileges

Get IBM 8658 - Eserver xSeries 230 PDF manuals and user guides
UPC - 087944602644
View all IBM 8658 manuals
Add to My Manuals
Save this manual to your list of manuals

Page 108 highlights

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. Granting and revoking database privileges The following information describes how to grant and revoke database privileges. Note: If your primary system is OS/2, refer to "Database privileges on OS/2 systems" on page 99. 1. Start a DB2 command window. Notes: a. If it is not already running, start the DB2 database manager. b. If you are not connected to the DB2 Netfinity database, connect to the database now. 2. Type the following command: DB2 GRANT privilegecode ON TABLE tablename TO userid 98 : Netfinity 5100 Type 8658 Models 11Y, 21Y, 31Y, 41Y, 51Y, 1RY, 2RY, 3RY, 4RY, 5RY

  • 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
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.
Granting
and
revoking
database
privileges
The
following
information
describes
how
to
grant
and
revoke
database
privileges.
Note:
If
your
primary
system
is
OS/2,
refer
to
“Database
privileges
on
OS/2
systems”
on
page
99.
1.
Start
a
DB2
command
window.
Notes:
a.
If
it
is
not
already
running,
start
the
DB2
database
manager.
b.
If
you
are
not
connected
to
the
DB2
Netfinity
database,
connect
to
the
database
now.
2.
Type
the
following
command:
DB2
GRANT
privilegecode
ON
TABLE
tablename
TO
userid
98
:
Netfinity
5100
Type
8658
Models
11Y,
21Y,
31Y,
41Y,
51Y,
1RY,
2RY,
3RY,
4RY,
5RY