Adding space to rootdbs

I have a root dbspace that is 30MB and have less than 20% free space. Are there any issues to just adding another chunk to the rootdbs? I have added chunks to other dbspaces before but never to a root dbspace. We plan on upgrading this server to IDS 10 later this year. Currently it is IDS 9.21.UC4 running on Linux. Thanks Peter ---------- CONFIDENTIALITY NOTICE: This e-mail message, including any attachments,is for the sole use of the intended recipient(s), even if addressed incorrectly, and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy or delete all copies of the original message and all attachments, including deletion from the trash or equivalent folder. Thank you.

I have added space to existing rootdbs on other versions of informix without any issue. Ravi. "Peter J Dia...." <pdiazdeleon@infinityhealthcare.com> wrote: I have a root dbspace that is 30MB and have less than 20% free space. Are there any issues to just adding another chunk to the rootdbs? I have added chunks to other dbspaces before but never to a root dbspace. We plan on upgrading this server to IDS 10 later this year. Currently it is IDS 9.21.UC4 running on Linux. Thanks Peter ---------- CONFIDENTIALITY NOTICE: This e-mail message, including any attachments,is for the sole use of the intended recipient(s), even if addressed incorrectly, and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy or delete all copies of the original message and all attachments, including deletion from the trash or equivalent folder. Thank you. --------------------------------- Do you Yahoo!? Read only the mail you want - Yahoo! Mail SpamGuard.

Peter There is no problem with adding chunks to rootdbs the same way as any other. What you might want to investigate is why your rootdbs is getting full (or is so full). Have you created a specific dbspace for your physical log and moving it? have you created a specific space for your logical log files and relocated them? Have you created temper dbspaces to hold your temp tables and sort files? Were any of your databases (except the system ones) created in the rootdbs (the default location)? have you got any large table in the rootdbs (oncheck -pe) that are growing and could be re-located? Keith -> -----Original Message----- -> From: forum.subscriber@iiug.org [mailto:forum.subscriber@iiug.org]On -> Behalf Of Peter J Dia.... -> Sent: Thursday, April 14, 2005 8:21 PM -> To: ids@iiug.org -> Subject: Adding space to rootdbs [4712] -> -> -> I have a root dbspace that is 30MB and have less than 20% -> free space. -> Are there any issues to just adding -> another chunk to the rootdbs? I have added chunks to other dbspaces -> before but never to a root dbspace. -> We plan on upgrading this server to IDS 10 later this year. -> Currently -> it is IDS 9.21.UC4 running on Linux. -> -> Thanks -> Peter -> -> -> -> ---------- -> CONFIDENTIALITY NOTICE: This e-mail message, including any -> attachments,is for the sole use of the intended -> recipient(s), even if addressed incorrectly, and may contain -> confidential and privileged information. Any unauthorized -> review, use, disclosure or distribution is prohibited. If -> you are not the intended recipient, please contact the -> sender by reply e-mail and destroy or delete all copies of -> the original message and all attachments, including deletion -> from the trash or equivalent folder. Thank you. -> -> -> ******************************************************************************** ** This message is sent in strict confidence for the addressee only. It may contain legally privileged information. The contents are not to be disclosed to anyone other than the addressee. Unauthorised recipients are requested to preserve this confidentiality and to advise the sender immediately of any error in transmission. This footnote also confirms that this email message has been swept for the presence of computer viruses, however we cannot guarantee that this message is free from such problems. ******************************************************************************** **

