Topic
1 reply Latest Post - ‏2012-09-28T12:16:47Z by SystemAdmin
bella1
bella1
8 Posts
ACCEPTED ANSWER

Pinned topic DB2 UDB table & tablespace info

‏2012-09-28T11:55:58Z |
DB2 9.5 udb

Hello Team,

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...
Updated on 2012-09-28T12:16:47Z at 2012-09-28T12:16:47Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    17917 Posts
    ACCEPTED ANSWER

    Re: DB2 UDB table & tablespace info

    ‏2012-09-28T12:16:47Z  in response to bella1
    You can find with SYSCAT.TABLES catalog view.

    You can find TBSPACEID fo your tablespace in SYSCAT.TABLESPACES catalog view.

    Thanks,
    Mano