Difference: FileAnalysisAndRecovery (1 vs. 8)

Revision 82016-10-11 - JeffPrentice

Line: 1 to 1
 
META TOPICPARENT name="SystemAdministration"

File Analysis and Recovery

Line: 35 to 35
 VERIFY KEY #2 - verifies the alt index #2, etcetera ...

QUIT - exit the "-an=" utility.

Changed:
<
<

FREELIST damage (APPX 4.0.a & earlier)

>
>

FREELIST damage (APPX 4.0.a & earlier)

  A type of file damage that VERIFY KEY #ALL does not tell you about is freelist damage. The freelist is the list of pointers in AppxIO files that point to deleted records. This list can get damaged. It could for example point to a live record, indicating erroneously that it is deleted.
Line: 57 to 57
 

Recovering a Damaged File:

Changed:
<
<
There are several techniques that can recover a damaged file. It's not possible to determine in advance which technique will give the best results, therefore we recommend you back up the damaged file, then try these techniques to see which one recovers the most data
Important Note
>
>
These techniques require thought knowledge of the Appx directory/file structure as well as the associated application files and processing. If you have any questions after reading these procedures, please call Appx Technical Support (1-800-879-2779) before proceeding.
 
Changed:
<
<
The Export and Import utilities should not be used for recovering a damaged file. The export routine will stop reading the corrupt file when the corruption is encountered. The resulting export file will be missing the remaining data records.

Rebuilding the key file

>
>
There are several techniques that may recover damaged file(s). We recommend that you back up your files before attempting one these techniques. Select the appropriate method after careful analysis of your particular situation.

Important Note

The Export and Import utilities should not be used for recovering a damaged file. In all likelihood this method will result in lost data.

Rebuilding the key file

  This is the easiest & simplest type of recovery. Either delete or rename the existing .key file, then run 'Create Files' on the Data File Management menu. This will rebuild the key file, and when it is complete run the 'Verify' step again to check the record counts and confirm the file is good. Even if the file passes verification, you might have lost data. If possible, check the file to see if any valid data was lost.
Changed:
<
<

Restoring files from Backup

>
>

Restoring files from Backup

  Note that all work performed since the backup was made will be lost.

When restoring design files, the entire application should be restored from backup, not just a single file. The best course of action is to restore all of the applications for the version to ensure that design integrity is maintained across applications.

Changed:
<
<
When restoring data files, it may be necessary to restore the entire database. For example, it makes no sense to restore an Order file without also restoring the line item file. Consider other files which may have been updated during the course of processing. Those files may also need to be restored.

APPX Recover Utility

>
>
When restoring data files, it may be necessary to restore the entire database. For example, it makes no sense to restore an Order file without also restoring its line item file. Consider other files which may have been updated during the course of processing. Those files may also need to be restored.

APPX Recover Utility

If the above techniques aren't successful, then you can run the Appx Recover Utility. This is the safest method for recovering your damaged or corrupt file(s).

 
Changed:
<
<
If the above techniques aren't successful, then you can try the 'appx.exe -r' option. You can also use this technique to recover accidentally deleted records, if you can perform this procedure in time. Since APPX re-uses deleted records, if new data is added after the deleted records, the deleted record may already be overwritten.
>
>
You can also use this technique to recover accidentally deleted records, if you can perform this procedure in time. Since APPX re-uses deleted records, if new data is added after the deleted records, the deleted record may already be overwritten.
  Usage:
In Windows: %APPXPATH%\..\appx.exe -r old.file new.file [deleted.record.file]

Revision 72016-10-11 - JeffPrentice

Line: 1 to 1
 
META TOPICPARENT name="SystemAdministration"

File Analysis and Recovery

Line: 57 to 58
 

Recovering a Damaged File:

There are several techniques that can recover a damaged file. It's not possible to determine in advance which technique will give the best results, therefore we recommend you back up the damaged file, then try these techniques to see which one recovers the most data

Changed:
<
<

Rebuilding the key file

>
>
Important Note

The Export and Import utilities should not be used for recovering a damaged file. The export routine will stop reading the corrupt file when the corruption is encountered. The resulting export file will be missing the remaining data records.

Rebuilding the key file

  This is the easiest & simplest type of recovery. Either delete or rename the existing .key file, then run 'Create Files' on the Data File Management menu. This will rebuild the key file, and when it is complete run the 'Verify' step again to check the record counts and confirm the file is good. Even if the file passes verification, you might have lost data. If possible, check the file to see if any valid data was lost.
Changed:
<
<

Export/Import the file

>
>

Restoring files from Backup

Note that all work performed since the backup was made will be lost.

When restoring design files, the entire application should be restored from backup, not just a single file. The best course of action is to restore all of the applications for the version to ensure that design integrity is maintained across applications.

 
Changed:
<
<
This approach might recover more data than rebuilding the key. It will read the file by it's primary key and export the data. You can then import the file with the 'Replace' option to rebuild the .dat and .key file. Import and Export are on the Data File Management menu.

APPX -recover Option

>
>
When restoring data files, it may be necessary to restore the entire database. For example, it makes no sense to restore an Order file without also restoring the line item file. Consider other files which may have been updated during the course of processing. Those files may also need to be restored.

APPX Recover Utility

 
Changed:
<
<
If the above techniques aren't successful, then you can try the '-recover' option. You can also use this technique to recover accidentally deleted records, if you can perform this procedure in time. Since APPX re-uses deleted records, if new data is added after the deleted records, the deleted record may already be overwritten.

Usage:

>
>
If the above techniques aren't successful, then you can try the 'appx.exe -r' option. You can also use this technique to recover accidentally deleted records, if you can perform this procedure in time. Since APPX re-uses deleted records, if new data is added after the deleted records, the deleted record may already be overwritten.

Usage:

 
In Windows: %APPXPATH%\..\appx.exe -r old.file new.file [deleted.record.file]
In Unix: $APPXPATH/../appx -r old.file new.file [deleted.record.file]
This utility will read an APPX indexed data file (.dat) and copy the good/active records to the output file. Any corrupt data is hex-dumped to the screen. If you redirect standard output (>bad.data ), you can collect any corrupted data into a file, for later examination.
Line: 77 to 86
  This utility does not deal with duplicate primary or unique alternate indices.
Changed:
<
<
After the command is complete, new.file contains the salvaged data. To access it, rename or delete the original file, then rename the new file to the original file name. Then you must create a new *.key file. This is done by renaming or deleting the existing *.key file, then running "Create Files" on the Data or Design File Management menu. The *.key file contains pointers to all of the data records in the *.dat file. By recovering the *.dat file, you invalidate the original *.key file.

