Hi All,
We have DB2 v9.5 Fix Pack 5 on AIX 5.3. We created an ID for backup vendor commvault to perform backup/restore but restrict them from data in the user tables. Below is what I have done so far..
created a group 'MAINT'
created an ID 'comvault' and assigned to MAINT group
updated dbm cfg using SYSMAINT MAINT
updated environment variable DB2_ALTERNATE_GROUP_LOOKUP using GETGRSET
recycled db2
When I try to backup the db, I am getting the SQL1092N error.

$ id
uid=76226077(comvault) gid=1(staff) groups=207(MAINT)
$ db2 backup db <dbname> online
SQL1092N "COMVAULT" does not have the authority to perform the requested command.

Any help is greatly appreciated.
Thanks,
Sam.

Sam, there are 5 diff answers to your question. be specific on the error message. better yet, look up message description.

Don't use uppercase group names.

Thanks Nick. Works great.