How to know the database name of a DB2 table

sandhyaragav · New User Joined: 05 Apr 2006 Posts: 14

Hi,

I know the DB2 table name and I want to know the database name that has this table. Can anyone please help me on this.

Regards
Sandhya

guptae · Posted: Thu Nov 30, 2006 3:42 pm

Hi There,

In our shop we have DB2 Admin - DB2 Admin Tool by which we can identify. Check in ur shop u must be having similar type of tool

guptae · Posted: Thu Nov 30, 2006 3:44 pm

Hi There,

In our shop we have DB2 Admin - DB2 Admin Tool by which we can identify. Check in ur shop u must be having similar type of tool

Phrzby Phil · Posted: Thu Nov 30, 2006 6:28 pm

run:

select *
from sysibm.systables

column DBNAME is what you want