User authorization in DB2

Posted by Daziplqa on Stack Overflow See other posts from Stack Overflow or by Daziplqa
Published on 2010-04-26T05:50:43Z Indexed on 2010/04/26 5:53 UTC
Read the original article Hit count: 201

Filed under:

Hi Folks,

I am using win Vista, and I am trying to backup some Database under DB2.

I am logged in using the Administrator user, and whenever I try to issue the backup command in the "command line processor", I get the following message:

SQL1092N "ADMINISTRATOR" does not have the authority to perform the requested command. SQLSTATE=00000

BTW, I have created a username/password pair (db2admin) while installing the DB2 server. So, Will this problem will be get solved if I use the db2admin user? And how to connect to the server (local server BTW) using the db2admin user ?

© Stack Overflow or respective owner

Related posts about db2