Hello,

I'm connected to both a local and a remote DB2 databases in Windows platform. The connection to the local one is as simple as typing
CONNECT TO MyLocalDB
but for the remote one, I always have to provide my user name and password
CONNECT TO MyRemoteDB USER me USING password

I heard that it is possible to avoid typing all the time the user name and password, as for the local databases (setting them as user preferences or letting Windows use its login information to connect the database). Is it possible? How can I do it?

Thanks, Cesar

hi

please change your authentication value for the db2 server from Server to Client, this would ensure that the authentication takes place at the client and not at the server which is default.

Cheers

Nitin.