Create Another Instance On The Same Server

Informix Guru's First post to the forum and new to Informix. I recently Installed Informix Dynamic Server 10.FC5 on a server running Solaris 10 (Sparc) which is being used as a test environment for our developers. The test environment is a replica of our production environment with the execption that the production system used raw files compared to test which is used cooked files. I have now been asked to create a small training environment on the same server that our test environemnt runs on this time using 15G of spare space in the /usr directory. What changes need to be made to create another instance? Here is what I have done so far: Created a new entry in the sqlhost file for the training instance: idstraining ontlitcp Intranet idstraining Made a copy of the test instance onconfig file (what changes would be required?) Added an entry in the /etc/services file (currently set to) idstest 1525/tcp # Informix tcp port idstraining 1530/tcp # Informix tcp port Below is a copy of my current environment - do I need to create another environment file? if so how do I create it and get the system to use it for the new instance. $ grep INF | env _=/usr/bin/env HZ=100DBSERVERNAME=idstest PATH=/usr/bin::/usr/informix/binEDITOR=vi INFORMIXSQLHOSTS=/usr/informix/etc/sqlhostsLOGNAME=informix DBCENTURY=C MAIL=/usr/mail/informix DB_LOCALE=en_us.utf8TERMCAP=/usr/informix/wyse60.tc SHELL=/usr/bin/ksh SERVERNUM=59 HOME=/export/home/informix INFORMIXDIR=/usr/informix LD_LIBRARY_PATH=/usr/informix/libTERM=wyse60 ONCONFIG=onconfig.IntranetPWD=/usr/informix/etc TZ=Australia/Queensland INFORMIXSERVER=idstest Ideally I would like to be able to switch between instances idstest and idstraining using oninit. If the above is way of the mark then how do I go about creating such an environment that allows both instances to run on the same server. Any help appreciated

Yes. You have to create an environment that diferenciates one instance from another. For instance, in one of my systems, i have a default 9.40 instance whith configuracion on directory /usr1/informix and a 10.50 on /usr1/informix1150. The default .profile of informix executes . /usr1/informix/.informixrcInst01 which has this lines INFORMIXDIR=/usr1/informix INFORMIXSERVER=nacional_net INFORMIXC=gcc ONCONFIG=onconfigDBTEMP=/usr1/informix/tmp among others. I can start up the default 9.40 instance on this environment. But, when I want to init the 11.50 instance, then i execute . /usr1/informix1150/.informixrcInst02 whith the lines INFORMIXDIR=/usr1/informix1150 INFORMIXSERVER=nacional2_net INFORMIXC=gcc ONCONFIG=onconfig2DBTEMP=/usr1/informix1150/tmp which defines the environment to another instance. Now. As you have the same version for both instances, your INFORMIXDIR will be the same. The main difference will be defined by the ONCONFIG environment symbol. Be cautious with your dbspaces in order to not damage the production database. El lun, 26-04-2010 a las 21:40 -0400, JAMES MCLARDIE escribió: > Informix Guru's > > First post to the forum and new to Informix. > > I recently Installed Informix Dynamic Server 10.FC5 on a server running > Solaris 10 (Sparc) which is being used as a test environment for our > developers. The test environment is a replica of our production environment > with the execption that the production system used raw files compared to test > which is used cooked files. I have now been asked to create a small training > environment on the same server that our test environemnt runs on this time > using 15G of spare space in the /usr directory. > > What changes need to be made to create another instance? > Here is what I have done so far: > > Created a new entry in the sqlhost file for the training instance: > > idstraining ontlitcp Intranet idstraining> > Made a copy of the test instance onconfig file (what changes would be > required?) > > Added an entry in the /etc/services file (currently set to) > > idstest 1525/tcp # Informix tcp port > > idstraining 1530/tcp # Informix tcp port > > Below is a copy of my current environment - do I need to create another > environment file? if so how do I create it and get the system to use it for > the new instance. > > $ grep INF | env > _=/usr/bin/env > HZ=100> DBSERVERNAME=idstest > PATH=/usr/bin::/usr/informix/bin> EDITOR=vi > INFORMIXSQLHOSTS=/usr/informix/etc/sqlhosts> LOGNAME=informix > DBCENTURY=C > MAIL=/usr/mail/informix > DB_LOCALE=en_us.utf8> TERMCAP=/usr/informix/wyse60.tc > SHELL=/usr/bin/ksh > SERVERNUM=59 > HOME=/export/home/informix > INFORMIXDIR=/usr/informix > LD_LIBRARY_PATH=/usr/informix/lib> TERM=wyse60 > ONCONFIG=onconfig.Intranet> PWD=/usr/informix/etc > TZ=Australia/Queensland > INFORMIXSERVER=idstest> > Ideally I would like to be able to switch between instances idstest and > idstraining using oninit. > > If the above is way of the mark then how do I go about creating such an > environment that allows both instances to run on the same server. > > Any help appreciated > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

