1. Forum
  2. Usenet
  3. COMP.DATABASES.INFORMIX

  • AW: Which dbspace does a database occupy [39986]

    From Habichtsberg, Reinhard@21:1/5 to All on Thu Oct 12 11:37:12 2017
    To: informix-list@iiug.org (informix-list@iiug.org)

    Dbaccess dialog

    dbaccess - Database - Select - Info - Dbspace

    Shows the dbspace where the database initially was created. Tables are created there if not specified otherwise.

    HTH
    Reinhard

    -----Ursprüngliche Nachricht-----
    Von: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Im Auftrag von LARRY SORENSEN
    Gesendet: Montag, 25. September 2017 19:32
    An: ids@iiug.org
    Betreff: Which dbspace does a database occupy [39986]

    IDS 11.50.FC5

    Solaris 10

    I have several dbspaces and databases. How can I tell which dbspace a particular database is in?

    Thank you.

    Larry sorensen


    *******************************************************************************
    Forum Note: Use "Reply" to post a response in the discussion forum.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Lester Knutsen@21:1/5 to Reinhard on Thu Oct 12 09:36:05 2017
    Larry,

    One of my sysmaster queries does this.  See below, it will tell the defaut dbspace, owner and logging mode of all your databases.

    Webcast Replay - Using the Sysmaster database to perform an Informix Server Heath Check,by Lester Knutsen.
    https://youtu.be/3w83w1kc2gk


    Regards - Lester

    ----------------------------------------------------------------------------- -- Module: @(#)database_list.sql    2.5     Date: 2013/04/10
    -- Author: Lester Knutsen  Email: lester@advancedatatools.com --         Advanced DataTools Corporation
    -- Discription:    Displays database list,owner and logging status
    --    Tested with Informix 11.70 and Informix 12.10 -----------------------------------------------------------------------------

    database sysmaster;

    select
            dbinfo("DBSPACE",partnum) dbspace,
            name database,
            owner,
            is_logging,
            is_buff_log
    from sysdatabases
    order by dbspace, name;


    On 10/12/17 7:37 AM, Habichtsberg, Reinhard wrote:
    Dbaccess dialog

    dbaccess - Database - Select - Info - Dbspace

    Shows the dbspace where the database initially was created. Tables are created there if not specified otherwise.

    HTH
    Reinhard

    -----Ursprüngliche Nachricht-----
    Von: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Im Auftrag von LARRY SORENSEN
    Gesendet: Montag, 25. September 2017 19:32
    An: ids@iiug.org
    Betreff: Which dbspace does a database occupy [39986]

    IDS 11.50.FC5

    Solaris 10

    I have several dbspaces and databases. How can I tell which dbspace a particular database is in?

    Thank you.

    Larry sorensen


    *******************************************************************************
    Forum Note: Use "Reply" to post a response in the discussion forum.

    _______________________________________________
    Informix-list mailing list
    Informix-list@iiug.org
    http://members.iiug.org/mailman/listinfo/informix-list

    --
    ______________________________________________________________________
    Lester Knutsen lester@advancedatatools.com
    Advanced DataTools Corporation Voice: 703-256-0267 x102
    Visit our Web page: http://www.advancedatatools.com ______________________________________________________________________

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)