IBM VERSION 9 Manuel D’Utilisation

account

 

is

 

defined,

 

adding

 

a

 

domain

 

user

 

to

 

the

 

local

 

Administrators

 

group

 

on

 

the

 

server

 

does

 

not

 

grant

 

the

 

domain

 

user

 

SYSADM

 

authority

 

to

 

this

 

group.

 

To

 

avoid

 

adding

 

a

 

domain

 

user

 

to

 

the

 

Administrators

 

group

 

at

 

the

 

domain

 

controller,

 

create

 

a

 

global

 

group

 

and

 

add

 

the

 

domain

 

users

 

to

 

which

 

you

 

want

 

to

 

grant

 

SYSADM

 

authority

 

to

 

it.

 

Then

 

update

 

the

 

DB2

 

configuration

 

parameter

 

SYSADM_GROUP

 

with

 

the

 

name

 

of

 

the

 

global

 

group.

 

To

 

update

 

the

 

DB2

 

configuration

 

parameter,

 

enter

 

the

 

following

 

commands:

 

   

db2

 

update

 

dbm

 

cfg

 

using

 

sysadm_group

 

global_group

 

   

db2stop

 

   

db2start

 

 

 

  

v

   

“System

 

administration

 

authority

 

(SYSADM)”

 

in

 

 

 

 

 

  

v

   

“sysadm_group

 

-

 

System

 

administration

 

authority

 

group

 

name

 

configuration

 

parameter”

 

in

 

 

 

 

 

 

 

 

If

 

you

 

plan

 

to

 

use

 

the

 

Lightweight

 

Directory

 

Access

 

Protocol

 

(LDAP)

 

directory

 

server

 

feature

 

with

 

Windows

 

2000

 

or

 

Windows

 

Server

 

2003,

 

you

 

should

 

extend

 

the

 

Active

 

Directory

 

schema

 

to

 

contain

 

DB2

 

object

 

classes

 

and

 

attribute

 

definitions.

 

You

 

should

 

perform

 

this

 

task

 

before

 

you

 

install

 

any

 

DB2

 

products.

 

Extending

 

the

 

directory

 

schema

 

ensures

 

that:

 

v

   

The

 

default

 

DB2

 

instance,

 

created

 

during

 

the

 

installation,

 

is

 

cataloged

 

as

 

a

 

DB2

 

node

 

in

 

Active

 

Directory

 

provided

 

the

 

installation

 

user

 

ID

 

had

 

sufficient

 

privileges

 

to

 

write

 

to

 

Active

 

Directory.

 

v

   

Any

 

databases

 

that

 

the

 

user

 

creates

 

after

 

installation

 

will

 

automatically

 

be

 

cataloged

 

into

 

Active

 

Directory.

If

 

you

 

decide

 

to

 

install

 

your

 

DB2

 

product

 

and

 

create

 

databases

 

before

 

you

 

extend

 

the

 

directory

 

schema,

 

you

 

will

 

have

 

to

 

manually

 

register

 

the

 

node

 

and

 

catalog

 

the

 

databases.

 

 

  

 

Your

 

Windows

 

user

 

account

 

must

 

have

 

Schema

 

Administration

 

authority.

 

 

  

 

To

 

extend

 

the

 

directory

 

schema:

 

1.

   

Log

 

onto

 

the

 

domain

 

controller.

 

2.

   

Run

 

the

 

 

program

 

from

 

the

 

installation

 

CD

 

with

 

a

 

user

 

account

 

that

 

has

 

Schema

 

Administration

 

authority.

 

You

 

can

 

run

 

this

 

program

 

without

 

logging

 

off

 

and

 

logging

 

on

 

again,

 

as

 

follows:

 

   

runas

 

/user:MyDomain\Administrator

 

x:\db2\Windows\utilities\db2schex.exe

 

where

 

x:

 

represents

 

the

 

CD

 

drive

 

letter.

 

 

 

Getting

 

started

 

with

 

DB2

 

installation

 

and

 

administration