To support multiple instances on a single machine the following must be different: Environment: INFORMIXSERVER=<new server's name> # for starting the instance and forusers that want access to it. ONCONFIG file (it is common to name the ONCONFIG file onconfig.<servername>): DBSERVERNAMEDBSERVERALIASES (if you have any server alias names for multiple connection protocols) SERVERNUM <must be different for each server instance> ROOTDBS <each server must have its own root dbspace> All other parameters can be the same or different. You should be using the latest Informix release: 11.50xC6W3 or later. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) See you at the 2010 IIUG Informix Conference April 25-28, 2010 Overland Park (Kansas City), KS www.iiug.org/conf Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, 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. On Mon, Apr 26, 2010 at 9:40 PM, JAMES MCLARDIE <jmclardie@sealy.com.au>wrote: > Informix Guru's > > First post to the forum and new to Informix. > > I recently Installed Informix Dynamic Server 10.FC5 on a server running > Solaris 10 (Sparc) which is being used as a test environment for our > developers. The test environment is a replica of our production environment > with the execption that the production system used raw files compared to > test > which is used cooked files. I have now been asked to create a small > training > environment on the same server that our test environemnt runs on this time > using 15G of spare space in the /usr directory. > > What changes need to be made to create another instance? > Here is what I have done so far: > > Created a new entry in the sqlhost file for the training instance: > > idstraining ontlitcp Intranet idstraining> > Made a copy of the test instance onconfig file (what changes would be > required?) > > Added an entry in the /etc/services file (currently set to) > > idstest 1525/tcp # Informix tcp port > > idstraining 1530/tcp # Informix tcp port > > Below is a copy of my current environment - do I need to create another > environment file? if so how do I create it and get the system to use it for > the new instance. > > $ grep INF | env > _=/usr/bin/env > HZ=100> DBSERVERNAME=idstest > PATH=/usr/bin::/usr/informix/bin> EDITOR=vi > INFORMIXSQLHOSTS=/usr/informix/etc/sqlhosts> LOGNAME=informix > DBCENTURY=C > MAIL=/usr/mail/informix > DB_LOCALE=en_us.utf8> TERMCAP=/usr/informix/wyse60.tc > SHELL=/usr/bin/ksh > SERVERNUM=59 > HOME=/export/home/informix > INFORMIXDIR=/usr/informix > LD_LIBRARY_PATH=/usr/informix/lib> TERM=wyse60 > ONCONFIG=onconfig.Intranet> PWD=/usr/informix/etc > TZ=Australia/Queensland > INFORMIXSERVER=idstest> > Ideally I would like to be able to switch between instances idstest and > idstraining using oninit. > > If the above is way of the mark then how do I go about creating such an > environment that allows both instances to run on the same server. > > Any help appreciated > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001636e909e7fd936704852f9909

