C
ChUIMonster
Guest
Rather than create fixed size extents... after having loaded your .df file the first time: procopy $DLC/empty dbname probkup dbname dbname.pbk (at this point you will want to re-load the .df file if you plan to use this first iteration of the new db...) Then, in the future, restore dbname.pbk on top of the previous iteration of your db rather than creating a new empty database. This will preserve the storage areas and the extent allocations while keeping everything variable length. If your existing process is creating storage areas with prostrct etc this will also allow you to skip those steps. You would only need a new probkup if you add storage areas or if you add enough tables and indexes that the expansion of the areas starts to be noticeable again.
Continue reading...
Continue reading...