Sybase Technical Library - Product Manuals Home
[Search Forms] [Previous Section with Hits] [Next Section with Hits] [Clear Search] Expand Search
Configuring Adaptive Server for UNIX Platforms [Table of Contents] Chapter 1 Introduction

Configuring Adaptive Server for UNIX Platforms

[-] About This Book

About This Book

This guide, Configuring Adaptive Server for UNIX Platforms, provides instructions for performing specific configuration tasks for Sybase® Adaptive Server(TM) Enterprise on the following platforms:

The operating system release levels for these platforms on which Adaptive Server is certified to execute is provided in the installation documentation or release bulletin for your platform.

This guide provides:

Before configuring Adaptive Server according to the instructions in this book, you should have a newly installed or upgraded Adaptive Server on your system. If you do not, follow the installation and upgrade instructions in the installation documentation for your platform.

Audience

This guide is written for Sybase System Administrators.

How to use this book

This book contains the following chapters:

Related documents

The following documents comprise the Sybase Adaptive Server Enterprise documentation:

Other sources of information

Use the Sybase Technical Library CD and the Technical Library Product Manuals web site to learn more about your product:

Sybase certifications on the web

Technical documentation at the Sybase web site is updated frequently.

For the latest information on product certifications and/or the EBF Rollups:

Point your web browser to Technical Documents .

In the Browse section, click on What's Hot.

Select links to Certification Reports and EBF Rollups, as well as links to Technical Newsletters, online manuals, and so on.

If you are a registered SupportPlus user:

Point your web browser to Technical Documents .

In the Browse section, click on What's Hot.

Click on EBF Rollups.

You can research EBFs using Technical Documents, and you can download EBFs using Electronic Software Distribution (ESD).

Follow the instructions associated with the SupportPlusSM Online Services entries.

If you are not a registered SupportPlus user, and you want to become one:

You can register by following the instructions on the Web.

To use SupportPlus, you need:

A Web browser that supports the Secure Sockets Layer (SSL), such as Netscape Navigator 1.2 or later

An active support license

A named technical support contact

Your user ID and password

Whether or not you are a registered SupportPlus user:

You may use Sybase's Technical Documents. Certification Reports are among the features documented at this site.

Point your web browser to Technical Documents

In the Browse section, click on What's Hot.

Click on the topic that interests you.

Conventions

Table 1 shows the conventions used in this manual.

Conventions for this manual

Item

Example

Command names, keywords, command options, utility names, utility flags, and system procedure names

create database

isql -U

sp_configure

Database names

master, model, and tempdb databases

Datatypes

int, datetime, and varchar datatypes

File names and path names

interfaces

$SYBASE/bin

Variables, or words that placeholders for values that you fill in

select column_name
   from table_name
   where search_conditions

Examples showing the use of Transact-SQL commands

select * from publishers

Examples of output from the computer

0736  New  Age Books         Boston       MA 
0877  Binnet & Hardley      Washington   DC 
1389  Algodata  Infosystems  Berkeley     CA

Parentheses - if shown in the syntax, type them as part of the command.

compute row_aggregate (column_name)

Comma - choose one or more options.

Type commas as part of the command.

cash,  check, credit

Vertical bar - choose only one option.

Do not type the bars.

cash | check | credit

Curly braces around options separated by commas - you must choose at least one option. You may choose more than one.

Do not type the braces.

{cash,  check, credit}

Curly braces around options separated by vertical bars - you must choose only one option.

Do not type the braces.

{cash | check | credit}

Brackets around options separated by commas - choosing an option is optional. You may choose more than one.

Do not type the brackets.

[cash,  check, credit]

Brackets around options separated by vertical bars - choosing an option is optional. You may choose only one.

Do not type the brackets.

[cash | check | credit]

An ellipsis (...) means that you can repeat the preceding optional unit (between the square brackets) as many times as you like.

In this example, you must specify at least one toy and enter its price. You must choose only one method of payment: cash, check, or credit. You may also buy additional toys. Separate each toy with a comma. You may put each item on a separate line for readability, but this is not required.

buy toy = price {cash | check | credit} 
    [, toy = price {cash | check | credit} ]...

buy doll = 25.50 check, 
     train = 60.00  credit, 
     bicycle = 150.00  credit, 
     paint  set = 6.00 cash

Transact-SQL does not restrict the number of words you can put on a line or where to break a line. However, for readability, examples and syntax statements in this manual are formatted so that each clause of a statement begins on a new line. Clauses that have more than one part extend to additional lines, which are indented.

You can disregard case when typing Transact-SQL keywords. For example, Adaptive Server understands SELECT, Select, and select to be the same. In this manual, most examples are in lower case. Case sensitivity of database objects, such as table names, depends on the sort order installed on Adaptive Server. You can change case sensitivity for single-byte character sets by reconfiguring the Adaptive Server sort order. For more information, see Chapter 19, "Configuring Character Sets, Sort Orders, and Languages," in the System Administration Guide.

Commands for both the C and Bourne shells are provided in this document, when they differ. The initialization file for the C shell is called .cshrc. The initialization file for the Bourne shell is called .profile. If you are using a different shell, such as the Korn shell, see your shell-specific documentation for the correct command syntax.

If you need help

Each Sybase installation that has purchased a support contract has one or more designated people who are authorized to contact Sybase Technical Support. If you cannot resolve a problem using the manuals or online help, please have the designated person contact Sybase Technical Support or the Sybase subsidiary in your area.

Configuring Adaptive Server for UNIX Platforms [Table of Contents] Chapter 1 Introduction