Deliver to your Kindle or other device

Enter a promotion code
or gift card
 
 
 

Try it free

Sample the beginning of this book for free

Deliver to your Kindle or other device

Sorry, this item is not available in
Image not available for
Color:
Image not available
 

DB2 Developer's Guide: A Solutions-Oriented Approach to Learning the Foundation and Capabilities of DB2 for z/OS (6th Edition) (IBM Press) [Kindle Edition]

Craig S. Mullins
5.0 out of 5 stars  See all reviews (9 customer reviews)

Digital List Price: $71.99 What's this?
Print List Price: $89.99
Kindle Price: $57.59
You Save: $32.40 (36%)

Free Kindle Reading App Anybody can read Kindle books—even without a Kindle device—with the FREE Kindle app for smartphones, tablets and computers.

To get the free app, enter your email address or mobile phone number.

Formats

Amazon Price New from Used from
Kindle Edition $57.59  
Paperback $84.76  

Book Description

DB2 Developer's Guide is the field's #1 go-to source for on-the-job information on programming and administering DB2 on IBM z/OS mainframes. Now, three-time IBM Information Champion Craig S. Mullins has thoroughly updated this classic for DB2 v9 and v10. Mullins fully covers new DB2 innovations including temporal database support; hashing; universal tablespaces; pureXML; performance, security and governance improvements; new data types, and much more. Using current versions of DB2 for z/OS, readers will learn how to: * Build better databases and applications for CICS, IMS, batch, CAF, and RRSAF * Write proficient, code-optimized DB2 SQL * Implement efficient dynamic and static SQL applications * Use binding and rebinding to optimize applications * Efficiently create, administer, and manage DB2 databases and applications * Design, build, and populate efficient DB2 database structures for online, batch, and data warehousing * Improve the performance of DB2 subsystems, databases, utilities, programs, and SQL stat DB2 Developer's Guide, Sixth Edition builds on the unique approach that has made previous editions so valuable. It combines: * Condensed, easy-to-read coverage of all essential topics: information otherwise scattered through dozens of documents * Detailed discussions of crucial details within each topic * Expert, field-tested implementation advice * Sensible examples


Editorial Reviews

From the Back Cover

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

About the Author

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.

 


Product Details

  • File Size: 89110 KB
  • Print Length: 1656 pages
  • Simultaneous Device Usage: Up to 5 simultaneous devices, per publisher limits
  • Publisher: IBM Press; 6 edition (May 1, 2012)
  • Sold by: Amazon Digital Services, Inc.
  • Language: English
  • ISBN-10: 0132836440
  • ISBN-13: 978-0132836449
  • ASIN: B007Y6K9TK
  • Text-to-Speech: Enabled
  • X-Ray:
  • Word Wise: Not Enabled
  • Lending: Not Enabled
  • Amazon Best Sellers Rank: #129,137 Paid in Kindle Store (See Top 100 Paid in Kindle Store)
  •  Would you like to give feedback on images?


Customer Reviews

5.0 out of 5 stars
(9)
5.0 out of 5 stars
4 star
0
3 star
0
2 star
0
1 star
0
Share your thoughts with other customers
Most Helpful Customer Reviews
4 of 4 people found the following review helpful
5.0 out of 5 stars Comprehensive April 14, 2013
Format:Kindle Edition|Verified Purchase
Well organized and useful to both the novice and the experienced DB2 z/OS professional. Can be utilized as a reference for specific topics or read sequentially or randomly. Craig provides good examples and explains difficult concepts in an easily understood manner.
Comment | 
Was this review helpful to you?
3 of 3 people found the following review helpful
Format:Paperback|Verified Purchase
If Sheryl Larson recommends this book (which she does), then that is good enough for me. I learned a couple of new SQL techniques after just browsing through a few pages. Lots more to go through.
Comment | 
Was this review helpful to you?
1 of 1 people found the following review helpful
5.0 out of 5 stars It is great and comprehensive January 6, 2013
By Jim B.
Format:Paperback|Verified Purchase
I love this book it is comprehensive, suggests best practices. It is well organized so you can usually find what you are looking for. I had the previous edition for version 9 and it is wonderful too. I use it for reading assignment s when I’m doing training to backup whatever topic I’m discussing.
Comment | 
Was this review helpful to you?
1 of 1 people found the following review helpful
5.0 out of 5 stars db2 developsers guide October 15, 2012
By Hasib
Format:Paperback|Verified Purchase
This is one of the best books i have ever seen on the subject. I have reviewed craig's V4 also and i find that V6 has much more information than the earlier versions. craig has also touched on interesting topics like LObs and XML
Comment | 
Was this review helpful to you?
1 of 1 people found the following review helpful
5.0 out of 5 stars Best book on the topic January 17, 2013
Format:Paperback|Verified Purchase
This book is an excellent reference. I've bought several editions of his book ove the years. I view this as a very readable alternative to poring through IBM manuals
Comment | 
Was this review helpful to you?

What Other Items Do Customers Buy After Viewing This Item?


Forums

There are no discussions about this product yet.
Be the first to discuss this product with the community.
Start a new discussion
Topic:
First post:
Prompts for sign-in
 


Look for Similar Items by Category