Re: Finding the dbspace a db resides in
}>From ilist@rmy.emory.edu Mon Jul 28 19:18:11 1997
}>Received: from rmy.rmy.emory.edu (rmy.rmy.emory.edu [170.140.97.4])
}> by hobbes.dbintellect.com (8.8.6/8.8.6) with ESMTP id TAA01238
}> for <settler@dbintellect.com>; Mon, 28 Jul 1997 19:18:10 -0600 (MDT)
}>Received: (from ilist@localhost) by rmy.rmy.emory.edu (8.7.1/8.7.1) id TAA12871 for informix-list-out; Mon, 28 Jul 1997 19:25:01 -0400 (EDT)
}>From: otto@alldata.com (Doug Otto)
}>Message-Id: <5rj491$8b7@webserver>
}>Subject: Finding the dbspace a db resides in
}>Date: 28 Jul 1997 21:51:29 GMT
}>Reply-To: otto@alldata.com (Doug Otto)
}>Organization: Alldata Intranet
}>Sender: informix-list-owner@rmy.emory.edu
}>To: informix-list@rmy.emory.edu
}>X-Informix-List-Id: <news.40955>
}>
}>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
}>
Try this query against the sysmaster database:
select a.name,b.name
from sysdatabases a
,sysdbstab b
where b.dbsnum = trunc(a.partnum/1048576)
-------------------------------------------------------------------
Jeff Craig | dbINTELLECT Technologies, Inc.
Senior Consultant | Golden, CO
| (303) 275-6954 ext. 8008
| email: settler@dbintellect.com
| fax: (303) 275-2134
-------------------------------------------------------------------