Line: 1 to 1 | ||||||||
---|---|---|---|---|---|---|---|---|
APPXUTIL Overview | ||||||||
Added: | ||||||||
> > | This document is applicable to versions of APPX prior to 4.2.0. If you are using a later version refer to File Analysis & Recovery. | |||||||
What is APPXUTIL?APPXUTIL.EXE is used to invoke the command line functions of APPX, on a Windows PC. These functions include: | ||||||||
Line: 41 to 43 | ||||||||
How do I verify all files in a database?The "appxutil -v" command verifies one file at a time. To verify an entire database, you could individually enter the commands at the DOS command prompt, but it is more efficient to create a batch file which does it. Use your favorite text editor to create a text file (NOT a .doc file!) which looks like: | ||||||||
Deleted: | ||||||||
< < |
| |||||||
Added: | ||||||||
> > |
| |||||||
It's necessary to add a line to the script for each data file. You may want to do a "dir > temp", then bring that up in an editor window, and cut and paste filenames into the verify script. Save this file as "verfyAAA.bat", in the directory containing appxutil. It is a good idea to create a batch file to verify each of your databases, in advance, so that when you want to verify all files in a database, you can just run the applicable script without having to spend time creating it. |
Line: 1 to 1 | ||||||||
---|---|---|---|---|---|---|---|---|
APPXUTIL Overview | ||||||||
Line: 16 to 16 | ||||||||
Starting with APPX 3.3 and above, the data file verification (-v) function can be invoked from the database management menu, so it is not necessary to use APPXUTIL.EXE to access that capability. However, APPXUTIL.EXE is still needed by users of APPX 3.3 and above, to perform one of the two steps required for cross-platform data file import/export, and for detailed data file/key integrity analysis.
Where do I get it? | ||||||||
Changed: | ||||||||
< < | APPXUTIL.EXE is found in the .\Tools directory, underneath the appx.exe engine. | |||||||
> > | You can get appxutil from http://www.appx.com/ftp/. Go to folder appx/support/utilities/appxutil and download the appxutil.zip file. | |||||||
Verifying data files with APPXUTILWhat does it mean to 'verify' a data file? |
Line: 1 to 1 | ||||||||
---|---|---|---|---|---|---|---|---|
APPXUTIL Overview | ||||||||
Line: 50 to 50 | ||||||||
Analyzing a data file will interactively provide more information about the file's internal structure. In general, this isn't important unless the file has failed verification. | ||||||||
Changed: | ||||||||
< < | For more information, see File Analysis and Recovery | |||||||
> > | For more information, see File Analysis and Recovery | |||||||
Comments:Read what other users have said about this page or add your own comments. |
Line: 1 to 1 | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Added: | |||||||||||
> > |
APPXUTIL OverviewWhat is APPXUTIL?APPXUTIL.EXE is used to invoke the command line functions of APPX, on a Windows PC. These functions include:
Why does a user of APPX for Windows need it?Traditionally, APPX data file verification and analysis are done from the command line, using the normal 'appx' engine itself. Since APPX for Windows is a GUI program, and the data file verification and analysis functions are text-based utilities, it is necessary to have a separate, alternate copy of the 'appx' engine which runs in text rather than GUI mode, in order to use those functions. This alternate version of APPX is called APPXUTIL.EXE. Starting with APPX 3.3 and above, the data file verification (-v) function can be invoked from the database management menu, so it is not necessary to use APPXUTIL.EXE to access that capability. However, APPXUTIL.EXE is still needed by users of APPX 3.3 and above, to perform one of the two steps required for cross-platform data file import/export, and for detailed data file/key integrity analysis.Where do I get it?APPXUTIL.EXE is found in the .\Tools directory, underneath the appx.exe engine.Verifying data files with APPXUTILWhat does it mean to 'verify' a data file?Verification checks to make sure there are no duplicate keys, that each key points to only one record, that all keys point to active (rather than deleted) records, and that all indexes for that file have the same number of keys.When might I want to do it?
How can APPX data file indexes become corrupt?The 'APPXIO' file system has proven itself to be very stable over the years. However, no database system is immune to the effects of system or application crashes, in which unpredictable things happen to database files. For example, APPX might be in the middle of adding a record, and has completed updating 2 of 3 keys, at the time of a crash. This leaves the index for that file in an inconsistent state. The data itself is correct and intact, but the key file must be rebuilt in order for the indexes to be correct. Typically, a system administrator is not going to know in detail what was happening on the system, when a power failure or equipment problem occurred, and will not know whether any APPX data files on the system became corrupted as a result. Verifying the data file would tell you whether or not it is necessary to run "Rebuild keys" for that file.How do I verify the file 'ORDER' in application 'AAA', database 'DDD'?
How do I verify all files in a database?The "appxutil -v" command verifies one file at a time. To verify an entire database, you could individually enter the commands at the DOS command prompt, but it is more efficient to create a batch file which does it. Use your favorite text editor to create a text file (NOT a .doc file!) which looks like:
Analyzing data files with APPXUTILAnalyzing a data file will interactively provide more information about the file's internal structure. In general, this isn't important unless the file has failed verification. For more information, see File Analysis and RecoveryComments:Read what other users have said about this page or add your own comments.-- ChrisBrower - 2011-06-21 |