Cover -- Acknowledgments -- Copyright -- Contents -- Introduction IBM DB2 10 for z/OS Certifi ed Database Administrator -- 1: DB2 Product Fundamentals -- DB2 and the On Demand Business -- The DB2 Product Family -- DB2 Middleware and Connectivity -- InfoSphere Optim Data Lifecycle Management for DB2 -- Additional DB2 Application Development and Administration -- Summary and Resources -- Practice Questions and Answers -- 2: Environment -- z/OS -- DB2 for z/OS -- DB2 and Security -- Parallel Sysplex Support -- Storage Management Subsystem -- DB2 Interfaces -- Installation, Migration, and Conversion -- DSNZPARMs -- Commands -- DB2 Utilities -- Catalog and Directory -- Distributed Data -- Memory Management -- Summary and Resources -- Practice Questions and Answers -- 3: Access and Security -- DB2 Subsystem Access -- Data Set Protection -- Encryption -- DB2 Object Access -- Multilevel Security -- Auditing -- Summary and Resources -- Practice Questions and Answers -- 4: Database Objects -- Understanding Data Structures -- Managing Database Objects -- Data Types -- Tables -- Sequence Objects -- Table Spaces -- Views -- Materialized Query Tables -- Clone Tables -- Temporal Tables -- Hash Tables (Tables with Hash Access Enabled) -- Indexes -- Databases -- Storage Groups -- Database Design and Implementation -- Sample Implementation -- Summary and Resources -- Practice Questions and Answers -- 5: Retrieving and Manipulating Database Objects -- Data Retrieval -- Data Modifi cation -- Summary and Resources -- Practice Questions and Answers -- 6: Advanced SQL Coding -- Subqueries -- Unions -- Excepts -- Intersects -- Nested Table Expressions -- Common Table Expressions -- Data Change Tables -- Joins -- ORDER BY and FETCH FIRST in Subselects and Fullselects -- CASE Expressions -- Row Expressions -- PureXML Usage -- OLAP Specifi cation.

Predicates and Filtering -- Summary and Resources -- Practice Questions and Answers -- 7: Maintaining Data -- Data Movement -- Data Maintenance -- Rebuilding Indexes -- Data Statistics -- Real-Time Statistics -- Data Maintenance Process -- Diagnose Utility -- Standalone Utilities -- Displaying Utilities -- Resolving Restrictive and Advisory States -- Summary and Resources -- Practice Questions and Answers -- 8: Recovery and Restart -- Database Recovery Concepts -- Logging -- Image Copies -- Establishing a Point of Consistency -- Recovery Concepts -- System-Level Backup and Recovery -- Backup and Recovery of the DB2 Catalog and Directory -- Disaster Recovery -- LOB and XML Recovery -- Tracker Site Recovery -- DB2 Restart -- Data Sharing Recovery -- Summary and Resources -- Practice Questions and Answers -- 9: Data Sharing -- Data Sharing Benefi ts -- Data Sharing Components -- Shared Data -- Maintaining Data Integrity -- Performance -- Processing Costs -- Movement to Data Sharing -- Workload Management and Affi nity Processing -- Submitting Work -- Communicating with a Data Sharing Group -- Sysplex Query Parallelism -- Recovery Considerations -- Summary and Resources -- Practice Questions and Answers -- 10: Using SQL in an Application Program -- Delimiting SQL in a Program -- Declaring Table and View Defi nitions -- SQL Execution Validation -- Using Cursors -- Executing SQL Statements -- Using Dynamic SQL -- ODBC -- JDBC, SQLJ, and pureQuery -- Summary and Resources -- Practice Questions and Answers -- 11: Binding an Application Program -- Precompile and Bind -- Plan or Package Ownership -- Plan Execution Authorization -- Summary and Resources -- Practice Questions and Answers -- 12: Application Program Features -- Commit, Rollback, and Savepoint -- Savepoints -- Global Transactions -- Global Temporary Tables -- Fetch for Limited Rows.

Multi-Row Operations -- Identity Columns -- Sequence Objects -- Optimistic Locking -- Temporal Data Management -- Summary and Resources -- Practice Questions and Answers -- 13: Stored Procedures -- Stored Procedures -- Benefi ts -- Writing Stored Procedures -- Native SQL Procedures -- Defi ning Stored Procedures -- Removing Stored Procedures -- Schema Qualifi cation -- Execution Environments -- SQL Procedure Language -- SQL and Java Procedure Development -- DB2-Supplied Stored Procedures -- Summary and Resources -- Practice Questions and Answers -- 14: Accessing Distributed Data -- Distributed Data -- Communications Protocols -- Communications Database -- Communicating with a Data Sharing Group -- Coding Methods for Distributed Data -- Programming Considerations -- Application Design Options -- Remote Query Performance -- Summary and Resources -- Practice Questions and Answers -- 15: Advanced Functionality -- Triggers -- Object-Relational Extensions -- User-Defi ned Functions -- Large Objects -- XML -- Summary and Resources -- Practice Questions and Answers -- 16: Locking and Concurrency -- Locking Data -- Avoiding Locks -- System Parameters -- Claims and Drains -- Locking Issues and Problems -- Lock Promotion and Escalation -- Database and Application Design for Concurrency -- Lock Monitoring -- Summary and Resources -- Practice Questions and Answers -- 17: Performance Monitoring and Tuning -- Access Paths and Optimization -- Access Path Evaluation -- Guidelines for Using Explain Output -- Access Path Optimization Hints -- Catalog Statistics -- Predicate Types -- Designing Indexes and SQL for Performance -- Dynamic SQL -- Query Parallelism -- Database Monitoring -- Tracing Problems in DB2 -- Using DISPLAY Commands -- Buffer Pools -- Logging -- Opening and Closing Data Sets -- Summary and Resources -- Practice Questions and Answers -- Appendix A.

Appendix B -- Appendix C -- Appendix D -- Index.