Hi Colleagues,

Somebody can say me in what system catalog table is save the database name in a instance db2 9.5.

Thank you for you help.

afaik, the db name is not in any system table/view.

you may use db snapshot table function/view to get db name

hth

sathyaram

You can get the name of the (connected) database through SQL.

Andy

it seems to me very strange that not this in tables of the catalogue of the system db2 not this keeping nowhere.
Greetings.

DB2 does know what databases are in its catalog. If you enter "DB2 LIST DB DIRECTORY" or "DB2 LIST DATABASE DIRECTORY", you will see all the databases catalogged on the server both local and remote.

Andy

I make this question because I want to know the size of the database, I know that this information could be are in the catalogue tables.
Greetings.

Your original post only wanted to get the database name from the catalog tables. It does not exist there. If you want the size of the database, if your runstats are current, i recently posted a query that would give you the information.

Andy

get_dbsize_info procedure will help to get size

The thing is that each database has its own catalog (in DB2 LUW). So it doesn't make much sense to store the database name in the catalog; it would just be a single value to begin with. The special register CURRENT SERVER - as mentioned by Andy - serves this purpose very well. So why would you want to have it "in a catalog table"?

p.s: LIST DB DIRECTORY shows the database directory known to the instance. That is a level above databases.