Create database on NT

J. Piaser

Create database on NT
I have just installed a DB2 server on my NT workstation :
1/ I first created a NT administrator called "db2admin" with a "db2admin"
password.
2/ I then lauched the DB2 setup with the same default administrator.

After all these actions, the only way I found to create a new database
using the 'create database' statement is
1/ logoff from my personal account
2/ login as db2admin
3/ execute the statement in the DB2 command line editor
A bit frustrating, isn't it ?

My questions are :
1/ I would like to be able to use DB2 command line editor as 'db2admin'
while being logged in NT with my personal account. Any idea of how to
manage ?
2/ Is it possible to alter the wrights of another user so that he can have
the same priviledges that of the administrator ? How can I do that in the
command line editor ?

Thanks answering

regards



Larry Hubbard

Re: Create database on NT
(in response to J. Piaser)
You can get relief in a couple of different ways with the choice being up to
you or your organization's policies.

1. As you ask in question 2, you can go to your passwords and users folder
in the Control Panel and add your userid to the Administrators group.
However, objects created that way will have yourself as owner and your
userid as the schema qualifier.

2. You could simply use the db2admin userid to create the database then give
your own userid DBADM authority. This should allow you to perform most, if
not all of the tasks you need.

3. Finally, you could create an new NT group then set that group as your
SYSADM group in the DBM configuration file.

4. Really finally, you could simply connect to the database with userid of
db2admin and password db2admin, then do whatever you like.

HTH

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On Behalf Of
J. Piaser
Sent: Thursday, January 10, 2002 6:34 AM
To: [login to unmask email]
Subject: Create database on NT


I have just installed a DB2 server on my NT workstation :
1/ I first created a NT administrator called "db2admin" with a "db2admin"
password.
2/ I then lauched the DB2 setup with the same default administrator.

After all these actions, the only way I found to create a new database
using the 'create database' statement is
1/ logoff from my personal account
2/ login as db2admin
3/ execute the statement in the DB2 command line editor
A bit frustrating, isn't it ?

My questions are :
1/ I would like to be able to use DB2 command line editor as 'db2admin'
while being logged in NT with my personal account. Any idea of how to
manage ?
2/ Is it possible to alter the wrights of another user so that he can have
the same priviledges that of the administrator ? How can I do that in the
command line editor ?

Thanks answering

regards