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 -iThis 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

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 ------------------------------

| view attached 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 KbytesDbspaces 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 ------------------------------

I see your database is calling this script in sysadmin which is creating dbspaces and database 18:23:49 SCHAPI: Using (/opt3/dbs/ifx/IDS-14.10.FC4W1/etc/sysadmin/sch_init_idstoro3.sql) to initialize this instance. -- Sent from my iPhone

Maybe this onconfig Parameter: $ onstat -g cfg full AUTO_TUNE_SERVER_SIZE IBM Informix Dynamic Server Version 14.10.FC3DE -- On-Line -- Up 00:01:15 -- 165016 KbytesConfiguration Parameter Info id name type maxlen units rsvd tunable 64 AUTO_TUNE_SERVER_SIZE CHAR 7 * default : OFF onconfig: current : OFF Description: Use the AUTO_TUNE_SERVER_SIZE configuration parameter to indicate whether this instance is a SMALL, MEDIUM, LARGE, or XLARGE instance. The server's automatic tuning features will allocate resources like buffer pools, logical logs, and spaces accordingly. The default value for this parameter is OFF. Cheers, Markus ------------------------------ Markus Holzbauer ------------------------------

Oh Yes!!! When you have installed the bundle and say yes to create the server, then this script is present in $INFORMIXDIR/etc/sysadmin which creates dbspaces ------------------------------ Gaurav Kumar ------------------------------

I did never create any script file like $INFORMIXDIR/etc/sysadmin/sch_init_idstoro3.sql I guess the installer did!!! That file owner is root:root and it has the same date as my installation log files: -rwxr-xr-x 1 root root 20050 Aug 18 12:17 IBM_Informix_Software_Bundle_Install_08_18_2020_11_01_27.log -rw-rw-rw- 1 root root 1079 Aug 18 11:02 etc/sysadmin/sch_init_idstoro3.sql Anyway, thanks for the tip! Seb ------------------------------ Sebastien FLAESCH ------------------------------

Here my setting: informix@toro:/opt3/dbs/ifx/IDS-14.10.FC4W1$ onstat -g cfg full AUTO_TUNE_SERVER_SIZE IBM Informix Dynamic Server Version 14.10.FC4W1WE -- On-Line -- Up 20:34:26 -- 185996 KbytesConfiguration Parameter Info id name type maxlen units rsvd tunable 64 AUTO_TUNE_SERVER_SIZE CHAR 7 * default : OFF onconfig: SMALL current : SMALL Description: Use the AUTO_TUNE_SERVER_SIZE configuration parameter to indicate whether this instance is a SMALL, MEDIUM, LARGE, or XLARGE instance. The server's automatic tuning features will allocate resources like buffer pools, logical logs, and spaces accordingly. The default value for this parameter is OFF. ------------------------------ Sebastien FLAESCH ------------------------------

Hi Sebastien, Oh Yes!!! When you have installed the bundle and say 'yes' to create the server, then this script will be visible in $INFORMIXDIR/etc/sysadmin gets called when sysadmin database is getting created and is a party of sysadmin to create dbspaces and move physical log and logical log and do many more things for your env. You don't have create any environment and onconfig file. This script will do by its own everything for you. ------------------------------ Gaurav Kumar ------------------------------

Gaurav, Sebastian: I believe that this script is created by the installer when you tell it to create a server for you. Since you dropped your instance but did not do a clean install the file was left around from the original installation and startup and so was executed by a sysadmin task shortly after you initialized the engine by the task manager! I think that a PMR to have that file removed after it is executed is in order! Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.

Ok ! If it's identified, I am good with that, and now at least we have an explanation... I thought I was going crazy. HCL: You need to bullet proof such enhancements before release! ... and any doc link describing this is welcome! Seb ------------------------------ Sebastien FLAESCH ------------------------------

<quote> HCL: You need to bullet proof such enhancements before release! </quote> Maybe not keep breaking existing functionality first J Cheers Paul

Hello Sebastien, I think Informix is creating that dbspaces if AUTO_TUNE_SERVER_SIZE is not set to OFF or blank. Cheers, Markus ------------------------------ Markus Holzbauer ------------------------------

It is described here: https://www.ibm.com/support/knowledgecenter/en/SSGU8G_12.1.0/com.ibm.adref.doc/ids_adr_1183.htm Cheers, Markus ------------------------------ Markus Holzbauer ------------------------------

Ok thank you Markus! Seb ------------------------------ Sebastien FLAESCH ------------------------------

Hi Art, it is confusing, indeed. But IMHO it would be better just to rename file since it is really good starting point if you do lot of repetitive oninit -i and onspaces commands. Regards Hrvoje ------------------------------ Hrvoje Zokovic ------------------------------

Hrvoje: OK, I get that. But the dbschema -c option (or myschema --infrastructure option) will generate the commands needed to rebuild an instance, so that installation time script file is a bit redundant. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.

Art, I agree. Regards Hrvoje ------------------------------ Hrvoje Zokovic ------------------------------