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

Foreword   xxi
Preface   xxiiiPart ONE: Introduction to DB2   1Chapter 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   223Chapter 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: pure

pure

The Difference: pure

Creating an

Creating Tables with pure

Inserting Data into pure

Selecting Data from pure

Updating and Deleting pure

Indexing pure

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
Lockingv610
Summary   621

Part THREE: DB2 Administration   623Chapter 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   975Chapter 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   1023Appendix 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