Re: Informix Online - Table disk location

Kamlesh writes: |> |> I am running Informix Online 4.1 on a hp 9000 running hp-ux 8.02 |> |> I have set up the database so tables are spread across three different |> disks on raw disk partions. |> |> My question is, is there an easy way to find out where a particular |> table is located on disk. tbcheck -pe will print a report of each chunk and the extents for the tables (in physical order) as they appear in that chunk, along with the size and offset of the extents. The tables are listed by table name. |> I have used tbstat -t, and looked at the address of the particular |> table, but tbstat only shows the active tables. |> |> I have looked in the systables table, and the partnum is similar to |> the address. How does the address or partnum related to the location |> of the table in a particular dbspace or disk partion? It has no relation. Partnum is actually composed of the dbspace number and page number within the tblspace tblspace where the page describing the table in question is located. Dave