Example:

>
>
By recovering the *.dat file, you invalidate the original *.key file.

After the command is complete, new.file contains the salvaged data. To access it, rename or delete the original file, then rename the new file to the original file name. Then you must create a new *.key file. This is done by renaming or deleting the existing *.key file, then running "Create Files" on the Data or Design File Management menu. The *.key file contains pointers to all of the data records in the *.dat file.

Example:

  The following command (in Windows) ...

Revision 62016-01-29 - JeanNeron

Line: 1 to 1
 
META TOPICPARENT name="SystemAdministration"

File Analysis and Recovery

Verifying and Analyzing a File

Added:
>
>
You can verify a file's integrity from the Data File Management menu ('Verify Files') or from the command line. To verify files from the command line:
 
In Windows: %APPXPATH%\..\appx.exe -v={filename}
In Unix: $APPXPATH/../appx -v={filename}
Changed:
<
<
... will manually verify an APPX datafile. This does the same thing as interactive "Verify Files Menu", "Verify Integrity" from the Database, Design File, and System Administration File Management menus, but from a command line.

If the invocation of this command results in no output, then the file passes verification. Any output from this command means that the file fails verification.

>
>
If the invocation of this command results in no output, then the file passes verification. Any output from this command means that the file fails verification.
 
Changed:
<
<
To analyze a damaged file ...
In Windows: %APPXPATH%\..\appx.exe -an={filename}
>
>
The Verify step is a pass/fail test. To get more information about the file you can analyze it via:

In Windows: %APPXPATH%\..\appx.exe -an={filename}
 
In Unix: $APPXPATH/../appx -an={filename}
Changed:
<
<
... gives you a"BRF>" prompt for {filename}. The most useful command at this prompt is ...
>
>
This will give you a"BRF>" prompt for {filename}. The most useful command at this prompt is ...
  VERIFY KEY #ALL
Line: 33 to 34
 VERIFY KEY #2 - verifies the alt index #2, etcetera ...

QUIT - exit the "-an=" utility.

Changed:
<
<
If the file doesn't pass #ALL verification, but does pass COUNT REC verification, then it means that the *.dat portion of the file is probably OK, but the *.key indices are probably damaged. In this case, rename or delete the *.key file, then run 'Create Files' on the Data File or Design File Management menu. This will recreate your indices from scratch.

If the file doesn't pass COUNT REC analysis, you have a seriously damaged *.dat file. Your best bet at this point is to use the recover procedure below, or if necessary restore from backup.

FREELIST damage

>
>

FREELIST damage (APPX 4.0.a & earlier)

  A type of file damage that VERIFY KEY #ALL does not tell you about is freelist damage. The freelist is the list of pointers in AppxIO files that point to deleted records. This list can get damaged. It could for example point to a live record, indicating erroneously that it is deleted.

Up through APPX version 4.0.a the menu driven Verify Integrity utilities, the 'appx -v={filename}, and the 'appx -an={filename}', VERIFY KEY #ALL option don't detect such damaged freelist conditions.

