Check list to Add a new instance

Hi, I have a suse-linux and Ids 1170fc8 environment. I have 2 Instances and I like to add another one. My question is, what do I need to do ? I think, I have to do the next things: - create another onconfig file with the name of the new server and alias. - define the new service port in /etc/services. - add the new server in sqlhost file. - define a directory to put the dbspace files. - execute an oninit -i. What else do I need to do ? Thanks in advance.

A few things come to mind, which you may have already thought of: - Create a chunk for your root dbspace - Modify the new onconfig file to reference the new chunk and different informix log file/console file (and check to make sure you're not overwriting anything referenced by the other instances) - Modify the new onconfig and put in a different DBSERVERNUM - Modify the profile, or script you use to give you an option to set the environment for the new instance - Make sure that you review your backups so that they will be kept separate - Make sure that you have the correct environment variables set when you initialize the instance Mike Walker Advanced DataTools Corporation -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Jorge Valenzuela Sent: Sunday, April 17, 2016 7:24 AM To: ids@iiug.org Subject: Check list to Add a new instance [36981] Hi, I have a suse-linux and Ids 1170fc8 environment. I have 2 Instances and I like to add another one. My question is, what do I need to do ? I think, I have to do the next things: - create another onconfig file with the name of the new server and alias. - define the new service port in /etc/services. - add the new server in sqlhost file. - define a directory to put the dbspace files. - execute an oninit -i. What else do I need to do ? Thanks in advance. **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.

Just two more things: 1. set SERVERNUM to a unique number (at least unique on that machine). 2. Set ROOTPATH to a unique file 3. Create the ROOTPATH file 4. Optionally set the TBLTBLFIRST and TBLTBLNEXT parameters in the ONCONFIG file to set the extent sizing for the tablespace tablespace (partition header page table) in the root dbspace (since you will not be running onspaces to create this. The defaults hold information for about 500 entities, so if you expect the root dbspace to have to hold more than that you should set these appropriately. (Ideally the root dbspace only holds the system databases sysmaster and sysutils - even sysadmin should be moved out after initialization in a perfect world.) 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. On Sun, Apr 17, 2016 at 9:23 AM, Jorge Valenzuela <jorgervt@gmail.com> wrote: > Hi, > I have a suse-linux and > Ids 1170fc8 environment. I have 2 Instances and I like to add another one. > > My question is, what do I need to do ? > > I think, I have to do the next things: > > - create another onconfig file with the name of the new server and alias. > - define the new service port in /etc/services. > - add the new server in sqlhost file. > - define a directory to put the dbspace files. > - execute an oninit -i. > > What else do I need to do ? > > Thanks in advance. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --047d7bdc08a6428b6a0530afd0df

I prefer to change the name/path of the online.log (and online.con, although there's not much there) file so as to have a unique online.log for each instance. -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art Kagel Sent: Sunday, April 17, 2016 11:23 AM To: ids@iiug.org Subject: Re: Check list to Add a new instance [36983] Just two more things: 1. set SERVERNUM to a unique number (at least unique on that machine). 2. Set ROOTPATH to a unique file 3. Create the ROOTPATH file 4. Optionally set the TBLTBLFIRST and TBLTBLNEXT parameters in the ONCONFIG file to set the extent sizing for the tablespace tablespace (partition header page table) in the root dbspace (since you will not be running onspaces to create this. The defaults hold information for about 500 entities, so if you expect the root dbspace to have to hold more than that you should set these appropriately. (Ideally the root dbspace only holds the system databases sysmaster and sysutils - even sysadmin should be moved out after initialization in a perfect world.) 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. On Sun, Apr 17, 2016 at 9:23 AM, Jorge Valenzuela <jorgervt@gmail.com> wrote: > Hi, > I have a suse-linux and > Ids 1170fc8 environment. I have 2 Instances and I like to add another one. > > My question is, what do I need to do ? > > I think, I have to do the next things: > > - create another onconfig file with the name of the new server and alias. > - define the new service port in /etc/services. > - add the new server in sqlhost file. > - define a directory to put the dbspace files. > - execute an oninit -i. > > What else do I need to do ? > > Thanks in advance. > > > > **************************************************************************** *** > Forum Note: Use "Reply" to post a response in the discussion forum. > > --047d7bdc08a6428b6a0530afd0df **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum. -- *CONFIDENTIALITY NOTICE*: This email communication may contain private, confidential, or legally privileged information intended for the sole use of the designated and/or duly authorized recipient(s). If you are not the intended recipient or have received this email in error, please notify the sender immediately by email and permanently delete all copies of this email including all attachments without reading them. If you are the intended recipient, secure the contents in a manner that conforms to all applicable state and/or federal requirements related to privacy and confidentiality of such information.

Good point John! Same for the CONSOLE log unless you are directing it to /dev/null or /dev/console. 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. On Mon, Apr 18, 2016 at 5:13 PM, John Fahey <jfahey@mandm.net> wrote: > I prefer to change the name/path of the online.log (and online.con, > although > there's not much there) file so > as to have a unique online.log for each instance. > > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art > Kagel > Sent: Sunday, April 17, 2016 11:23 AM > To: ids@iiug.org > Subject: Re: Check list to Add a new instance [36983] > > Just two more things: > > 1. set SERVERNUM to a unique number (at least unique on that machine). > > 2. Set ROOTPATH to a unique file > > 3. Create the ROOTPATH file > > 4. Optionally set the TBLTBLFIRST and TBLTBLNEXT parameters in the > > ONCONFIG file to set the extent sizing for the tablespace tablespace > > (partition header page table) in the root dbspace (since you will not be > > running onspaces to create this. The defaults hold information for about > > 500 entities, so if you expect the root dbspace to have to hold more than > > that you should set these appropriately. (Ideally the root dbspace only > > holds the system databases sysmaster and sysutils - even sysadmin should be > > moved out after initialization in a perfect world.) > > 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. > > On Sun, Apr 17, 2016 at 9:23 AM, Jorge Valenzuela <jorgervt@gmail.com> > wrote: > > > Hi, > > I have a suse-linux and > > Ids 1170fc8 environment. I have 2 Instances and I like to add another > one. > > > > > My question is, what do I need to do ? > > > > I think, I have to do the next things: > > > > - create another onconfig file with the name of the new server and alias. > > - define the new service port in /etc/services. > > - add the new server in sqlhost file. > > - define a directory to put the dbspace files. > > - execute an oninit -i. > > > > What else do I need to do ? > > > > Thanks in advance. > > > > > > > > > > **************************************************************************** > *** > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --047d7bdc08a6428b6a0530afd0df > > > **************************************************************************** > *** > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- > > *CONFIDENTIALITY NOTICE*: This email communication may contain private, > confidential, or legally privileged information intended for the sole use > of the designated and/or duly authorized recipient(s). If you are not the > intended recipient or have received this email in error, please notify the > sender immediately by email and permanently delete all copies of this email > including all attachments without reading them. If you are the intended > recipient, secure the contents in a manner that conforms to all applicable > state and/or federal requirements related to privacy and confidentiality of > such information. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --047d7bfeab62c5b20c0530c8ed83