This manual contains the following chapters:
Chapter 1, “Overview of System Administration,” describes the structure of the Sybase system.
Chapter 2, “System and Optional Databases,” discusses the contents and function of the Adaptive Server system databases.
Chapter 3, “System Administration for Beginners,” summarizes important tasks that new System Administrators need to perform.
Chapter 4, “Diagnosing System Problems,” discusses Adaptive Server and Backup Server™ error handling and shows how to shut down servers and kill user processes.
Chapter 5, “Setting Configuration Parameters,” summarizes the configuration parameters that you set with sp_configure, which control many aspects of Adaptive Server behavior.
Chapter 6, “Limiting Access to Server Resources,” explains how to create and manage resource limits with Adaptive Server.
Chapter 7, “Configuring Character Sets, Sort Orders, and Languages,” discusses international issues, such as the files included in the Language Modules and how to configure an Adaptive Server language, sort order, and character set.
Chapter 8, “Configuring Client/Server Character Set Conversions,” discusses character set conversion between Adaptive Server and clients in a heterogeneous environment.
Chapter 9, “Security Administration,” provides an overview of the security features available in Adaptive Server.
Chapter 10, “Managing Adaptive Server Logins and Database Users,” describes methods for managing Adaptive Server login accounts and database users.
Chapter 11, “Managing User Permissions,” describes the use and implementation of user permissions.
Chapter 12, “Auditing,” describes how to set up auditing for your installation.
Chapter 13, “Managing Remote Servers,” discusses the steps the System Administrator and System Security Officer of each Adaptive Server must execute to enable remote procedure calls (RPCs).
Chapter 14, “Using Kerberos, DCE, and Windows NT LAN Manager,” describes the network-based security services that enable you to authenticate users and protect data transmitted among machines on a network.
Chapter 15, “Overview of Disk Resource Issues,” provides an overview of Adaptive Server disk resource issues.
Chapter 16, “Initializing Database Devices,” describes how to initialize and use database devices.
Chapter 17, “Mirroring Database Devices,” describes how to mirror database devices for nonstop recovery from media failures.
Chapter 18, “Configuring Memory,” explains how to configure Adaptive Server to use the available memory on your system.
Chapter 19, “Configuring Data Caches,” discusses how to create named caches in memory and bind objects to those caches.
Chapter 20, “Managing Multiprocessor Servers,” explains how to use multiple CPUs with Adaptive Server and discusses system administration issues that are unique to symmetric multiprocessing (SMP) environments.
Chapter 21, “Creating and Managing User Databases,” discusses the physical placement of databases, tables, and indexes, and the allocation of space to them.
Chapter 22, “Setting Database Options,” describes how to set database options.
Chapter 23, “Creating and Using Segments,” describes how to use segments, which are named collections of database devices, in databases.
Chapter 24, “Using the reorg Command,” describes how to use the reorg command.
Chapter 25, “Checking Database Consistency,” describes how to use the database consistency checker, dbcc, to detect and fix database problems.
Chapter 26, “Developing a Backup and Recovery Plan,” discusses the capabilities of the Backup Server and how to develop your backup strategy.
Chapter 27, “Backing Up and Restoring User Databases,” discusses how to recover user databases.
Chapter 28, “Restoring the System Databases,” discusses how to recover system databases.
Chapter 29, “Managing Free Space with Thresholds,” discusses managing space with thresholds.