Changed:
<
<
To find a damaged freelist condition, you must use the APPX engine (the engine is all that's necessary) release 4.0.a or higher, then go into the BRF> command line from 'appx -an={filename}', then execute the command:
>
>
To find a damaged freelist condition, you must use the APPX engine (the engine is all that's necessary) release 4.1 or higher, then go into the BRF> command line from 'appx -an={filename}', then execute the command:
 

VERIFY FREELIST

Line: 57 to 54
  If the file passes this verification, you may safely export and re-import the file, in order to initialize its freelist.
Deleted:
<
<
If the file doesn't pass #ALL verification, but does pass COUNT REC verification, then it means that the *.dat portion of the file is probably OK, but the *.key indices are probably damaged. In this case, rename or delete the *.key file, then run "Create Files" on the Data File or Design File Management menu. This will recreate your indices from scratch. It will then be safe to export and re-import the file.

If the file doesn't pass COUNT REC analysis, you have a seriously damaged *.dat file. Your best bet at this point is to use the recover procedure below, or if necessary restore from backup.

 

Recovering a Damaged File:

Changed:
<
<
The following steps can be used to recover data from a damaged file. You can also use this technique to recover accidentally deleted records, if you can perform this procedure in time. Since APPX re-uses deleted records, if new data is added after the deleted records, the deleted record may already be overwritten.

Usage:

>
>
There are several techniques that can recover a damaged file. It's not possible to determine in advance which technique will give the best results, therefore we recommend you back up the damaged file, then try these techniques to see which one recovers the most data

Rebuilding the key file

This is the easiest & simplest type of recovery. Either delete or rename the existing .key file, then run 'Create Files' on the Data File Management menu. This will rebuild the key file, and when it is complete run the 'Verify' step again to check the record counts and confirm the file is good. Even if the file passes verification, you might have lost data. If possible, check the file to see if any valid data was lost.

Export/Import the file

This approach might recover more data than rebuilding the key. It will read the file by it's primary key and export the data. You can then import the file with the 'Replace' option to rebuild the .dat and .key file. Import and Export are on the Data File Management menu.

APPX -recover Option

If the above techniques aren't successful, then you can try the '-recover' option. You can also use this technique to recover accidentally deleted records, if you can perform this procedure in time. Since APPX re-uses deleted records, if new data is added after the deleted records, the deleted record may already be overwritten.

Usage:

 
In Windows: %APPXPATH%\..\appx.exe -r old.file new.file [deleted.record.file]
In Unix: $APPXPATH/../appx -r old.file new.file [deleted.record.file]
This utility will read an APPX indexed data file (.dat) and copy the good/active records to the output file. Any corrupt data is hex-dumped to the screen. If you redirect standard output (>bad.data ), you can collect any corrupted data into a file, for later examination.
Changed:
<
<
Deleted Records are discarded, unless a third filename is given on the command line. In this case, the deleted records are copied to the given file. This file is a fixed-length consecutive file. To access it from within APPX, you must design transfer your data dictionary, remove the indices, and change the file type to consecutive. This is needed since the deleted records could contain duplicate key values.
>
>
Deleted Records are discarded, unless a third filename is given on the command line. In this case, the deleted records are copied to the given file. This file is a consecutive file, either fixed length or variable length depending on the attribute of the original file. To access it from within APPX, you must design transfer your data dictionary, remove the indices, and change the file type to consecutive. This is needed since the deleted records could contain duplicate key values.
  Overhead blocks are also removed. These blocks are used to track deleted record space within the file for reuse. Since the new file has no deleted record space, it no longer needs these blocks.

This utility does not deal with duplicate primary or unique alternate indices.

After the command is complete, new.file contains the salvaged data. To access it, rename or delete the original file, then rename the new file to the original file name. Then you must create a new *.key file. This is done by renaming or deleting the existing *.key file, then running "Create Files" on the Data or Design File Management menu. The *.key file contains pointers to all of the data records in the *.dat file. By recovering the *.dat file, you invalidate the original *.key file.

Changed:
<
<

Example:

>
>

Example:

  The following command (in Windows) ...

Revision 52016-01-20 - JeanNeron

Line: 1 to 1
 
META TOPICPARENT name="SystemAdministration"

File Analysis and Recovery

Changed:
<
<

Verifying and Analyzing a File

>
>

Verifying and Analyzing a File

 
In Windows: %APPXPATH%\..\appx.exe -v={filename}
In Unix: $APPXPATH/../appx -v={filename}
... will manually verify an APPX datafile. This does the same thing as interactive "Verify Files Menu", "Verify Integrity" from the Database, Design File, and System Administration File Management menus, but from a command line.
Line: 13 to 13
 To analyze a damaged file ...
In Windows: %APPXPATH%\..\appx.exe -an={filename}
In Unix: $APPXPATH/../appx -an={filename}
Changed:
<
<
... gives you a"BRF>" prompt for {filename}. The most useful command at this prompt is ...
>
>
... gives you a"BRF>" prompt for {filename}. The most useful command at this prompt is ...
 
Changed:
<
<
VERIFY KEY #ALL
>
>
VERIFY KEY #ALL
  which performs counts the number of records in the .dat portion of the file verifying the .dat as it goes, and verifies all Keys in the .key portion of the file. Other useful commands are:
HELP          - list all available commands.

Line: 36 to 36
  If the file doesn't pass #ALL verification, but does pass COUNT REC verification, then it means that the *.dat portion of the file is probably OK, but the *.key indices are probably damaged. In this case, rename or delete the *.key file, then run 'Create Files' on the Data File or Design File Management menu. This will recreate your indices from scratch.
Deleted:
<
<
(For quite large files, it may be faster to use the 'recover.exe' procedure below, the 3)CreateFiles to recreate your keyfile, albeit at the cost of more designer time required to do this safely.)
 If the file doesn't pass COUNT REC analysis, you have a seriously damaged *.dat file. Your best bet at this point is to use the recover procedure below, or if necessary restore from backup.

FREELIST damage

Line: 61 to 59
  If the file doesn't pass #ALL verification, but does pass COUNT REC verification, then it means that the *.dat portion of the file is probably OK, but the *.key indices are probably damaged. In this case, rename or delete the *.key file, then run "Create Files" on the Data File or Design File Management menu. This will recreate your indices from scratch. It will then be safe to export and re-import the file.
Deleted:
<
<
(For quite large files, it may be faster to use the 'recover.exe' procedure below, then 3)CreateFiles to recreate your keyfile, albeit at the cost of more designer time required to do this safely.)
 If the file doesn't pass COUNT REC analysis, you have a seriously damaged *.dat file. Your best bet at this point is to use the recover procedure below, or if necessary restore from backup.
Changed:
<
<

File Recovery: appx -r (or -recover)

>
>

Recovering a Damaged File:

 
Added:
>
>
The following steps can be used to recover data from a damaged file. You can also use this technique to recover accidentally deleted records, if you can perform this procedure in time. Since APPX re-uses deleted records, if new data is added after the deleted records, the deleted record may already be overwritten.
 

Usage:

In Windows: %APPXPATH%\..\appx.exe -r old.file new.file [deleted.record.file]
In Unix: $APPXPATH/../appx -r old.file new.file [deleted.record.file]
Line: 77 to 74
  This utility does not deal with duplicate primary or unique alternate indices.
Changed:
<
<
* IMPORTANT * Any file you recover must have a new *.key file built. This is done by renaming or deleting the *.key file, then running 3)Create Files. The *.key file contains pointers to all of the data records in the *.dat file. By recovering the *.dat file, you invalidate the original *.key file.
>
>
After the command is complete, new.file contains the salvaged data. To access it, rename or delete the original file, then rename the new file to the original file name. Then you must create a new *.key file. This is done by renaming or deleting the existing *.key file, then running "Create Files" on the Data or Design File Management menu. The *.key file contains pointers to all of the data records in the *.dat file. By recovering the *.dat file, you invalidate the original *.key file.
 

Example:

The following command (in Windows) ...

Line: 101 to 98
  Space Allocation Reduction = 0 bytes

* You MUST create a new '.key' file that matches your new '.dat' file!

Deleted:
<
<

What to do with a file that Fails Verification?

If Verify Integrity results in a 'Failed' condition, perform the following procedure:

1) If you are running under Unix, su to the appx UserID.

2) Call up a MS-DOS Command box (or Unix Command prompt). Change directories:

cd {appx.exe.folder}\data\DDD\AAA\Data ... where ...

{appx.exe.folder} is the directory containing your 'appx.exe' engine,
DDD is your Database ID (or for your Appl Design files, the Appl's 2-digit version#), and
AAA is your Application ID.

(If you are using FMS Groups, adjust this 'cd' accordingly.)

Example:

D:
cd \APPX\data\DBS\APL\Data

3) Type:

{appx.exe.folder}\tools\recover.exe FILE.dat FILE.new

... where FILE is the name of the file you are recovering.

4) From the Command prompt, perform:

ren FILE.dat FILE.dat.keep
ren FILE.key FILE.key.keep

ren FILE.new FILE.dat

This moves the original FILE.* files out of the way (but keeps them around a while in case they're needed), then moves the recovered FILE.new into place as the new FILE.dat.

5) Go back to Database Management (or Design File Management) for your application. Run 3)Create Files on FILE. This creates a new FILE.key to go along with your recovered FILE.dat.

To double-check, run 13)Verify Menu, 1)Integrity to confirm that the file is OK, and that the Active Records Copied above equals the number reported in the Verify Integrity utility.

 

Comments:

Revision 42016-01-20 - JeanNeron

Line: 1 to 1
 
META TOPICPARENT name="SystemAdministration"

File Analysis and Recovery

Changed:
<
<

