In order to set entries in the HKLM part of the registry (DB2SET), you need
the rights to be able to do just that. Administrators have these by default,
normal users do not. The security settings can be changed, but this is
normally not very wise.
I do not know how you define the very generic "DBA tasks", and therefore
cannot answer the question. If you mean "install DB2" and such like, then
yes, you'll need administrative rights. I suggest you read up on Windows
security.
<ne*****@hotmail.com> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...
Thanks Mark.
Would this imply that in oder to perform DBA tasks on Windows platform,
the account must have at least local admin rights?
Mark Yudkin wrote: <ne*****@hotmail.com> wrote in message
news:11**********************@g43g2000cwa.googlegr oups.com... > Dear all,
>
> On W2K DB2 V8.2.2, is it possible to execute DB2SET command using an
> account that is neither a member of LOCAL nor DOMAIN Admin group?
No. This is not permitted, as you don't have the rights.
>
> I have created a non-admin domain account to log in the machine and
> include it to a group that is assigned to SYSADM_GROUP. It can do all
> sort of things except that it returns SQL1092N when executing DB2SET
> command.
>
> We run in a Domain Controller environment.
>
> Many thanks!
>