DB2 9 for Linux, UNIX, and Windows: DBA Guide, Reference, and Exam Prep (6th Edition) [Hardcover]

George Baklarz (Author), Paul C. Zikopoulos (Author)

Book Description

ISBN-10: 013185514X | ISBN-13: 978-0131855144 | Publication Date: November 29, 2007 | Edition: 6

DB2^® 9 builds on the world's number one enterprise database to simplify the delivery of information as a service, accelerate development, and dramatically improve operational efficiency, security, and resiliency.

Now, this new edition offers complete, start-to-finish coverage of DB2 9 administration and development for Linux^®, UNIX^®, and Windows^® platforms, as well as authoritative preparation for the latest IBM DB2 certification exam.

Written for both DBAs and developers, this definitive reference and self-study guide covers all aspects of deploying and managing DB2 9, including DB2 database design and development; day-to-day administration and backup; deployment of networked, Internet-centered, and SOA-based applications; migration; and much more. You'll also find an unparalleled collection of expert tips for optimizing performance, availability, and value.

Coverage includes:

• Important security and resiliency enhancements, including advanced access control; fine-grained, label-based security; and the new security administrator role
• Breakthrough pureXML^™ features that make it easier to succeed with service-oriented architecture
• Operational improvements that enhance DBA efficiency--including self-tuning memory allocation, automated storage management, and storage optimization
• Table-partitioning features that improve scalability and manageability
• Powerful improvements for more agile and rapid development, including the new Eclipse-based Developer Workbench and simple SQL or XQuery access to all data

Whatever your role in working with DB2 or preparing for certification, DB2 9 for Linux, UNIX, and Windows, Sixth Edition is the one book you can't afford to be without.

Download Complete DB2 V9 Trial Version

Visit ibm.com/db2/9/download.html to download a complete trial version of DB2, which enables you to try out dozens of the most powerful features of DB2 for yourself: everything from pureXML support to automated administration and optimization.

• Straight from IBM, the ultimate guide to running DB2 9 and preparing for the latest IBM DB2 certification exam!
• Covers powerful DB2 9 enhancements ranging from automated management to improved compression
• Covers the full spectrum of DBA responsibilities, including server management, data placement, XML concepts, activity analysis, high availability, and security
• Presents expert tips and best practices from the DB2 customer support organization

Editorial Reviews

About the Author

George Baklarz, B. Math, M.Sc., Ph.D., has spent 22 years at IBM working on various aspects of database technology. From 1987 to 1991 he worked on SQL/DS as part of the product planning department, system test team, performance team, and application development group. In 1991, Baklarz was part of the team that helped moved the OS/2 ES database to Toronto to become part of the DB2 family of products. Since that time he has worked on vendor enablement, competitive analysis, product marketing, product planning, and technical sales support. Today, Baklarz is the Program Director responsible for Dynamic Warehousing Pre-Sales Support, and he works with customers to help them understand DB2 technology directions and uses their feedback to improve the product. When not traveling the world, Baklarz lectures at the University of Guelph, teaching relational database concepts to students. You can reach him at [e-mail].

Paul C. Zikopoulos, B.A., M.B.A., is an award-winning writer and speaker with the IBM Database Competitive Technology team. He has more than thirteen years of experience with DB2 and has written more than 150 magazine articles and is currently working on book number twelve. Zikopoulos has authored the books Information on Demand: Introduction to DB2 9.5 New Features; DB2 9 Database Administration Certification Guide and Reference (6th Edition); DB2 9: New Features; Information on Demand: Introduction to DB2 9 New Features; Off to the Races with Apache Derby; DB2 Version 8: The Official Guide; DB2: The Complete Reference; DB2 Fundamentals Certification for Dummies; DB2 for Dummies; and A DBA's Guide to Databases on Linux. Zikopoulos is a DB2 Certified Advanced Technical Expert (DRDA and Cluster/EEE) and a DB2 Certified Solutions Expert (Business Intelligence and Database Administration). In his spare time, he enjoys all sorts of sporting activities, including running with his dog Chachi, avoiding punches in his MMA class, and trying to figure out the world according to Chloë, his daughter. You can reach him at [e-mail].

Product Details

• Hardcover: 1136 pages
• Publisher: IBM Press; 6 edition (November 29, 2007)
• Language: English
• ISBN-10: 013185514X
• ISBN-13: 978-0131855144
• Product Dimensions: 9.3 x 7.4 x 2.3 inches
• Shipping Weight: 3.9 pounds (View shipping rates and policies)
• Average Customer Review: 4.6 out of 5 stars  See all reviews (5 customer reviews)
• Amazon Best Sellers Rank: #677,425 in Books (See Top 100 in Books)
  • #29 in Books > Computers & Technology > Certification > Linux

More About the Author

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

Customer Reviews

Most Helpful Customer Reviews

4 of 4 people found the following review helpful:

5.0 out of 5 stars The must have book, March 6, 2008

By 

Denis Vasconcelos (Brazil) - See all my reviews
(REAL NAME)   

This review is from: DB2 9 for Linux, UNIX, and Windows: DBA Guide, Reference, and Exam Prep (6th Edition) (Hardcover)

This book features all the information you need to complete the certification exams together with your experience and a DB2 copy.
Many people that I know read and study this book, and on the day before the exams read the DevelopeWorks' tutorial as flash cards..
This book together with a free DB2 copy (DB2 Express-C) are what you need to pass the exams.

If you are not interested in the certification, this book is still for you if you need a great reference book or complete guide for DBAs.

If you are a self made DBA may be astonhised/surprised after you read the book, because of some many new details or best practices you will find.

If you are a total beginner, pick this book together with the Understanding DB2: Learning Visually with Examples and you are all set to go.

1 of 1 people found the following review helpful:

5.0 out of 5 stars Great DB2 Information Source, March 10, 2010

By 

David Adler "spatial guru" (Woodstock, NY) - See all my reviews
(REAL NAME)   

Amazon Verified Purchase

This review is from: DB2 9 for Linux, UNIX, and Windows: DBA Guide, Reference, and Exam Prep (6th Edition) (Hardcover)

I ordered this a while back but hadn't gotten a chance to read it until a major snowstorm with power out for several days.

Although a DB2 user for over 20 years, I found considerable new information. There was also a section on the free downloadable DB2DEMO program which is a great resource for sample SQL queries exercising new functionality.

1 of 1 people found the following review helpful:

5.0 out of 5 stars Edileusa Prado, February 14, 2008

By 

Edileusa E. Prado "EEP" (Sao Paulo - Brazil) - See all my reviews
(REAL NAME)   

This review is from: DB2 9 for Linux, UNIX, and Windows: DBA Guide, Reference, and Exam Prep (6th Edition) (Hardcover)

Excellent Book!!! This is comprehensive book of DB2 9 it was written using a easy language with examples and pictures.