Great answer Keith, you cover it all. :0) -----Original Message----- From: Simmons, Keith [mailto:keith.simmons@office2office.biz] Sent: Friday, April 15, 2005 3:13 AM To: ids@iiug.org Subject: RE: Adding space to rootdbs [4721] Peter There is no problem with adding chunks to rootdbs the same way as any other. What you might want to investigate is why your rootdbs is getting full (or is so full). Have you created a specific dbspace for your physical log and moving it? have you created a specific space for your logical log files and relocated them? Have you created temper dbspaces to hold your temp tables and sort files? Were any of your databases (except the system ones) created in the rootdbs (the default location)? have you got any large table in the rootdbs (oncheck -pe) that are growing and could be re-located? Keith -> -----Original Message----- -> From: forum.subscriber@iiug.org [mailto:forum.subscriber@iiug.org]On -> Behalf Of Peter J Dia.... -> Sent: Thursday, April 14, 2005 8:21 PM -> To: ids@iiug.org -> Subject: Adding space to rootdbs [4712] -> -> -> I have a root dbspace that is 30MB and have less than 20% -> free space. -> Are there any issues to just adding -> another chunk to the rootdbs? I have added chunks to other dbspaces -> before but never to a root dbspace. -> We plan on upgrading this server to IDS 10 later this year. -> Currently -> it is IDS 9.21.UC4 running on Linux. -> -> Thanks -> Peter -> -> -> -> ---------- -> CONFIDENTIALITY NOTICE: This e-mail message, including any -> attachments,is for the sole use of the intended -> recipient(s), even if addressed incorrectly, and may contain -> confidential and privileged information. Any unauthorized -> review, use, disclosure or distribution is prohibited. If -> you are not the intended recipient, please contact the -> sender by reply e-mail and destroy or delete all copies of -> the original message and all attachments, including deletion -> from the trash or equivalent folder. Thank you. -> -> -> **************************************************************************** ****** This message is sent in strict confidence for the addressee only. It may contain legally privileged information. The contents are not to be disclosed to anyone other than the addressee. Unauthorised recipients are requested to preserve this confidentiality and to advise the sender immediately of any error in transmission. This footnote also confirms that this email message has been swept for the presence of computer viruses, however we cannot guarantee that this message is free from such problems. **************************************************************************** ******

My problem is that I am only given one drive to work with. It is mirrored by Windows 2003, so it is actually 2 drives, but appears as one. I went to the trouble to allocate spaces for everything, as Informix recommends, but when the machine was hit by hackers, and I had to reload the box, I used 6gb rootspace and mirrored it (on the same drive). The space is less than 1/3 used after 2 years of running. This is all OLTP. There are about 3000 columns in about 300 tables. Would it have done any good to have separate spaces when there is only one (physical) drive ? ----- Original Message ----- From: "Meza, Silvana" <smeza@fheg.follett.com> To: <ids@iiug.org> Sent: Friday, April 15, 2005 8:54 AM Subject: RE: Adding space to rootdbs [4724] > Great answer Keith, you cover it all. > :0) > > -----Original Message----- > From: Simmons, Keith [mailto:keith.simmons@office2office.biz] > Sent: Friday, April 15, 2005 3:13 AM > To: ids@iiug.org > Subject: RE: Adding space to rootdbs [4721] > > > Peter > > There is no problem with adding chunks to rootdbs the same way as any other. > What you might want to investigate is why your rootdbs is getting full (or > is so full). Have you created a specific dbspace for your physical log and > moving it? have you created a specific space for your logical log files and > relocated them? Have you created temper dbspaces to hold your temp tables > and sort files? Were any of your databases (except the system ones) created > in the rootdbs (the default location)? have you got any large table in the > rootdbs (oncheck -pe) that are growing and could be re-located? > > Keith > > -> -----Original Message----- > -> From: forum.subscriber@iiug.org [mailto:forum.subscriber@iiug.org]On > -> Behalf Of Peter J Dia.... > -> Sent: Thursday, April 14, 2005 8:21 PM > -> To: ids@iiug.org > -> Subject: Adding space to rootdbs [4712] > -> > -> > -> I have a root dbspace that is 30MB and have less than 20% > -> free space. > -> Are there any issues to just adding > -> another chunk to the rootdbs? I have added chunks to other dbspaces > -> before but never to a root dbspace. > -> We plan on upgrading this server to IDS 10 later this year. > -> Currently > -> it is IDS 9.21.UC4 running on Linux. > -> > -> Thanks > -> Peter > -> > -> > -> > -> ---------- > -> CONFIDENTIALITY NOTICE: This e-mail message, including any > -> attachments,is for the sole use of the intended > -> recipient(s), even if addressed incorrectly, and may contain > -> confidential and privileged information. Any unauthorized > -> review, use, disclosure or distribution is prohibited. If > -> you are not the intended recipient, please contact the > -> sender by reply e-mail and destroy or delete all copies of > -> the original message and all attachments, including deletion > -> from the trash or equivalent folder. Thank you. > -> > -> > -> > > **************************************************************************** > ****** > This message is sent in strict confidence for the addressee only. It may > contain legally privileged information. The contents are not to be disclosed > to anyone other than the addressee. Unauthorised recipients are requested to > preserve this confidentiality and to advise the sender immediately of any > error in transmission. This footnote also confirms that this email message > has been swept for the presence of computer viruses, however we cannot > guarantee that this message is free from such problems. > **************************************************************************** > ****** > > > > > __________ NOD32 1.1063 (20050415) Information __________ > > This message was checked by NOD32 antivirus system. > http://www.nod32.com > > > > __________ NOD32 1.1063 (20050415) Information __________ > > This message was checked by NOD32 antivirus system. > http://www.nod32.com > >

