Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2002
    Posts
    3

    Unanswered: finding dbspace for table?

    How would I determine in which dbspace a table is created? Tables are not created in the default dbspace for the database.

    So far oncheck -pe seems to be the best option. Does oncheck -pe perform any locking?

  2. #2
    Join Date
    Nov 2001
    Location
    Germany
    Posts
    14

    Lightbulb

    Hi,
    database sysmaster;
    select tabname, dbinfo('dbspace', tn.partnum)
    from systabnames tn, systabinfo ti
    where ti.ti_partnum = tn.partnum
    and tn.dbsname = "your_database_name"
    and tn.tabname = "your_table_name"
    order by tabname

    would give you the dbspace name where your table resides.


    Murat

Posting Permissions

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