The appx utilities, found in the /tools directory below the appx engine, allow batch manipulation and recovery of AppxIO files. In the Windows environment, execute these commands from a DOS popup box. Or use the command line to perform the same functions in Unix.

Command Line Invocations: appx.exe or appx

'appx.exe' lets you perform switched invocations of APPX for Windows, without clearing the DOS box. From a Unix prompt, the command is simply 'appx'. Here's how you would use switches to verify and analyze APPX data files:

Issuing in the DOS box the command ...

appx -u

more

Or in Unix, the command ... appx -u more

... will result in the output ...

Usage:

        -k                          define a new keymap
        -m=<[user_id:]keymap_name>  override keymap ID
        -d=<database_id>            override startup database
        -a=<application_id>         override startup application
        -t=<process_type>           override startup process type
        -p=<process_name>           override startup process name
        -i=<flat_file_name>         convert a flat file into AppxIO
        -e=<data_file_name>         convert an AppxIO file into flatfile
        -v=<data_file_name>         verify the integrity of AppxIO file
        -an=<data_file_name>        analyze an AppxIO file
        -l=<log file name>          start a license server
        -r (or -recover)            recover damaged files (see below)

Restrictions:

An application_id and process_type must always be included when specifying a process_name. If an application_id is included without specifying a process_type/name, the startup menu for the application is used.

If no application_id is specified, the startup application and menu for the database is used. If no database_id is specified, the startup database defined for the user within System Administration is used. If the startup database is also unspecified, the APPX main menu is used.

The valid process_types are Menu, Job, Input, Output, Update, Action, Inquiry, Query, Status, and Subroutine. Use underscores (_) in place of embedded spaces within parameters.

Substituting the "-k" through "-l=" switches will let you specify particular actions upon invoking the appx.exe engine.

(Consider the possibility of building your desired command line invocation strings in MS Word, Notepad or WordPad, then cutting and pasting them into your DOS box.)

For more information on appxutil.exe, see the APPXUTIL Overview.

Verifying and Analyzing a File

In Windows:

%APPXPATH%\..\tools\appxutil.exe -v={filename}

In Unix: $APPXPATH/../tools/appx -v={filename}
>
>

 
Added:
>
>

Verifying and Analyzing a File

In Windows: %APPXPATH%\..\appx.exe -v={filename}
In Unix: $APPXPATH/../appx -v={filename}
 ... will manually verify an APPX datafile. This does the same thing as interactive "Verify Files Menu", "Verify Integrity" from the Database, Design File, and System Administration File Management menus, but from a command line.

If the invocation of this command results in no output, then the file passes verification. Any output from this command means that the file fails verification.

To analyze a damaged file ...

Changed:
<
<
In Windows:

%APPXPATH%\..\tools\appxutil.exe -an={filename}

In Unix: $APPXPATH/../tools/appx -an={filename}

>
>
In Windows: %APPXPATH%\..\appx.exe -an={filename}
In Unix: $APPXPATH/../appx -an={filename}
 ... gives you a"BRF>" prompt for {filename}. The most useful command at this prompt is ...

VERIFY KEY #ALL

Line: 74 to 34
  QUIT - exit the "-an=" utility.
Changed:
<
<
If the file doesn't pass #ALL verification, but does pass COUNT REC verification, then it means that the *.dat portion of the file is probably OK, but the *.key indices are probably damaged. In this case, rename or delete the *.key file, then run 3)CreateFiles. This will recreate your indices from scratch.
>
>
If the file doesn't pass #ALL verification, but does pass COUNT REC verification, then it means that the *.dat portion of the file is probably OK, but the *.key indices are probably damaged. In this case, rename or delete the *.key file, then run 'Create Files' on the Data File or Design File Management menu. This will recreate your indices from scratch.
  (For quite large files, it may be faster to use the 'recover.exe' procedure below, the 3)CreateFiles to recreate your keyfile, albeit at the cost of more designer time required to do this safely.)
Changed:
<
<
If the file doesn't pass COUNT REC analysis, you have a seriously damaged *.dat file. Your best bet at this point is to use the "Recover.exe" procedure below, or if necessary restore from backup.
>
>
If the file doesn't pass COUNT REC analysis, you have a seriously damaged *.dat file. Your best bet at this point is to use the recover procedure below, or if necessary restore from backup.
 

FREELIST damage

Changed:
<
<
A type of file damage that VERIFY KEY #ALL does not tell you about is freelist damage. The freelist is the list of pointers in AppxIO files that point to deleted records. This list can get damaged. It could for example point to a live record, indicating erroneously that it is deleted.
>
>
A type of file damage that VERIFY KEY #ALL does not tell you about is freelist damage. The freelist is the list of pointers in AppxIO files that point to deleted records. This list can get damaged. It could for example point to a live record, indicating erroneously that it is deleted.
 
Changed:
<
<
Up through APPX version 4.0.a (and perhaps higher), the menu driven Verify Integrity utilities, the 'appx -v={filename}, and the 'appx -an={filename}', VERIFY KEY #ALL option don't detect such damaged freelist conditions.
>
>
Up through APPX version 4.0.a the menu driven Verify Integrity utilities, the 'appx -v={filename}, and the 'appx -an={filename}', VERIFY KEY #ALL option don't detect such damaged freelist conditions.
  To find a damaged freelist condition, you must use the APPX engine (the engine is all that's necessary) release 4.0.a or higher, then go into the BRF> command line from 'appx -an={filename}', then execute the command:
Line: 99 to 59
  If the file passes this verification, you may safely export and re-import the file, in order to initialize its freelist.
Changed:
<
<
If the file doesn't pass #ALL verification, but does pass COUNT REC verification, then it means that the *.dat portion of the file is probably OK, but the *.key indices are probably damaged. In this case, rename or delete the *.key file, then run 3)CreateFiles. This will recreate your indices from scratch. It will then be safe to export and re-import the file.
>
>
If the file doesn't pass #ALL verification, but does pass COUNT REC verification, then it means that the *.dat portion of the file is probably OK, but the *.key indices are probably damaged. In this case, rename or delete the *.key file, then run "Create Files" on the Data File or Design File Management menu. This will recreate your indices from scratch. It will then be safe to export and re-import the file.
  (For quite large files, it may be faster to use the 'recover.exe' procedure below, then 3)CreateFiles to recreate your keyfile, albeit at the cost of more designer time required to do this safely.)
