Author Description

Advanced Topics In DB2 is a unique book that covers specific 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 *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.