You would only require a different INFORMIXDIR if each instance is to be running a different version of Informix. As long as they are running the same version, they can share the INFORMIXDIR and associated environment variables like LD_LIBRARY_PATH, PATH, etc.. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) See you at the 2010 IIUG Informix Conference April 25-28, 2010 Overland Park (Kansas City), KS www.iiug.org/conf Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, 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. On Mon, Apr 26, 2010 at 11:22 PM, nestor gomez munoz < nestorgm@prodigy.net.mx> wrote: > Yes. You have to create an environment that diferenciates one instance > from another. > > For instance, in one of my systems, i have a default 9.40 instance whith > configuracion on directory /usr1/informix and a 10.50 > on /usr1/informix1150. The default .profile of informix executes > .. /usr1/informix/.informixrcInst01 > which has this lines > INFORMIXDIR=/usr1/informix > INFORMIXSERVER=nacional_net > INFORMIXC=gcc > ONCONFIG=onconfig> DBTEMP=/usr1/informix/tmp > > among others. > I can start up the default 9.40 instance on this environment. > > But, when I want to init the 11.50 instance, then i execute > .. /usr1/informix1150/.informixrcInst02 > whith the lines > INFORMIXDIR=/usr1/informix1150 > INFORMIXSERVER=nacional2_net > INFORMIXC=gcc > ONCONFIG=onconfig2> DBTEMP=/usr1/informix1150/tmp > > which defines the environment to another instance. > > Now. As you have the same version for both instances, your INFORMIXDIR > will be the same. The main difference will be defined by the ONCONFIG > environment symbol. > Be cautious with your dbspaces in order to not damage the production > database. > > El lun, 26-04-2010 a las 21:40 -0400, JAMES MCLARDIE escribió: > > Informix Guru's > > > > First post to the forum and new to Informix. > > > > I recently Installed Informix Dynamic Server 10.FC5 on a server running > > Solaris 10 (Sparc) which is being used as a test environment for our > > developers. The test environment is a replica of our production > environment > > with the execption that the production system used raw files compared to > test > > which is used cooked files. I have now been asked to create a small > training > > environment on the same server that our test environemnt runs on this > time > > using 15G of spare space in the /usr directory. > > > > What changes need to be made to create another instance? > > Here is what I have done so far: > > > > Created a new entry in the sqlhost file for the training instance: > > > > idstraining ontlitcp Intranet idstraining> > > > Made a copy of the test instance onconfig file (what changes would be > > required?) > > > > Added an entry in the /etc/services file (currently set to) > > > > idstest 1525/tcp # Informix tcp port > > > > idstraining 1530/tcp # Informix tcp port > > > > Below is a copy of my current environment - do I need to create another > > environment file? if so how do I create it and get the system to use it > for > > the new instance. > > > > $ grep INF | env > > _=/usr/bin/env > > HZ=100> > DBSERVERNAME=idstest > > PATH=/usr/bin::/usr/informix/bin> > EDITOR=vi > > INFORMIXSQLHOSTS=/usr/informix/etc/sqlhosts> > LOGNAME=informix > > DBCENTURY=C > > MAIL=/usr/mail/informix > > DB_LOCALE=en_us.utf8> > TERMCAP=/usr/informix/wyse60.tc > > SHELL=/usr/bin/ksh > > SERVERNUM=59 > > HOME=/export/home/informix > > INFORMIXDIR=/usr/informix > > LD_LIBRARY_PATH=/usr/informix/lib> > TERM=wyse60 > > ONCONFIG=onconfig.Intranet> > PWD=/usr/informix/etc > > TZ=Australia/Queensland > > INFORMIXSERVER=idstest> > > > Ideally I would like to be able to switch between instances idstest and > > idstraining using oninit. > > > > If the above is way of the mark then how do I go about creating such an > > environment that allows both instances to run on the same server. > > > > Any help appreciated > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001636b2bf8804721504852fb8d1

