DB2 Universal Database in the Solaris Operating Environment

The Team That Wrote This Book This book was produced by a team of specialists from around the world working at the International Technical Support Organization, Austin Center. Tetsuya Shirai is a Project Leader at the International Technical Support Organization (ITSO), Austin Center. He worked in Tokyo, Japan before joining the Austin ITSO. He has been with IBM for seven years, working for the last four years with DB2 UDB products. He has worked in the area of DB2 services, teaching classes to both customers and employees of IBM. He has also provided consulting services to DB2 customers worldwide. Dr. Rodolphe Michel is currently providing technical support, education, and consulting services to DB2 customers across EMEA on all the DB2 UDB platforms. He has been with IBM since 1989. He has been a member of the DB2 development team at the IBM Database Technology Institute (DBTI) in San Jose, CA (USA), has been a speaker at numerous international technical conferences (VLDB, IDUG, and so on), and has taught DB2 UDB related courses and certification programs worldwide. Rodolphe Michel holds a Ph.D. in Computer Science from Paris 6 University. Mark Wilding currently works as an Advisory Software Developer at the IBM Toronto Lab where he has been an integral part of the DB2 UDB UNIX Porting Team since joining IBM in 1996. He is currently the technical lead for the Solaris port of DB2 with an in-depth knowledge of many other UNIX based operating systems. Mark has also worked extensively with Clustering and High Availability, thus, bringing specific expertise in DB2 and the other Sun Cluster environment. Mark is also a recognized networking expert. Tom Bauch has been a Systems Engineer with IBM since 1979. During his career, he has supported SQL/DS, DL/I, DB2/2, DB2 Common Server, and DB2 Universal Database. He spent several years with IBM Education and Training, teaching DB2 Administration, Net.Data, DB2 EEE Administration, and the DB2 Extenders classes. Currently, he is a Consulting Systems Engineer on IBMs DB2 Ranger Team, which is exclusively dedicated to supporting IBM Data Management Solutions on Sun Solaris. Scott Logan is a Senior Development Analyst at the IBM Toronto Lab and is the technical lead of the DB2 UDB UNIX Porting Team. A member of the DB2 UDB team since its inception in 1991, Scott was a member of the original team that began porting DB2 Version 1 to Solaris and HP-UX in 1993. Scott has been involved in producing numerous published performance benchmarks with DB2 for Solaris and has worked extensively with customers helping them plan, implement, tune, and refine their DB2 for Solaris installations. A recognized expert on Solaris and portability issues within IBM, Scott currently leads the group of IBM developers porting DB2 to more than six UNIX variants including Solaris, HP-UX and Linux. Scott is a member of the DB2 UDB Software Design Group.

1. Overview.


DB2 Universal Database—TheScalable Database. DB2 UDB for Solaris Operating Environment. DB2 UDB for Solaris Scenarios.



2. DB2 UDB Installation.


Installing DB2 UDB Servers. Distributed Installation. DB2 UDB Environment. DAS and DB2 Instances. Using the Command Line Processor. Un-Installing DB2 Products.



3. Introduction to SUN's Disk Technology.


File Systems on Solaris. Disk Slice. Administrative Tasks. NFS under Solaris. Disk Management.



4. Creating Database Objects.


Overview of Database Objects. Databases. Schemas. Bufferpools. Table Spaces. Creating Tables. Indexes. Creating a Trigger. Creating a View.



5. DB2 UDB Client/Server Communications.


Road Map to Client/Server Communications. DB2 Discovery. DB2 Cirectories. Configuring DB2 Clients. Configuring Communications. Bind Utilities.



6. DB2 UDB Graphical Tools.


Overview. Control Center. Command Center. Script Center. Journal. Setting up the Control Center to Manage DB2 UDB for Solaris.



7. Backup and Recovery.


Overview of Database Recovery. Recovery Concepts and Issues. Database Backup and Recovery Using the SmartGuides. Using ADSM for DB2 UDB in the Solaris Operating Environment. Disaster Recovery Considerations.



8. DB2 UDB Enterprise-Extended Edition.


System Types Supported by DB2 UDB EEE. DB2 UDB EEE Concepts. Installation and Configuration. Post-Installation Tasks.



9. DB2 UDB and High-Availability on Sun Cluster.


Overview. Sun Cluster. DB2 UDB with Sun Cluster. The DB2 HA Agent. Set up DB2 UDB and Sun Cluster. Failover Times. Trouble Shooting.



10. Performance Monitoring and Tuning.


Monitoring Methods. Obtaining Database Access Information. Application Analysis: The EXPLAIN Facilities. Index Advisor Facility. Monitoring DB2 UDB. Performance Considerations. Diagnostics and Problem Determination. General Solaris Considerations. Useful Solaris Tools.



Appendix A: Hint and Tips.


Commands and Utilities in the Solaris Operating Environment. DB2 Profile Registry Variables. DB2WATCH Utility. Making the CD-ROM Drive Available. Sun Documentation. Useful Websites.



Appendix B: Related publications.


Index.