Re: databases to databasespace

In article <36459C65.2E8EE653@charlestoncounty.org>, Peter Shankey <shankeyp@charlestoncounty.org> wrote: > it is my understanding that: > a database can exist in one and only one databasespace. > a databasespace does not have to have anything in it, but can contain > temp space, logical logs and one or more databases. > > So, what would be the SQL on the system tables (sysmaster) which would > tell me what database is in what databasespace? > > thanks > > Hi, you can get the information from the following sql statement running on sysmaster database. select sysdbspartn.name as database, sysdbspaces.name as dbspace from sysdbspartn, sysdbspaces where round((sysdbspartn.partnum)/1048576) = sysdbspaces.dbsnum; Hope it will help. -ramana -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own