DB2 9.5 udb
Which table can i use to get the list of tables pertaining to a specific tablespace.
I mean if there is a tablespace and i need to check which all tables are present in it...
SystemAdmin 110000D4XK17917 Posts
Re: DB2 UDB table & tablespace info2012-09-28T12:16:47ZThis is the accepted answer. This is the accepted answer.You can find with SYSCAT.TABLES catalog view.
You can find TBSPACEID fo your tablespace in SYSCAT.TABLESPACES catalog view.