DB2 9 for Linux, UNIX, and Windows
DBA Guide, Reference, and Exam Prep
6th Edition
Published on 29. November 2007
Book
Hardback
1136 pages
978-0-13-185514-4 (ISBN)
Description
DB2 (R) 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 (R), UNIX (R), and Windows (R) 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 (TM) 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 VersionVisit 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
Now, this new edition offers complete, start-to-finish coverage of DB2 9 administration and development for Linux (R), UNIX (R), and Windows (R) 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 (TM) 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 VersionVisit 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
More details
Edition
6th edition
Language
English
Place of publication
Armonk
United States
Publishing group
Pearson Education (US)
Target group
College/higher education
Dimensions
Height: 237 mm
Width: 185 mm
Thickness: 59 mm
Weight
1830 gr
ISBN-13
978-0-13-185514-4 (9780131855144)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Other editions
Additional editions
George Baklarz | Paul Zikopoulos
DB2 9 for Linux, UNIX, and Windows
DBA Guide, Reference, and Exam Prep
E-Book
11/2007
6th Edition
Pearson ITP
from
€31.00
Available for download
Previous edition
George Baklarz | Bill Wong
DB2 Universal Database V8 for Linux, UNIX, and Windows Database Administration Certification Guide
Book
02/2003
5th Edition
IBM Press
€59.55
Article exhausted; check for reprint
Persons
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 Chloe, his daughter. You can reach him at paulz_ibm@msn.com.
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 Chloe, his daughter. You can reach him at paulz_ibm@msn.com.
Content
Foreword xxi
Preface xxiiiPart ONE: Introduction to DB2 1Chapter 1: Product Overview 3Information as a Service 4
The DB2 for Linux, UNIX, and Windows Data Server 9
DB2 Connectivity 28
DB2 Administration 45
Summary 60Chapter 2: Getting Started 63Product Installation 64
The DB2 Environment 98
Summary 115Chapter 3: Getting Connected 117DB2 Client Overview 118
Roadmap to Distributed Communications 124
Summary 164Chapter 4: Controlling Data Access 167Overview of Security 168
Auditing 216
Summary 221Part TWO: Using SQL 223Chapter 5: Database Objects 225Understanding Database Objects 227
Managing Database Objects 235
Tables 263
Database Design and Implementation 316
Summary 325Chapter 6: Manipulating Database Objects 327Data Retrieval 328
Data Modification 365
View Classification 383
Summary 395Chapter 7: Advanced SQL 397Triggers 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 487Chapter 8: pureXML Storage Engine 489pureXML 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 537Chapter 9: Development SQL 539User-Defined Functions 540
Structured Data Types 549
Schemas and Aliases 555
COMMIT and ROLLBACK 558
SQL Procedural Language 559
Stored Procedures 578
Summary 597Chapter 10: Concurrency 599Concurrency 600
Isolation Levels 607
Lockingv610
Summary 621Part THREE: DB2 Administration 623Chapter 11: Data Storage Management 625Processor, 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 699Chapter 12: Maintaining Data 701Moving Data 702
Data Movement Utilities 705
Data Maintenance 766
Data Maintenance Process 786
Summary 791Chapter 13: Database Recovery 793Database 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 869Chapter 14: Monitoring and Tuning 871Elements 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 973Part FOUR: Developing Applications 975Chapter 15: Application Development Overview 977DB2 Application Development Environment 978
DB2 Programming Interfaces 982
Summary 995Chapter 16: Development Considerations 997Embedded SQL Overview 998
Support for CLI and ODBC Programming 1009
Support for Java Programming 1018
DB2 Developer Workbench 1021
Summary 1022Part FIVE: Appendices 1023Appendix A: DB2 9 Certification Test Objectives 1025DB2 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) 1034Appendix B: DB2DEMO Installation 1037Installation Requirements 1038
Using the DB2DEMO Program 1045
Advanced Programming Information 1066
Support 1095Index 1097
Preface xxiiiPart ONE: Introduction to DB2 1Chapter 1: Product Overview 3Information as a Service 4
The DB2 for Linux, UNIX, and Windows Data Server 9
DB2 Connectivity 28
DB2 Administration 45
Summary 60Chapter 2: Getting Started 63Product Installation 64
The DB2 Environment 98
Summary 115Chapter 3: Getting Connected 117DB2 Client Overview 118
Roadmap to Distributed Communications 124
Summary 164Chapter 4: Controlling Data Access 167Overview of Security 168
Auditing 216
Summary 221Part TWO: Using SQL 223Chapter 5: Database Objects 225Understanding Database Objects 227
Managing Database Objects 235
Tables 263
Database Design and Implementation 316
Summary 325Chapter 6: Manipulating Database Objects 327Data Retrieval 328
Data Modification 365
View Classification 383
Summary 395Chapter 7: Advanced SQL 397Triggers 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 487Chapter 8: pureXML Storage Engine 489pureXML 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 537Chapter 9: Development SQL 539User-Defined Functions 540
Structured Data Types 549
Schemas and Aliases 555
COMMIT and ROLLBACK 558
SQL Procedural Language 559
Stored Procedures 578
Summary 597Chapter 10: Concurrency 599Concurrency 600
Isolation Levels 607
Lockingv610
Summary 621Part THREE: DB2 Administration 623Chapter 11: Data Storage Management 625Processor, 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 699Chapter 12: Maintaining Data 701Moving Data 702
Data Movement Utilities 705
Data Maintenance 766
Data Maintenance Process 786
Summary 791Chapter 13: Database Recovery 793Database 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 869Chapter 14: Monitoring and Tuning 871Elements 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 973Part FOUR: Developing Applications 975Chapter 15: Application Development Overview 977DB2 Application Development Environment 978
DB2 Programming Interfaces 982
Summary 995Chapter 16: Development Considerations 997Embedded SQL Overview 998
Support for CLI and ODBC Programming 1009
Support for Java Programming 1018
DB2 Developer Workbench 1021
Summary 1022Part FIVE: Appendices 1023Appendix A: DB2 9 Certification Test Objectives 1025DB2 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) 1034Appendix B: DB2DEMO Installation 1037Installation Requirements 1038
Using the DB2DEMO Program 1045
Advanced Programming Information 1066
Support 1095Index 1097