Changed:
<
<
If the file doesn't pass COUNT REC analysis, you have a seriously damaged *.dat file. Your best bet at this point is to use the recover.exe procedure below, or if necessary restore from backup.
>
>
If the file doesn't pass COUNT REC analysis, you have a seriously damaged *.dat file. Your best bet at this point is to use the recover procedure below, or if necessary restore from backup.
 

File Recovery: appx -r (or -recover)

Usage:

Changed:
<
<
In Windows:

%APPXPATH%\..\appx.exe -r old.file new.file [deleted.record.file]

>
>
In Windows: %APPXPATH%\..\appx.exe -r old.file new.file [deleted.record.file]
 
In Unix: $APPXPATH/../appx -r old.file new.file [deleted.record.file]
Changed:
<
<
This utility will read an APPX indexed data file (.dat) and copy the good/active records to the output file. Any corrupt data is hex-dumped to the screen. If you redirect standard output ( >bad.data ), you can collect any corrupted data into a file, for later examination.
>
>
This utility will read an APPX indexed data file (.dat) and copy the good/active records to the output file. Any corrupt data is hex-dumped to the screen. If you redirect standard output (>bad.data ), you can collect any corrupted data into a file, for later examination.
  Deleted Records are discarded, unless a third filename is given on the command line. In this case, the deleted records are copied to the given file. This file is a fixed-length consecutive file. To access it from within APPX, you must design transfer your data dictionary, remove the indices, and change the file type to consecutive. This is needed since the deleted records could contain duplicate key values.
Line: 123 to 82
  The following command (in Windows) ...
Deleted:
<
<
 appx.exe -r C:\APPX\DATA\DDD\PAT\Data\BB.dat C:\APPX\DATA\DDD\PAT\Data\BB.new

... will generate the following output and files ...

Line: 146 to 103
 * You MUST create a new '.key' file that matches your new '.dat' file!

What to do with a file that Fails Verification?

Changed:
<
<

If 13)Verify 1)Integrity results in a 'Failed' condition, perform the following procedure:

>
>
If Verify Integrity results in a 'Failed' condition, perform the following procedure:
  1) If you are running under Unix, su to the appx UserID.
Changed:
<
<
2) Call up a MS-DOS Command box (or Unix Command prompt). Change directories:
>
>
2) Call up a MS-DOS Command box (or Unix Command prompt). Change directories:
  cd {appx.exe.folder}\data\DDD\AAA\Data ... where ...

{appx.exe.folder} is the directory containing your 'appx.exe' engine,
DDD is your Database ID (or for your Appl Design files, the Appl's 2-digit version#), and
AAA is your Application ID.

Deleted:
<
<
  (If you are using FMS Groups, adjust this 'cd' accordingly.)

Example:

D:
cd \APPX\data\DBS\APL\Data

Changed:
<
<
3) Type:
>
>
3) Type:
  {appx.exe.folder}\tools\recover.exe FILE.dat FILE.new

... where FILE is the name of the file you are recovering.

Changed:
<
<
4) From the Command prompt, perform:
>
>
4) From the Command prompt, perform:
  ren FILE.dat FILE.dat.keep
ren FILE.key FILE.key.keep

Revision 32012-02-29 - ChrisBrower

Line: 1 to 1
 
META TOPICPARENT name="SystemAdministration"

File Analysis and Recovery

The appx utilities, found in the /tools directory below the appx engine, allow batch manipulation and recovery of AppxIO files. In the Windows environment, execute these commands from a DOS popup box. Or use the command line to perform the same functions in Unix.

Line: 39 to 39
 (Consider the possibility of building your desired command line invocation strings in MS Word, Notepad or WordPad, then cutting and pasting them into your DOS box.)

For more information on appxutil.exe, see the APPXUTIL Overview.

Changed:
<
<

Verifying and Analyzing a File

>
>

Verifying and Analyzing a File

 
In Windows:

%APPXPATH%\..\tools\appxutil.exe -v={filename}

In Unix: $APPXPATH/../tools/appx -v={filename}
Deleted:
<
<
 ... will manually verify an APPX datafile. This does the same thing as interactive "Verify Files Menu", "Verify Integrity" from the Database, Design File, and System Administration File Management menus, but from a command line.

If the invocation of this command results in no output, then the file passes verification. Any output from this command means that the file fails verification.

Changed:
<
<
To analyze a damaged file ...
>
>
To analyze a damaged file ...
 
In Windows:

%APPXPATH%\..\tools\appxutil.exe -an={filename}

In Unix: $APPXPATH/../tools/appx -an={filename}
Changed:
<
<
>
>
  ... gives you a"BRF>" prompt for {filename}. The most useful command at this prompt is ...
Line: 103 to 101
  If the file doesn't pass #ALL verification, but does pass COUNT REC verification, then it means that the *.dat portion of the file is probably OK, but the *.key indices are probably damaged. In this case, rename or delete the *.key file, then run 3)CreateFiles. This will recreate your indices from scratch. It will then be safe to export and re-import the file.
Changed:
<
<
(For quite large files, it may be faster to use the 'recover.exe' procedure below, then 3)CreateFiles to recreate your keyfile, albeit at the cost of more designer time required to do this safely.)
>
>
(For quite large files, it may be faster to use the 'recover.exe' procedure below, then 3)CreateFiles to recreate your keyfile, albeit at the cost of more designer time required to do this safely.)
 
Changed:
<
<
If the file doesn't pass COUNT REC analysis, you have a seriously damaged *.dat file. Your best bet at this point is to use the recover.exe procedure below, or if necessary restore from backup.

File Recovery: appx -r (or -recover)

>
>
If the file doesn't pass COUNT REC analysis, you have a seriously damaged *.dat file. Your best bet at this point is to use the recover.exe procedure below, or if necessary restore from backup.

File Recovery: appx -r (or -recover)

 

Usage:

In Windows:

%APPXPATH%\..\appx.exe -r old.file new.file [deleted.record.file]

Line: 146 to 144
  Space Allocation Reduction = 0 bytes

* You MUST create a new '.key' file that matches your new '.dat' file!

Changed:
<
<

What to do with a file that Fails Verification?

>
>

What to do with a file that Fails Verification?

 
Deleted:
<
<
  If 13)Verify 1)Integrity results in a 'Failed' condition, perform the following procedure:
Line: 191 to 189
 Read what other users have said about this page or add your own comments.
Changed:
<
<

<--/commentPlugin-->
>
>

<--/commentPlugin-->
 \ No newline at end of file

Revision 22012-02-27 - ChrisBrower

