INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

db2admin cannot run db2start, grant

db2admin cannot run db2start, grant

(OP)
I have to create instances, databases and next HADR clusters.
Environment: Windows 2008 R2 64 bit, DB2 v9.7 ESE FP 3a
Unfortunately I inherited the DB2 installation as trusted from another person only with screen shots (incomplete).
The response file was generated but it was deleted ?!? ... and no other information available ...
I experienced lots of strange things that gave me a lot of trouble.

The DB2 installations were created as Administrator user and db2admin was set as DAS.
There should be at least three instances each with 5 to 6 databases for different middleware applications, WPS, WP, WCM etc
Because of the pressure and the deadline I have rushed and I did not create different users for each instance.
I logged into Windows as Administrator and I created the instances with:

CODE

db2icrt -s ese -u db2admin

Databases should be created as db2admin - the applications should connect to DB2 as db2admin with JDBC.
I could not create them using db2admin but using Administrator and I cannot run db2stop/db2start as db2admin!
I set up the SYSADM_GROUP as Administrators.
I added db2admin to Administrators group as well.
db2admin could not be used to run functions, could not grant anything... (despite that db2admin is member of Administrators as SYSADM_GROUP)
When I launched CC for example I saw the instances appearing as different hostnames in left panel!
I fixed the grant issue - as Administrator I gave grants to db2admin.
Finally the applications could connect to databases.
I still have a problem with db2stop/db2start:

CODE

DB21009E  This command must be launched from a command window running with full administrative privileges.
SQL1092N  "DB2ADMIN" does not have the authority to perform the requested command or operation.

I has just discovered that:
DB2 v9.7 was installed without enabed OS security. (DB2ADMNS group was not created)
FP 3a was installed with enabled OS security!
Everything worked just fine when I was logged as Administrator.
I wonder if I create manually DB2ADMNS OS group and next add this group to 'DB Groups' for each of the about 20 databases everything would be fine?
I am really concerned about this push-up setup and what is the best solution to try to fix this mess?

Thank you,

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close