DB2 for zOS Version 8 DBA Certification Guide

book cover
• Table of Contents
• Index
DB2 for z/OS Version 8 DBA Certification Guide
By Susan Lawson
Publisher: Prentice Hall PTR
Pub Date: October 28, 2004
ISBN: 0-13-149120-2
Pages: 688

  • A practical guide to DB2 z/OS database administration that is 100 percent focused on running DB2 in z/OS environments

  • The only comprehensive preparation guide for the IBM Certified Database Administrator for DB2 Universal Database V8 z/OS certification

  • Covers database planning, design, implementation, operation, recovery, security, performance, installation, migration, and more

  • Sample test questions help you prepare for both IBM DB2 DBA Tests 700 and 702

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

  • Understanding the DB2 product family, architecture, attachments, and the DB2 z/OS environment

  • Securing enterprise-class DB2 installations and applications

  • Using SQL to create and manage database objects, and manipulate and retrieve information

  • Mastering key DBA tasks, including loading, reorganizing, quiescing, repairing, and recovering data; recovering and rebuilding indexes; and gathering statistics

  • Implementing data sharing in Parallel Sysplex environments

  • Learning the fundamentals of DB2 application development from the DBA's perspective

  • Leveraging advanced DB2 functions, including stored procedures and other object-relational extensions

  • Optimizing DB2 applications and the DB2 engine for maximum performance

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.

book cover
• Table of Contents
• Index
DB2 for z/OS Version 8 DBA Certification Guide
By Susan Lawson
Publisher: Prentice Hall PTR
Pub Date: October 28, 2004
ISBN: 0-13-149120-2
Pages: 688

   IBM Press SeriesInformation Management
      On Demand Computing Books
      DB2 Books
      More Books from IBM Press
   Part I.  DB2 Family and DB2 for z/OS Environment
         Chapter 1.  Product Overview
      DB2 and the On-Demand Business
      DB2 Universal Database
      DB2 Middleware and Connectivity
      DB2 Application Development
      DB2 Administration
      Data Management Tools
      Additional Resources
         Chapter 2.  DB2 Environment
      Address Spaces
      Parallel Sysplex Support
      Installation and Migration
      System Parameters
      Catalog and Directory
      Distributed Data
      Subsystem Pools
      Additional Resources
         Chapter 3.  DB2 Access and Security
      Subsystem Access
      Data Set Protection
      Access to DB2 Objects
      Multilevel Security
      Additional Resources
   Part II.  Structured Query Language
         Chapter 4.  Database Objects
      Understanding Data Structures
      Managing Database Objects
      Creating Database Objects
      Database Design and Implementation
      Additional Resources
         Chapter 5.  Retrieving and Manipulating Database Objects
      Data Retrieval
      Data Modification
      Additional Resources
         Chapter 6.  Advanced SQL Coding
      Nested and Common Table Expressions
      CASE Expressions
      Row Expressions
      OLAP and Star Joins
      Predicates and Filtering
      Additional Resources
   Part III.  Database Administration
         Chapter 7.  Maintaining Data
      Data Movement
      Data Maintenance
      Gathering Statistics
      Statistics Usage
      Resolving Restrictive and Advisory States
      Additional Resources
         Chapter 8.  Recovery and Restart
      Database Recovery Concepts
      Image Copies
      Data Recoveries
      Disaster Recoveries
      System-Level Backup and Recovery
      DB2 Restart
      Additional Resources
   Part IV.  Developing Applications with DB2
         Chapter 9.  Data Sharing
      Data Sharing Components
      Maintaining Data Integrity
      Performance and Processing Costs
      Movement to Data Sharing
      Recovery Considerations
      Additional Resources
         Chapter 10.  Using SQL in an Application Program
      Delimiting SQL in a Program
      Table and View Definitions
      Host Variables and Structures
      SQL Execution Validation
      Dynamic SQL
      Additional Resources
         Chapter 11.  Binding an Application Program
      Plan or Package Ownership
      Additional Resources
         Chapter 12.  Application Program Features
      Commit, Rollback, and Savepoint Operations
      Global Transactions
      Global Temporary Tables
      Fetch for Limited Rows
      Identity Columns
      Sequence Objects
      Additional Resources
   Part V.  Advanced Functions and Performance
         Chapter 13.  Stored Procedures
      Benefits of Using Stored Procedures
      Writing Stored Procedures
      Defining Stored Procedures
      Execution Environments
      SQL Procedure Language
      Developing SQL Stored Procedures
      DB2 Development Center
      Additional Resources
         Chapter 14.  Accessing Distributed Data
      Distributed Data
      Coding Methods for Distributed Data
      Programming Considerations
      Remote Query Performance
      Additional Resources
         Chapter 15.  Object-Relational Functionality
      Object-Relational Extensions
      Large Objects
      Additional Resources
         Chapter 16.  Locking and Concurrency
      Locking Data
      Avoiding Locks
      Claims and Drains
      Locking Issues and Problems
      Designing for Concurrency
      Additional Resources
         Chapter 17.  SQL Optimization and Performance
      Access Paths and Optimization
      Designing Indexes and SQL for Performance
      Additional Resources
         Chapter 18.  DB2 Monitoring and Tuning
      Overview of Performance and Tuning
      Database Monitoring
      Using Traces to Solve Problems in DB2
      Memory Tuning
      Additional Resources
         Appendix A.  DDL for the DB2CERT Database
         Appendix B.  IBM Certified Database Administrator for DB2 UDB Version 8 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