I am connected to a db2 database ver 8.1 on AIX 5.1 server using my personal id 'udbuser'. I want to 'su' to different user 'batchuser' to run some db2 commands and execute few scripts using command center. How do I accomplish this?

I can very well do this using telnet. but want to do same using command center.

Thanks,
toby

Hi - try this:


connect reset;

connect to <yourdb> user <youruser> using <yourpassword>;


But remeber that you can only be connected as one user at the time.

Hope this helps

Is there any other way to do this in control center other than connect database command.

and you must confirm the user 'batchuser' have the proper right in the database .

No I don't think there is any other way.

But isn't connect reset/connect adequate?

Cheers