From a logical aspect, yes. From a physical and common sense aspect you've done the right thing. j. ----- Original Message ----- From: "Bill Hamilton" <laidback@finsco.com> To: <ids@iiug.org> Sent: Friday, April 22, 2005 8:01 PM Subject: Re: Adding space to rootdbs [4778] > My problem is that I am only given one drive to work with. > It is mirrored by Windows 2003, so it is actually 2 drives, but appears as > one. > > I went to the trouble to allocate spaces for everything, as Informix > recommends, > but when the machine was hit by hackers, and I had to reload the box, > I used 6gb rootspace and mirrored it (on the same drive). > The space is less than 1/3 used after 2 years of running. > This is all OLTP. > There are about 3000 columns in about 300 tables. > > Would it have done any good to have separate spaces when there is only > one (physical) drive ? > > > ----- Original Message ----- > From: "Meza, Silvana" <smeza@fheg.follett.com> > To: <ids@iiug.org> > Sent: Friday, April 15, 2005 8:54 AM > Subject: RE: Adding space to rootdbs [4724] > > > > Great answer Keith, you cover it all. > > :0) > > > > -----Original Message----- > > From: Simmons, Keith [mailto:keith.simmons@office2office.biz] > > Sent: Friday, April 15, 2005 3:13 AM > > To: ids@iiug.org > > Subject: RE: Adding space to rootdbs [4721] > > > > > > Peter > > > > There is no problem with adding chunks to rootdbs the same way as any > other. > > What you might want to investigate is why your rootdbs is getting full (or > > is so full). Have you created a specific dbspace for your physical log and > > moving it? have you created a specific space for your logical log files > and > > relocated them? Have you created temper dbspaces to hold your temp tables > > and sort files? Were any of your databases (except the system ones) > created > > in the rootdbs (the default location)? have you got any large table in the > > rootdbs (oncheck -pe) that are growing and could be re-located? > > > > Keith > > > > -> -----Original Message----- > > -> From: forum.subscriber@iiug.org [mailto:forum.subscriber@iiug.org]On > > -> Behalf Of Peter J Dia.... > > -> Sent: Thursday, April 14, 2005 8:21 PM > > -> To: ids@iiug.org > > -> Subject: Adding space to rootdbs [4712] > > -> > > -> > > -> I have a root dbspace that is 30MB and have less than 20% > > -> free space. > > -> Are there any issues to just adding > > -> another chunk to the rootdbs? I have added chunks to other dbspaces > > -> before but never to a root dbspace. > > -> We plan on upgrading this server to IDS 10 later this year. > > -> Currently > > -> it is IDS 9.21.UC4 running on Linux. > > -> > > -> Thanks > > -> Peter > > -> > > -> > > -> > > -> ---------- > > -> CONFIDENTIALITY NOTICE: This e-mail message, including any > > -> attachments,is for the sole use of the intended > > -> recipient(s), even if addressed incorrectly, and may contain > > -> confidential and privileged information. Any unauthorized > > -> review, use, disclosure or distribution is prohibited. If > > -> you are not the intended recipient, please contact the > > -> sender by reply e-mail and destroy or delete all copies of > > -> the original message and all attachments, including deletion > > -> from the trash or equivalent folder. Thank you. > > -> > > -> > > -> > > > > > **************************************************************************** > > ****** > > This message is sent in strict confidence for the addressee only. It may > > contain legally privileged information. The contents are not to be > disclosed > > to anyone other than the addressee. Unauthorised recipients are requested > to > > preserve this confidentiality and to advise the sender immediately of any > > error in transmission. This footnote also confirms that this email message > > has been swept for the presence of computer viruses, however we cannot > > guarantee that this message is free from such problems. > > > **************************************************************************** > > ****** > > > > > > > > > > __________ NOD32 1.1063 (20050415) Information __________ > > > > This message was checked by NOD32 antivirus system. > > http://www.nod32.com > > > > > > > > __________ NOD32 1.1063 (20050415) Information __________ > > > > This message was checked by NOD32 antivirus system. > > http://www.nod32.com > > > > > > >

