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

4.12 avg rating
( 25 ratings by Goodreads )
 
9780132836425: DB2 Developer's Guide: A Solutions-Oriented Approach to Learning the Foundation and Capabilities of DB2 for z/OS (6th Edition) (IBM Press)

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

"synopsis" may belong to another edition of this title.

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.

 

"About this title" may belong to another edition of this title.

Top Search Results from the AbeBooks Marketplace

1.

Mullins, Craig
Published by Prentice Hall
ISBN 10: 0132836424 ISBN 13: 9780132836425
New Quantity Available: > 20
Seller
INDOO
(Avenel, NJ, U.S.A.)
Rating
[?]

Book Description Prentice Hall. Book Condition: New. Brand New. Bookseller Inventory # 0132836424

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 68.85
Convert Currency

Add to Basket

Shipping: US$ 3.50
Within U.S.A.
Destination, Rates & Speeds

2.

Craig S. Mullins
Published by Pearson Education 2012-04-27, Upper Saddle River, N.J. :|London (2012)
ISBN 10: 0132836424 ISBN 13: 9780132836425
New paperback Quantity Available: 1
Seller
Blackwell's
(Oxford, OX, United Kingdom)
Rating
[?]

Book Description Pearson Education 2012-04-27, Upper Saddle River, N.J. :|London, 2012. paperback. Book Condition: New. Bookseller Inventory # 9780132836425

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 82.55
Convert Currency

Add to Basket

Shipping: US$ 3.82
From United Kingdom to U.S.A.
Destination, Rates & Speeds

3.

Craig S. Mullins
Published by Pearson Education (US), United States (2017)
ISBN 10: 0132836424 ISBN 13: 9780132836425
New Paperback Quantity Available: 1
Seller
The Book Depository US
(London, United Kingdom)
Rating
[?]

Book Description Pearson Education (US), United States, 2017. Paperback. Book Condition: New. 6th Revised edition. 236 x 195 mm. Language: English . Brand New Book. 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. Bookseller Inventory # KNV9780132836425

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 87.67
Convert Currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, Rates & Speeds

4.

Craig S. Mullins
Published by Pearson Education (US), United States (2017)
ISBN 10: 0132836424 ISBN 13: 9780132836425
New Paperback Quantity Available: 1
Seller
The Book Depository
(London, United Kingdom)
Rating
[?]

Book Description Pearson Education (US), United States, 2017. Paperback. Book Condition: New. 6th Revised edition. 236 x 195 mm. Language: English . Brand New Book. 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. Bookseller Inventory # KNV9780132836425

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 90.73
Convert Currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, Rates & Speeds

5.

Mullins, Craig S.
ISBN 10: 0132836424 ISBN 13: 9780132836425
New Quantity Available: 1
Seller
Rating
[?]

Book Description Book Condition: New. Publisher/Verlag: IBM Press | A Solutions-Oriented Approach to Learning the Foundation and Capabilities of DB2 for z/OS | Format: Paperback | Language/Sprache: english | 2107 gr | 1560 pp. Bookseller Inventory # K9780132836425

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 95.96
Convert Currency

Add to Basket

Shipping: US$ 2.23
From Germany to U.S.A.
Destination, Rates & Speeds

6.

Craig S. Mullins
Published by Pearson Education (2012)
ISBN 10: 0132836424 ISBN 13: 9780132836425
New Quantity Available: 1
Seller
Books2Anywhere
(Fairford, GLOS, United Kingdom)
Rating
[?]

Book Description Pearson Education, 2012. PAP. Book Condition: New. New Book. Shipped from US within 10 to 14 business days. Established seller since 2000. Bookseller Inventory # IB-9780132836425

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 87.31
Convert Currency

Add to Basket

Shipping: US$ 11.45
From United Kingdom to U.S.A.
Destination, Rates & Speeds

7.

Craig S. Mullins
Published by IBM Press (2012)
ISBN 10: 0132836424 ISBN 13: 9780132836425
New Paperback Quantity Available: 1
Seller
Ergodebooks
(RICHMOND, TX, U.S.A.)
Rating
[?]

Book Description IBM Press, 2012. Paperback. Book Condition: New. 6. Bookseller Inventory # DADAX0132836424

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 98.33
Convert Currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, Rates & Speeds

8.

Craig S. Mullins
Published by Pearson Education (US), United States (2017)
ISBN 10: 0132836424 ISBN 13: 9780132836425
New Paperback Quantity Available: 10
Seller
Book Depository hard to find
(London, United Kingdom)
Rating
[?]

Book Description Pearson Education (US), United States, 2017. Paperback. Book Condition: New. 6th Revised edition. 236 x 195 mm. Language: English . This book usually ship within 10-15 business days and we will endeavor to dispatch orders quicker than this where possible. Brand New Book. 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. Bookseller Inventory # BZV9780132836425

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 106.43
Convert Currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, Rates & Speeds

9.

Mullins, Craig S.
Published by IBM Press (2012)
ISBN 10: 0132836424 ISBN 13: 9780132836425
New Paperback Quantity Available: 1
Seller
Murray Media
(North Miami Beach, FL, U.S.A.)
Rating
[?]

Book Description IBM Press, 2012. Paperback. Book Condition: New. Bookseller Inventory # 0132836424

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 105.78
Convert Currency

Add to Basket

Shipping: US$ 2.99
Within U.S.A.
Destination, Rates & Speeds

10.

Craig S. Mullins
Published by Pearson Education (US) Apr 2012 (2012)
ISBN 10: 0132836424 ISBN 13: 9780132836425
New Taschenbuch Quantity Available: 2
Rating
[?]

Book Description Pearson Education (US) Apr 2012, 2012. Taschenbuch. Book Condition: Neu. 189x230x52 mm. Neuware - Revised and updated to cover the latest release of the software, this guide covers programming and design issues, data modeling, operating system internals, on-line transaction processing systems, and more. 1656 pp. Englisch. Bookseller Inventory # 9780132836425

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 97.34
Convert Currency

Add to Basket

Shipping: US$ 13.42
From Germany to U.S.A.
Destination, Rates & Speeds

There are more copies of this book

View all search results for this book