General Reference : User's Guide : Command Line Interface Utilities
 
Command Line Interface Utilities
Using Zen from the Command Line
This following topics discuss Zen command line interface (CLI) utilities:
CLI Utilities Overview
Command Line Interface Tool Reference
CLI Utilities Overview
In addition to providing GUI utilities, Zen provides a number of command line interface (CLI) utilities that you can use. In most cases, these utilities duplicate functionality you can perform with GUI utilities.
For default locations of Zen files, see Where are the files installed? in Getting Started with Zen.
Platforms that Include CLI Utilities
These utilities are provided in the following installations:
Windows – Enterprise Server, Cloud Server, Workgroup, and a limited set on Client
Linux, macOS, and Raspbian – Enterprise Server, Cloud Server, and a limited set on Client
The following summary of utilities notes which ones are present in a particular installation.
Where to Find CLI Utilities
Please note the location based on your platform.
Windows
In Windows, the utilities are installed to the bin directory of your Zen installation. If you installed to the default installation location, C:\Program Files (x86)\Actian\Zen\bin\. Since the Zen installation places your installation directory in the Path environment variable, these utilities should be available from any command prompt.
Linux, macOS, and Raspbian
On Linux and macOS, utilities are installed to /usr/local/actianzen/bin. The user zen-svc has the necessary environment variables to use the utilities. If you wish to use utilities from accounts other than zen-svc, follow the instructions in Zen Account Management on Linux, macOS, and Raspbian.
Utilities by Platform and Engine Type
The following tables outlines the command line tools, the platform where they are available, as well as whether the tool also has a graphical user interface.
Tool
Description
GUI Available
Windows
Linux or macOS
Server
Client
Server
Client
Configures Zen components
Zen Control Center (see Configuration Reference in Advanced Operations Guide)
Yes
Yes
Yes
Yes
Imports data into a database
No
Yes
No
Yes
No
Monitors Zen activity
Monitor tool (see Monitoring in Advanced Operations Guide)
Yes
 
Yes
 
Creates and administers database user names and passwords
No
No
No
Yes
No
Repairs and manipulates data files
Maintenance tool (see Manipulating Btrieve Data Files with Maintenance in Advanced Operations Guide)
Yes
Yes
Yes
Yes
w64clilcadm (Windows 64-bit)
clilcadm64 (Linux or macOS 64-bit)
Applies and administers user licenses.
License Administrator (see License Administration)
Yes
No
Yes
No
w64clipaadm (Windows 64-bit)
clipaadm64 (Linux or macOS 64-bit)
Phone authorization tool used to authorize product keys when an internet connection is unavailable.
(Phone authorization only)
Phone Authorization Wizard opened by running guipaadm at a command prompt
Yes
Yes
Yes
Yes
Finds and corrects data fragmentation, rebuilds indexes, removes unused space.
Defragmenter (see Monitoring Data File Fragmentation in Advanced Operations Guide)
Yes
No
Yes
No
Creates and administers named databases
No
No
No
Yes
No
Exports delimited data to a text file based on a SELECT statement
Yes
Yes
Yes
Yes
Creates and administers Engine DSNs on the server
No
No
No
Yes
Yes
isql64 (Linux or macOS 64-bit)
Allows you to run SQL statements interactively and test connectivity to a DSN.
No
No
No
Yes
Yes
w64licgetauth (Windows 64-bit)
licgetauth64 (Linux or macOS 64-bit)
Transmits authorization request data and retrieves authorization key data.
(Offline authorization only)
No
Yes
Yes
Yes
Yes
Notification Viewer
Provides two interfaces: Notification area icons and a graphical user interface. Although not strictly a CLI tool, it is mentioned here for reference.
See Notification Viewer in Advanced Operations Guide.
Yes
No
Yes
No
Manipulates Zen services
No
Yes
Yes
No
No
Configures Zen components by editing the Zen registry
No
No
No
Yes
Yes
Register Zen components
No
No
No
Yes
Yes
Specifies user names and passwords for secure databases
Zen Control Center (see Zen Security in Advanced Operations Guide)
Yes
Yes
Yes
Yes
Processes SQL statements in a command file
Zen Control Center (see SQL Editor)
Yes
Yes
Yes
Yes
Specifies user names and passwords for remote servers
No
Yes
Yes
Yes
Yes
Rebuilds MicroKernel data files.
Rebuild wizard (see Rebuild Tool GUI Reference in Advanced Operations Guide)
Yes
Yes
Yes
Yes
Command Line Interface Tool Reference
This section provides a reference for the following command line interface utilities:
bcfg
bdu
bmon
btadmin
butil
clilcadm
w64clilcadm
clilcadm64
clipaadm
w64clipaadm
clipaadm64
dbdefrag
dbmaint
dsnadd
isql
isql64
licgetauth
w64licgetauth
licgetauth64
psc
psregsvr
pvdbpass
pvddl
pvnetpass
rbldcli