I am running DB2 v8.2.9 and AIX 5.3, I have a user, who is DBADM in a database, that is trying to issue the command "db2 get snapshots for locks on db ... " and he is getting SQL error due to lack of authorization.

He was able to perform this, using a shell script, in our old environment which was DB2 v7.1.0 / AIX 4.3 under a different user id. So in the new environment I granted his user id exactly the same as the old one, but he still has problems. I tried to find in DB2 manuals the level of authorization necessary for get snapshot command but I couldn't find anything there. Since I am DBA (SYSADM) I don't problems with authorization.

What can I do?

Thanks

Don't know what kind of DB2 manuals you were looking at. Mine says