DB2 for z/OS Version 8 DBA Certification Guide
DB2 for z/OS Version 8 DBA Certification Guide
ISBN: 0131491202
EAN: 2147483647
EAN: 2147483647
Year: 2003
Pages: 175
Pages: 175
Authors: Susan Lawson
- 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
DB2 for z/OS Version 8 DBA Certification Guide
ISBN: 0131491202
EAN: 2147483647
EAN: 2147483647
Year: 2003
Pages: 175
Pages: 175
Authors: Susan Lawson