Re: databases to databasespace

Peter Shankey 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 Peter, I do not know the SQL statement you are searching for by heart. But I am nopt sure about your understanding. Do you mean a database and all of it's tables may reside in a single dbspace only? This would be wrong. When you create a database in a dbspace, this means only that the dictionary of this database will reside in the named dbspace. Tables belonging to this database may (default) or may not (option in CREATE TABLE) be in this dbspace. Regards -- Helmut Leininger Bull AG / Vienna Unix Support Email: helmut.leininger@bull.de This opinion is mine and not necessarily that of my employer. No guarantees whatsoever.