RE: Finding the dbspace a db resides in

Posted in 1997

Sujit Pal — 29 Jul 1997 13:48:03 -0400 — source: Informix-list mailing list archive (1991-1998)

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