---

DB2 for z/OS Version 8 DBA Certification Guide

ISBN: 0131491202
EAN: 2147483647

Year: 2003
Pages: 175

Authors: Susan Lawson

BUY ON AMAZON

• DB2 for zOS Version 8 DBA Certification Guide
• Table of Contents
• Copyright
• IBM Press SeriesInformation Management
• On Demand Computing Books
• DB2 Books
• More Books from IBM Press
• FOREWORD
• PREFACE
• ACKNOWLEDGMENTS
• PartI.DB2 Family and DB2 for zOS Environment
• Chapter1.Product Overview
• DB2 and the On-Demand Business
• DB2 Universal Database
• DB2 Middleware and Connectivity
• DB2 Application Development
• DB2 Administration
• Data Management Tools
• Summary
• Additional Resources
• Chapter2.DB2 Environment
• zOS
• Address Spaces
• Security
• Parallel Sysplex Support
• DFSMS
• Interfaces
• Installation and Migration
• System Parameters
• Commands
• Utilities
• Catalog and Directory
• Distributed Data
• Subsystem Pools
• Summary
• Additional Resources
• Chapter3.DB2 Access and Security
• Subsystem Access
• Data Set Protection
• Access to DB2 Objects
• Multilevel Security
• Auditing
• Summary
• Additional Resources
• PartII.Structured Query Language
• Chapter4.Database Objects
• Understanding Data Structures
• Managing Database Objects
• Creating Database Objects
• Database Design and Implementation
• Summary
• Additional Resources
• Chapter5.Retrieving and Manipulating Database Objects
• Data Retrieval
• Data Modification
• Summary
• Additional Resources
• Chapter6.Advanced SQL Coding
• Subqueries
• Unions
• Joins
• Nested and Common Table Expressions
• CASE Expressions
• Row Expressions
• OLAP and Star Joins
• Predicates and Filtering
• Summary
• Additional Resources
• PartIII.Database Administration
• Chapter7.Maintaining Data
• Data Movement
• Data Maintenance
• Gathering Statistics
• Statistics Usage
• Resolving Restrictive and Advisory States
• Summary
• Additional Resources
• Chapter8.Recovery and Restart
• Database Recovery Concepts
• Logging
• Image Copies
• Data Recoveries
• Disaster Recoveries
• System-Level Backup and Recovery
• DB2 Restart
• Summary
• Additional Resources
• PartIV.Developing Applications with DB2
• Chapter9.Data Sharing
• Data Sharing Components
• Maintaining Data Integrity
• Performance and Processing Costs
• Movement to Data Sharing
• Recovery Considerations
• Summary
• Additional Resources
• Chapter10.Using SQL in an Application Program
• Delimiting SQL in a Program
• Table and View Definitions
• Host Variables and Structures
• SQL Execution Validation
• Cursors
• Dynamic SQL
• Summary
• Additional Resources
• Chapter11.Binding an Application Program
• Precompiling
• Binding
• Plan or Package Ownership
• Summary
• Additional Resources
• Chapter12.Application Program Features
• Commit, Rollback, and Savepoint Operations
• Global Transactions
• Global Temporary Tables
• Fetch for Limited Rows
• Identity Columns
• Sequence Objects
• Summary
• Additional Resources
• PartV.Advanced Functions and Performance
• Chapter13.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
• Summary
• Additional Resources
• Chapter14.Accessing Distributed Data
• Distributed Data
• Coding Methods for Distributed Data
• Programming Considerations
• Remote Query Performance
• Summary
• Additional Resources
• Chapter15.Object-Relational Functionality
• Triggers
• Object-Relational Extensions
• Large Objects
• Summary
• Additional Resources
• Chapter16.Locking and Concurrency
• Locking Data
• Avoiding Locks
• Claims and Drains
• Locking Issues and Problems
• Designing for Concurrency
• Summary
• Additional Resources
• Chapter17.SQL Optimization and Performance
• Access Paths and Optimization
• Designing Indexes and SQL for Performance
• Summary
• Additional Resources
• Chapter18.DB2 Monitoring and Tuning
• Overview of Performance and Tuning
• Database Monitoring
• Using Traces to Solve Problems in DB2
• Memory Tuning
• Summary
• Additional Resources
• AppendixA.DDL for the DB2CERT Database
• AppendixB.IBM Certified Database Administrator for DB2 UDB Version 8 for zOS
• DB2 UDB V8 Family Fundamentals: 700 Exam
• DB2 UDB V8 for zOS Database Administration: 702 Exam
• AppendixC.702 Sample Exam
• Questions
• Answers and Chapter References
• BIBLIOGRAPHY
• Index
• B