Here my idstoro3.log file...
And ontat -d shows:
informix@toro:/opt3/dbs/ifx/IDS-14.10.FC4W1/etc$ onstat -d
IBM Informix Dynamic Server Version 14.10.FC4W1WE -- On-Line -- Up 19:17:03 -- 185996 Kbytes
Dbspaces
address number flags fchunk nchunks pgsize flags owner name
45948028 1 0x30001 1 1 2048 N BA informix rootdbs
49673b78 2 0x30001 2 1 2048 N BA informix physdbs
4896eb88 3 0x20001 3 1 2048 N BA informix logdbs
493c9da0 4 0x20001 4 1 2048 N BA informix datadbs
49538ce0 5 0x28001 5 1 2048 N SBA informix sbspace
497b36f0 6 0x2001 6 1 2048 N TBA informix tempdbs
6 active, 2047 maximum
Chunks
address chunk/dbs offset size free bpages flags pathname
45948268 1 1 0 250000 228055 PO-B-- /opt3/dbs/ifx/IDS-14.10.FC4W1/storage/rootdbs
4896e028 2 2 0 15360 459 PO-B-D /opt3/dbs/ifx/IDS-14.10.FC4W1/storage/plogdbs
493c9028 3 3 0 14848 459 PO-B-D /opt3/dbs/ifx/IDS-14.10.FC4W1/storage/llogdbs
49785028 4 4 0 110592 110539 PO-B-D /opt3/dbs/ifx/IDS-14.10.FC4W1/storage/datadbs
496b3028 5 5 0 16384 15205 15205 POSB-D /opt3/dbs/ifx/IDS-14.10.FC4W1/storage/sbspace
Metadata 1126 837 1126
48c3c028 6 6 0 27648 27595 PO-B-- /opt3/dbs/ifx/IDS-14.10.FC4W1/storage/tempdbs
6 active, 32766 maximum
NOTE: The values in the "size" and "free" columns for DBspace chunks are
displayed in terms of "pgsize" of the DBspace to which they belong.
Expanded chunk capacity mode: always
------------------------------
Sebastien FLAESCH
------------------------------
Original Message:
Sent: Wed August 26, 2020 07:02 AM
From: Gaurav Kumar
Subject: IDS 14.10: Automatic dbspaces/chunk creation?
Hi Sebastien ,
I don't think Informix will create any dbspace apart from root dbspace when you initialize it..
May be you are running some script or your instance was not initialized properly.
Can you share your online.log and the output of onstat -d
------------------------------
Gaurav Kumar
Original Message:
Sent: Wed August 26, 2020 04:18 AM
From: Sebastien FLAESCH
Subject: IDS 14.10: Automatic dbspaces/chunk creation?
Hello!
I have recently played with server re-initialization using oninit -i with IDS 14.10.FC1 and 14.10.FC4W1 ...
I wonder if IDS does automatically create chunks and dbspaces: Is this the case?
Note: At some point I have created my own chunks/dbspaces, but then I wanted to re-init from scratch just with an clean/empty rootdbs... but when creating my databases, new chunks/dbspaces appear magically.
I must be missing something.
I expected that only a rootdbs would be used, if you do not manually create your chunks/dbspaces...
Are there some onconfig settings that make IDS automatically create chunks/dbspaces?
If such feature exists, can someone point me to the doc where this is explained?
I read about the etc/oncfg_* file containing dbspace info, but I have deleted this file before re-initializing, and I have created an empty rootdbs file ...
Here the sequence of actions:
1) cd $INFORMIXDIR/storage
2) rm -rf *
3) cat /dev/null > rootdbs
4) chmod 660 rootdbs
5) set FULL_DISK_INIT=1 in my etc/onconfig.idstoro3 file
6) rm $INFORMIXDIR/etc/oncfg_idstoro3.185
7) oninit -i
=> ok ... server started...
In a first time, I see only rootdbs chunk, but after creating 2 databases, seems that IDS automatically creates more chunks/dbspaces:
informix@toro:/opt3/dbs/ifx/IDS-14.10.FC4W1/storage$ oninit -i
This action will initialize IBM Informix Dynamic Server;
any existing IBM Informix Dynamic Server databases will NOT be accessible -
Do you wish to continue (y/n)? y
Warning: Parameter's user-configured value was adjusted. (DS_MAX_SCANS)
Warning: Parameter's user-configured value was adjusted. (MAX_PDQPRIORITY)
Warning: Parameter's user-configured value was adjusted. (ONLIDX_MAXMEM)
informix@toro:/opt3/dbs/ifx/IDS-14.10.FC4W1/storage$ ls -l
total 500004
-rw-rw---- 1 informix informix 512000000 Aug 25 18:23 rootdbs
informix@toro:/opt3/dbs/ifx/IDS-14.10.FC4W1/storage$ dbaccess - -
> create database test1 with buffered log;
Database created.
> grant connect to sf;
Permission granted.
> grant dba to sf;
Permission granted.
> ^C
informix@toro:/opt3/dbs/ifx/IDS-14.10.FC4W1/storage$ dbaccess - -
> create database test2 with buffered log;
Database created.
> grant connect to sf;
Permission granted.
> grant dba to sf;
Permission granted.
> ^C
informix@toro:/opt3/dbs/ifx/IDS-14.10.FC4W1/storage$ ls -l
total 869672
-rw-rw---- 1 informix informix 226492416 Aug 25 18:23 datadbs
-rw-rw---- 1 informix informix 30408704 Aug 25 18:24 llogdbs
-rw-rw---- 1 informix informix 31457280 Aug 25 18:24 plogdbs
-rw-rw---- 1 informix informix 512000000 Aug 25 18:24 rootdbs
-rw-rw---- 1 informix informix 33554432 Aug 25 18:23 sbspace
-rw-rw---- 1 informix informix 56623104 Aug 25 18:24 tempdbs
Is this normal?
As I have multiple IDS version installed, can it be that some dbspace config file is used from somewhere else as my current INFORMIXDIR?
Seb
------------------------------
Sebastien FLAESCH
------------------------------
#Informix