Line: 1 to 1
 
META TOPICPARENT name="SystemAdministration"

File Analysis and Recovery

Changed:
<
<

The appx utilities, found in the /tools directory below the appx engine, allow batch manipulation and recovery of AppxIO files. In the Windows environment, execute these commands from a DOS popup box. Or use the command line to perform the same functions in Unix.

>
>

The appx utilities, found in the /tools directory below the appx engine, allow batch manipulation and recovery of AppxIO files. In the Windows environment, execute these commands from a DOS popup box. Or use the command line to perform the same functions in Unix.

 

Command Line Invocations: appx.exe or appx

'appx.exe' lets you perform switched invocations of APPX for Windows, without clearing the DOS box. From a Unix prompt, the command is simply 'appx'. Here's how you would use switches to verify and analyze APPX data files:

Changed:
<
<
Issuing in the DOS box the command ...

appx -u

more

>
>
Issuing in the DOS box the command ...

appx -u

more

 
Or in Unix, the command ... appx -u more

... will result in the output ...

Changed:
<
<

Usage:

>
>

Usage:

 
        -k                          define a new keymap
        -m=<[user_id:]keymap_name>  override keymap ID
        -d=<database_id>            override startup database

Line: 28 to 24
  -l=<log file name> start a license server -r (or -recover) recover damaged files (see below)
Changed:
<
<

Restrictions:

>
>

Restrictions:

  An application_id and process_type must always be included when specifying a process_name. If an application_id is included without specifying a process_type/name, the startup menu for the application is used.
Line: 38 to 34
  Substituting the "-k" through "-l=" switches will let you specify particular actions upon invoking the appx.exe engine.
Changed:
<
<
>
>
 
Changed:
<
<
(Consider the possibility of building your desired command line invocation strings in MS Word, Notepad or WordPad, then cutting and pasting them into your DOS box.)
>
>
(Consider the possibility of building your desired command line invocation strings in MS Word, Notepad or WordPad, then cutting and pasting them into your DOS box.)
 
Changed:
<
<
For more information on appxutil.exe, see the APPXUTIL Overview.
>
>
For more information on appxutil.exe, see the APPXUTIL Overview.
 

Verifying and Analyzing a File

In Windows:

%APPXPATH%\..\tools\appxutil.exe -v={filename}

In Unix: $APPXPATH/../tools/appx -v={filename}
Line: 54 to 49
  If the invocation of this command results in no output, then the file passes verification. Any output from this command means that the file fails verification.
Changed:
<
<
To analyze a damaged file ...
>
>
To analyze a damaged file ...
 
In Windows:

%APPXPATH%\..\tools\appxutil.exe -an={filename}

In Unix: $APPXPATH/../tools/appx -an={filename}

Changed:
<
<
... gives you a"BRF>" prompt for {filename}. The most useful command at this prompt is ...
>
>
... gives you a"BRF>" prompt for {filename}. The most useful command at this prompt is ...
 
Changed:
<
<
VERIFY KEY #ALL
>
>
VERIFY KEY #ALL
  which performs counts the number of records in the .dat portion of the file verifying the .dat as it goes, and verifies all Keys in the .key portion of the file. Other useful commands are:
HELP          - list all available commands.

Line: 89 to 81
 (For quite large files, it may be faster to use the 'recover.exe' procedure below, the 3)CreateFiles to recreate your keyfile, albeit at the cost of more designer time required to do this safely.)

If the file doesn't pass COUNT REC analysis, you have a seriously damaged *.dat file. Your best bet at this point is to use the "Recover.exe" procedure below, or if necessary restore from backup.

Changed:
<
<

FREELIST damage

>
>

FREELIST damage

 
Changed:
<
<
A type of file damage that VERIFY KEY #ALL does not tell you about is freelist damage. The freelist is the list of pointers in AppxIO files that point to deleted records. This list can get damaged. It could for example point to a live record, indicating erroneously that it is deleted.
>
>
A type of file damage that VERIFY KEY #ALL does not tell you about is freelist damage. The freelist is the list of pointers in AppxIO files that point to deleted records. This list can get damaged. It could for example point to a live record, indicating erroneously that it is deleted.
  Up through APPX version 4.0.a (and perhaps higher), the menu driven Verify Integrity utilities, the 'appx -v={filename}, and the 'appx -an={filename}', VERIFY KEY #ALL option don't detect such damaged freelist conditions.
Line: 111 to 103
  If the file doesn't pass #ALL verification, but does pass COUNT REC verification, then it means that the *.dat portion of the file is probably OK, but the *.key indices are probably damaged. In this case, rename or delete the *.key file, then run 3)CreateFiles. This will recreate your indices from scratch. It will then be safe to export and re-import the file.
Changed:
<
<
(For quite large files, it may be faster to use the 'recover.exe' procedure below, then 3)CreateFiles to recreate your keyfile, albeit at the cost of more designer time required to do this safely.)
>
>
(For quite large files, it may be faster to use the 'recover.exe' procedure below, then 3)CreateFiles to recreate your keyfile, albeit at the cost of more designer time required to do this safely.)
 
Changed:
<
<
If the file doesn't pass COUNT REC analysis, you have a seriously damaged *.dat file. Your best bet at this point is to use the recover.exe procedure below, or if necessary restore from backup.
>
>
If the file doesn't pass COUNT REC analysis, you have a seriously damaged *.dat file. Your best bet at this point is to use the recover.exe procedure below, or if necessary restore from backup.
 

File Recovery: appx -r (or -recover)

Changed:
<
<

Usage:

>
>

Usage:

 
In Windows:

%APPXPATH%\..\appx.exe -r old.file new.file [deleted.record.file]

In Unix: $APPXPATH/../appx -r old.file new.file [deleted.record.file]
Line: 130 to 121
 This utility does not deal with duplicate primary or unique alternate indices.

* IMPORTANT * Any file you recover must have a new *.key file built. This is done by renaming or deleting the *.key file, then running 3)Create Files. The *.key file contains pointers to all of the data records in the *.dat file. By recovering the *.dat file, you invalidate the original *.key file.

Changed:
<
<

Example:

>
>

Example:

  The following command (in Windows) ...
Changed:
<
<
>
>
  appx.exe -r C:\APPX\DATA\DDD\PAT\Data\BB.dat C:\APPX\DATA\DDD\PAT\Data\BB.new
Deleted:
<
<
  ... will generate the following output and files ...
APPX Recover Utility:
             Input Filename = C:\32\DATA\ttt\PAT\Data\bb.dat

