Product Description

This is the only IBM insider's reference and guidebook for making the most of DB2 in Solaris enterprise environments. Coverage includes: integrating Solaris and DB2 to build more secure database applications; working with DB2's management utilities in a Solaris environment; client/server communications under Solaris; special issues and opportunities associated with running DB2 Universal Database Enterprise Edition under Solaris, and much more! The authors explain configuring Solaris and DB2 failover support and provide expert tips and techniques for DB2/Solaris performance monitoring, optimization, and troubleshooting. If you manage or develop for DB2 on Solaris, this book is critical to your success -- and you can't find it anywhere else!

Product Details

• Amazon Sales Rank: #302234 in Books
• Published on: 2003-09-18
• Format: Illustrated
• Original language: English
• Number of items: 1
• Binding: Paperback
• 560 pages

From the Back Cover
Now, direct from IBM", there's a definitive guide to installing, running, and optimizing the latest versions of DB2 on the Solaris platform.

DB2 for Solaris: The Official Guide offers systematic and authoritative guidance on every key decision and challenge you'll face, from choosing the right DB2 edition to monitoring and optimizing performance, implementing clustering to managing backup and recovery.

This book presents never-before-published insights from IBM's DB2 for Solaris support experts, as well as the leader of IBM's DB2 Solaris port. You'll find best practices, techniques, tips, guidelines, and rules of thumb for all this, and more:

• Installing DB2 on Solaris
• Working with disks, file systems, memory, and CPUs
• Using the graphical administration and monitoring tools of DB2
• Optimizing database and Solaris operating system performance
• Implementing clusters with Veritas Cluster Server and Sun Cluster
• Managing client/server communications and TCP/IP networking
• Leveraging lightweight OS semaphores, kernelized asynchronous I/O, SMP processor sets, intimate shared memory, and other advanced Solaris features
• Utilizing inter-partition parallelism with DB2 Universal Database Enterprise Server Edition's Data Partitioning feature

About the Author

TOM BAUCH is a Senior Certified IT Specialist and Technical Lead of the DB2 Ranger Team at IBM Software Group. He has been with the Ranger Team supporting DB2 on Solaris since 1998, and prior to that was a DB2 instructor for IBM. MARK WILDING, Advisory Software Developer at the IBM Toronto Lab, is currently the architect for DB2 Serviceability. Bauch and Wilding co-authored DB2 Universal Database in the Solaris Operating Environment.

Customer Reviews

A Handy Reference
Tom and Mark have done an excellent job at covering new V8 features and Solaris internals. This book combines DB2 and Solaris implementation details and is a must for Solaris SAs and DB2 DBAs supporting DB2 on Solaris. They have aptly pointed out the unique DB2 on Solaris differences that you need to know to get the best performance out of DB2 on Solaris (Kernel asynchronous I/O, double buffering, disk architecture, concurrent I/O, performance of raw devices,VCS, Quick I/O, Cached Quick I/O, address space diagrams and details on memory management by the MMU). By adding the additional details on Solaris in Chapters 11 - 15, the authors have made the book a handy reference.

Technical Manager
This book consolidates an abunance of hints, tips and techniques learned by Mark and Tom from years of working with DB2 on Solaris. Since Mark Wilding is a key developer of DB2 on Solaris and Tom has been working in the field with customers using DB2 on Solaris, you could not ask for a better combination.
They both have been very helpful to me and I found their book enlightening. Also, it is a great training tool for our new people not familiar with Solaris and DB2.

Excellent Technical Reference
This is a must read for anyone using Solaris and Unix, not just DB2 for Solaris. The first half of the book focuses on DB2 for Solaris, and the second half dives deep into Solaris internals and principles. Much of the information documented here is difficult to find anywhere and is highly recommended for anyone who wants to know how key aspects of a Unix operating system ticks. I particularly like sections like "Life and Times of a Load Instruction", "Memory Map and Address Space", and "Simple/Advanced Network Debugging". An excellent reference worthy of being on the same shelf as Richard Stevens' Unix classics!