Informix

Informix

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only
  • 1.  Database default dbspace

    Posted Tue December 10, 2019 02:00 PM
    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


  • 2.  RE: Database default dbspace

    Posted Tue December 10, 2019 02:08 PM
    Edited by System Admin Fri January 20, 2023 04:36 PM
    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
    ------------------------------



  • 3.  RE: Database default dbspace

    Posted Tue December 10, 2019 02:58 PM
    Ohhh, that's exactly what i was looking for!!!

    Thank you so much!!!

    ------------------------------
    Rubén García Muro
    ------------------------------



  • 4.  RE: Database default dbspace

    Posted Tue December 10, 2019 03:11 PM
    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