DB2, Database Administration & Management

Advanced topics in DB2

Name: Advanced topics in DB2
Author: Blaine Lucyk
ISBN: 9780201576528

by Blaine Lucyk

Write a review

Overview

and complex problems encountered by the DB2 database administrator (DBA). The book is presented from the perspective of the practitioner and is designed to cover more advanced topics of DB2. The author provides several algorithms, new formulas, and step-by-step solutions to real life problems. In addition, the book features challenging scenarios and hands-on practice suggestions that provide valuable experience to the reader. Not found in other introductory books or directly in DB2 manuals, these scenarios and how-to-get practice suggestions motivate the reader to simulate and solve difficult problems before they occur in production.

The book's material is presented from a problem solving point of view and brings relevant information together from courses, conferences, seminars and DB2 manuals in a way that is immediately useful to the DBA. Advanced Topics in DB2 is a ready reference with extensive appendices such as a survey of third-party vendor tools; useful CLISTs and edit macro tools; instruction on hexa- decimal conversion and two's complement arithmetic; and how to improve DSN1COPY performance using VSAM Buffering.

TOPICS INCLUDE:

Mass Data Movement Techniques
RRDF, LOG APPLY and Continuous Availability
Sparse Indexes
Hot Spots and How to Cool Them Down
Revolving Tablespaces
Place Holders
The Existential Quantifier
How to Backout a Corrupting Program
Getting Important Information Out of the DB2 Log

DB2 users will find this reference an essential companion to the DB2 Manuals.

Reviews

There are no reviews yet. Log in to write one.

Editorials

Booknews

For the database administrator, or application developer, who already has a working knowledge of DB2. Offers several algorithms, new formulas, and features scenarios and practice suggestions that help simulate and solve problems before they occur in production. Also treats design topics, SQL, and tips on DB2 performance. Covers versions 2.2 and 2.3. Annotation c. Book News, Inc., Portland, OR (booknews.com)