From a DB2 command line window, you can issue the command:
db2 get dbm cfg | more
You may find that SYSADM_GROUP, SYSCTRL_GROUP, and
SYSMAINT_GROUPS are all blank, or unspecified.
It is a good practice to create operating system groups for
these purposes (eg. PROD_SYSADM, TEST_SYSADM, PROD_SYSCTRL,
Once you have created the OS groups, you can assign users to
these groups. For instance, add your domain account to the
Once you have your OS groups created, you can update the
db2 update dbm cfg using SYSADM_GROUP GROUPNAME
db2 update dbm cfg using SYSCTRL_GROUP GROUPNAME
After updating the DBM CFG, it'd be a good idea to stop and
start the database manager (db2stop, db2start) to ensure the
changes take effect.
Provided that your domain account belongs to the SYSADM_GROUP,
it should now be able to successfully create databases and
whatever else you'd like to do.
As an extra note, try to use groups as much as possible. The
efficient DBA will grant object (table, view, ...) privileges
to groups (eg. ENDUSERS), then add user accounts to the OS
groups. This tends to make security administration much easier.
Also, if you need to take a table offline to users, one revoke
of the group's privileges does the trick.
Hope this helps, and happy new year!
Win the e-Business race with high performance tools from
Dimitris Margaritis <[login to unmask email]> wrote in message
<[login to unmask email]>...
> Hi all
> I have just installed DB2 7.1 on an NT workstation machine.
> starts using a local account.
> I log on using mydomain account and when I try to create a
database I got
> message that my account has no priviledges to create
> What I have to do in order domain account obtain sysadm
> add account to Administrators group of Primary domain