---

The Definitive Solutions-Oriented Guide to DB2 for z/OS: Now Fully Updated for Both v9 and v10!

DB2 Developer´s Guide is the world´s #1 go-to source for on-the-job information on programming and administering DB2. Now, three-time IBM Information Champion Craig S. Mullins has thoroughly updated this classic for the newest versions of DB2 for z/OS: DB2 V9 andV10.

This Sixth Edition builds on the unique approach that has made previous editions so valuable. It brings together condensed, easy-to-read coverage of all essential topics: information otherwise scattered through dozens of IBM and third-party documents. Throughout, Mullins offers focused drill-down on the key details DB2 developers need to succeed, with expert, field-tested implementation advice and realistic examples.

Extensive updates address IBM´s latest DB2 for z/OS innovations and best practices. Mullins introduces DB2´s newest data types, performance and security enhancements, pureXML support, and much more. Whether you´re a professional DB2 developer, DBA, sysadmin, or advanced user, this book will make you more productive, effective, and successful.

Coverage includes
- Modern DB2 SQL tools, tips, and tricks
- Best practices for data definition, indexing, and change management
- Large objects and object/relational databases
- Temporal data support
- DB2 security, authorization, and auditing
- Dynamic SQL programming and DB2 stored procedures
- "Under the hood" with the DB2 Optimizer and Catalog
- Performance monitoring in-depth: EXPLAIN, object monitoring, and RTS
- REORG, RUNSTATS, REBIND: superior approaches to managing DB2 access path changes
- DB2 tuning: environment, components, and resource governing
- Optimizing DB2 utilities and commands

---