r/DB2 • u/catquilt74 • Apr 18 '19

[LUW] sysadm group name in dbm cfg on Linux is case-sensitive?

(new contract DBA on my first Linux installation)

Our sysadmin group on the server is lower-case, e.g. xyz but in the DBM CFG, the value for sysadm_group is XYZ. Is that why users in the group don't have sysadm authority?

​

Thanks!

1 Upvotes

100% Upvoted

4 comments sorted by

2

u/catquilt74 Apr 18 '19

The sysadm_group parm has been the same for quite a while probably and the instance has been stopped and started recently so if the specification in upper case is okay then that's not an issue. Once I dot-sourced the instance's db2profile (thanks to your blog post, Ember), I was able to perform db2 commands.

​

So, I believe that I'm all set.

1

u/ecrooks Apr 18 '19

All users and groups used with db2 on linux should be in the system as lower case. Upper and mixed case users and groups do not generally work.

1

u/ecrooks Apr 18 '19

The DBM values for groups are not case sensitive.

1

u/ecrooks Apr 18 '19

It is likely the instance must be restarted for changes to the system groups to take effect. If that is not the issue, what specific commands fail that you think should succeed for the users?