Not sure I agree totally :-) Even with one drive you will get some protection (from rootdbs filling up) if you separate logical logs out and data. Mirroring to the same drive is literally a waste of space, a sense of security and a performance hit!. Windows is already giving you the protection against drive loss and the (minimal) read performance, why inflict four writes on the system when onlty two are needed !! Keith -> -----Original Message----- -> From: Jack Parker [mailto:vze2qjg5@verizon.net] -> Sent: Saturday, April 23, 2005 12:22 PM -> To: ids@iiug.org -> Subject: Re: Adding space to rootdbs [4782] -> -> -> From a logical aspect, yes. From a physical and common -> sense aspect you've -> done the right thing. -> -> j. -> -> ----- Original Message ----- -> From: "Bill Hamilton" <laidback@finsco.com> -> To: <ids@iiug.org> -> Sent: Friday, April 22, 2005 8:01 PM -> Subject: Re: Adding space to rootdbs [4778] -> -> -> > My problem is that I am only given one drive to work with. -> > It is mirrored by Windows 2003, so it is actually 2 -> drives, but appears as -> > one. -> > -> > I went to the trouble to allocate spaces for everything, -> as Informix -> > recommends, -> > but when the machine was hit by hackers, and I had to -> reload the box, -> > I used 6gb rootspace and mirrored it (on the same drive). -> > The space is less than 1/3 used after 2 years of running. -> > This is all OLTP. -> > There are about 3000 columns in about 300 tables. -> > -> > Would it have done any good to have separate spaces when -> there is only -> > one (physical) drive ? -> > -> > -> > ----- Original Message ----- -> > From: "Meza, Silvana" <smeza@fheg.follett.com> -> > To: <ids@iiug.org> -> > Sent: Friday, April 15, 2005 8:54 AM -> > Subject: RE: Adding space to rootdbs [4724] -> > -> > -> > > Great answer Keith, you cover it all. -> > > :0) -> > > -> > > -----Original Message----- -> > > From: Simmons, Keith [mailto:keith.simmons@office2office.biz] -> > > Sent: Friday, April 15, 2005 3:13 AM -> > > To: ids@iiug.org -> > > Subject: RE: Adding space to rootdbs [4721] -> > > -> > > -> > > Peter -> > > -> > > There is no problem with adding chunks to rootdbs the -> same way as any -> > other. -> > > What you might want to investigate is why your rootdbs -> is getting full -> (or -> > > is so full). Have you created a specific dbspace for -> your physical log -> and -> > > moving it? have you created a specific space for your -> logical log files -> > and -> > > relocated them? Have you created temper dbspaces to hold -> your temp -> tables -> > > and sort files? Were any of your databases (except the -> system ones) -> > created -> > > in the rootdbs (the default location)? have you got any -> large table in -> the -> > > rootdbs (oncheck -pe) that are growing and could be re-located? -> > > -> > > Keith -> > > -> > > -> -----Original Message----- -> > > -> From: forum.subscriber@iiug.org -> [mailto:forum.subscriber@iiug.org]On -> > > -> Behalf Of Peter J Dia.... -> > > -> Sent: Thursday, April 14, 2005 8:21 PM -> > > -> To: ids@iiug.org -> > > -> Subject: Adding space to rootdbs [4712] -> > > -> -> > > -> -> > > -> I have a root dbspace that is 30MB and have less than 20% -> > > -> free space. -> > > -> Are there any issues to just adding -> > > -> another chunk to the rootdbs? I have added chunks to -> other dbspaces -> > > -> before but never to a root dbspace. -> > > -> We plan on upgrading this server to IDS 10 later this year. -> > > -> Currently -> > > -> it is IDS 9.21.UC4 running on Linux. -> > > -> -> > > -> Thanks -> > > -> Peter -> > > -> -> > > -> -> > > -> -> > > -> ---------- -> > > -> CONFIDENTIALITY NOTICE: This e-mail message, including any -> > > -> attachments,is for the sole use of the intended -> > > -> recipient(s), even if addressed incorrectly, and may contain -> > > -> confidential and privileged information. Any unauthorized -> > > -> review, use, disclosure or distribution is prohibited. If -> > > -> you are not the intended recipient, please contact the -> > > -> sender by reply e-mail and destroy or delete all copies of -> > > -> the original message and all attachments, including deletion -> > > -> from the trash or equivalent folder. Thank you. -> > > -> -> > > -> -> > > -> -> > > -> > > -> > -> ************************************************************* -> *************** -> > > ****** -> > > This message is sent in strict confidence for the -> addressee only. It -> may -> > > contain legally privileged information. The contents are -> not to be -> > disclosed -> > > to anyone other than the addressee. Unauthorised recipients are -> requested -> > to -> > > preserve this confidentiality and to advise the sender -> immediately of -> any -> > > error in transmission. This footnote also confirms that -> this email -> message -> > > has been swept for the presence of computer viruses, -> however we cannot -> > > guarantee that this message is free from such problems. -> > > -> > -> ************************************************************* -> *************** -> > > ****** -> > > -> > > -> > > -> > > -> > > __________ NOD32 1.1063 (20050415) Information __________ -> > > -> > > This message was checked by NOD32 antivirus system. -> > > http://www.nod32.com -> > > -> > > -> > > -> > > __________ NOD32 1.1063 (20050415) Information __________ -> > > -> > > This message was checked by NOD32 antivirus system. -> > > http://www.nod32.com -> > > -> > > -> > -> > -> > -> -> ->

