butil

The PSQL Maintenance Utility, or butil, is a command line utility that performs command file and data manipulations on a data file.

The maintenance utility performs the following file and data manipulations:

•

Starts and stops continuous operations for use in performing server backups.

•

Recovers changes made to a file between the time of the last backup and a system failure.

•

Imports and exports ASCII, unformatted, and SDF sequential data.

•

Copies data between data files.

•

Returns MicroKernel Engine version information.

Continuous operation is an MicroKernel Engine feature that enables you to back up files while they are in use by PSQL-based applications. Two maintenance commands, startbu and endbu, begin and end continuous operation on a file or set of files.

Synopsis

butil

-CLONE outputFile sourceFile [/O<owner | *>] [/pagecompresson | /pagecompressoff] [/recordcompresson | /recordcompressoff] [/UIDuname /PWDpword [/DBdbname]]

-CLROWNER sourceFile /O<owner | *> [/UIDuname /PWDpword [/DBdbname]]

@commandFile [commandOutputFile]

-COPY sourceFile outputFile
[/O< owner1 | *> [/O<owner2 | *>]] [/UIDuname /PWDpword [/DBdbname]]

-CREATE outputFile descriptionFile [< Y | N >] [/UIDuname /PWDpword [/DBdbname]]

-DROP sourceFile < keyNumber | SYSKEY >
[/O<owner | *>] [/UIDuname /PWDpword [/DBdbname]]

-ENDBU < /A | sourceFile | @listFile > [/UIDuname /PWDpword [/DBdbname]]

-INDEX sourceFile indexFile descriptionFile
[ /O<owner | *>] [/UIDuname /PWDpword [/DBdbname]]

-LOAD unformattedFile outputFile [/O<owner |*>] [/UIDuname /PWDpword [/DBdbname]]

-RECOVER sourceFile unformattedFile [/O<owner |*>] [/UIDuname /PWDpword [/DBdbname]]

-SAVE sourceFile unformattedFile
[Y indexFile | N <keyNumber | -1>] [/O<owner1 | *>
[/O<owner2 | *>]] [/UIDuname /PWDpword [/DBdbname]]

-SETOWNER sourceFile /O<owner | *> level [/UIDuname /PWDpword [/DBdbname]]

-SINDEX sourceFile <descriptionFile | SYSKEY> [keyNumber] [/O<owner | *>] [/UIDuname /PWDpword [/DBdbname]]

-STARTBU <sourceFile | @listFile> [/UIDuname /PWDpword [/DBdbname]]

-STAT <sourceFile> [/O<owner | *>] [/UIDuname /PWDpword [/DBdbname]]

-VER

Note: On Linux or OS X distributions, all “/” parameters use the hyphen (“-”) instead of the slash. For example, the /O parameter for butil -copy is -O, as in butil -copy -O.

Options

Maintenance Utility command options are not case sensitive unless the option is a filename.

If you run butil without specifying a command option or with an invalid command option, a usage message is printed. The usage message indicates that there is an optional /S command line argument to butil. This argument is ignored under Linux or OS X.

For a complete discussion of the utility commands, options, and examples, see the section Btrieve Command-Line Maintenance Utility (butil) in Advanced Operations Guide.