You enter a utility program command at the system prompt in a UNIX shell.
If a utility:
Has an icon in the Sybase for Windows or Sybase for the Windows program group, double-click the icon to launch the utility program.
Does not have an icon in the program group, enter the utility program command at the Windows command prompt to launch the utility program.
Place
characters with special meaning to the shell (the command prompt
in Windows), such as the backslash (\),
asterisk (*), slash
(/), and spaces, in quotes.
You can precede some special characters with the backslash (\)
to “escape” them. This prevents the shell (command
prompt) from interpreting the special characters.
Table 7-1 describes the utility programs available with Adaptive Server.
The utility programs described in Table 7-1 may allow you to
use a -P parameter to enter your password.
If security is an issue, do not use this parameter to specify your
password. Another user may have an opportunity to see it. Instead,
log in as usual without the -P parameter,
and let Adaptive Server prompt you for your password.
Utility |
Description |
|---|---|
Executable form of the Backup Server™ program. |
|
Copies rows in a database table to or from an operating system file in a user-specified format. |
|
Converts a server-certificate request into a certificate authority-signed certificate. |
|
Export or import a PKCS#12 file. |
|
Creates a server certificate request and corresponding private key in two ways: |
|
Loads the character sets and sort order files. |
|
Precompiler for COBOL. |
|
Precompiler for C. |
|
Executable form of the Adaptive Server program. |
|
Generates data definition language for server- and database-level objects in ASE. |
|
Copies definitions for specified views, rules, defaults, triggers, procedures, or reports from a database to an operating system file or from an operating system file to a database. |
|
Allows you to view and edit server entries in the interfaces file in command-line mode. |
|
Allows you to view and edit server entries in the interfaces file using a graphical user interface based on X11/Motif. |
|
Copies a retained JAR from an Adaptive Server to a client file. |
|
Installs a JAR from a client file into an Adaptive Server. |
|
Interactive SQL parser to Adaptive Server. |
|
Installs a new language on the Adaptive Server. |
|
Displays optimizer statistics or loads updated statistics into system tables. |
|
Performs tests on an installation or database to determine its readiness for upgrade. |
|
Creates and prints an encrypted LDAP password in the libtcl.cfg file. |
|
qptune |
Enables you to fix missing statistics and identify the best query plan, optimization goal, or other configuration settings, and apply them at the query or server level. |
Shows Adaptive Servers and Backup Servers that are currently running on the local machine. |
|
Debugs stored procedures and triggers. |
|
Installs and modifies languages, character sets, and sort order defaults for Adaptive Server in GUI mode. |
|
Installs and modifies languages, character sets, and sort order defaults for Adaptive Server in command-line mode. |
|
Executable form of the Adaptive Server program. |
|
Upgrades your currently installed release of Adaptive Server to the newest release in GUI mode. |
|
Upgrades your currently installed release of Adaptive Server to the newest release in command-line mode. |
|
Creates a new Adaptive Server, Backup Server, or XP Server in GUI mode with default or user-specified values for key configuration attributes. |
|
Creates a new Adaptive Server, Backup Server, or XP Server in command-line mode with default or user-specified values for key configuration attributes. |
|
Starts an Adaptive Server or a Backup Server. |
|
srvmgr |
Starts Adaptive Server and Backup Server as Windows services. |
sybcluster |
Manages a shared-disk cluster. See Chapter 8, “Using sybcluster to Manage the Cluster.” |
sybdiag |
Collects comprehensive configuration and environment data for Adaptive Server. |
sybload |
Uploads Sybase products from the distribution media and builds the Sybase installation directory from the command line. |
sybmigrate |
Enables you to migrate database from a server using 2K logical pages to a server using 4, 8, or 16K logical pages. |
sybsetup |
Installs and configures Adaptive Server from a single location using a GUI interface. |
Starts XP Server manually. |
