Database name

esanthosh · #1 (**permalink**) 10-18-05, 09:25

Hi,

I connect to database using connect command from CLP.

db2 connect to db_name

Is there a way i can now find out which database I am connected to ? some variable or command...

Regards,
Santhosh

n_i · #2 (**permalink**) 10-18-05, 10:06

Issuing CONNECT without parameters will show you the local alias, while querying the CURRENT SERVER register variable will give you the remote database name.

przytula · #3 (**permalink**) 10-18-05, 11:44

or db2 get connection state

gardenman · #4 (**permalink**) 10-19-05, 02:09

Try:
values current server

Internet Services

Web Development

Digital Marketing

Consumer Tech