IBM DB2 Universal Database Version 8 for z/OS offers enterprises unprecedented opportunities to integrate information, deliver it on demand, and manage it simply and cost-effectively. Now, one of the world's leading DB2 consultants presents the definitive guide to administering DB2 UDB V8 databases in z/OS environments. DB2 for z/OS Version 8 DBA Certification Guide also serves as a key tool for anyone preparing for IBM Certified Database Administrator for DB2 Universal Database V8 for z/OS certification.
IBM Gold Consultant Susan Lawson presents hundreds of practical techniques, expert guidelines, and useful tips for every facet of DB2 UDB database administration, including database implementation, operation, recovery, security, auditing, performance, installation, migration, SQL, and more. Coverage includes
Whether you are administering DB2 UDB V8 in z/OS environments, planning to do so, or preparing for DB2 UDB V8 DBA certification, DB2 for z/OS Version 8 DBA Certification Guide will be your single most valuable resource.
I. DB2 FAMILY AND DB2 FOR Z/OS ENVIRONMENT.
1. Product Overview.
DB2 and the On-Demand Business.
DB2 Universal Database.
DB2 Middleware and Connectivity.
DB2 Application Development.
Data Management Tools.
Parallel Sysplex Support.
Installation and Migration.
Catalog and Directory.
3. DB2 Access and Security.
Data Set Protection.
Access to DB2 objects.
II. STRUCTURED QUERY LANGUAGE.
4. Database Objects.
Understanding Data Structures.
Managing Database Objects.
Creating Database Objects.
Database Design and Implementation.
5. Retrieving and Manipulating Database Objects.
6. Advanced SQL Coding.
Nested and Common Table Expressions.
OLAP and Star Joins.
Predicates and Filtering.
III. DATABASE ADMINISTRATION.
7. Maintaining Data.
Resolving Restrictive and Advisory States.
8. Recovery and Restart.
Database Recovery Concepts.
System-Level Backup and Recovery.
IV. DEVELOPING APPLICATIONS WITH DB2.
9. Data Sharing.
Data Sharing Components.
Maintaining Data Integrity.
Performance and Processing Costs.
Movement to Data Sharing.
10. Using SQL in an Application Program.
Delimiting SQL in a Program.
Table and View Definitions.
Host Variables and Structures.
SQL Execution Validation.
11. Binding an Application Program.
Plan or Package Ownership.
12. Application Program Features.
Commit, Rollback, and Savepoint Operations.
Global Temporary Tables.
Fetch for Limited Rows.
Multirow Fetch and Multirow Insert.
V. ADVANCED FUNCTIONS AND PERFORMANCE.
13. Stored Procedures.
Benefits of Using Stored Procedures.
Writing Stored Procedures.
Defining Stored Procedures.
SQL Procedure Language.
Developing SQL Stored Procedures.
DB2 Development Center.
14. Accessing Distributed Data.
Coding Methods for Distributed Data.
Remote Query Performance.
15. Object-Relational Functionality.
16. Locking and Concurrency.
Claims and Drains.
Locking Issues and Problems.
Designing for Concurrency.
17. SQL Optimization and Performance.
Access Paths and Optimization.
Designing Indexes and SQL for Performance.
18. DB2 Monitoring and Tuning.
Overview of Performance and Tuning.
Using Traces to Solve Problems in DB2.
Appendix A. DDL for the DB2CERT Database.
Appendix B. IBM Certified Database Administrator for DB2 UDB V8 for z/OS.
DB2 UDB V8 Family Fundamentals: 700 Exam.
DB2 UDB V8 for z/OS Database Administration: 702 Exam.
Appendix C. 702 Sample Exam.
Answers and Chapter References.