I agree that it is a peformance hit, but the Windows mirror just protects you from a drive crash. If a space goes bad, you get 2 copies of the space that is down. You must resort to a restore. ;-{ ----- Original Message ----- From: "Simmons, Keith" <keith.simmons@office2office.biz> To: <ids@iiug.org> Sent: Monday, April 25, 2005 7:21 AM Subject: RE: Adding space to rootdbs [4794] > Not sure I agree totally :-) > Even with one drive you will get some protection (from rootdbs > filling up) if you separate logical logs out and data. > Mirroring to the same drive is literally a waste of space, a > sense of security and a performance hit!. > Windows is already giving you the protection against drive loss > and the (minimal) read performance, why inflict four writes on > the system when onlty two are needed !! > > Keith > > -> -----Original Message----- > -> From: Jack Parker [mailto:vze2qjg5@verizon.net] > -> Sent: Saturday, April 23, 2005 12:22 PM > -> To: ids@iiug.org > -> Subject: Re: Adding space to rootdbs [4782] > -> > -> > -> From a logical aspect, yes. From a physical and common > -> sense aspect you've > -> done the right thing. > -> > -> j. > -> > -> ----- Original Message ----- > -> From: "Bill Hamilton" <laidback@finsco.com> > -> To: <ids@iiug.org> > -> Sent: Friday, April 22, 2005 8:01 PM > -> Subject: Re: Adding space to rootdbs [4778] > -> > -> > -> > My problem is that I am only given one drive to work with. > -> > It is mirrored by Windows 2003, so it is actually 2 > -> drives, but appears as > -> > one. > -> > > -> > I went to the trouble to allocate spaces for everything, > -> as Informix > -> > recommends, > -> > but when the machine was hit by hackers, and I had to > -> reload the box, > -> > I used 6gb rootspace and mirrored it (on the same drive). > -> > The space is less than 1/3 used after 2 years of running. > -> > This is all OLTP. > -> > There are about 3000 columns in about 300 tables. > -> > > -> > Would it have done any good to have separate spaces when > -> there is only > -> > one (physical) drive ? > -> > > -> > > -> > ----- Original Message ----- > -> > From: "Meza, Silvana" <smeza@fheg.follett.com> > -> > To: <ids@iiug.org> > -> > Sent: Friday, April 15, 2005 8:54 AM > -> > Subject: RE: Adding space to rootdbs [4724] > -> > > -> > > -> > > Great answer Keith, you cover it all. > -> > > :0) > -> > > > -> > > -----Original Message----- > -> > > From: Simmons, Keith [mailto:keith.simmons@office2office.biz] > -> > > Sent: Friday, April 15, 2005 3:13 AM > -> > > To: ids@iiug.org > -> > > Subject: RE: Adding space to rootdbs [4721] > -> > > > -> > > > -> > > Peter > -> > > > -> > > There is no problem with adding chunks to rootdbs the > -> same way as any > -> > other. > -> > > What you might want to investigate is why your rootdbs > -> is getting full > -> (or > -> > > is so full). Have you created a specific dbspace for > -> your physical log > -> and > -> > > moving it? have you created a specific space for your > -> logical log files > -> > and > -> > > relocated them? Have you created temper dbspaces to hold > -> your temp > -> tables > -> > > and sort files? Were any of your databases (except the > -> system ones) > -> > created > -> > > in the rootdbs (the default location)? have you got any > -> large table in > -> the > -> > > rootdbs (oncheck -pe) that are growing and could be re-located? > -> > > > -> > > Keith > -> > > > -> > > -> -----Original Message----- > -> > > -> From: forum.subscriber@iiug.org > -> [mailto:forum.subscriber@iiug.org]On > -> > > -> Behalf Of Peter J Dia.... > -> > > -> Sent: Thursday, April 14, 2005 8:21 PM > -> > > -> To: ids@iiug.org > -> > > -> Subject: Adding space to rootdbs [4712] > -> > > -> > -> > > -> > -> > > -> I have a root dbspace that is 30MB and have less than 20% > -> > > -> free space. > -> > > -> Are there any issues to just adding > -> > > -> another chunk to the rootdbs? I have added chunks to > -> other dbspaces > -> > > -> before but never to a root dbspace. > -> > > -> We plan on upgrading this server to IDS 10 later this year. > -> > > -> Currently > -> > > -> it is IDS 9.21.UC4 running on Linux. > -> > > -> > -> > > -> Thanks > -> > > -> Peter > -> > > -> > -> > > -> > -> > > -> > -> > > -> ---------- > -> > > -> CONFIDENTIALITY NOTICE: This e-mail message, including any > -> > > -> attachments,is for the sole use of the intended > -> > > -> recipient(s), even if addressed incorrectly, and may contain > -> > > -> confidential and privileged information. Any unauthorized > -> > > -> review, use, disclosure or distribution is prohibited. If > -> > > -> you are not the intended recipient, please contact the > -> > > -> sender by reply e-mail and destroy or delete all copies of > -> > > -> the original message and all attachments, including deletion > -> > > -> from the trash or equivalent folder. Thank you. > -> > > -> > -> > > -> > -> > > -> > -> > > > -> > > > -> > > -> ************************************************************* > -> *************** > -> > > ****** > -> > > This message is sent in strict confidence for the > -> addressee only. It > -> may > -> > > contain legally privileged information. The contents are > -> not to be > -> > disclosed > -> > > to anyone other than the addressee. Unauthorised recipients are > -> requested > -> > to > -> > > preserve this confidentiality and to advise the sender > -> immediately of > -> any > -> > > error in transmission. This footnote also confirms that > -> this email > -> message > -> > > has been swept for the presence of computer viruses, > -> however we cannot > -> > > guarantee that this message is free from such problems. > -> > > > -> > > -> ************************************************************* > -> *************** > -> > > ****** > -> > > > -> > > > -> > > > -> > > > -> > > __________ NOD32 1.1063 (20050415) Information __________ > -> > > > -> > > This message was checked by NOD32 antivirus system. > -> > > http://www.nod32.com > -> > > > -> > > > -> > > > -> > > __________ NOD32 1.1063 (20050415) Information __________ > -> > > > -> > > This message was checked by NOD32 antivirus system. > -> > > http://www.nod32.com > -> > > > -> > > > -> > > -> > > -> > > -> > -> > -> > > > __________ NOD32 1.1076 (20050424) Information __________ > > This message was checked by NOD32 antivirus system. > http://www.nod32.com > > > > __________ NOD32 1.1076 (20050424) Information __________ > > This message was checked by NOD32 antivirus system. > http://www.nod32.com > >