Thanks for the responses. I'm my original post I stated that I would like to switch between instances using oninit which wasn't quiet accurate. Can someone verify if the following is possible and if so does that change anything with the configuration not already metioned in the previous replies. I have created a executable file called training that contains all environmet vairables for the training instance ie onconfig, servernum, servername etc. Added new entry to sqlhosts file. Copied test onconfig file to create training onconfig file and change a few parameters. Added entry to etc/services file. The /usr directory has 15gb of free space where I have created a root dbspace and chunk and also a database dbspace and chunk. The majority of space is in the database chunk as this is where I want to house the data. Now when I log into the test environment I run .training to take me to the correct environment. I then use dbaccess and have the option to connect to idstest or idstraining. When selecting idstraining I get message 908: cannot connect to database server idstraining. Have I missed any steps? How can I connect to the training environment without bringing down the test database? Hope this makes some sense. Thanks in advance.

Just to get the dumb stuff out of the way, did you initialize the second in= stance by running oninit -I with INFORMIXDIR set to idstraining? Does onst= at report that the instance is online? Art=20 -----Original Message----- From: JAMES MCLARDIE <jmclardie@sealy.com.au> Sent: Tuesday, April 27, 2010 6:35 AM To: ids@iiug.org Subject: Re: Create Another Instance On The Same Server [19871] Thanks for the responses. I'm my original post I stated that I would like t= o=20 switch between instances using oninit which wasn't quiet accurate. Can some= one=20 verify if the following is possible and if so does that change anything wit= h=20 the configuration not already metioned in the previous replies.=20 I have created a executable file called training that contains all environm= et=20 vairables for the training instance ie onconfig, servernum, servername etc.= =20 Added new entry to sqlhosts file.=20 Copied test onconfig file to create training onconfig file and change a few= =20 parameters.=20 Added entry to etc/services file.=20 The /usr directory has 15gb of free space where I have created a root dbspa= ce=20 and chunk and also a database dbspace and chunk. The majority of space is i= n=20 the database chunk as this is where I want to house the data.=20 Now when I log into the test environment I run .training to take me to the= =20 correct environment. I then use dbaccess and have the option to connect to= =20 idstest or idstraining. When selecting idstraining I get message 908: canno= t=20 connect to database server idstraining.=20 Have I missed any steps?=20 How can I connect to the training environment without bringing down the tes= t=20 database?=20 Hope this makes some sense.=20 Thanks in advance.=20 ***************************************************************************= ****=20 Forum Note: Use "Reply" to post a response in the discussion forum.=20

