Check and resynchronize ISAM file if out of sync (Revision 6 or higher)
|
WSupported on Windows
|
USupported on Unix
|
|
NSupported in Synergy .NET
|
isutl -s [sync_option] [-h|-?] [-mLevel#] [-t directory_list] [-%] filename[ ...]
Options
sync_option
(optional) One or more of the following:
Check and resynchronize the file using cooperative locking without requiring exclusive access. (default)
Check and resynchronize the file using exclusive locking.
-h or -?
(optional) Display help screen.
-mlevel#
(optional) Specify a message level that defines the amount of information displayed during an operation, where level is one of the following values:
0 = No output is generated. All errors generated are returned in the form of an exit status. (See Exit status in the Discussion.)
1 = Only errors and necessary output are displayed. (default)
2 = Process information is displayed, in addition to errors and necessary output.
-t directory_list
(optional) Specify one or two directories (separated by a comma) to store temporary files. (See Temporary files for isutl in the Discussion.)
-%
(optional) Display a running status (0 to 100) to indicate the percentage completed by the operation. (See Running status in the Discussion.)
filename
The name of the ISAM file(s) into which you want to check and resynchronize. The default extension is .ism.
Isutl -s is supported only on 64-bit operating systems.
A RESILIENT or FULLRESILIENT file that is out of sync must be resynchronized before it can be opened. This happens automatically in the following cases:
- When remote files are opened or updated via 64-bit xfServer.
- When local files are opened or updated and rsynd is running on the system as described in Resynchronization and resilience.
- When you’ve configured xfServer to resynchronize files on start-up, as described in Automating file maintenance with xfServer (Windows and Unix).
In all other cases, you’ll need to run isutl -s to manually resynchronize your ISAM files.
Isutl -s first checks a resilient ISAM file for synchronization. If the file is not marked with the RESILIENT or FULLRESILIENT file option, a “File not resilient” message is displayed.
If the resilient file is in correct synchronization, a “File in sync” message is displayed. Otherwise, the file is re-indexed and resynchronized, and a log entry is made in isutl.log.
The -t (temporary file directories) option specifies one or two directories, separated by a comma, for temporary work files used by isutl. The directory specifications must be valid path specifications or logicals that reference a local or network drive (although we do not recommend network locations except as a way to provide enough space). An xfServer remote file specification is not supported. The default location for temporary files is the current directory.
If only the first directory is specified, it is the directory in which to place all temp files (all_tempfilesdirectory). If two directories are specified, the first is the directory in which to place all key files (key_tempfilesdirectory). The directory specified after the comma (regardless of whether or not a first directory is specified) is the directory in which to place all sort files (sort_tempfilesdirectory).
Using -t is useful in managing disk usage, but it can also be used to improve performance. Using temp directories for better performance is accomplished by isolating I/O operations to separate physical disks (especially on SSD drives). Here are some options:
-
Performance will be better if both keys and sort files are located on separate disks from the target file: -tall_tempfilesdirectory.
-
Performance may improve even more if the sort files are located on a different disk to separate the input files from the output sort files during the key sorts: -t key_tempfilesdirectory,sort_tempfilesdirectory.
-
On files with multiple keys and only a single secondary disk available, offloading just the key sorts and leaving the key files on the current disk may improve performance by specifying just the sort directory preceded by a comma: -t ,sort_tempfilesdirectory.
|
The use of temporary files to enhance performance is only beneficial when the specified directories reside on a different physical disk or LUN, not just different directories or file systems on the same drive. |
For very large files, if you have access to more than one physical disk, we recommend using the -t option for better performance as well as space management.
|
Make sure sufficient disk space is available for temporary work files, especially when processing large ISAM files. The amount of disk space required for temporary files varies with each file and operation being performed. |
When the -% (display running status) option is specified, the numbers displayed indicate the percentage of the overall reload operation completed for each file. When message level 2 (-m2) is also specified, an individual process percentage as well as a total overall percentage is displayed for each file.
Isutl generates an exit status, which can be especially useful if you’ve used the -m0 option. Possible return values are as follows:
|
Exit status |
Meaning |
|---|---|
|
0 |
Isutl was successful. |
|
A Synergy DBMS error number |
Isutl failed as a result of the specified error. (See Synergy DBMS errors for the message text that maps to each error number.) |
|
-1 |
More than one file was specified on the command line, and at least one file failure occurred. |
