Covering practical database administration for Sybase System 10, this book provides real-world solutions to real-world problems, such as capacity planning, disaster recovery, upgrading from System 4.9 to System 10, and performance tuning. It describes how to plan for growth from single server to multi-server installations and contains program scripts that implement procedures recommended in the book.
FREE Two-Day Shipping for Students. Learn more |
Book Description
Editorial Reviews
From the Publisher
This is the first book that shows Sybase database administrators exactly how to manage complex multi-SQL Server environments.
From the Inside Flap
Preface
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.
Purpose
Who Is This Book For?
What You Need to Know to Use This Book
What You Will Learn From This Book
Conventions
Terms
Versions of SQL Server
SQL Server System 11
Versions of Replication Server
Purpose
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.
Conventions
Sybase SQL Server commands are shown in the text in the following font:
disk init
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
sp_ sp_helpdevice
Stored procedures not supplied (or supported) by Sybase (described in Chapter 15 "Scripts") are referred to as
p_ p_devspace
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:
dkinfo
Real-world experiences that you need to think about are preceded by
;-)
Terms
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.
server
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.
server machine
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.
server device
Same as server logical device
spindle
Anothe
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.
Purpose
Who Is This Book For?
What You Need to Know to Use This Book
What You Will Learn From This Book
Conventions
Terms
Versions of SQL Server
SQL Server System 11
Versions of Replication Server
Purpose
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.
Conventions
Sybase SQL Server commands are shown in the text in the following font:
disk init
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
sp_ sp_helpdevice
Stored procedures not supplied (or supported) by Sybase (described in Chapter 15 "Scripts") are referred to as
p_ p_devspace
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:
dkinfo
Real-world experiences that you need to think about are preceded by
;-)
Terms
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.
server
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.
server machine
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.
server device
Same as server logical device
spindle
Anothe
Product Details
Would you like to update product info or give feedback on images?
|
More About the Author
Discover books, learn about writers, read author blogs, and more.
Customer Reviews
|
Share your thoughts with other customers:
|
||||||||||||||||||||||
|
Most Helpful Customer Reviews
2 of 2 people found the following review helpful:
1.0 out of 5 stars
Terrible.,
By A Customer
This review is from: Sybase Database Administrator's Handbook (Hardcover)
This book was terribly written, contained few examples and was pretty useless as a dba handbook.
Share your thoughts with other customers: Create your own review
|
|
Tag this product(What's this?)Think of a tag as a keyword or label you consider is strongly related to this product.
Tags will help all customers organize and find favorite items. |
Sell a Digital Version of This Book in the Kindle Store
If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store.
Learn more
Customer Discussions
|
This product's forum
Active discussions in related forums
Search Customer Discussions
|
Related forums
|
Listmania!
So You'd Like to...
Look for Similar Items by Category
- Books > Business & Investing > Economics
- Books > Computers & Technology > Databases > Relational Databases
- Books > Computers & Technology > Hardware > Microprocessors & System Design
- Books > Computers & Technology > Software
- Books > New & Used Textbooks > Computer Science > Database Storage & Design
- Books > Science & Math > Mathematics
