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.
Business data processing specialist
SystemAdmin 110000D4XK5837 Posts
Re: DB2ADMNS and DB2USERS groups2012-07-13T07:10:35ZThis is the accepted answer. This is the accepted answer.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...
Leo_52 060000XSAJ70 Posts
Re: DB2ADMNS and DB2USERS groups2012-07-13T14:38:26ZThis is the accepted answer. This is the accepted answer.
- SystemAdmin 110000D4XK
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!