Results 1 to 4 of 4

Thread: Database name

  1. #1
    Join Date
    Oct 2005
    Posts
    8

    Unanswered: Database name

    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

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Issuing CONNECT without parameters will show you the local alias, while querying the CURRENT SERVER register variable will give you the remote database name.

  3. #3
    Join Date
    Nov 2004
    Posts
    374

    dbname

    or db2 get connection state
    Best Regards, Guy Przytula
    DB2/ORA/SQL Services
    DB2 DBA & Advanced DBA Certified
    DB2 Dprop Certified
    http://users.skynet.be/przytula/dbss.html

  4. #4
    Join Date
    Apr 2004
    Posts
    54
    Try:
    values current server

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •