DB2 Developer's Guide

( 3 )


DB2 Developer's Guide, Fourth Edition is completely revised and updated, covering all the new features for Version 6 for OS/390. It includes a special chapter on how changes to the product impact its use. This book clarifies complex DB2 topics, provides performance and procedural advice for implementing well-designed DB2 applications, and describes what DB2 does behind the scenes. An entire chapter on Internet-related features is included.

Written for technical users...

See more details below
Available through our Marketplace sellers.
Other sellers (Hardcover)
  • All (7) from $2.21   
  • New (1) from $105.00   
  • Used (6) from $2.21   
Sort by
Page 1 of 1
Showing All
Note: Marketplace items are not eligible for any BN.com coupons and promotions
Seller since 2015

Feedback rating:



New — never opened or used in original packaging.

Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.

Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.

Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.

Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.

Brand new.

Ships from: acton, MA

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
Page 1 of 1
Showing All
Sort by
Sending request ...


DB2 Developer's Guide, Fourth Edition is completely revised and updated, covering all the new features for Version 6 for OS/390. It includes a special chapter on how changes to the product impact its use. This book clarifies complex DB2 topics, provides performance and procedural advice for implementing well-designed DB2 applications, and describes what DB2 does behind the scenes. An entire chapter on Internet-related features is included.

Written for technical users of DB2, this reference book provides hard-to-find information about this database. Packed with tips and experience-based techniques, this book also delivers information on coding efficient SQL, monitoring, and tuning DB2 performance.

Read More Show Less

Editorial Reviews

New edition of a text that provides a solutions-oriented approach to learning the foundation and capabilities of the latest version of the DB2 database system. The 42 chapters describe how to master the details of DB2 for OS/390; create, administer, and manage efficient DB2 databases and applications; handle new database features of DB2 V6, including large objects, DDL and utility changes, Java, triggers, UDFs, and more; understand the fundamentals of DB2 data sharing; save time and improve performance using DB2 utilities; implement efficient dynamic and static SQL applications for DB2; build effective DB2 stored procedures and utilize them appropriately; and access DB2 data using Java. Annotation c. Book News, Inc., Portland, OR (booknews.com)
Read More Show Less

Product Details

  • ISBN-13: 9780672301919
  • Publisher: Sams
  • Publication date: 4/10/1992
  • Series: Professional Reference Series
  • Pages: 400
  • Product dimensions: 7.80 (w) x 9.46 (h) x 1.91 (d)

Meet the Author

Craig S. Mullins is Director of DB2 Technology Planning for BMC Software, Inc. He 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 Sybase classes. Craig 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, PLATINUM Technology, Inc.), consulting (ASSET, Inc.), and computer industry analysis (Gartner Group). Additionally, Craig authored many of the popular "Platinum Monthly DB2 Tips" and worked on Platinum's DB2 system catalog and access path posters.
Read More Show Less

Read an Excerpt

Chapter 1: The Magic Words

Once upon a time there was a kingdom called Userville. The people in the kingdom were impatient and wanted to know everything about everything-they could never get enough information. Life was difficult and the people were unhappy because data was often lost, and even when it was available, it was often inaccurate and not easy to access.

The King decided to purchase DB2, an advanced tool for storing and retrieving data that could be processed by the Users and turned into information. "This," he thought, "should keep the people happy. DB2 will solve all my problems." But he soon found out that special knowledge was necessary to make DB2 work its wonders. Nobody in Userville knew how to use it.

Luckily, a grand Wizard living in a nearby kingdom knew many mystical secrets for retrieving data. These secrets were a form of magic called SQL. The King of Userville summoned the Wizard, offering him many great treasures if only he would help the poor Users in Userville.

The Wizard soon arrived, determined to please. Armed with nothing more than SQL and a smile, the Wizard strode to the terminal and uttered the magic words.

A crowd gathered and applauded as the desired information began pumping out of the terminal. "More, more," shouted the data-starved masses. The Wizard gazed into the screen, and with amazing speed effortlessly produced report after report. The King was overheard to say, "You know, this is just too good to be true!" Everybody was happy. The Users had their share of information, the King had a peaceful kingdom, and the Wizard had his treasures and the respect of the Users.

For many months, the Users were satisfied with the magic of the great Wizard. Then, one day, the Wizard disappeared ...in a jet to the West Coast for 130 grand a year. The people of the kingdom began to worry. "How will we survive without the magic of the Wizard? Will we have to live, once again, without our precious information?" The Wizard's apprentice tried to silence the crowd by using his magic, but it wasn't the same. The information was still there, but it wasn't coming fast enough or as effortlessly. The apprentice was not yet as skilled as the great Wizard who had abandoned the kingdom. But, as luck would have it, one day he stumbled upon the great Wizard's diary. He quickly absorbed every page and soon was invoking the Wizard's magic words. And all was well again.

Well, life is not always that simple. Departing Wizards do not often leave behind documentation of their secrets. The first part of this book can be used as a "Wizard's diary" for efficient SQL. This chapter is an overview of SQL, not from a syntactic viewpoint, but from a functional viewpoint. This chapter is not intended to teach SQL, but to provide a framework for the advanced issues discussed in the remainder of this text. This framework delineates the differences between SQL and procedural languages and outlines the components and types of SQL. Chapters 2 through 4 delve into the performance and administrative issues surrounding - the effective implementation of SQL for DB2.

So continue and take the next step toward becoming a DB2 Wizard...

An Overview of SQL

