Home

	Expand Search

Configuring Adaptive Server Enterprise 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(R) Adaptive Server(TM) Enterprise on the following platforms:

• Sun Solaris 2.x (SPARC)
• IBM RISC System/6000 AIX
• HP 9000 Series 800 HP-UX
• Digital UNIX

The operating system release levels on which Adaptive Server is certified to execute for the above platforms is provided in
Installing Adaptive Server and OmniConnect on UNIX Platforms.

This guide provides:

• An overview of the Adaptive Server infrastructure
• Instructions for reconfiguring certain attributes of your existing Adaptive Server, Backup Server(TM), or XP Server to meet your specific needs
• Instructions for configuring your Adaptive Server for optional functionality, such as auditing or two-phase commit transactions

Audience

This guide is written for Sybase System Administrators.

Before Using This Book

Before using 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 Installing Adaptive Server and OmniConnect on UNIX Platforms.

About This Book

This book contains the following chapters:

• Chapter 1, "Introduction," presents an overview of the following components of the Adaptive Server infrastructure: the Sybase installation directory, the interfaces file, and the system devices and system databases.
• Chapter 2, "Starting and Stopping Adaptive Server and Backup Server," describes the different methods of starting and stopping Adaptive Server and Backup Server.
• Chapter 3, "Configuring the Operating System for Adaptive Server," discusses some operating system configuration issues.
• Chapter 4, "The Interfaces File," describes the interfaces file.
• Chapter 5, "Using dsedit," describes how to use the dsedit utility to modify the interfaces file.
• Chapter 6, "Using dscp," describes how to use the dscp utility to modify the interfaces file.
• Chapter 7, "Localization," provides an introduction to language, character sets, and sort orders, the $SYBASE/locales directory, and how to reconfigure language, character sets, and sort orders.
• Chapter 8, "Installing Online Help and Sample Databases," describes how to install online help for Transact-SQL(R) syntax and how to install U.S. English and foreign language sample databases that can be used for learning Transact-SQL.
• Chapter 9, "Configuring for Two-Phase Commit Transactions," describes how to configure Adaptive Server for two-phase commit functionality.
• Chapter 10, "Configuring for Auditing," provides an introduction to the audit system and how to configure Adaptive Server for auditing.
• Chapter 11, "Administrative and Monitoring Tasks," describes some of the administrative and monitoring tasks specific to your operating system.
• Appendix A, "Adaptive Server System Specifications," provides Adaptive Server system specifications for each supported platform.
• Appendix B, "Choosing and Preparing a Database Device," describes the types of database devices, guidelines for choosing one type over another, and how to prepare a database device for use.
• Appendix C, "Character Sets, Sort Orders, and Message Language," provides a list of platforms and their native character sets, and describes available sort orders and message languages supported by Adaptive Server.

Adaptive Server Enterprise Documents

The following documents comprise the Sybase Adaptive Server Enterprise documentation:

• The Release Bulletin for your platform - contains last-minute information that was too late to be included in the books.

  A more recent version of the Release Bulletin may be available on the World Wide Web. To check for critical product or document information that was added after the release of the product CD, use SyBooks(TM)-on-the-Web.

• The Adaptive Server installation documentation for your platform - describes installation and upgrade procedures for all Adaptive Server and related Sybase products.
• The Adaptive Server configuration documentation for your platform - describes configuring a server, creating network connections, configuring for optional functionality, such as auditing, installing most optional system databases, and performing operating system administration tasks.
• What's New in Adaptive Server Enterprise? - describes the new features in Adaptive Server release 11.5, the system changes added to support those features, and the changes that may affect your existing applications.
• Navigating the Documentation for Adaptive Server - an electronic interface for using Adaptive Server. This online document provides links to the concepts and syntax in the documentation that are relevant to each task.
• Transact-SQL User's Guide - documents Transact-SQL(R), Sybase's enhanced version of the relational database language. This manual serves as a textbook for beginning users of the database management system. This manual also contains descriptions of the pubs2 and pubs3 sample databases.
• System Administration Guide - provides in-depth information about administering servers and databases. This manual includes instructions and guidelines for managing physical resources and user and system databases, and specifying character conversion, international language, and sort order settings.
• Adaptive Server Reference Manual - contains detailed information about all Transact-SQL commands, functions, procedures, and datatypes. This manual also contains a list of the Transact-SQL reserved words and definitions of system tables.
• Performance and Tuning Guide - explains how to tune Adaptive Server for maximum performance. This manual includes information about database design issues that affect performance, query optimization, how to tune Adaptive Server for very large databases, disk and cache issues, and the effects of locking and cursors on performance.
• The Utility Programs manual for your platform - documents the Adaptive Server utility programs, such as isql and bcp, which are executed at the operating system level.
• Security Administration Guide - explains how to use the security features provided by Adaptive Server to control user access to data. This manual includes information about how to add users to Adaptive Server, administer both system-defined and user-defined roles, grant database access to users, and manage remote Adaptive Servers.
• Security Features User's Guide - provides instructions and guidelines for using the security options provided in Adaptive Server from the perspective of the non-administrative user.
• Error Messages and Troubleshooting Guide - explains how to resolve frequently occurring error messages and describes solutions to system problems frequently encountered by users.
• Component Integration Services User's Guide for Adaptive Server Enterprise and OmniConnect - explains how to use the Adaptive Server Component Integration Services feature to connect remote Sybase and non-Sybase databases.
• Adaptive Server Glossary - defines technical terms used in the Adaptive Server documentation.

Other Sources of Information

Use the SyBooks(TM) and SyBooks-on-the-Web online resources to learn more about your product:

• SyBooks documentation is on the CD that comes with your software. The DynaText browser, also included on the CD, allows you to access technical information about your product in an easy-to-use format.

  Refer to Installing SyBooks in your documentation package for instructions on installing and starting SyBooks.

• SyBooks-on-the-Web is an HTML version of SyBooks that you can access using a standard Web browser.

  To use SyBooks-on-the-Web, go to http://www.sybase.com, and choose Documentation.

Conventions

The following style conventions are used in this manual:

• In a sample screen display, commands you should enter exactly as shown are given in:

  this font 

• In a sample screen display, words which you should replace with the appropriate value for your installation are shown in:

  this font 

• In the regular text of this document, the names of files and directories appear in italics:

  /usr/u/sybase

• The names of programs, utilities, procedures, and commands appear in bold type:

  sybsetup

• 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, refer to your shell-specific documentation for the correct command syntax.

The conventions for syntax statements in this manual are as follows:

Table 1: SQL syntax conventions

Key	Definition
command	Command names, command option names, utility names, utility flags, and other keywords are in bold.
variable	Variables, or words that stand for values that you fill in, are in italics.
{ }	Curly braces indicate that you choose at least one of the enclosed options. Do not include braces in your option.
[ ]	Brackets mean choosing one or more of the enclosed options is optional. Do not include brackets in your option.
( )	Parentheses are to be typed as part of the command.
|	The vertical bar means you can select only one of the options shown.
,	The comma means you can choose as many of the options shown as you like, separating your choices with commas to be typed as part of the command.

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.