Here is my configuration and the error I am getting. I have not created dbs_root as of yet... is this not created when you first initialize? In the /usr/informix directory I have an executable called training, it has the following variables.Changes made DBSERVERNAME, INFORMIXSERVER, ONCONFIG SERVERNUM $ more trainingDBCENTURY=C DBSERVERNAME=idstraining DB_LOCALE=en_us.utf8EDITOR=vi ERRNO=13 FCEDIT=/bin/ed HOME=/export/home/informix HZ=100 IFS=' ' INFORMIXDIR=/usr/informix INFORMIXSERVER=idstraining INFORMIXSQLHOSTS=/usr/informix/etc/sqlhosts LD_LIBRARY_PATH=/usr/informix/libLINENO=1 LOGNAME=informix MAIL=/usr/mail/informix MAILCHECK=600 OLDPWD=/ ONCONFIG=onconfig.TrainingOPTIND=1 PATH=/usr/bin::/usr/informix/binPPID=29072 PS1='$ ' PS2='> ' PS3='#? ' PS4='+ ' PWD=/export/home/informix RANDOM=31050 SECONDS=15762 SERVERNUM=65 SHELL=/usr/bin/ksh TERM=wyse60 TERMCAP=/usr/informix/wyse60.tc TMOUT=0 TZ=Australia/Queensland _=env -------------------------------------------------------------------------------- In the /usr/informix/etc/sqlhosts file I have the following # DBSSERVER ConnType Host Service # ========= ======== ==== ======= # idstest onipcshm Intranet idstest idstest ontlitcp Intranet idstest idstraining ontlitcp Intranet idstraining -------------------------------------------------------------------------------- I have copied the test onconfig file and renamed onconfig.Training and made a few changes to ROOTNAME, ROOTPATH, SERVERNUM, DBSERVERNAME $ more onconfig.Training #************************************************************************** ## Licensed Material - Property Of IBM # # "Restricted Materials of IBM" # # IBM Informix Dynamic Server # (c) Copyright IBM Corporation 1996, 2005 All rights reserved. # # Title: idsprod.onconfig # Description: IBM Informix Dynamic Server Configuration Parameters # # Sealy "idstest" Production 64 Bit InformixServer #************************************************************************** # Root Dbspace Configuration ROOTNAME dbs_root # Root dbspace name ROOTPATH /usr/root ROOTOFFSET 0 # Offset of root dbspace into device (Kbytes) ROOTSIZE 180000 # Size of root dbspace (Kbytes) # Disk Mirroring Configuration Parameters MIRROR 0 # Mirroring flag (Yes = 1, No = 0) MIRRORPATH # Path for device containing mirrored root MIRROROFFSET 0 # Offset into mirrored device (Kbytes) # Physical Log Configuration PHYSDBS dbs_root # Location (dbspace) of physical log PHYSFILE 90000 # Physical log file size (Kbytes) # Logical Log Configuration LOGFILES 71 # Number of logical log files LOGSIZE 2000 # Logical log size (Kbytes)LOG_BACKUP_MODE MANUAL # Logical log backup mode (MANUAL, CONT) # Tablespace Tablespace Configuration in Root Dbspace TBLTBLFIRST 0 # First extent size (Kbytes) (0 = default) TBLTBLNEXT 0 # Next extent size (Kbytes) (0 = default) # Security # DBCREATE_PERMISSION: # By default any user can create a database. Uncomment DBCREATE_PERMISSON to # limit database creation to a specific user. Add a new DBCREATE_PERMISSION # line for each permitted user. DBCREATE_PERMISSION informix # DB_LIBRARY_PATH: # When loading a (C or C++) shared object (for a UDR or UDT), IDS checks that # the user-specified path starts with one of the directory prefixes listed in # the comma-separated list of prefixes in DB_LIBRARY_PATH. The string # "$INFORMIXDIR/extend" must be included in DB_LIBRARY_PATH in order for # extensibility and IBM supplied blades to work correctly. # DB_LIBRARY_PATH $INFORMIXDIR/extend # IFX_EXTEND_ROLE: # 0 (or off) => Disable use of EXTEND role to control who can register # external routines. # 1 (or on) => Enable use of EXTEND role to control who can register # external routines. This is the default behaviour. # IFX_EXTEND_ROLE 1 # To control the usage of EXTEND role. # Diagnostics MSGPATH /usr/informix/online.log # System message log file path CONSOLE /usr/informix/console.log # System console message path # To automatically backup logical logs, edit alarmprogram.sh and set # BACKUPLOGS=Y #ALARMPROGRAM /apps/informix/etc/alarmprogram.sh # Alarm program path ALRM_ALL_EVENTS 0 # Triggers ALARMPROGRAM for any event occur TBLSPACE_STATS 1 # Maintain tblspace statistics # System Archive Tape Device TAPEDEV /export/home/informix/zL0tape TAPEBLK 32 # Tape block size (Kbytes) TAPESIZE 100000000 # Maximum amount of data to put on tape (Kbytes) # Log Archive Tape Device #LTAPEDEV /mnt/sealybackup/logs # Log tape device path LTAPEDEV /export/home/informix/ztape.out LTAPEBLK 32 # Log tape block size (Kbytes) LTAPESIZE 100000000 # Max amount of data to put on log tape (Kbytes) # Optical STAGEBLOB # Informix Dynamic Server staging area # System Configuration SERVERNUM 65 # Unique id corresponding to a OnLine instance DBSERVERNAME idstraining # Name of default database server DBSERVERALIASES # List of alternate dbservernames DEADLOCK_TIMEOUT 60 # Max time to wait of lock in distributed env. RESIDENT 0 # Forced residency flag (Yes = 1, No = 0) MULTIPROCESSOR 0 # 0 for single-processor, 1 for multi-processor NUMCPUVPS 1 # Number of user (cpu) vps SINGLE_CPU_VP 0 # If non-zero, limit number of cpu vps to one NOAGE 1 # Process aging AFF_SPROC 0 # Affinity start processor AFF_NPROCS 0 # Affinity number of processors # Shared Memory Parameters LOCKS 100000 # Maximum number of locks NUMAIOVPS 10 # Number of IO vps PHYSBUFF 32 # Physical log buffer size (Kbytes) LOGBUFF 32 # Logical log buffer size (Kbytes) CLEANERS 16 # Number of buffer cleaner processes SHMBASE 0x10a000000 # Shared memory base address SHMVIRTSIZE 60000 # initial virtual shared memory segment size SHMADD 10000 # Size of new shared memory segments (Kbytes) EXTSHMADD 8192 # Size of new extension shared memory segments (Kbytes) SHMTOTAL 0 # Total shared memory (Kbytes). 0=>unlimited CKPTINTVL 300 # Check point interval (in sec) TXTIMEOUT 0x12c # Transaction timeout (in sec) STACKSIZE 64 # Stack size (Kbytes) # Dynamic Logging # DYNAMIC_LOGS: # 2 : server automatically add a new logical log when necessary. (ON) # 1 : notify DBA to add new logical logs when necessary. (ON) # 0 : cannot add logical log on the fly. (OFF) # # When dynamic logging is on, we can have higher values for LTXHWM/LTXEHWM, # because the server can add new logical logs during long transaction rollback. # However, to limit the number of new logical logs being added, LTXHWM/LTXEHWM # can be set to smaller values. # # If dynamic logging is off, LTXHWM/LTXEHWM need to be set to smaller values # to avoid long transaction rollback hanging the server due to lack of logical # log space, i.e. 50/60 or lower. # # In case of system configured with CDR, the difference between LTXHWM and # LTXEHWM should be atleast 30% so that we could minimize log overrun issue. DYNAMIC_LOGS 2 LTXHWM 70 LTXEHWM

