Getting started

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.

The utility programs available with Adaptive Server are:

backupserver – executable form of the Backup Server^™ program.

bcp – copies rows in a database table to or from an operating system file in a user-specified format.

certauth – converts a server-certificate request into a certificate authority-signed certificate.

certpk12 – export or import a PKCS#12 file.

certreq – creates a server certificate request and corresponding private key in two ways:

charset – loads the character sets and sort order files.

cobpre – precompiler for COBOL.

cpre – precompiler for C.

dataserver – executable form of the Adaptive Server program.

ddlgen – generates data definition language for server- and database-level objects in ASE.

defncopy – 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.

dscp – allows you to view and edit server entries in the interfaces file in command-line mode.

dsedit – allows you to view and edit server entries in the interfaces file using a graphical user interface.

extractjava – copies a retained JAR from an Adaptive Server to a client file.

installjava – installs a JAR from a client file into an Adaptive Server.

isql – interactive SQL parser to Adaptive Server.

langinstall – installs a new language on the Adaptive Server.

optdiag – displays optimizer statistics or loads updated statistics into system tables.

preupgrade – performs tests on an installation or database to determine its readiness for upgrade.

pwdcrypt – creates and prints an encrypted LDAP password in the libtcl.cfg file.

qmutil – (Cluster Edition only) allows you to back up, restore, and reconfigure the quorum device.

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.

showserver – shows Adaptive Servers and Backup Servers that are currently running on the local machine.

sqldbgr – debugs stored procedures and triggers.

sqlloc – installs and modifies languages, character sets, and sort order defaults for Adaptive Server in GUI mode.

sqllocres – installs and modifies languages, character sets, and sort order defaults for Adaptive Server in command-line mode.

sqlsrvr – executable form of the Adaptive Server program.

sqlupgrade – upgrades your currently installed release of Adaptive Server to the newest release in GUI mode.

sqlupgraderes – upgrades your currently installed release of Adaptive Server to the newest release in command-line mode.

srvbuild – creates a new Adaptive Server, Backup Server, or XP Server in GUI mode with default or user-specified values for key configuration attributes.

srvbuildres – creates a new Adaptive Server, Backup Server, or XP Server in command-line mode with default or user-specified values for key configuration attributes.

startserver – starts an Adaptive Server or a Backup Server.

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.

sybmigrate – enables you to migrate database from a server using 2K logical pages to a server using 4, 8, or 16K logical pages.

sybtsmpasswd – records or changes the user password and creates the Tivoli Storage Manager (TSM) encrypted password file, TSM.PWD, on the TSM client machine.

xpserver – starts XP Server manually.

These utility programs 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.