That is going to be excellent for scheduled maintenance On Thu, 13 May 2021, 2:30 pm A. Razzak Memon, <[email protected]> wrote:
> Thursday, May 13, 2021 > > Tip of the Day: Enhanced UNLOAD Parameters for Partial Database Rebuilds > Product.......: R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5) > Build.........: 10.5.3.20513 or higher > Sections......: Commands > Keywords......: UNLOAD, STRUCTURE, DATA, NOSCHEMA, Database, Rebuild > > Did you know the UNLOAD command has been enhanced to allow partial > unloading for "all" database areas, to better evaluate the rebuild > process? > > The UNLOAD STRUCTURE FOR DATABASE command was implemented to unload > the character settings and the CREATE SCHEMA command. > > The UNLOAD DATA NOSCHEMA command was implemented to remove character > setting portions commands before unloading the data. > > The following performs a database unload into three separate parts, > to evaluate the rebuild process for flaws in the database stability/ > integrity. > > -- Unload the structure for the database and tables as Part 1 > OUTPUT DB_Part1.rmd > UNLOAD STRUCTURE FOR DATABASE > UNLOAD STRUCTURE FOR TABLEDEF > OUTPUT SCREEN > > -- Unload the data from the tables as Part 2 > OUTPUT DB_Part2.rmd > UNLOAD DATA NOSCHEMA > OUTPUT SCREEN > > -- Unload the remaining structure as Part 3 > OUTPUT DB_Part3.rmd > UNLOAD STRUCTURE FOR VIEWS > UNLOAD STRUCTURE FOR INDEXES > UNLOAD STRUCTURE FOR ACCESS > UNLOAD STRUCTURE FOR AUTONUM > UNLOAD STRUCTURE FOR COMMENTS > UNLOAD STRUCTURE FOR RULES > UNLOAD STRUCTURE FOR PROCEDURES > UNLOAD STRUCTURE FOR TRIGGERS > OUTPUT SCREEN > > Using a command file like the above allows the database unload to be > divided into three parts; two for the structure definitions and one > for the data. > > To rebuild the database you would run the three command files. > > RUN DB_Part1.rmd > RUN DB_Part2.rmd > RUN DB_Part3.rmd > > Each DB_Part file can be run, or traced, individually to monitor the > database creation process, for possible flaws in the database! > > Very Best R:egards, > > Razzak. > > https://www.rbase.com > http://www.facebook.com/rbase/ > > > -- > For group guidelines, visit > http://www.rbase.com/support/usersgroup_guidelines.php > --- > You received this message because you are subscribed to the Google Groups > "RBASE-L" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/rbase-l/1N63qG-1lRYPY0L2e-016Rg0%40mrelay.perfora.net > . > -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/CABnhDATCUXLxMe2ubiNecJUwXWJXGO2XyXL5WpJ7tCh5SvaHnw%40mail.gmail.com.
