This is the first book that shows Sybase database administrators exactly how to manage complex multi-SQL Server environments.From the Inside Flap:
This book discusses the issues that anyone involved with the DBA team supporting a large multiserver environment needs to be aware of. Here we cover what is and is not discussed in the text.
This book discusses the issues that anyone involved with the DBA team supporting a large multi-server environment needs to be aware of. Here we cover what is and is not discussed in the text.
Who Is This Book For?
What You Need to Know to Use This Book
What You Will Learn From This Book
Versions of SQL Server
SQL Server System 11
Versions of Replication Server
This book is intended for those persons who will take a small Sybase SQL Server 4.9.x or System 10 to a large Sybase SQL Server® 4.9.x or System 10 multiserver environment that will be administered by a team of DBAs.
Who Is This Book For?
Clearly, the DBA is one person that this book is intended for, but so is the manager who is trying to plan such growth and the financial officer who will have to pay for staff and hardware to support the system. The experiences described here will benefit DBAs with less experience, while the checklists and procedures will save the experienced DBA time.
It is assumed that the reader is familiar with the Sybase SQL Server and the commands used to control the server. The book does not provide a complete syntax for any of the server commands and as such is not intended as a beginning training text.
The Sybase courses are very good for this purpose, and this book is an excellent companion to the course material as it expands on, explains, and underscores the practical impacts of many things described in the course and the manuals.
What You Need to Know to Use This Book
This book is based on experiences with the Sybase SQL Server running on Sun® hardware using SunOS™ 4.1.3. The descriptions of the server and the procedures will work with the Sybase SQL Server on other UNIX® operating systems.
Every attempt has been made to make the discussion relevant to any Sybase SQL Server installation. When needed, commands or procedures that are specific to SunOS are identified as such.
You probably won't use and don't need to use all of the material presented all at once. Certain sections will be immediately relevant to your current situation. When a crisis hits, you can use the other sections as checklists of things to review as a way to isolate and fix the problems your system is experiencing.
What You Will Learn From This Book
The DBA who is responsible for the administration of a Sybase SQL Server will find the information directly applicable to his or her job. While portions of the discussions relate directly to the SunOS UNIX environment, the commands used are described in sufficient detail that the equivalent commands for virtually any UNIX platform could be readily identified.
With the growth in the databases themselves comes an increase in the number of database servers as well. While a single server was fine for the pilot project, you now need to consider the implications of a single server failure and how to implement a standby system. Users in various parts of your growing business will want their data on their own server, located near the primary users and maintained by their own DBA. All of this causes more servers, oftentimes containing much of the same data, that must all communicate with each other. The DBA must learn about the new issues relevant to dealing with multiple servers.
This book is designed for use in the real world. Procedures are laid out to be followed step-by-step. Sufficient detail is included to ensure the procedures can be used on a variety of systems by all members of the DBA staff, from the most senior to the latest recruit. Further, these procedures make the process of training a new person much easier.
Real-world observations are included throughout the text and are denoted by the ;-) symbol. These observations are included to provide motivation to readers to pay attention to the subject and apply what is presented to their own systems. Viewed another way, these observations provide stark evidence of the price you may well pay if you choose to avoid the advice presented. Without these observations it is easy to dismiss the instruction as too detailed and perhaps even paranoid.
Disasters do happen and real people get fired over them.
The manuals included with the Sybase SQL Server (including the CD- based products SyBooks and AnswerBase) are excellent and cover the topic of a single server very well. This is their purpose and their duty. However, as your system grows to even two servers, there are new problems that just aren't addressed in the manuals.
This book covers these issues in detail and as such provides a bridge between the manuals with their server-centric view of the world to your multiserver environment. While the manuals are invaluable for documenting and describing all the options for a given command, they won't even begin to help you understand the large database environment.
As your business grows and expands, you will need to be familiar with the System 10 family of Sybase products. Whether you upgrade your existing servers from 4.9.x to System 10 or install a new server at System 10, you will face the hurdles of upgrading and installing. System 10 has many new features, and the upgrade process is more involved than simply installing another EBF. This book will cover the upgrade process in detail and will cover the important differences between the 4.9.x and System 10 versions of the Sybase SQL Server.
As with the many Sybase products available, there are an endless number of permutations of hardware, operating system software, middle-ware, and so on, that you may have in your environment. We make no attempt to address the issues that would arise in any given multivendor environment. We cover in great detail the issues relevant to administering a Sybase multiserver environment running UNIX.
While the examples are taken from a SunOS environment, care has been taken to make these examples useful in any UNIX environment. Wherever possible, we avoid the use of commands or tools that are only available in the SunOS environment.
Further, the function of the SunOS commands used is covered in sufficient detail that it should be easy to determine the equivalent commands or options in the UNIX environment that you are using.
This book does not cover any theory of databases, nor does it compare the functionality of any competing products. We assume you have (or were hired into an environment that already has) selected Sybase SQL Server. If you are in the process of selecting the DBMS for your environment, this book will assist you in determining what you need to have in place to maintain a large, multiserver Sybase system, but, it will not provide any comparisons to other DBMS vendors or their products. We assume you are at a point where you need information relevant to administering a Sybase environment, not in need of a survey of DBMS products.
Sybase SQL Server commands are shown in the text in the following font:
Sybase SQL Server command syntax is shown in the following font:
sp_helpdb database_name sp_helpuser sa sp_addsegment segment_name, server_device sp_addsegment myseg0, server_device_1
Stored procedures supplied by Sybase as part of the SQL Server product are referred to as
Stored procedures not supplied (or supported) by Sybase (described in Chapter 15 "Scripts") are referred to as
The names of databases, segments, tables, and columns are shown in the following font:
master database system segment syslogins table segmap column
Operating system (OS) commands are shown in the following font:
Real-world experiences that you need to think about are preceded by
There are many terms that are used in the description of the Sybase SQL Server and its environment. Listed below are some terms that will be used throughout the book.
These terms are defined here to provide a standard set of definitions for the discussions that follow.
Within this book a server is a Sybase Server, and almost all the time it refers to a SQL Server. Occasionally the term "server" may refer to a Sybase Open Server such as the Backup Server that is part of the System 10 SQL Server.
Refers to the CPU, memory, disks and network interfaces that form the computer that actually executes the SQL Server.
server logical device (tape or disk)
A device as seen by the SQL Server. Note that SQL Server only knows about devices that are assigned to it and there isn't necessarily any direct correlation between a SQL Server device and a physical disk for example.
Same as server logical device
"About this title" may belong to another edition of this title.
Book Description Book Condition: New. Dust Jacket Condition: New. Shipped promptly and delivered within 3 to 5 working days. For PO BOX, APO, FPO and Puerto Rico addresses delivery done in 20 to 25 working days. Serving customers since 2006. Thousand of satisfied customers!. Bookseller Inventory # MISC_9780133574777_Pear17jun_18
Book Description Prentice Hall PTR, 1995. Hardcover. Book Condition: New. book. Bookseller Inventory # M0133574776
Book Description Prentice Hall PTR, 1995. Hardcover. Book Condition: New. Bookseller Inventory # DADAX0133574776
Book Description Prentice-Hall. Book Condition: New. pp. 520. Bookseller Inventory # 7125131
Book Description Book Condition: New. New. International edition. Different ISBN and Cover image but contents are same as US edition. Perfect condition. Customer satisfaction our priority. Bookseller Inventory # ABE-FEB-19768
Book Description Book Condition: New. New. International edition. Different ISBN and Cover image but contents are same as US edition. Perfect condition. Customer satisfaction our priority. Bookseller Inventory # ABE-BOOK-19768
Book Description Book Condition: Brand New. New. SoftCover International edition. Different ISBN and Cover image but contents are same as US edition. Customer Satisfaction guaranteed!!. Bookseller Inventory # SHUB19768
Book Description Book Condition: Brand New. New, SoftCover International edition. Different ISBN and Cover image but contents are same as US edition. Excellent Customer Service. Bookseller Inventory # ABEUSA-19768
Book Description Book Condition: Brand New. Brand New Paperback International Edition, Perfect Condition. Printed in English. Excellent Quality, Service and customer satisfaction guaranteed!. Bookseller Inventory # AIND-52600
Book Description Book Condition: New. Brand New Paperback International Edition.We Ship to PO BOX Address also. EXPEDITED shipping option also available for faster delivery. Bookseller Inventory # AUSBNEW-52600