Database default dbspace
Posted in 2019
Topics: Storage & Space Management
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
There is no onstat for that. You can query sysmaster:sysdatabases and join to sysdbspaces. Or get my utils2_ak package and run the listdb7 utility it includes with the -D option. It will report the default dbspace among other things.
You can download there latest from my website at
www.askdbmgt.com/my-utilities
Art
------Original Message------
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