Vantage - Dump & Load Advice

On 11-1-2012 14:21, moeswede@... wrote:
> Progress recomend the following block sizes:
>
> Unix 8192
> Linux 4096
> Windows 4096

Actually they recommend that the database blocksize be equal to the
filesystem
blocksize. The default for NTFS is 4k, so this is also good for Progress.

But you can also use 8k or more for Progress, if you are comfortable with
reformatting the NTFS filesystem that stores the database accordingly.

Be aware that many Progress tuning parameters take database blocksize as
a unit.
Some users see a performance improvement when they change the blocksize from
4k to 8k, when in fact the biggest change is that the -B parameter (amount
of buffering) doubles effectively. The same can be achieved with just
doubling
the tuning parameter, and leaving the database as is.

Pim
Hi All
Â
Just looking for a bit of advice on Dump & Load.
Â
We cant locate our empty DB.
Â
In Progress Admin tools you can create a new one which we have done but how do we know if it is 4KB blocks?
Â
Also, after you have done your dump and load what sort of information do you check (against the un-dump/load data) to make sure all of the data is correct and in-tact?
Â
Thanks,
Â
CHRIS

[Non-text portions of this message have been removed]
Chris,

The empty database is in "e:\Epicor\oe102a" folder and you want to be sure to pick the "empty8.db" file if you want it to be 8KB blocks or pick empty4.db" file if you want it to be 4KB blocks.
At the end of the dump and load you compare two "tabanalys" reports, one run against the DbOrig database and one run against the DbLoad database. You compare all the tables in both reports except for the tables having names beginning with an underscore and the license tables. All of these tables should match for record counts per table. Do not compare the Total Record Count.
Just want to know do you have the "ASCII Dump and Load" instructions from Epicor? You can call tech support and request a copy if needed.
Hope this helps!

Jill Schoedel
Metalworks

--- In vantage@yahoogroups.com, Chris Thompson <chriselectrix@...> wrote:
>
> Hi All
> Â
> Just looking for a bit of advice on Dump & Load.
> Â
> We cant locate our empty DB.
> Â
> In Progress Admin tools you can create a new one which we have done but how do we know if it is 4KB blocks?
> Â
> Also, after you have done your dump and load what sort of information do you check (against the un-dump/load data) to make sure all of the data is correct and in-tact?
> Â
> Thanks,
> Â
> CHRIS
>
> [Non-text portions of this message have been removed]
>
In a progress database (OpenEdge10) the block size defaults to the following if not specified with the "-blocksize" option when creating the database:
Unix 1024 and Windows 4096.

Progress recomend the following block sizes:

Unix 8192
Linux 4096
Windows 4096

Epicor suggests using the _proutil mfgsys -C tabanalys > <filename> command on the database before the dump and after the load to compare the record count on each tables. This in run from the command line while in the progress environment (the "Proenv" option in the openendge menus). The "> <filename>" sends the data to a text file.

If you don't have it, I would recommend contacting tech support and getting their Dump and Load kit.

--- In vantage@yahoogroups.com, Chris Thompson <chriselectrix@...> wrote:
>
> Hi All
> Â
> Just looking for a bit of advice on Dump & Load.
> Â
> We cant locate our empty DB.
> Â
> In Progress Admin tools you can create a new one which we have done but how do we know if it is 4KB blocks?
> Â
> Also, after you have done your dump and load what sort of information do you check (against the un-dump/load data) to make sure all of the data is correct and in-tact?
> Â
> Thanks,
> Â
> CHRIS
>
> [Non-text portions of this message have been removed]
>