Cover
title | : | Administrator's Guide to Sybase ASE 12.5 |
author | : | Garbus, Jeffrey R. |
publisher | : | Wordware Publishing |
isbn10 | asin | : | 1556223072 |
print isbn13 | : | 9781556223075 |
ebook isbn13 | : | 9780585402079 |
language | : | English |
subject | Client/server computing, Sybase. |
publication date | : | 2001 |
lcc | : | QA76.9.C55A36 2001eb |
ddc | : | 005.75/8 |
subject | : | Client/server computing, Sybase. |
Page i
Administrator's Guide to Sybase ASE 12.5
Jeffrey Garbus
Alvin Chang
Gary Tyrrell
Penny Garbus
Contributing authors: Brian Davignon, Rick Kinnaird, Christine Lindsay, Jim Nimmo, Sheri Page, and Brian Taylor
Page ii
Library of Congress Cataloging-in-Publication Data
Administrator's guide to Sybase ASE 12.5 / by Jeffrey Garbus ... [et al.]
p. cm.
Includes index.
ISBN 1-55622-307-2 (pb)
1. Client/server computing. 2. Sybase. I. Garbus, Jeffrey R.
QA76.9.C55 A36 2001
005.75'8--dc21 2001057364
2002, Wordware Publishing, Inc.
All Rights Reserved
2320 Los Rios Boulevard
Plano, Texas 75074
No part of this book may be reproduced in any form or by any means without permission in writing from Wordware Publishing, Inc.
Printed in the United States of America
ISBN 1-55622-307-2
10 9 8 7 6 5 4 3 2 1,
0111
Sybase is a registered trademark of Sybase, Inc. Other product names mentioned are used for identification purposes only and may be trademarks of their respective companies.
Portions of Chapter 16 are from the Sybase Troubleshooting Guide and are used with the permission of Sybase, Inc. Appendix E is used with the permission of Imperial Technology, Inc. Appendix F and Appendix G are used with the permission of White Sands Technology, Inc.
All inquiries for volume purchases of this book should be addressed to Wordware Publishing, Inc., at the above address. Telephone inquiries may be made by calling:
(972) 423-0090
Page iii
Dedication
For my love
Jeff Garbus
To Helen, for her time, patience, and indulgence.
Gary Tyrrell
For all my parents, George, Bea, Sharon, Stanley,
and my kids, Gillian, Max, Devon, Brandon.
Penny Garbus
Page iv
About the Authors
Jeff Garbus' background includes a B.S. degree from Rensselaer Polytechnic Institute, and work experience from PCs to mainframes and back again. He has many years of Microsoft and Sybase SQL Server experience, with a special emphasis on assisting clients in migrating from existing systems to pilot and large-scale projects. He is well known in the industry, having spoken at user conferences and user groups for many years, written articles and columns for many magazines nationally and internationally, as well as having written several books. Recently his focus has been on Very Large Databases, data warehousing, training, and remote database administration.
Jeff has been in consulting for fourteen years, training for nine, and in the software business for eighteen. He has a demonstrated talent for staying at the leading edge of technology, as well as transferring his knowledge to others.
Jeff currently is CEO of Soaring Eagle Consulting, an RDBMS consulting and training firm based in Tampa, which specializes in solving business problems as well as performance problems. Soaring Eagle now offers remote database administration services.
Gary Tyrrell is a Principal Instructor with Sybase, where he teaches a wide variety of courses on ASE, ASA, Replication Server, SQL, and database design. He is not the same Gary Tyrrell from the famous 1982 StanfordCalifornia game, so please stop asking him what happened to the trombone.
Alvin Chang is a technical trainer, author, and consultant working for Soaring Eagle Consulting, a Tampa-based consulting and training firm. He has taught Adaptive Server Enterprise throughout the United States. Currently specializing in Sybase and Microsoft System Administration, Alvin started as a technical trainer for products like Microsoft Office, Lotus Smartsuite, and Lotus Notes before moving into RDBMSs. This is his fifth book.
He can be reached at alvin@soaringeagleltd.com.
As a technical writer and project lead for Soaring Eagle Consulting, Penny Garbus has written literally thousands of pages of Sybase training over the last several years, from versions 10 through 12.5.
Page v
Contents
Foreword | xiv |
Preface | xv |
Acknowledgments | xvi |
Introduction | xvii |
Chapter 1 Systems Administration Overview | |
Architecture Overview | |
Responsibilities of the Sybase Systems Administrator | |
Installing the Sybase Adaptive Server | |
Establishing Connectivity Between Clients and Servers | |
Installing and Maintaining User Databases | |
Establishing Security for Adaptive Server Enterprise | |
Maintaining and Troubleshooting the ASE | |
Establishing Disaster Recovery Procedures | |
Monitoring ASE | |
Use of Utilities | |
Databases | |
System Tables Overview | |
System Tables in Special Uses Databases | |
Sybase System Stored Procedures | |
Chapter 2 Adaptive Server Installation | |
Step 1: Preparation | |
Logical Page Size | |
Physical Devices | |
Server Names | |
Networking Information | |
Sybase Software Asset Manager | |
Step 2: File Transfer | |
Step 3: Running Installation | |
Interfaces File | |
Runserver File | |
Errorlog File | |
servername.cfg Server Configuration File | |
SSL in Adaptive Server | |
Environmental Variables | |
Page vi
Next page