Salesforce

Binary Dump With Tables Larger Than 2 GB

« Go Back

Information

 
TitleBinary Dump With Tables Larger Than 2 GB
URL Name17528
Article Number000123111
EnvironmentProduct: Progress
Version: 8.x, 9.x
Product: OpenEdge
Version: 10.x, 11.x
OS: All supported platforms
Question/Problem Description
Binary Dump With Tables Larger Than 2 GB
What files are written to when binary dumping a table bigger than 2 Gig?
How the binary dump files are named when binary dumping a table bigger than 2 Gig?
Steps to Reproduce
Clarifying Information
Error Message
Defect Number
Enhancement Number
Cause
Resolution
A section is a file containing a section of a table.
Every binary dumped table has at minimum, 1 section.

A new section is created when Progress runs out of disk space writing the previous section, or the maximum files size for the operating system is reached.
The first section is named <table>.bd. The second has a suffix of .bd2 the 3rd, .bd3 and so on.

Naming of the sections is performed internally by Progress and automatically.

If the directory entered is a removable device (tape drive), Progress writes directly to the device when it names the file.

When a new section must be created, a partial record might be left at the end of the previous section.
Because of this, the new section starts with the same record that was partially written in the previous section. The Binary Load utility handles the partial record appropriately.

Each section can be binary loaded independently of any other section (ie. each section has enough information in it for stand alone load without dependencies).  
Not able specify different locations for each section on the dump.

The dump is made in its entirety to the path or destination provided.  When loading several sections, every section to be loaded must be specified.  

Able to build a script to load all the sections in a process.  

Once the process finishes, idxbuild should be run.
Workaround
Notes
Syntax for binary dump:proutil <db> -C dump <table> <directory> [-index <num>]
Keyword Phrase
Last Modified Date4/26/2016 8:28 PM

Powered by