DB get Current DB Name

Question

I need to write a SQL Script in DB2 and I have to make a constraint in order for this SQL to run only on some specific DBs.

I looked online for solutions but I did not find any.

Does anybody know a way to get the name of the current connected DB?

data_henrik · Accepted Answer · 2017-01-16 12:12:41Z

4

Try this:

Select CURRENT_SERVER from sysibm.sysdummy1

The database name can be retrieved via the special register CURRENT_SERVER.

answered Jan 16, 2017 at 12:12

data_henrik

17.3k2 gold badges33 silver badges56 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Alex Over a year ago

Hi data_henrik, your SQL seems to work. I only wonder if it will bring back the accurate Name on other DB. I also found the DB_Name Column in SYSIBMADM->APPLICATIONS->DB_NAME meanwhile. Thank you! I will mark your answer as useful :).

Alex Over a year ago

My feedback will be recorded and it'll be displayed soon. Thank you once again :)

mstram Over a year ago

CURRENT_SERVER throws an error in DB2 v9. (z/os) CURRENT SERVER works though

Collectives™ on Stack Overflow

DB get Current DB Name

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related