Changed:
<
<
Output Filename = C:\32\DATA\ttt\PAT\Data\bx.dat

File Header Information:

>
>
Output Filename = C:\32\DATA\ttt\PAT\Data\bx.dat
File Header Information:

  File Organization = 3 ( Fixed Length Records ) Record Length = 19 UnixIO Version = 2 Freelist Starting Address = 0
Changed:
<
<
End of File Address = 617

Recover Completion Information:

>
>
End of File Address = 617
Recover Completion Information:

  Active Records Copied = 3 Deleted Records Removed = 0 Overhead Records Removed = 0
Line: 166 to 152
  If 13)Verify 1)Integrity results in a 'Failed' condition, perform the following procedure:
Changed:
<
<
1) If you are running under Unix, su to the appx UserID.
>
>
1) If you are running under Unix, su to the appx UserID.

2) Call up a MS-DOS Command box (or Unix Command prompt). Change directories:

 
Changed:
<
<
2) Call up a MS-DOS Command box (or Unix Command prompt). Change directories:
>
>
cd {appx.exe.folder}\data\DDD\AAA\Data ... where ...
 
Changed:
<
<
cd {appx.exe.folder}\data\DDD\AAA\Data ... where ...
>
>
{appx.exe.folder} is the directory containing your 'appx.exe' engine,
DDD is your Database ID (or for your Appl Design files, the Appl's 2-digit version#), and
AAA is your Application ID.
 
Changed:
<
<
{appx.exe.folder} is the directory containing your 'appx.exe' engine,
DDD is your Database ID (or for your Appl Design files, the Appl's 2-digit version#), and
AAA is your Application ID.
>
>
 
Changed:
<
<
(If you are using FMS Groups, adjust this 'cd' accordingly.)
>
>
(If you are using FMS Groups, adjust this 'cd' accordingly.)
  Example:

D:
cd \APPX\data\DBS\APL\Data

Changed:
<
<
3) Type:
>
>
3) Type:
  {appx.exe.folder}\tools\recover.exe FILE.dat FILE.new
Deleted:
<
<
  ... where FILE is the name of the file you are recovering.
Changed:
<
<
4) From the Command prompt, perform:
>
>
4) From the Command prompt, perform:
  ren FILE.dat FILE.dat.keep
ren FILE.key FILE.key.keep

ren FILE.new FILE.dat

Deleted:
<
<
 
Changed:
<
<
This moves the original FILE.* files out of the way (but keeps them around a while in case they're needed), then moves the recovered FILE.new into place as the new FILE.dat.
>
>
This moves the original FILE.* files out of the way (but keeps them around a while in case they're needed), then moves the recovered FILE.new into place as the new FILE.dat.
 
Changed:
<
<
5) Go back to Database Management (or Design File Management) for your application. Run 3)Create Files on FILE. This creates a new FILE.key to go along with your recovered FILE.dat.
>
>
5) Go back to Database Management (or Design File Management) for your application. Run 3)Create Files on FILE. This creates a new FILE.key to go along with your recovered FILE.dat.
 
Changed:
<
<
To double-check, run 13)Verify Menu, 1)Integrity to confirm that the file is OK, and that the Active Records Copied above equals the number reported in the Verify Integrity utility.
>
>
To double-check, run 13)Verify Menu, 1)Integrity to confirm that the file is OK, and that the Active Records Copied above equals the number reported in the Verify Integrity utility.
 

Comments:

Read what other users have said about this page or add your own comments.


Deleted:
<
<

<--/commentPlugin-->
 \ No newline at end of file
Added:
>
>

<--/commentPlugin-->

Revision 12012-02-14 - ChrisBrower

Line: 1 to 1
Added:
>
>
META TOPICPARENT name="SystemAdministration"

File Analysis and Recovery

The appx utilities, found in the /tools directory below the appx engine, allow batch manipulation and recovery of AppxIO files. In the Windows environment, execute these commands from a DOS popup box. Or use the command line to perform the same functions in Unix.

Command Line Invocations: appx.exe or appx

'appx.exe' lets you perform switched invocations of APPX for Windows, without clearing the DOS box. From a Unix prompt, the command is simply 'appx'. Here's how you would use switches to verify and analyze APPX data files:

Issuing in the DOS box the command ...

appx -u

more

Or in Unix, the command ... appx -u more

... will result in the output ...

Usage:

        -k                          define a new keymap
        -m=<[user_id:]keymap_name>  override keymap ID
        -d=<database_id>            override startup database
        -a=<application_id>         override startup application
        -t=<process_type>           override startup process type
        -p=<process_name>           override startup process name
        -i=<flat_file_name>         convert a flat file into AppxIO
        -e=<data_file_name>         convert an AppxIO file into flatfile
        -v=<data_file_name>         verify the integrity of AppxIO file
        -an=<data_file_name>        analyze an AppxIO file
        -l=<log file name>          start a license server
        -r (or -recover)            recover damaged files (see below)

Restrictions:

An application_id and process_type must always be included when specifying a process_name. If an application_id is included without specifying a process_type/name, the startup menu for the application is used.

If no application_id is specified, the startup application and menu for the database is used. If no database_id is specified, the startup database defined for the user within System Administration is used. If the startup database is also unspecified, the APPX main menu is used.

The valid process_types are Menu, Job, Input, Output, Update, Action, Inquiry, Query, Status, and Subroutine. Use underscores (_) in place of embedded spaces within parameters.

Substituting the "-k" through "-l=" switches will let you specify particular actions upon invoking the appx.exe engine.

(Consider the possibility of building your desired command line invocation strings in MS Word, Notepad or WordPad, then cutting and pasting them into your DOS box.)

For more information on appxutil.exe, see the APPXUTIL Overview.

Verifying and Analyzing a File

In Windows:

%APPXPATH%\..\tools\appxutil.exe -v={filename}

In Unix: $APPXPATH/../tools/appx -v={filename}

... will manually verify an APPX datafile. This does the same thing as interactive "Verify Files Menu", "Verify Integrity" from the Database, Design File, and System Administration File Management menus, but from a command line.

If the invocation of this command results in no output, then the file passes verification. Any output from this command means that the file fails verification.

To analyze a damaged file ...

In Windows:

%APPXPATH%\..\tools\appxutil.exe -an={filename}

In Unix: $APPXPATH/../tools/appx -an={filename}

... gives you a"BRF>" prompt for {filename}. The most useful command at this prompt is ...

