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

by ;
  • ISBN13:


  • ISBN10:


  • Edition: 6th
  • Format: Hardcover
  • Copyright: 2007-11-19
  • Publisher: IBM Press
  • Purchase Benefits
  • Free Shipping On Orders Over $35!
    Your order must be $35 or more to qualify for free economy shipping. Bulk sales, PO's, Marketplace items, eBooks and apparel do not qualify for this offer.
  • Get Rewarded for Ordering Your Textbooks! Enroll Now
List Price: $69.99 Save up to $2.80
  • eBook
    Add to Cart


Supplemental Materials

What is included with this book?

  • The eBook copy of this book is not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.


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.

Author Biography

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

Forewordp. xxi
Prefacep. xxiii
Introduction to DB2p. 1
Product Overviewp. 3
Information as a Servicep. 4
The DB2 for Linux, UNIX, and Windows Data Serverp. 9
DB2 Connectivityp. 28
DB2 Administrationp. 45
Summaryp. 60
Getting Startedp. 63
Product Installationp. 64
The DB2 Environmentp. 98
Summaryp. 115
Getting Connectedp. 117
DB2 Client Overviewp. 118
Roadmap to Distributed Communications
Summaryp. 164
Controlling Data Accessp. 167
Overview of Securityp. 168
Auditingp. 216
Summaryp. 221
Using SQLp. 223
Database Objectsp. 225
Understanding Database Objectsp. 227
Managing Database Objectsp. 235
Tablesp. 263
Database Design and Implementationp. 316
Summaryp. 325
Manipulating Database Objectsp. 327
Data Retrievalp. 328
Data Modificationp. 365
View Classificationp. 383
Summaryp. 395
Advanced SQL 397
Triggersp. 398
Recursive SQLp. 405
Outer Joinp. 409
OLAP Featuresp. 414
Advanced Case Expressionsp. 432
Structured Types and Typed Tablesp. 434
Summary Tablesp. 456
Sequencesp. 469
Advanced Functionsp. 472
Summaryp. 487
pureXML Storage Enginep. 489
pureXML Feature Packp. 490
The Difference: pureXMLp. 495
Creating an XML-enabled Databasep. 500
Creating Tables with pureXMLp. 502
Inserting Data into pureXML Columnsp. 504
Selecting Data from pureXML Columnsp. 513
Updating and Deleting pureXML Columnsp. 520
Indexing pureXML Columnsp. 521
XML Schema Repository (XSR)p. 533
Summaryp. 537
Development SQLp. 539
User-Defined Functionsp. 540
Structured Data Typesp. 549
Schemas and Aliasesp. 555
Commit and Rollbackp. 558
SQL Procedural Languagep. 559
Stored roceduresp. 578
Summaryp. 597
Concurrencyp. 599
Concurrencyp. 600
Isolation Levelsp. 607
Lockingvp. 610
Summaryp. 621
DB2 Administrationp. 623
Data Storage Managementp. 625
Processor, Memory, and Disk Resourcesp. 626
DB2 Storage Modelp. 628
Table Space Designp. 640
Implementation Examplesp. 652
Automatic Storagep. 664
Table Space Maintenancep. 666
Table (Range) Partitioningp. 674
Summaryp. 699
Maintaining Datap. 701
Moving Datap. 702
Data Movement Utilitiesp. 705
Data Maintenancep. 766
Data Maintenance Processp. 786
Summaryp. 791
Database Recoveryp. 793
Database Recovery Conceptsp. 794
Types of Recoveryp. 795
Recovery Strategiesp. 796
Use of Log Filesp. 797
Version Recovery Using Backup and Restorep. 805
Roll-Forward Recoveryp. 827
Managing Log Filesp. 837
Other Recovery Considerationsp. 838
High Availabilityp. 845
High-Availability Disaster Recoveryp. 850
Summaryp. 869
Monitoring and Tuningp. 871
Elements of Performancep. 872
DB2 Architecture Overviewp. 876
DB2 Sorting Methodsp. 887
Monitoring the DB2 Systemp. 887
Database Monitoringp. 890
SQL Monitoringp. 921
Diagnostics and Problem Determinationp. 947
Self-Tuning Memory Managerp. 960
Summaryp. 973
Developing Applicationsp. 975
Application Development Overviewp. 977
DB2 Application Development Environmentp. 978
DB2 Programming Interfacesp. 982
Summaryp. 995
Development Considerationsp. 997
Embedded SQL Overviewp. 998
Support for CLI and ODBC Programmingp. 1009
Support for Java Programmingp. 1018
DB2 Developer Workbenchp. 1021
Summaryp. 1022
Appendicesp. 1023
DB2 9 Certification Test Objectivesp. 1025
DB2 Certification Levelsp. 1026
DB2 9 Fundamentals (730)p. 1027
DB2 for LUW Database Administration (731)p. 1029
DB2 for LUW Advanced DBA (734)p. 1032
IBM Certified DBA for DB2 9 for LUW, Upgrade (736)p. 1034
DB2DEMO Installationp. 1037
Installation Requirementsp. 1038
Using the DB2DEMO Programp. 1045
Advanced Programming Informationp. 1066
Supportp. 1095
Indexp. 1097
Table of Contents provided by Publisher. All Rights Reserved.

Rewards Program

Write a Review