DB2 for Solaris: The Official Guide (IBM Press Series--Information Management) [Paperback]

Thomas Bauch (Author), Mark Wilding (Author)

Book Description

Publication Date: September 18, 2003 | Series: IBM Press Series--Information Management

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!

Editorial Reviews

From the Back Cover

• The definitive guide to DB2 Version 8 for Solaris -- straight from IBM's experts
• Covers planning, installation, configuration, administration, and optimization
• Shows how to leverage both Solaris and DB2 features to maximize performance and scalability
• Fully updated for the newest DB2 Universal Database V8 tools, features, and enhancements

PRENTICE HALL

Upper Saddle River, NJ 07458

www.phptr.com

$59.99 U.S.

$90.00 Canada

0-13-046380-9

IBM's DB2 Universal Database Version 8 for Solaris has been carefully engineered to deliver all of the immense power, flexibility, and scalability of DB2, while taking full advantage of the capabilities of Sun's Solaris operating system. 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:

Sum

• 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.

Product Details

• Paperback: 560 pages
• Publisher: Prentice Hall PTR (September 18, 2003)
• Language: English
• ISBN-10: 0130463809
• ISBN-13: 978-0130463807
• Product Dimensions: 9.3 x 7 x 1.5 inches
• Shipping Weight: 2.3 pounds
• Average Customer Review: 4.2 out of 5 stars  See all reviews (5 customer reviews)
• Amazon Best Sellers Rank: #3,626,822 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

2 of 2 people found the following review helpful:

5.0 out of 5 stars A Handy Reference, December 4, 2003

By 

Philip K Gunning (sinking spring, pa United States) - See all my reviews
(REAL NAME)   

This review is from: DB2 for Solaris: The Official Guide (IBM Press Series--Information Management) (Paperback)

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.

2 of 2 people found the following review helpful:

5.0 out of 5 stars Technical Manager, November 20, 2003

By A Customer

This review is from: DB2 for Solaris: The Official Guide (IBM Press Series--Information Management) (Paperback)

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.

1 of 1 people found the following review helpful:

5.0 out of 5 stars Excellent Technical Reference, January 16, 2004

By 

DB2Solaris User (New York, USA) - See all my reviews

This review is from: DB2 for Solaris: The Official Guide (IBM Press Series--Information Management) (Paperback)

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!