dbspace and the table

Posted in 1999

Topics: Storage & Space Management, Server Administration

John — Fri, 14 May 1999 14:40:58 +0200 — source: Informix-list mailing list archive (1991-1998)

How can I identify in which dbaspaces the table is located?

↪ replying to John

James — Fri, 14 May 1999 08:05:48 -0500 — source: Informix-list mailing list archive (1991-1998)

Select trunc(tb.partnum/1048576) dbspace,db.name from sysmaster:systabnames tb,sysmaster:sysdbspaces db where tb.dbsname = "name_of_your_database" and tb.tabname = "name_of_your_table" and db.dbsnum = trunc(tb.partnum/1048576) This should work for you. HTH James John wrote: > How can I identify in which dbaspaces the table is located?

↪ replying to John

Vic Glass — Fri, 14 May 1999 18:00:23 -0400 — source: Informix-list mailing list archive (1991-1998)

oncheck -pe John wrote: > How can I identify in which dbaspaces the table is located?

Glossary

dbspace