Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2005
    Posts
    11

    Unanswered: how to see what tables are in a particular dbspace

    How do I ensure that a particular dbspace contains particular tables. I tried select statements in the sysmaster tables, but i don't know which sysmaster table will contain all these information. Your help will be greatly appreciated. Thank you.

  2. #2
    Join Date
    Nov 2004
    Posts
    143
    Hi,

    You can use the following query:

    select DBINFO("DBSPACE",partnum),
    dbsname,
    tabname,
    pe_phys,
    pe_size
    from sysptnext, systabnames
    where pe_partnum = partnum
    order by 1

    where DBSPACE is the name the dbspace on which you want to run the query.

    Bye

    Nitin

  3. #3
    Join Date
    Nov 2004
    Posts
    143
    Hi,

    You can use the following query:

    select DBINFO("DBSPACE",partnum),
    dbsname,
    tabname,
    pe_phys,
    pe_size
    from sysptnext, systabnames
    where pe_partnum = partnum
    order by 1

    where DBSPACE is the name the dbspace on which you want to run the query.

    Bye

    Nitin

  4. #4
    Join Date
    Dec 2005
    Posts
    11
    Thanks Nitin. It was a great help.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •