Administration utilities overview

Reference Manual
CHAPTER 4. Database Administration Utilities

Administration utilities overview

This chapter presents reference information on the programs and database administration utilities that are part of Adaptive Server Anywhere. The utilities can be accessed from Sybase Central, from Interactive SQL, or as command-line programs.

For Info For comprehensive documentation on Sybase Central, see the Sybase Central online Help. For an introduction to the Sybase Central database administration tool, see Managing Databases with Sybase Central.

The administration utilities use a set of system environment variables. These variables are described in Environment variables.

The administration utilities also use a standard set of return codes. These return codes are described in Software component Return codes.

Adaptive Server Anywhere for Unix platforms
The syntax for starting utilities on Unix platforms differs slightly from other platforms. On Unix platforms, programs are executed with commands typed in the lower case, and program files do not have an .exe suffix.

File administration statements

A set of SQL statements are available that carry out some of the tasks that the administration utilities carry out. These statements are listed in SQL Statements.

Software component Return codes

All database components use the following return codes. The header file sqldef.h has constants defined for these codes.

Code

Explanation

0

Success

1

General failure

2

Invalid file format, and so on

3

File not found, unable to open, and so on

4

Out of memory

5

Terminated by the user

6

Failed communications

7

Missing a required database name

8

Client/server protocol mismatch

9

Unable to connect to the database server

10

Database server not running

11

Database server not found

254

Reached stop time

255

Invalid parameters on the command line

Code	Explanation
0	Success
1	General failure
2	Invalid file format, and so on
3	File not found, unable to open, and so on
4	Out of memory
5	Terminated by the user
6	Failed communications
7	Missing a required database name
8	Client/server protocol mismatch
9	Unable to connect to the database server
10	Database server not running
11	Database server not found
254	Reached stop time
255	Invalid parameters on the command line