Murakami Sale
 
 

Recently Viewed clear list


Q&A | August 19, 2014

Richard Kadrey: IMG Powell’s Q&A: Richard Kadrey



Describe your latest book. The Getaway God is the sixth book in the Sandman Slim series. In it, the very unholy nephilim, James Stark, aka Sandman... Continue »
  1. $17.49 Sale Hardcover add to wish list

spacer
Qualifying orders ship free.
$99.25
New Trade Paper
Ships in 1 to 3 days
Add to Wishlist
available for shipping or prepaid pickup only
Available for In-store Pickup
in 7 to 12 days
Qty Store Section
1 Remote Warehouse Database- Design

Other titles in the IBM Press series:

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

by

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

 

Synopses & Reviews

Publisher Comments:

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

Synopsis:

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

About the Author

Craig S. Mullins is president and principal consultant of Mullins Consulting, Inc., a leading data management consultancy. He is also a principal with SoftwareOnZ, a mainframe software distributor that publishes The Database Site. Mullins has been honored as an IBM Information Champion for his exceptional contributions to the IBM Data Management community. He has 30+ years of experience in all facets of database systems development in multiple industries, and has worked with DB2 since Version 1. Mullins presents at events including the International DB2 Users Group (IDUG) and IBM Information on Demand, and has authored hundreds of technical articles on DB2 and databases.

Table of Contents

Part I SQL Tools, Tips, and Tricks

Acknowledgements

1 The Magic Words

2 Data Manipulation Guidelines

3 Using DB2 Functions

4 Using UDFs and UDTs

5 Data definition Guidelines

6 Indexing Guidelines

7 Online Schema Evolution and Database Definition on Demand

8 Using DB2 Triggers

9 Large Objects and Object/Relational Databases

10 Using XML in DB2 for z/OS

11 Temporal Database Support

12 DB2 Security, Authorization, and Auditing Guidelines

Part II DB2 Application Development

13 Using DB2 in an Application Program

14 Dynamic SQL Programming

15 Program Preparation

16 Using DB2 Stored Procedures

17 DB2 and the Internet

Part III DB2 In-Depth

18 The Doors to DB2

19 Data Sharing

20 DB2 Behind the Scenes

21 The Optimizer

22 The Table-Based Infrastructure of DB2

23 Locking DB2 Data

Part IV DB2 Performance Monitoring

24 Traditional DB2 Performance Monitoring

25 Using EXPLAIN

26 The Five R's

27 DB2 Object Monitoring Using the DB2 Catalog

Part V DB2 Performance Tuning

28 Tuning DB2's Environment

29 Tuning DB2's Components

30 DB2 Resource Governing

Part VI DB2 Utilities and Commands

31 An Introduction to DB2 Utilities

32 Data Consistency Utilities

33 Backup and Recovery Utilities

34 Data Movement and Organization Utilities

35 Catalog Manipulation Utilities

36 Miscellaneous Utilities

37 DB2 Commands

38 DB2 Utility and Command Guidelines

39 Contingency Planning

Part VII The Ideal DB2 Environment

40 Components of a Total DB2 Solution

41 Organizational Issues

Part VIII Distributed DB2

42 DRDA

43 Distributed DB2

44 DB2 Connect

45 Distribution Guidelines

46 Data Warehousing With DB2

IFC - Inside Front Cover

IBC - Inside Back Cover

Index

 

Product Details

ISBN:
9780132836425
Author:
Mullins, Craig
Publisher:
IBM Press
Author:
Mullins, Craig S.
Subject:
Database design
Subject:
Database Management - General
Edition Description:
Trade paper
Series:
IBM Press
Publication Date:
20120431
Binding:
TRADE PAPER
Language:
English
Pages:
1656
Dimensions:
9.05 x 7.36 x 2.03 in 2082 gr

Other books you might like

  1. Microsoft SQL Server 2008... New Trade Paper $59.99

Related Subjects

Computers and Internet » Artificial Intelligence » General
Computers and Internet » Database » Applications
Computers and Internet » Database » Design
Computers and Internet » Software Engineering » Software Management
Transportation » Automotive » General

DB2 Developer's Guide: A Solutions-Oriented Approach to Learning the Foundation and Capabilities of DB2 for Z/OS New Trade Paper
0 stars - 0 reviews
$99.25 In Stock
Product details 1656 pages IBM Press - English 9780132836425 Reviews:
"Synopsis" by , 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
spacer
spacer
  • back to top
Follow us on...




Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.