Home

	Expand Search

System Administration Guide Supplement for Novell NetWare

Preface

Preface

This manual, System Administration Guide Supplement for Novell NetWare , describes operating system commands and issues relevant to SYBASE SQL Serverä running in a NetWare environment. It supplements the System Administration Guide .

Audience

This manual is intended for SYBASE® System Administrators and Database Owners running SQL Server in a NetWare environment.

How to Use This Book

This document is divided into these chapters:

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

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

• Chapter 3, "The Interfaces File," describes how SYBASE software uses the interfaces file and how to modify the file. This chapter also describes using SQL Server with NetWare bindery services.

• Chapter 4, "Routine Tasks, Maintenance, and Troubleshooting," lists 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.

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

• Appendix A, "System Administration Guide Examples," provides NetWare examples for the Transact-SQL commands and procedures discussed in the System Administration Guide.

• Appendix B, "SQL Server System Specifications," describes the requirements and limitations of SYBASE SQL Server in the NetWare environment.

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 Novell NetWare .

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, see the appropriate documentation listed below.

• 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 Novell NetWare , 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.

Other Sources of Information

For more information about specific NetWare commands, see the Novell NetWare documentation that came with your operating system.

If you are using NetWare version 4.01, you can also get help on selected NetWare commands by typing "help" at the console prompt.

Conventions

The term "System Administrator" refers to the person responsible for administering SQL Server. This person (the "SA") may be different from the person responsible for operating system administration within an organization.

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:

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 may select only one of the options shown.
,	The comma means you may 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

Help is available for your SYBASE software in the form of documentation and Sybase Technical Support. For assistance with your NetWare software, contact Novell or your operating system administrator.

Technical Support

Each SYBASE installation site has a person designated as the Sybase Technical Support contact. If you cannot resolve a problem using the manuals, ask the designated person at your site to contact Sybase Technical Support.