Home

	Expand Search

System Administration Guide Supplement for SunOS Release 4.x (BSD)

Preface

Preface

This manual, System Administration Guide Supplement for SunOS Release 4.x (BSD) , describes operating system commands and issues relevant to SYBASE SQL Serverä running in a SunOS Release 4.x environment. It supplements the System Administration Guide .

Audience

This manual is intended for SYBASE System Administrators and Database Owners running SYBASE SQL Server in a SunOS Release 4.x environment.

How to Use This Book

This book is divided into the following chapters:

• Chapter 1, "Introduction," is an introduction to system-specific SQL Server issues.

• Chapter 2, "The Interfaces File," describes how SYBASE software uses the interfaces file and explains how to create entries in the file.

• Chapter 3, "Choosing Database Devices," describes using raw partitions and operating system files for database devices initialized after installing SQL Server.

• Chapter 4, "Operating System Setup," describes aspects of the operating system that affect SQL Server operation and the changes you may need to make SQL Server run more efficiently.

• Chapter 5, "Performance and Tuning," describes how to optimize SQL Server performance on your operating system. It also lists the operating system commands you can use to monitor SQL Server's use of system resources.

• Chapter 6, "Routine Tasks, Maintenance, and Troubleshooting," lists the SQL Server system administration tasks that can be performed more effectively using operating system utilities. It also describes the sample databases provided with SQL Server.

• Appendix A, "SQL Server System Specifications," details requirements and limitations for SQL Server on your operating system.

  Note: For information on language, character set, and sort order issues for SQL Server and Backup Serverä, see the SYBASE SQL Server Installation Guide and the System Administration Guide .

Related Documents

This illustration shows the documents you need to install, set up, and use SQL Server:

Figure 1: Documents needed for installing and using SQL Server

If you have not yet installed SQL Server, see the SYBASE SQL Server Release Bulletin and the SYBASE SQL Server Installation Guide for information on installation.

When you have installed SQL Server, use this document, along with the System Administration Guide , to set up your environment. The System Administration Guide describes database administration tasks common to all platforms on which SQL Server runs.

When you are ready to use SQL Server, other manuals that you may find useful are:

• SYBASE SQL Server Reference Manual , which contains detailed information on all of the SYBASE commands and system procedures discussed in this manual.

• SYBASE SQL Server Utility Programs for UNIX , an operating system-specific document, which describes executable programs that help you administer SQL Server.

• Transact-SQL User's Guide , which documents Transact-SQL", Sybase's enhanced version of the SQL relational database language. It serves as a textbook for beginning users of the SYBASE database management system.

For more information about specific operating system commands, see your SunOS Release 4.x documentation.

Conventions

The term ''System Administrator'' refers to the user responsible for administrative tasks for SQL Server. This user (an ''SA'') may be different from the user responsible for administrative tasks for your operating system.

The term $SYBASE refers to the location of the SYBASE home directory.

Style Conventions

SQL syntax statements display the syntax and all options for a command and are printed like this:

 sp_dropdevice [  device_name  ] 

See the following section, "SQL Syntax Conventions", for more information.

Examples showing the use of Transact-SQL commands are printed like this:

 select * from publishers 

Examples of output from the computer are printed like this:

 pub_id   pub_name             city       state  
 -------  -----------------------------   ------- 
 0736     New Age Books        Boston      MA  
 0877     Binnet & Hardley     Washington  DC  
 1389     Algodata Infosystems Berkeley    CA  
 (3 rows affected) 

SQL Syntax Conventions

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

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

For assistance with your SunOS Release 4.x software, contact Sun Microsystems or your SunOS system administrator.

If you have questions about SYBASE software that are not answered in this guide, other manuals, or on-line documentation, ask the designated person at your site to contact Sybase Technical Support.

What's Next?

Chapter 1 provides an overview of the topics covered in this document.