Corrupt database repair

Thank you! We don't have a corrupt database. I just wanted to make sure
that I had the info. if we ever did!

Wendy (Bowen) Pursche
Network Administrator
Schmald Tool & Die, Inc.
(810) 743-1600 ext.323
wpursche@...


----- Original Message -----
From: Plaman Dick <dick.plaman@...>
To: <vantage@egroups.com>
Sent: Wednesday, December 06, 2000 3:21 PM
Subject: RE: [Vantage] corrupt database repair


> This document was obtained from Epicor's ERA-net.
>
>
>
> ----------
>
> PG How to Truncate, DBRPR and IDXBuild for 4.00Page: 408MPS
> Summary: PG How to Truncate, DBRPR and IDXBuild for 4.00
> AnswerBook: Vantage ChangeRequests
>
> PROBLEM DESCRIPTION:
>
> How do I correct data corruption issues?
>
>
> the next time you try it.)
Someone had mentioned that there is a DBRPR.* file in Progress that allows you to repair a damaged database? Or was it something that had to be downloaded? I looked under my Progress\Bin directory and did not see it.

Wendy Pursche
Network Administrator
Schmald Tool & Die, Inc.
(810) 743-1600 ext.323
wpursche@...



[Non-text portions of this message have been removed]
This document was obtained from Epicor's ERA-net.



----------

PG How to Truncate, DBRPR and IDXBuild for 4.00Page: 408MPS
Summary: PG How to Truncate, DBRPR and IDXBuild for 4.00
AnswerBook: Vantage ChangeRequests

PROBLEM DESCRIPTION:

How do I correct data corruption issues?


PROBLEM RESOLUTION:

Below are the three instructions typically used to correct database issues.

If there is data corruption, these three functions can be run in order as they
appear in this document. However, IdxBuild can be run without Truncating the .B1
file or running DBRPR.

================================================================
TRUNCATE BI

In general we DO NOT recommend you truncate the .bi file. However, there are
times when you are forced to truncate the .bi due to a crash or system failure.

The .bi file in your Vantage database directory contains completed transactions
that may or may not, have yet been written to the ".db" file, which is the
complete database.

To truncate the .bi file, make sure you have shut down the Vantage database
server, stopping the Gears of ProControl. Then execute the following command at
a DOS prompt from one of your workstations:


For NT: (Vantage 4.00)

1) Go to the SERVER.

2) Using the MS-DOS Command Prompt, change directory to:
C:\Epicor\Progress\BIN ( Replacing C:\ with your physical drive)

3) Then type:
_proutil c:\epicor\vantage\db\vantage.db -C truncate bi

** If the system will not allow you to truncate the bi file normally, you will
need to "force" the truncation. Enter the following command:

_proutil c:\epicor\vantage\db\vantage.db -C truncate bi -F


===============================================================
DB REPAIR UTILITY

How to run the database utility DBRPR to scan your database for bad records and
blocks.
Run this utility if:
- You receive errors that indicate the there has been database corruption or
damage. (Errors include 1124, 355, 18, 49, etc.)
- You have had disk or hardware problems that may have damaged the database and
structures in any way.

CAUTION: Keep in mind, if the data block cannot be repaired, this utility may
attempt to simply remove it from your database. If there is severe corruption,
you should alway try to restore your database to some time prior to the
corruption. If this is not possible, then Dumping and Loading your database my
be the only solution.

PREREQUISITES:
The database repair utility is a function of proutil and the _proutil
executable. You execute it like any other proutil function. However there are a
number of prerequisites to using the utility:

1. ALWAYS HAVE A CURRENT BACKUP OF THE DATABASE.
2. The ProControl must be down and the database not in use.


RUNNING THE UTILITY:
To execute the Database repair utility:
1. Trucate the BI file. (See above)
2. Using the MS-DOS Command Prompt, change directory to:
C:\Epicor\Progress\Bin> ( Replacing C:\ with your physical drive)
3. Enter the command:
_proutil c:\epicor\vantage\db\vantage.db -C dbrpr


The Version of your PROGRESS Software will display followed by the main menu:

DATABASE REPAIR MENU
--------------------
--> 1. Database Scan Menu
2. Test One or More Indicies
3. Remove Bad Record Fragment
4. Dump Block
5. Load Block
6. Copy Bytes Between Files
7. Load RM Dump File
8. Reformat Block to a Free Block
Q. Quit

Choice:


Select Option 1. Database Scan Menu


From the DATABASE SCAN MENU select options 3, 5, 7 and 8. Simple turn on each of
these by pressing 3 then , 5 then , etc.

Once all selections are turned "ON", then press and to begin processing.


===============================================================
INDEX REBUILD.

Follow this procedure to rebuild ALL indexes. Following the DBRPR and/or due to
index corruption, you will need to rebuild the database indexes.

To rebuild all indexes, select All from the Index Rebuild Utility menu. The
index rebuild will begin processing. The utility ends when the DOS prompt is
redisplayed.

** Reindexing may take a Few HOURS depending on the size of your database. On
the average a 200MB database running this utility at the server (200mhz Pentium)
will run about 1 to 1.5 hours.

FOR NT (you must do this at the server for NT)
1. With ProControl shutdown the database stopped.
2. Using the MS-DOS Command Prompt, change directory to:
C:\Epicor\Progress\Bin> ( Replacing C:\ with your physical drive)
3. Enter the command:
SET DLC=C:\Epicor\Progress
4. Enter the command:
Path=C:\Epicor\Progress;%PATH%
5. From this DOS prompt enter the command:
_proutil C:\Epicor\Vantage\db\vantage.db -C idxbuild all -TM 32 -TB 24


ADDITIONAL INFORMATION:
Version: 4.00



XA400



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