How can we know the DB2 database/tablespace name for table?

santoshkumarmanilakkoju · Posted: Fri Apr 23, 2010 1:56 pm

Hi,

I know a table name and its corresponding database name in production sub-system DB2.

I want to know corresponding db name for the table in test subsytem DB2Q/DB2T.

Ex:NNDB2M.T_OMR_RQST is the name in production sub-system.

Please let me know if there is a way to find out the corrsponding name in test i.e. ?.T_OMR_RQST

dbzTHEdinosauer · Posted: Fri Apr 23, 2010 4:09 pm

other than asking someone, like DBA,

I would

look in JES and find the DB2 started tasks
look at a bind for a module in test/quality control environments

sushanth bobby · Posted: Fri Apr 23, 2010 4:11 pm

Santosh,

Try this in your test sub-systems,

santoshkumarmanilakkoju · Posted: Fri Apr 23, 2010 5:10 pm

Thank you Sushanth It worked.

My be my question was not clear.
It was to know the creator name of a table in a particulat DB2 sub-system

I tried this and it worked.

SELECT CREATOR FROM SYSIBM.SYSTABLES
WHERE NAME = 'T_OMR_RQST';

sushanth bobby · Posted: Fri Apr 23, 2010 6:36 pm

I am glad it worked, thanks for letting us know santosh.

As dbz said, you can also look creator name of the table in bind statement QUALIFIER option.

Sushanth