DB2 9 for Linux, UNIX, and Windows: DBA Guide, Reference, and Exam Prep

DB2 9 for Linux, UNIX, and Windows: DBA Guide, Reference, and Exam Prep

NOOK Book(eBook)

$52.49 $55.99 Save 6% Current price is $52.49, Original price is $55.99. You Save 6%.
View All Available Formats & Editions

Available on Compatible NOOK Devices and the free NOOK Apps.
WANT A NOOK?  Explore Now


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

Product Details

ISBN-13: 9780132797405
Publisher: Pearson Education
Publication date: 11/19/2007
Series: IBM Press
Sold by: Barnes & Noble
Format: NOOK Book
Pages: 1136
File size: 27 MB
Note: This product may take a few minutes to download.

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 gbaklarz@uoguelph.ca.

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 paulz_ibm@msn.com.

Table of Contents

Foreword        xxi
Preface        xxiii
Part ONE: Introduction to DB2        1 Chapter 1: Product Overview        3
Information as a Service        4
The DB2 for Linux, UNIX, and Windows Data Server        9
DB2 Connectivity        28
DB2 Administration        45
Summary        60
Chapter 2: Getting Started        63
Product Installation        64
The DB2 Environment        98
Summary        115
Chapter 3: Getting Connected        117
DB2 Client Overview        118
Roadmap to Distributed Communications        124
Summary        164
Chapter 4: Controlling Data Access        167
Overview of Security        168
Auditing        216
Summary        221
Part TWO: Using SQL        223 Chapter 5: Database Objects        225
Understanding Database Objects        227
Managing Database Objects        235
Tables        263
Database Design and Implementation        316
Summary        325
Chapter 6: Manipulating Database Objects        327
Data Retrieval        328
Data Modification        365
View Classification        383
Summary        395
Chapter 7: Advanced SQL        397
Triggers        398
Recursive SQL        405
Outer Join        409
OLAP Features        414
Advanced CASE Expressions        432
Structured Types and Typed Tables        434
Summary Tables        456
Sequences        469
Advanced Functions        472
Summary        487
Chapter 8: pureXML Storage Engine        489
pureXML Feature Pack        490
The Difference: pureXML        495
Creating an XML-enabled Database        500
Creating Tables with pureXML        502
Inserting Data into pureXML Columns        504
Selecting Data from pureXML Columns        513
Updating and Deleting pureXML Columns        520
Indexing pureXML Columns        521
XML Schema Repository (XSR)        533
Summary        537
Chapter 9: Development SQL        539
User-Defined Functions        540
Structured Data Types        549
Schemas and Aliases        555
COMMIT and ROLLBACK        558
SQL Procedural Language        559
Stored Procedures        578
Summary        597
Chapter 10: Concurrency        599
Concurrency        600
Isolation Levels        607
Summary        621
Part THREE: DB2 Administration        623 Chapter 11: Data Storage Management        625
Processor, Memory, and Disk Resources        626
DB2 Storage Model        628
Table Space Design        640
Implementation Examples        652
Automatic Storage        664
Table Space Maintenance        666
Table (Range) Partitioning        674
Summary        699
Chapter 12: Maintaining Data        701
Moving Data        702
Data Movement Utilities        705
Data Maintenance        766
Data Maintenance Process        786
Summary        791
Chapter 13: Database Recovery        793
Database Recovery Concepts        794
Types of Recovery        795
Recovery Strategies        796
Use of Log Files        797
Version Recovery Using Backup and Restore        805
Roll-Forward Recovery        827
Managing Log Files        837
Other Recovery Considerations        838
High Availability        845
High-Availability Disaster Recovery        850
Summary        869
Chapter 14: Monitoring and Tuning        871
Elements of Performance        872
DB2 Architecture Overview        876
DB2 Sorting Methods        887
Monitoring the DB2 System        887
Database Monitoring        890
SQL Monitoring        921
Diagnostics and Problem Determination        947
Self-Tuning Memory Manager        960
Summary        973
Part FOUR: Developing Applications        975 Chapter 15: Application Development Overview        977
DB2 Application Development Environment        978
DB2 Programming Interfaces        982
Summary        995
Chapter 16: Development Considerations        997
Embedded SQL Overview        998
Support for CLI and        ODBC Programming        1009
Support for Java Programming        1018
DB2 Developer Workbench        1021
Summary        1022
Part FIVE: Appendices        1023 Appendix A: DB2 9 Certification Test Objectives        1025
DB2 Certification Levels        1026
DB2 9 Fundamentals (730)        1027
DB2 for LUW Database Administration (731)        1029
DB2 for LUW Advanced DBA (734)        1032
IBM Certified DBA for DB2 9 for LUW, Upgrade (736)        1034
Appendix B: DB2DEMO Installation        1037
Installation Requirements        1038
Using the DB2DEMO Program        1045
Advanced Programming Information        1066
Support        1095
Index        1097

Customer Reviews

Most Helpful Customer Reviews

See All Customer Reviews