Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Dave Kosenko — — source: Informix-list mailing list archive (1991-1998)
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
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.