Re: DBSPACE - DATABASE

Posted in 1998

Art S. Kagel — Tue, 23 Jun 1998 11:31:28 -0400 — source: Informix-list mailing list archive (1991-1998)

Georg Kowatsch wrote: > > in which "systables" can i read the relation between dbspace to > databases???? In no systables. The information is contained in: sysmaster.sysdatabases and sysmaster.sysdbspaces hence: select db.name database, ds.name dbspace, trunc(partnum/1048576) dbsnum from sysdatabases db, sysdbspaces ds where ds.dbsnum = trunc(partnum/1048576); Art S. Kagel