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
Craig S. Mullins is a data management strategist, researcher, and consultant. He is president and principal consultant of Mullins Consulting, Inc. and the publisher and editor of The Database Site (www.TheDatabaseSite.com). Craig has also been appointed as an Information Champion by IBM.
Craig has extensive experience in all facets of database systems development, including systems analysis and design, database and system administration, data analysis, and developing and teaching DB2 and database development classes. He has worked with DB2 since Version 1 and has experience in multiple roles, including programmer, DBA, instructor, and analyst. His experience spans industries, having worked for companies in the following fields: manufacturing (USX Corporation), banking (Mellon Bank), utilities (Duquesne Light Company), commercial software development (BMC Software, NEON Enterprise Software, and PLATINUM Technology, Inc.), consulting (ASSET, Inc. and Mullins Consulting, Inc.), and computer industry analysis (Gartner Group). In addition, Craig authored many of the popular “Platinum Monthly DB2 Tips” and worked on Platinum’s DB2 system catalog and access path posters.
Craig is a regular lecturer at industry conferences. You may have seen him present at such events as the International DB2 Users Group (IDUG), the IBM Information on Demand (IOD) Conference, the IBM DB2 Technical Conference, SHARE, DAMA, CMG, or at one of many regional user groups throughout the world. Craig is a member of the IDUG Volunteers Hall of Fame.
Craig is also the author of
Database Administration: The Complete Guide to Practices and Procedures(ISBN 0-201-74129-6). This book offers the industry’s only comprehensive guide to heterogeneous database administration.
Craig is a frequent contributor to computer industry publications, with hundreds of articles published over the past couple decades. His articles have been published in
Byte,
DB2 Update,
Database Programming & Design,
DBMS,
Data Management Review,
zJournal, and many others. Craig writes four regular columns, including “The DBA Corner” for
Database Trends and Applications, “The Database Report” for
The Data Administration Newsletter, “z/Data Perspectives” for
zJournal, and “The Buffer Pool” for
IDUG Solutions Journal. He also writes a blog focusing on DB2 topics at http://db2portal.blogspot.com. Complete information on Craig’s published articles and books can be found on his website at www.craigsmullins.com.
Craig graduated cum laude from the University of Pittsburgh with a B.S. degree and a dual major in computer science and economics. Follow Craig on Twitter at www.twitter.com/craigmullins.