VERIFY KEY #ALL

which performs counts the number of records in the .dat portion of the file verifying the .dat as it goes, and verifies all Keys in the .key portion of the file. Other useful commands are:

HELP          - list all available commands.

DUMP HEADER   - will give you info about the file, including the
                number of keys.

COUNT REC     - will give a count of the number of records that
                {FILENAME.dat} believes it contains.

VERIFY KEY #0 - verifies the primary index, and gives # of records.

VERIFY KEY #1 - verifies the alt index #1, and gives # of records.

VERIFY KEY #2 - verifies the alt index #2, etcetera ...

QUIT          - exit the "-an=" utility.

If the file doesn't pass #ALL verification, but does pass COUNT REC verification, then it means that the *.dat portion of the file is probably OK, but the *.key indices are probably damaged. In this case, rename or delete the *.key file, then run 3)CreateFiles. This will recreate your indices from scratch.

(For quite large files, it may be faster to use the 'recover.exe' procedure below, the 3)CreateFiles to recreate your keyfile, albeit at the cost of more designer time required to do this safely.)

If the file doesn't pass COUNT REC analysis, you have a seriously damaged *.dat file. Your best bet at this point is to use the "Recover.exe" procedure below, or if necessary restore from backup.

FREELIST damage

A type of file damage that VERIFY KEY #ALL does not tell you about is freelist damage. The freelist is the list of pointers in AppxIO files that point to deleted records. This list can get damaged. It could for example point to a live record, indicating erroneously that it is deleted.

Up through APPX version 4.0.a (and perhaps higher), the menu driven Verify Integrity utilities, the 'appx -v={filename}, and the 'appx -an={filename}', VERIFY KEY #ALL option don't detect such damaged freelist conditions.

To find a damaged freelist condition, you must use the APPX engine (the engine is all that's necessary) release 4.0.a or higher, then go into the BRF> command line from 'appx -an={filename}', then execute the command:

VERIFY FREELIST

If the freelist is damaged, this command will give you an error condition to that effect. To repair the damage, execute:

VERIFY KEY #ALL

If the file passes this verification, you may safely export and re-import the file, in order to initialize its freelist.

If the file doesn't pass #ALL verification, but does pass COUNT REC verification, then it means that the *.dat portion of the file is probably OK, but the *.key indices are probably damaged. In this case, rename or delete the *.key file, then run 3)CreateFiles. This will recreate your indices from scratch. It will then be safe to export and re-import the file.

(For quite large files, it may be faster to use the 'recover.exe' procedure below, then 3)CreateFiles to recreate your keyfile, albeit at the cost of more designer time required to do this safely.)

If the file doesn't pass COUNT REC analysis, you have a seriously damaged *.dat file. Your best bet at this point is to use the recover.exe procedure below, or if necessary restore from backup.

File Recovery: appx -r (or -recover)

Usage:

In Windows:

%APPXPATH%\..\appx.exe -r old.file new.file [deleted.record.file]

In Unix: $APPXPATH/../appx -r old.file new.file [deleted.record.file]

This utility will read an APPX indexed data file (.dat) and copy the good/active records to the output file. Any corrupt data is hex-dumped to the screen. If you redirect standard output ( >bad.data ), you can collect any corrupted data into a file, for later examination.

Deleted Records are discarded, unless a third filename is given on the command line. In this case, the deleted records are copied to the given file. This file is a fixed-length consecutive file. To access it from within APPX, you must design transfer your data dictionary, remove the indices, and change the file type to consecutive. This is needed since the deleted records could contain duplicate key values.

Overhead blocks are also removed. These blocks are used to track deleted record space within the file for reuse. Since the new file has no deleted record space, it no longer needs these blocks.

This utility does not deal with duplicate primary or unique alternate indices.

* IMPORTANT * Any file you recover must have a new *.key file built. This is done by renaming or deleting the *.key file, then running 3)Create Files. The *.key file contains pointers to all of the data records in the *.dat file. By recovering the *.dat file, you invalidate the original *.key file.

Example:

The following command (in Windows) ...

appx.exe -r C:\APPX\DATA\DDD\PAT\Data\BB.dat C:\APPX\DATA\DDD\PAT\Data\BB.new

... will generate the following output and files ...

APPX Recover Utility:
             Input Filename = C:\32\DATA\ttt\PAT\Data\bb.dat
            Output Filename = C:\32\DATA\ttt\PAT\Data\bx.dat

File Header Information:
          File Organization = 3 ( Fixed Length Records )
              Record Length = 19
             UnixIO Version = 2
  Freelist Starting Address = 0
        End of File Address = 617

Recover Completion Information:
     Active Records Copied = 3
    Deleted Records Removed = 0
   Overhead Records Removed = 0
          File Errors Found = 0
      New Eof Seek Location = 617
 Space Allocation Reduction = 0 bytes

* You MUST create a new '.key' file that matches your new '.dat' file!

What to do with a file that Fails Verification?

If 13)Verify 1)Integrity results in a 'Failed' condition, perform the following procedure:

1) If you are running under Unix, su to the appx UserID.

2) Call up a MS-DOS Command box (or Unix Command prompt). Change directories:

cd {appx.exe.folder}\data\DDD\AAA\Data ... where ...

{appx.exe.folder} is the directory containing your 'appx.exe' engine,
DDD is your Database ID (or for your Appl Design files, the Appl's 2-digit version#), and
AAA is your Application ID.

(If you are using FMS Groups, adjust this 'cd' accordingly.)

Example:

D:
cd \APPX\data\DBS\APL\Data

3) Type:

{appx.exe.folder}\tools\recover.exe FILE.dat FILE.new

... where FILE is the name of the file you are recovering.

4) From the Command prompt, perform:

ren FILE.dat FILE.dat.keep
ren FILE.key FILE.key.keep

ren FILE.new FILE.dat

This moves the original FILE.* files out of the way (but keeps them around a while in case they're needed), then moves the recovered FILE.new into place as the new FILE.dat.

5) Go back to Database Management (or Design File Management) for your application. Run 3)Create Files on FILE. This creates a new FILE.key to go along with your recovered FILE.dat.

To double-check, run 13)Verify Menu, 1)Integrity to confirm that the file is OK, and that the Active Records Copied above equals the number reported in the Verify Integrity utility.

Comments:

Read what other users have said about this page or add your own comments.



<--/commentPlugin-->
 
This site is powered by the TWiki collaboration platform Powered by PerlCopyright © 2008-2021 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback