MC Press Online
Welcome to the MC Press Online!
Need help with our eBooks?
Contact PublishersRow.com
Click here, to go to our main store

  MC Press Online eBookStore  

DB2 9 for z/OS Database Administration: Certification Study Guide (Exam 732)
preview of book DB2 9 for z/OS Database Administration: Certification Study Guide (Exam 732)
text of book DB2 9 for z/OS Database Administration: Certification Study Guide (Exam 732)

DB2 9 for z/OS Database Administration: Certification Study Guide (Exam 732)

Authors:
Publisher: MC Press Online
Publication Date: November 2007
Subject: Computer: Database Management & Development
Number of Pages: 994

Free Preview    Email to Friend   Add to wish list
 Available as: (for format`s description click on its name)
Individual E-Version (PDF) Individual E-Version (PDF) ISBN: 9781583470749  
$30.36
 
 Reg.: $
64.95 per N pages
 You Save: 
$34.59 (53%)
 Online  Open CopyPrint    
all time
Printed Edition   see MC Press Online    
About this title
DB2 9 for z/OS Database Administration Certification Guide is the definitive guide to preparing for the IBM Certification 732 Version 9 DBA Certification Exam. The book covers all topics on the exam and also provides a wealth of information about DB2 z/OS Version 9. It also includes a lot of practical information and tips for best performance and usage of DB2. The book is written by two industry experts who were both members of the team that created the 732 exam.

This book covers all of the topics that are on the exam: Database design and implementation, operation and recovery, security and auditing, performance, and installation and migration. There are practice questions with detailed answers at the end of each chapter, as well as an 80+ question practice exam.

Beyond certification prep, the book also covers the new features of Version 9 for both database and application development. It will serve as an essential tool for studying for exam 732 as well as a reference that all DB2 DBAs will want on their desktops.

732 Exam Objectives Covered in This Book:
  • Section 1 - Database Design and Implementation
  • Section 2 - Operation and Recovery
  • Section 3 - Security and Auditing
  • Section 4 – Performance
  • Section 5 - Installation and Migration/Upgrade
About authors
Susan Lawson
Susan Lawson is an internationally recognized consultant and lecturer with a background in system and database administration. She currently works with several large clients to help develop, implement, and tune some of the world's largest and most complex DB2 databases and applications. Susan also conducts performance and availability audits to help clients reduce costs through proper performance tuning and ensure availability. She also writes articles and white papers, presents at user group meetings, and teaches a variety of DB2 courses. Susan is an IBM GOLD Consultant for DB2 and System z and an IBM Champion.

Daniel Luksetich
Daniel Luksetich is a DB2 database professional with more than 26 years of experience in high-performance design and tuning of very large databases and highly available, high-volume database applications. He also teaches DB2 courses and has authored books, guides, whitepapers, and magazine articles. Working as a DB2 application architect, Dan has been involved in several very large DB2 application designs. An IBM Champion, Dan specializes in DB2 for z/OS but has worked with DB2 on a variety of platforms. His specialties include performance audits, SQL education, backup and recovery, stored procedures, UDFs, triggers, application design, high-availability design, and DB2 high performance.

Contents
Chapter 1: DB2 Product Fundamentals
DB2 and the On Demand Business
The DB2 Product Family
DB2 Middleware and Connectivity
DB2 Application Development
DB2 Administration
Summary
Practice Questions
Answers

Chapter 2: Environment
z/OS
DB2 and Security
Parallel Sysplex Support
Storage Management Subsystem
DB2 Interfaces
Installation, Migration, and Conversion
DSNZPARMs
Commands
DB2 Utilities
Catalog and Directory
Distributed Data
Subsystem Pools
Summary
Additional Resources
Practice Questions
Answers

Chapter 3: Access and Security
DB2 Subsystem Access
Data-Set Protection
DB2 Object Access
Trusted Context
Multilevel Security
Auditing
Auditing Specific IDs or Roles
Starting/Stopping the Trace
Auditing a Table
Summary
Additional Resources
Practice Questions
Answers

Chapter 4: Database Objects
Understanding Data Structures
Managing Database Objects
Data Types
Tables
Sequence Objects
Table Spaces
Views
Materialized Query Tables
Clone Tables
Indexes
Databases
Storage Groups
Database Design and Implementation
Sample Implementation
Summary
Additional Resources
Practice Questions
Answers

Chapter 5: Retrieving and Manipulating Database Objects
Data Retrieval
Data Modification
Summary
Additional Resources
Practice Questions
Answers

Chapter 6: Advanced SQL Coding
Subqueries
Unions
Excepts
Intersects
Nested Table Expressions
Common Table Expressions
Data Change Tables
Joins
ORDER BY and FETCH FIRST in Subselects and Fullselects
CASE Expressions
Row Expressions
XPath and XQuery
Predicates and Filtering
Summary
Additional Resources
Practice Questions
Answers

Chapter 7: Maintaining Data
Data Movement
Data Maintenance
Data Statistics
Real Time Statistics
Data Maintenance Process
Diagnose Utility
Standalone Utilities
Displaying Utilities
Resolving Restrictive and Advisory States
Summary
Additional Resources
Practice Questions
Answers

Chapter 8: Recovery and Restart
Database Recovery Concepts
Logging
Image Copies
Establishing a Point of Consistency
Recovery Concepts
System-Level Backup and Recovery
Backup and Recovery of the DB2 Catalog and Directory
Disaster Recovery
LOB Recovery
Tracker Site Recovery
DB2 Restart
Data-Sharing Recovery
Summary
Additional Resources
Practice Questions
Answers

Chapter 9: Data Sharing
Data Sharing Benefits
Data Sharing Components
Shared Data
Maintaining Data Integrity
Performance
Processing Costs
Movement to Data Sharing
Workload Management and Affinity Processing
Distributed Processing
Sysplex Query Parallelism
Recovery Considerations
Summary
Additional Resources
Practice Questions
Answers

Chapter 10: Using SQL in an Application Program
Delimiting SQL in a Program
Declaring Table and View Definitions
SQL Execution Validation
Using Cursors
Executing SQL Statements
Using Dynamic SQL
Summary
Additional Resources
Practice Questions
Answers

Chapter 11: Binding an Application Program
Precompile and Bind
Plan or Package Ownership
Plan Execution Authorization
Summary
Additional Resources
Practice Questions
Answers

Chapter 12: Application Program Features
Application Program Features
Global Transactions
Fetch for Limited Rows
Multi-Row Operations
Identity Columns
Summary
Additional Resources
Practice Questions
Answers

Chapter 13: Stored Procedures
Stored Procedures
Benefits
Writing Stored Procedures
Defining Stored Procedures
Removing Stored Procedures
Execution Environments
SQL Procedure Language
DB2 Developer Workbench
Summary
Additional Resources
Practice Questions
Answers

Chapter 14: Accessing Distributed Data
Distributed Data
Communications Protocols
Communications Database
Communicating with a Data-Sharing Group
Coding Methods for Distributed Data
Programming Considerations
Application Design Options
Remote Query Performance
Summary
Additional Resources
Practice Questions
Answers

Chapter 15: Advanced Functionality
Triggers
Object-Relational Extensions
User-Defined Functions
Large Objects
Extenders
Summary
Additional Resources
Practice Questions
Answers

Chapter 16: Locking and Concurrency
Locking Data
Avoiding Locks
System Parameters
Claims and Drains
Locking Issues and Problems
Lock Promotion and Escalation
Database and Application Design for Concurrency
Lock Monitoring
Summary
Additional Resources
Practice Questions
Answers

Chapter 17: Performance Monitoring and Tuning
Access Paths and Optimization
Access Path Evaluation
Guidelines for Using Explain Output
Access Path Optimization Hints
Catalog Statistics
Predicate Types
Designing Indexes and SQL for Performance
Dynamic SQL
Runtime Reoptimization
Query Parallelism
Elements of Performance
Database Monitoring
Tracing Problems in DB2
Using DISPLAY Commands
Buffer Pools
Logging
Summary
Additional Resources
Practice Questions
Answers

Appendix A: DB2 Sample Database
Appendix B: Sample Exam Questions
Appendix C: Sample Exam Answers
Appendix D: References
Related titles
Administering Informix Dynamic ServerAdministering Informix Dynamic Server
DB2 10 for z/OS Database Administration: Certification Study Guide (Exam 612)DB2 10 for z/OS Database Administration: Certification Study Guide (Exam 612)
DB2 10 for z/OS: Cost Savings . . . Right Out of the BoxDB2 10 for z/OS: Cost Savings . . . Right Out of the Box
DB2 10 for z/OS: The Smarter, Faster Way to UpgradeDB2 10 for z/OS: The Smarter, Faster Way to Upgrade
DB2 9 Fundamentals: Certification Study Guide (Exam 730)DB2 9 Fundamentals: Certification Study Guide (Exam 730)
DB2 9 System Administration for z/OS: Certification Study Guide (Exam 737)DB2 9 System Administration for z/OS: Certification Study Guide (Exam 737)
Business Value of DB2 for z/OS, TheBusiness Value of DB2 for z/OS, The
 
  Special Offer Code  
Enter your Special Offer Code here:
  Search for  

  Our Products  
Browse all »»
SQL for eServer i5 and iSeries
Identity Management: A Primer
Leadership in My Rearview Mirror

If download option is selected, Adobe Acrobat 5.0 or later is required to read our e-books*


Windows PC, Mac OS9/OSX, and Linux