Doug
On 7.x instances, try:
SELECT DBINFO("DBSPACE", HEX(partnum))
FROM systables
WHERE tabname = "systables"
On 5.x instances, try:
SELECT HEX(partnum) FROM systables
WHERE tabname = "systables"
In the first 2 characters of the output (after the 0x) you will see the chunk number. Do a tbstat -d to get the dbspace name.
HTH
Sujit Pal
----------
From: Doug Otto[SMTP:otto@alldata.com]
Sent: Monday, July 28, 1997 3:51 PM
To: informix-list@rmy.emory.edu
Subject: Finding the dbspace a db resides in
Anyone got a quick and dirty way to find out what dbspace a particular
database resides in? I know the info is available from tbcheck -pe
but I've got over 700 databases in my instance and it's kind of a pain
doing it that way.
Thanks in advance.
BTW - I'm running 5.07
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Doug Otto otto@alldata.com
Alldata Corporation dotto@calweb.com
Technical Manager, Database Development (800) 829-8727 ext. 3137