MC Press Online
Welcome to MC Press Online!
Need help with our eBooks?
Contact PublishersRow.com
Home  |  Cart  |  My Account  |  Support    
Click here, to go to our main store

  MC Press Online eBookStore   

 
 
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: Susan Lawson, Daniel Luksetich
Publisher: MC Press Online
Publication Date: November 2007
Subject: Computer: Database Management & Development

Free Preview    Email to Friend
 Available as: (for format`s description click on its name)
Individual E-Version (PDF) Individual E-Version (PDF) ISBN: 9781583470749  
$64.95
 
 Reg.: $
64.95 per N pages
 
 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 strong background in system and database administration. She has over 19 years experience in DB2 and 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 performs Performance Audits for many clients to help reduce costs through proper performance tuning. Her other activities have included authoring articles, presenting at user group meetings, and writing white papers. She is an IBM GOLD Consultant for DB2 and z/Series and has authored and co-authored several books.

Daniel Luksetich
Daniel Luksetich is a senior DB2 database administrator (DBA). He works as a DBA, application architect, presenter, author, and teacher. Dan has been in the information technology business for more than 22 years and has worked with DB2 for more than 17 years. He has been a COBOL and BAL programmer, DB2 system programmer, DB2 DBA, and DB2 application architect. His experience includes major implementations in z/OS, AIX, and Linux environments.

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: Cost Savings . . . Right Out of the BoxDB2 10 for z/OS: Cost Savings . . . Right Out of the Box
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)
 
  Special Offer Code  
Enter your Special Offer Code here:
  Search for  

  Our Products  
Browse all »»
IBM Business Analytics and Cloud Computing
IBM Business Analytics and Cloud Computing
Identity Management: A Primer
Identity Management: A Primer
IBM System i APIs at Work
IBM System i APIs at Work

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
 

  Secure Shopping  
 
money-back 30 days guarantee

All orders for eBooks are filled and customer/technical
support is provided by PublishersRow.com




Copyright © 2001-2011 by Publishers Row. All rights reserved.
Our Privacy Policy and Terms of Use