Table of Contents

•	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

		Copyright
		IBM Press SeriesInformation Management
			On Demand Computing Books
			DB2 Books
			More Books from IBM Press
		FOREWORD
		PREFACE
		ACKNOWLEDGMENTS
		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
				Summary
				Additional Resources
			Chapter 2.  DB2 Environment
				z/OS
				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
			Chapter 3.  DB2 Access and Security
				Subsystem Access
				Data Set Protection
				Access to DB2 Objects
				Multilevel Security
				Auditing
				Summary
				Additional Resources
		Part II.  Structured Query Language
			Chapter 4.  Database Objects
				Understanding Data Structures
				Managing Database Objects
				Creating Database Objects
				Database Design and Implementation
				Summary
				Additional Resources
			Chapter 5.  Retrieving and Manipulating Database Objects
				Data Retrieval
				Data Modification
				Summary
				Additional Resources
			Chapter 6.  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
		Part III.  Database Administration
			Chapter 7.  Maintaining Data
				Data Movement
				Data Maintenance
				Gathering Statistics
				Statistics Usage
				Resolving Restrictive and Advisory States
				Summary
				Additional Resources
			Chapter 8.  Recovery and Restart
				Database Recovery Concepts
				Logging
				Image Copies
				Data Recoveries
				Disaster Recoveries
				System-Level Backup and Recovery
				DB2 Restart
				Summary
				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
				Summary
				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
				Cursors
				Dynamic SQL
				Summary
				Additional Resources
			Chapter 11.  Binding an Application Program
				Precompiling
				Binding
				Plan or Package Ownership
				Summary
				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
				Summary
				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
				Summary
				Additional Resources
			Chapter 14.  Accessing Distributed Data
				Distributed Data
				Coding Methods for Distributed Data
				Programming Considerations
				Remote Query Performance
				Summary
				Additional Resources
			Chapter 15.  Object-Relational Functionality
				Triggers
				Object-Relational Extensions
				Large Objects
				Summary
				Additional Resources
			Chapter 16.  Locking and Concurrency
				Locking Data
				Avoiding Locks
				Claims and Drains
				Locking Issues and Problems
				Designing for Concurrency
				Summary
				Additional Resources
			Chapter 17.  SQL Optimization and Performance
				Access Paths and Optimization
				Designing Indexes and SQL for Performance
				Summary
				Additional Resources
			Chapter 18.  DB2 Monitoring and Tuning
				Overview of Performance and Tuning
				Database Monitoring
				Using Traces to Solve Problems in DB2
				Memory Tuning
				Summary
				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
				Questions
				Answers and Chapter References
		BIBLIOGRAPHY
		Index