Structured Query Language, better known as SQL (and pronounced "sequel" or "ess-cue-el"), is a powerful tool for manipulating data. It is the de facto standard query language for relational database management systems (RDBMSs) and is used not just by DB2, but also by the other leading RDBMS products such as Oracle, Sybase, Informix, and Microsoft SQL Server. Indeed, every relational database management system-and many nonrelational DBMS products-provide support for SQL. Why is this so? What benefits are accrued by using SQL rather than some other language? There are many reasons. Foremost is that SQL is a high-level language that provides a greater degree of abstraction than do procedural languages. Third-generation languages (3GLs), such as COBOL, and older fourth-generation languages (4GLs), such as FOCUS, require that the programmer navigate data structures. Program logic must be coded to proceed record-byrecord through the data stores in an order determined by the application programmer or systems analyst. This information is encoded in the high-level language and is difficult to change after it has been programmed. SQL, on the other hand, is fashioned so that the programmer can specify what data is needed but cannot specify how to retrieve it. SQL is coded without embedded data-navigational instructions. The DBMS analyzes SQL and formulates data-navigational instructions "behind the scenes." These data-navigational instructions are called access paths. By forcing the DBMS to determine the optimal access path to the data, a heavy burden is removed from the programmer. In addition, the database can have a better understanding of the state of the data it stores, and thereby can produce a more efficient and dynamic access path to the data. The result is that SQL, used properly, provides a quicker application development and prototyping environment than is available with corresponding high-level languages.

Another feature of SQL is that it is not merely a query language. The same language used to query data is used also to define data structures, control access to the data, and insert, modify, and delete occurrences of the data. This consolidation of functions into a single language eases communication between different types of users. DBAs, systems programmers, application programmers, systems analysts, systems designers, and end users all speak a common language: SQL. When all the participants in a project are speaking the same language, a synergy is created that can reduce overall system-development time...

Read More Show Less

Table of Contents

1 The Magic Words 3
2 Data Manipulation Guidelines 47
3 Data Definition Guidelines 81
4 Miscellaneous Guidelines 157
5 Using DB2 in an Application Program 183
6 Dynamic SQL Programming 235
7 Program Preparation 257
8 Alternative DB2 Application Development Methods 307
9 Using DB2 Stored Procedures 327
10 DB2 and the Internet 349
11 The Doors to DB2 373
12 Data Sharing 453
13 DB2 Behind the Scenes 467
14 The Optimizer 485
15 The Table-Based Infrastructure of DB2 529
16 Locking DB2 Data 543
17 Traditional DB2 Performance Monitoring 577
18 Using Explain 623
19 DB2 Object Monitoring Using the DB2 Catalog 645
20 Tuning DB2's Environment 673
21 Tuning DB2's Components 697
22 DB2 Resource Governing 747
23 An Introduction to DB2 Utilities 757
24 Data Consistency Utilities 765
25 Backup and Recovery Utilities 787
26 Data Organization Utilities 815
27 Catalog Manipulation Utilities 861
28 Miscellaneous Utilities 881
29 DB2 Commands 903
30 DB2 Utility and Command Guidelines 929
31 DB2 Contingency Planning 939
32 Components of a Total DB2 Solution 955
33 Organizational Issues 1017
34 DRDA 1043
35 Distributed DB2 1055
36 Distribution Guidelines 1071
37 Data Warehousing with DB2 1095
A DB2 SQLCODE and SQLSTATE Values 1119
B The DB2 Catalog Tables 1167
C The QMF Administrative Tables 1237
D DB2 Sample Tables 1243
E DB2 Manuals 1249
F Valid DB2 Data Types 1271
G DB2 Limits 1273
H Regional DB2 User Groups 1279
I DB2 on Other Platforms 1299
J Summary of Version 4 and Version 5 Changes 1305
Index 1309
Read More Show Less

Customer Reviews

Average Rating 4.5
( 3 )
Rating Distribution

5 Star


4 Star


3 Star


2 Star


1 Star


Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation


  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing all of 4 Customer Reviews
  • Anonymous

    Posted November 2, 2004

    very extensive

    [A review of the 5th EDITION 2004.] IBM invented relational databases and its DB2 is one of the company's core technologies. While it trails Oracle in market share, the capabilities as shown here by Mullins are probably at least the equal of Oracle's 10g. This book is designed for a full time DB2 administrator or developer, who needs an extensive reference on it. It's fair to say that you would not want to learn the theory of relational databases from this book. Sadly, there is only one, passing reference to E F Codd, in the context of normalisation of data. Minimal acknowledgment of the founder of relational modelling. Seek a learning of theory elsewhere. Instead, the book focuses on all the options built into DB2. By now, possibly person-centuries of IBM's programmer sweat have gone int this latest version 8. You can take advantage of this accrued expertise. Though the time needed to absorb a chapter may be nontrivial.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted April 15, 2002

    A very Good reference

    This is an excellent reference. If you truly want to understand the workings of DB2 you need this book in your library. It will give you the indepth details. However,it is not a book for showing you how to do something. There are other books more suitable for that.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted May 11, 2001

    Great Book & Reference

    This is a great book packed with lots of information on DB2 and also SQL. Although its not a SQL book it has some good examples of real world scripts. Good reference for any programmer who uses DB2, beginner or experienced.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted May 31, 2000

    The definitive guide to DB2

    The latest edition of Craig Mullins DB2 Developers Guide updated to include V6. This is an excellent reference book covering all aspects of DB2. A must for anyone working with DB2. Highly recommended.

    Was this review helpful? Yes  No   Report this review
Sort by: Showing all of 4 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)