dump & load scripts (^d)

img00100

This panel allows the user to create OS scripts to dump and load an entire database. With the free version of ProTop, only a simple, single-threaded D&L script is created. Most of the options above are available in the
commercial version of ProTop, which adds the ability to optimize the D&L with various options.


ProTop RT Label Description
Large Table Defines the size threshold over which "large" tables are segregated in their own storage area
Active Defines the read activity threshold over which "active" tables are segregated in their own storage area
Block Size Target block size.
Dump Index Choice of primary or no-index for type 2 storage areas
Dump Threads The number of dump threads to spawn
Dump & Load Work Dir Scripts are configured with this directory holding the newly created dump and load scripts
Target DB Dir Scripts are configured with this directory containing the target database file
Target BI Dir Scripts are configured with this directory containing the target database BI file
Target AI Dir Scripts are configured with this directory containing the target database AI file

Hitting the \<enter> key through these selections will cause the dump & load scripts to be created, or optionally use F1/GO/Ctrl-X.


img00200

ProTop RT Label Description
OK Returns you to the previous screen
Help Ignore if visible (only visible with OpenEdge development license)


Insight into Dump & Load Parameters

There are many valid recommendations regarding database block size, but we tend to favour 8192 (the largest possible value) in all cases. Other common answers are a) 4096 on Windows and Linux, 8192 on UNIX; b) match the file system block size to avoid torn pages.


Notes:

If you are using the commercial version of ProTop, setting the environment variable DUMPSCRIPTS=yes enables the advanced D&L Script Configuration dialog box seen above and includes these features: - The advanced st file has dedicated areas for large tables and other areas based on grouping by rows per block - The “advanced” dump scripts are multi threaded and there is an attempt to balance the threads


The non commerical version presents the "basic" dialog:

img00100

And provides these feaures:

Proposed Structure File

In either case, you must place a recent database analysis in your [PROTOPDIR]/dbanalys directory to get a proposed structure file in your [Dump & Load Work]/build directory.