Database administration utilities

Many of the utilities allow you to store command-line options in a configuration file.

Creates a client-side or a server-side backup of database files and transaction logs for running databases.

Allows clients to find database servers running on other subnets and through firewalls where UDP broadcasts normally do not reach.

Creates X.509 certificates.

Displays values within a Public Key Infrastructure (PKI) object, converts the encoding of PKI objects, or encrypts and decrypts private keys.

Creates, deletes, describes, and lists SQL Anywhere ODBC data sources.

Executes SQL statements on a database.

Erases database files and associated transaction logs, or individual transaction log files.

Generates a diagnostic log that allows the user to examine information for user-defined and system events. Use the sp_trace_events system procedure to see the descriptions of the events.

Uses obfuscation or encryption to hide the contents of configuration files and initialization files.

Converts a histogram into a Microsoft Excel chart containing information about the selectivity of predicates.

Displays information about the specified database.

Creates a new database.

Executes SQL statements and runs script files against a database.

Creates RSA key pairs for use with MobiLink end-to-end encryption.

Reports and changes the registry settings that control the language used by the database server, SQL Central, Interactive SQL, and other tools.

Translates a transaction log into a SQL script file.

Returns performance statistics for database servers on Unix.

Tests connections to database servers and databases.

Starts the Profiler so that you can profile a database or review the contents of a previous profiling session.

Locates database servers on the TCP/IP network.

Applies your software license to your database server or MobiLink server.

Creates, modifies, and deletes SQL Anywhere services.

Creates, modifies, and deletes SQL Anywhere services.

Starts a database server in the background.

Stops a database or database server.

Sends performance data about errors and diagnostic information to Technical Support.

Administers the transaction log for a database.

Unloads a database into a specified directory.

Updates the system tables and views, adds new database options, recreates all system stored procedures, installs jConnect support, archives the transaction log, and creates a new transaction log.

Validates the indexes and keys on tables and materialized views.

Returns information about the specified executable.