Ignore previous post I changed shmvirtsize and got the instace initialized. Thanks for the help.

You have to run the .training script as a <DOT> script otherwise the environment it modifies is a subshell which disappears when the script finishes. So: . ./.training Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) See you at the 2010 IIUG Informix Conference April 25-28, 2010 Overland Park (Kansas City), KS www.iiug.org/conf Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, 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. On Tue, Apr 27, 2010 at 7:35 AM, JAMES MCLARDIE <jmclardie@sealy.com.au>wrote: > Thanks for the responses. I'm my original post I stated that I would like > to > switch between instances using oninit which wasn't quiet accurate. Can > someone > verify if the following is possible and if so does that change anything > with > the configuration not already metioned in the previous replies. > > I have created a executable file called training that contains all > environmet > vairables for the training instance ie onconfig, servernum, servername etc. > > Added new entry to sqlhosts file. > > Copied test onconfig file to create training onconfig file and change a few > parameters. > > Added entry to etc/services file. > > The /usr directory has 15gb of free space where I have created a root > dbspace > and chunk and also a database dbspace and chunk. The majority of space is > in > the database chunk as this is where I want to house the data. > > Now when I log into the test environment I run .training to take me to the > correct environment. I then use dbaccess and have the option to connect to > idstest or idstraining. When selecting idstraining I get message 908: > cannot > connect to database server idstraining. > > Have I missed any steps? > > How can I connect to the training environment without bringing down the > test > database? > > Hope this makes some sense. > > Thanks in advance. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --000e0cd32c16af9380048563ba82