What is the connected database?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gregor Kovač - 15 Mar 2006 13:00 GMT

Hi!

How can I determine the name of a database I'm connected to.
I tried the SNAP_GET_DB, SNAPSHOT_DATABASE, ... but all these return all
databases that are defined as "Indirect" or "Home" in LIST DATABASE
DIRECTORY command. This is not the desired behaviour.

Any ideas?

Best regards,
Kovi

Signature

-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~

| Gregor Kovac | Gregor.Kovac@mikropis.si |

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

| In A World Without Fences Who Needs Gates? |
| Experience Linux. |

-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~

Reply to this Message

Knut Stolze - 15 Mar 2006 13:21 GMT

> Hi!
>
> How can I determine the name of a database I'm connected to.
> I tried the SNAP_GET_DB, SNAPSHOT_DATABASE, ... but all these return all
> databases that are defined as "Indirect" or "Home" in LIST DATABASE
> DIRECTORY command. This is not the desired behaviour.

Query the CURRENT SERVER special register:

$ db2 values current server

1
------------------
TEST

1 record(s) selected.

(All my databases are named "TEST" ;-))

Signature

Knut Stolze
DB2 Information Integration Development
IBM Germany

Reply to this Message

Gregor Kovač - 15 Mar 2006 15:03 GMT

>> Hi!
>>
[quoted text clipped - 14 lines]
>
> (All my databases are named "TEST" ;-))

Yes!! Thanks...

What other special registers are there ? :)

Signature

-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~

| Gregor Kovac | Gregor.Kovac@mikropis.si |

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

| In A World Without Fences Who Needs Gates? |
| Experience Linux. |

-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~