Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    20

    Question Unanswered: mapping dbspace to table to database

    Hi all. I have a query that will pull out my dbspace space utilization and I have a query that will map my dbspaces to my tables...but how can I map tables to their parent databases(I have multiple databases on same machine).

  2. #2
    Join Date
    Apr 2003
    Location
    Phoenix, AZ
    Posts
    177

    Re: mapping dbspace to table to database

    sysmaster database (which you are probibily already using for some of your queries) has systabnames. There you have the link between the database name, the table (or index) name) and the partition number - which points you to the dbspace.
    Fred Prose

Posting Permissions

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