DB2 Developer’s Guide: A Solutions-Oriented Approach to Learning the Foundation and Capabilities of DB2 for z/OS

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