Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Helmut Leininger — — source: Informix-list mailing list archive (1991-1998)
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.
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.