IDS Forum

Re: reduce size of root dbspace

Posted By: Art Kagel
Date: Wednesday, 18 July 2012, at 7:45 a.m.

In Response To: Re: reduce size of root dbspace (FRANK J. COMPUTER)

Frank:

Actually best practices is to keep rootdb, logical logs, and physical logs
in three independent dbspaces preferably on separate physical disk
structures and separate from the data chunks. This is because the rootdb
space is always busy and any write to the data will also write to the
logical logs while the first write to any page will also cause a physical
log record to be written.

Note that the logical logs rarely grow. They are <almost> fixed. Yes, you
can configure the engine to automatically add more logs if all logs fill
up, however, since you should be archiving the logical logs either
constantly (ontape -c) or as they fill (using the ALARMPROGRAM to run
ontape -a when one fills) and given that filling the logs to the high water
mark will cause transactions to rollback allowing logs to be reused, this
is a rare thing. At any rate these automatic logs are created in the
rootdb space regardless of where you move the manually created logical log
to, so...

Art

Art S. Kagel
Advanced DataTools (www.advancedatatools.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 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 Wed, Jul 18, 2012 at 2:47 AM, FRANK J. COMPUTER
<frank_in_pr@hotmail.com>wrote:

> Hello again, Prajakta,
>
> As you may already know, I'm also testing 11.70.TC5DE (32-bit WinVista
> SP2).
> If I recall correctly, you're testing FC5 (64-bit)?
>
> >How to reduce size of root dbspace in Informix 11.7 ?
> >Currently I have moved logical logs, physical logs, databases, temporary
> >dbspace all out of root space.
> >Currently only 6% of my root dbspace is used after importing required
> >databases and there is slim chance that the database will grow in size as
> it
> >is for evaluation only and I can reduce crap data if more space is
> required.
>
> IDS is new to me, but FWIW: Although you're just testing 11.70, my common
> sense tells me that you should keep the logs in rootdbs and never shrink
> its
> size because logs can grow very large over time, the server also needs
> additional space for other internal administration, etc. When installing
> 11.70, I'm assuming you chose to define a customized instance?, chose how
> much
> disk space, transaction logging yes/no, etc. etc., so the install program
> calculated a certain size for rootdbs. I wouldn't touch it!.. I think if
> rootdbs gets messed up, the server crashes and/or you could loose
> everything,
> unless you have a full backup of the folder that holds the dbspaces?
>
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>

--14dae9340e1bd6439004c5193191

Messages In This Thread

• reduce size of root dbspace
  PRAJAKTA CHIKHALE -- Wednesday, 18 July 2012, at 2:08 a.m.
  • Re: reduce size of root dbspace
    FRANK J. COMPUTER -- Wednesday, 18 July 2012, at 2:47 a.m.
    • Re: reduce size of root dbspace
      FRANK J. COMPUTER -- Wednesday, 18 July 2012, at 3:00 a.m.
    • Re: reduce size of root dbspace
      Art Kagel -- Wednesday, 18 July 2012, at 7:45 a.m.
      • Re: reduce size of root dbspace
        FRANK J. COMPUTER -- Wednesday, 18 July 2012, at 9:42 a.m.
        • RE: reduce size of root dbspace
          Paul Watson -- Wednesday, 18 July 2012, at 9:47 a.m.
          • RE: reduce size of root dbspace
            Fernando Nunes -- Wednesday, 18 July 2012, at 9:58 a.m.
          • Re: RE: reduce size of root dbspace
            FRANK J. COMPUTER -- Wednesday, 18 July 2012, at 11:07 a.m.
            • RE: RE: reduce size of root dbspace
              Paul Watson -- Wednesday, 18 July 2012, at 11:12 a.m.
            • Re: RE: reduce size of root dbspace
              Fernando Nunes -- Wednesday, 18 July 2012, at 11:13 a.m.
            • Re: RE: reduce size of root dbspace
              Art Kagel -- Wednesday, 18 July 2012, at 12:49 p.m.
        • Re: reduce size of root dbspace
          Art Kagel -- Wednesday, 18 July 2012, at 9:59 a.m.
  • Re: reduce size of root dbspace
    Art Kagel -- Wednesday, 18 July 2012, at 7:40 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.