Informix

nested-group-icon.png

DB2

Expand all | Collapse all

IDS 14.10: Automatic dbspaces/chunk creation?

  • 1.  IDS 14.10: Automatic dbspaces/chunk creation?

    Posted Wed August 26, 2020 04:19 AM

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


  • 2.  RE: IDS 14.10: Automatic dbspaces/chunk creation?

    Posted Wed August 26, 2020 07:03 AM
    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
    ------------------------------



  • 3.  RE: IDS 14.10: Automatic dbspaces/chunk creation?

    Posted Wed August 26, 2020 07:41 AM
      |   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 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
    ------------------------------

    Attachment(s)

    log
    idstoro3.log   22K 1 version


  • 4.  RE: IDS 14.10: Automatic dbspaces/chunk creation?

    Posted Wed August 26, 2020 08:34 AM
    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





  • 5.  RE: IDS 14.10: Automatic dbspaces/chunk creation?

    Posted Wed August 26, 2020 08:44 AM
    Edited by Gaurav Kumar Wed August 26, 2020 09:01 AM
    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
    ------------------------------



  • 6.  RE: IDS 14.10: Automatic dbspaces/chunk creation?

    Posted Wed August 26, 2020 08:57 AM
    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
    ------------------------------



  • 7.  RE: IDS 14.10: Automatic dbspaces/chunk creation?

    Posted Wed August 26, 2020 09:06 AM
    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
    ------------------------------



  • 8.  RE: IDS 14.10: Automatic dbspaces/chunk creation?

    Posted Wed August 26, 2020 09:18 AM
    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


    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.








  • 9.  RE: IDS 14.10: Automatic dbspaces/chunk creation?

    Posted Wed August 26, 2020 09:42 AM
    Edited by Sebastien FLAESCH Wed August 26, 2020 09:44 AM
    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
    ------------------------------



  • 10.  RE: IDS 14.10: Automatic dbspaces/chunk creation?

    Posted Wed August 26, 2020 09:55 AM

    <quote>

    HCL: You need to bullet proof such enhancements before release!

    </quote>

     

    Maybe not keep breaking existing functionality first J

     

    Cheers

    Paul

     






  • 11.  RE: IDS 14.10: Automatic dbspaces/chunk creation?

    Posted 29 days ago
    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
    ------------------------------



  • 12.  RE: IDS 14.10: Automatic dbspaces/chunk creation?

    Posted 29 days ago
    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


    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.








  • 13.  RE: IDS 14.10: Automatic dbspaces/chunk creation?

    Posted 21 days ago
    Art, I agree.
    Regards
    Hrvoje

    ------------------------------
    Hrvoje Zokovic
    ------------------------------



  • 14.  RE: IDS 14.10: Automatic dbspaces/chunk creation?

    Posted Wed August 26, 2020 08:39 AM

    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 Kbytes

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



  • 15.  RE: IDS 14.10: Automatic dbspaces/chunk creation?

    Posted Wed August 26, 2020 08:58 AM
    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 Kbytes

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



  • 16.  RE: IDS 14.10: Automatic dbspaces/chunk creation?

    Posted Wed August 26, 2020 10:07 AM

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



  • 17.  RE: IDS 14.10: Automatic dbspaces/chunk creation?

    Posted Wed August 26, 2020 10:39 AM

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



  • 18.  RE: IDS 14.10: Automatic dbspaces/chunk creation?

    Posted Wed August 26, 2020 10:52 AM
    Ok thank you Markus!
    Seb

    ------------------------------
    Sebastien FLAESCH
    ------------------------------