2 replies Latest Post - ‏2012-07-13T14:38:26Z by Leo_52
69 Posts

Pinned topic DB2ADMNS and DB2USERS groups

‏2012-07-06T07:36:07Z |
To whom this may concern

Ever since DB2 Express-C Version 9.n the groups DB2ADMNS and DB2USERS are no longer created during setup. Is this by design? These groups are actually being referred to during setup under Windows!

I had to create these groups manually, because one runs into numerous problems if these groups don't exist.

Leo Elsenberg
Business data processing specialist
Updated on 2012-07-13T14:38:26Z at 2012-07-13T14:38:26Z by Leo_52
  • SystemAdmin
    5837 Posts

    Re: DB2ADMNS and DB2USERS groups

    ‏2012-07-13T07:10:35Z  in response to Leo_52
    Hello Leo,

    I have not used DB2 on Windows for a while, but I believe these groups are created if, during setup, you choose some kind of Security scheme (DB2 Security vs System Security ???) which is not the default one...

    Hope this helps...
    Yves-Antoine Emmanuelli
    • Leo_52
      69 Posts

      Re: DB2ADMNS and DB2USERS groups

      ‏2012-07-13T14:38:26Z  in response to SystemAdmin
      Hello Yves-Antoine,

      Thank you for your comment.

      Up to and including version 9.5 this was true, but since version 9.7 the DB2ADMNS and DB2USERS groups are no longer being referred to during setup (one can't select these groups) and, quite consequently, they are not created. The absence of these groups creates all sorts of problems! Other user accounts on the machine (where DB2 has been setup) and users in the local network can't read or modify data – even a simple SQL query fails. After creating these groups manually and adding users to the corresponding groups everything works as expected again! What's the logic behind this? Is IBM trying to confuse us again?

      DB2 Express-C was such a good database management system, but the current DB2 Express-C releases are in such a terrible state that one can't seriously recommend the use/implementation of IBM DB2 anymore! I see many prospective customers moving to Microsoft SQL Server and, if asked for advice, I actually do recommend SQL Server nowadays. Come on, IBM, wake up – you are about to lose revenue! A flag-ship without sails is doomed to sink in stormy weather!

      Kind regards