Re: Root DBspace confusion

Hi Michael and Mark, Yes, this paragraph does not address what to do when you resize the root dbspace after you've already defined your dbspaces, chunks, etc. This section addresses sizing estimates BEFORE you start the database server the first time. We recommend elsewhere that the physical and logical logs should be in separate dbspaces from the root dbspace for better performance, and I think this paragraph was alluding to that recommendation for the initial sizing. We will clarify this section in the next version of the Administrator's Guide to indicate the following: - this estimate is the initial root dbspace size prior initializing the database server the first time - the initial size of the root dbspace depends on whether or not you plan to store other physical and logical units of storage (such as logs or temp tables) there. If you're expecting a lot of update activity, you might want to start with the logs in separate dbspaces from the root. - if you want to move the logs out of the root dbspace after the database server has been running for a while, use the procedure in "Moving a Logical-Log File to Another Dbspace" [in chapter 20 of 9.2 Admin Guide]. Thanks for the feedback! Virginia Panlasigui Principal Tech Writer At 03:41 PM 11/28/00 , Mark D. Stock wrote: >Michael Hoffman wrote: >> >> Hi all, >> >> A bit of confusion upon reading the Administrator's Guide prior to >> installing IDS 9.2. (After reading the following I went back to the 7.3 >> manual and found the same passage) >> >> In Chapter 14 (Data Storage): >> If you plan to move the physical and logical logs, the initial >> configuration for the root dbspace might differ markedly from >> the final configuration. You can resize the root dbspace after >> you remove the physical and logical logs. However, the root >> dbspace must be large enough for the minimum size configuration >> during disk initialization. >> >> (on page 14-46 in 9.2, 14-32 in 7.3) >> >> Am I mistaken, or is this totally wrong? Doesn't resizing the root dbspace >> entail reinitializing the Database, thus wiping out all data (logspaces >> included)? I figure you can *add* to the root dbspace easily enough, but >> the context of this passage (and my necessity, thus my curiousity) relates >> to *shrinking* the root dbspace size. > >Mmmm, I would say you have a valid point there. It does look like it's >implying that you can reduce the size after you move your logs out. As >you rightly state, you cannot resize the 1st chunk of the rootdbs. > >Cheers, >-- >Mark. > >+----------------------------------------------------------+-----------+ >| Mark D. Stock mailto:mdstock@mydas.freeserve.co.uk |//////// /| >| http://www.informix.com http://www.informixhandbook.com |///// / //| >| http://www.iiug.org +-----------------------------------+//// / ///| >| |This email will self-destruct in |/// / ////| >| |10 sec. If you received this email |// / /////| >| |in error, sorry about the mess. |/ ////////| >+----------------------+-----------------------------------+-----------+ >