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.
