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)