IDS Forum

RE: Adding space to rootdbs

Posted By: Simmons, Keith
Date: Monday, 25 April 2005, at 8:21 a.m.

In Response To: Re: Adding space to rootdbs (Jack Parker)

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

Messages In This Thread

• Adding space to rootdbs
  Peter J Diaz de Leon -- Thursday, 14 April 2005, at 3:20 p.m.
  • Re: Adding space to rootdbs
    Ravi T -- Thursday, 14 April 2005, at 5:46 p.m.
  • RE: Adding space to rootdbs
    Simmons, Keith -- Friday, 15 April 2005, at 4:11 a.m.
    • RE: Adding space to rootdbs
      Meza, Silvana -- Friday, 15 April 2005, at 9:54 a.m.
      • Re: Adding space to rootdbs
        Bill Hamilton -- Friday, 22 April 2005, at 7:01 p.m.
        • Re: Adding space to rootdbs
          Jack Parker -- Saturday, 23 April 2005, at 7:22 a.m.
          • RE: Adding space to rootdbs
            Simmons, Keith -- Monday, 25 April 2005, at 8:21 a.m.
            • Mirrors (was Adding space to rootdbs )
              Bill Hamilton -- Monday, 2 May 2005, at 9:58 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.