Discussion:
AW: Which dbspace does a database occupy [39986]
(too old to reply)
Habichtsberg, Reinhard
2017-10-12 11:37:12 UTC
Permalink
Raw Message
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-***@iiug.org [mailto:ids-***@iiug.org] Im Auftrag von LARRY SORENSEN
Gesendet: Montag, 25. September 2017 19:32
An: ***@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.
Lester Knutsen
2017-10-12 13:36:05 UTC
Permalink
Raw Message
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.



Regards - Lester

-----------------------------------------------------------------------------
-- Module: @(#)database_list.sql    2.5     Date: 2013/04/10
-- Author: Lester Knutsen  Email: ***@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;
Post by Habichtsberg, Reinhard
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-----
Gesendet: Montag, 25. September 2017 19:32
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
http://members.iiug.org/mailman/listinfo/informix-list
--
______________________________________________________________________
Lester Knutsen ***@advancedatatools.com
Advanced DataTools Corporation Voice: 703-256-0267 x102
Visit our Web page: http://www.advancedatatools.com
______________________________________________________________________
Loading...