select sysdatabases.name,
sysdatabases.owner,
sysdbspaces.name
from sysdbspaces,sysdatabases
where partdbsnum(sysdatabases.partnum) =
sysdbspaces.dbsnum
query on sysmaster of course
HTH
Hrvoje
------------------------------
Hrvoje Zokovic
------------------------------
Original Message:
Sent: Tue December 10, 2019 11:13 AM
From: Rubén García Muro
Subject: Database default dbspace
Hi,
I want to know the default dbspace of all my databases, i used to check it out with the onmonitor utility, but now it's gone. Is there any query to sysmaster to know this data?.
Thanks in advance.
------------------------------
Rubén García Muro
------------------------------
#Informix