DB2 Universal Database for OS/390 Version 7.1 Certification Guide

Multimedia Set (Print)
Used and New from Other Sellers
Used and New from Other Sellers
from $1.99
Usually ships in 1-2 business days
(Save 96%)
Other sellers (Multimedia Set)
  • All (15) from $1.99   
  • New (5) from $59.45   
  • Used (10) from $1.99   
Sort by
Page 1 of 1
Showing 1 – 4 of 5
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 Item.

Ships from: Chatham, NJ

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
Seller since 2008

Feedback rating:


Condition: New

Ships from: Chicago, IL

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
Seller since 2015

Feedback rating:


Condition: New
Brand new.

Ships from: acton, MA

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
Seller since 2015

Feedback rating:


Condition: New
Brand new.

Ships from: acton, MA

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
Page 1 of 1
Showing 1 – 4 of 5
Sort by


  • IBM's definitive, authoritative DB2 for OS/390 and z/OS reference and self-study guide!
  • The only comprehensive IBM(r) DB2 UDB V7.1 for OS/390 certification prep guide
  • Covers administration, security, SQL, application development, tuning, and much more
  • Contains dozens of expert DB2 tips, techniques and guidelines
  • CD-ROM contains complete DB2 for OS/390 sample exam

Written by IBM Gold Consultants for DB2 and S/390

  • The total resource for every professional running DB2 UDB V7.1 in OS/390 and z/OS environments
  • Database administration, security, monitoring, tuning, SQL, and application development
  • Sample test questions help you prepare for IBM's new DB2 UDB V7.1 for OS/390 exams

The CD-ROM included with this book contains a complete IBM DB2 for OS/390 certification sample exam.

IBM's DB2 Universal Database Version 7.1 for OS/390 delivers unparalleled performance, scalability, and reliability in today's enterprise e-business environments! Now, there's a complete, authoritative guide to deploying, managing, and developing applications with DB2 UDB V7.1 in both OS/390 and z/OS environments—and preparing for IBM's updated DB2 UDB V7.1 for OS/390 certification exam!

Direct from IBM, this comprehensive day-to-day reference for running DB2 UDB in OS/390 and z/OS environments is also the only book with the in-depth knowledge professionals need in order to pass IBM's latest DB2 for OS/390DBA certification exam. Full of expert tips, techniques, and guidelines, it covers virtually every aspect of working with DB2 UDB in enterprise server: administration, connectivity,development, and much more.

IBM Gold Consultants Richard Yevich and Susan Lawson present start-to-finish coverage of DB2's latest and most powerful enhancements, tools, and utilities, showing how to make the most of DB2 running on both OS/390 and next-generation z/OS platforms. Coverage includes:

  • An overview of the DB2 UDB product family
  • DB2 in OS/390 and z/OS environments: address spaces, attachments, interfaces, commands, and utilities
  • Comprehensive security coverage, including access controls and auditing techniques
  • SQL in depth: DB2 data structures, database objects, basic database design, and advanced coding
  • DB2 UDB administration: maintaining data, backup/recovery, and more
  • Performance monitoring and optimization: access paths, indexes, parallelism, buffer pool tuning, and subsystem tuning
  • Data sharing: architecture and implementation in a Parallel Sysplex environment
  • Detailed application development coverage: database extenders, cursors, stored procedures, triggers, object-relational extensions, locking, and concurrency

Whether you're deploying DB2 UDB V7.1 in an OS/390 environment, managing DB2 UDB V7.1, preparing for DB2 UDB V7.1 certification, or all three, DB2 Universal Database Version 7.1 for OS/390 Certification Guide will be your single most valuable resource.

Read More Show Less

Product Details

  • ISBN-13: 9780130650764
  • Publisher: Pearson Education
  • Publication date: 8/13/2001
  • Series: IBM DB2 Series
  • Edition description: BK&CD-ROM
  • Pages: 672
  • Product dimensions: 8.30 (w) x 7.96 (h) x 0.32 (d)

Meet the Author

Richard Yevich is an internationally recognized database consultant, and principal of YL&A, Inc., a firm specializing in consulting, performance audits, and e-commerce database development.

Susan Lawson, Principal Consultant with YL&A, has worked with DB2 for over twelve years. She has served as an IBM Data Sharing advocate, providing technical expertise for migration to DB2 Data Sharing in Parallel Sysplex environments. Lawson is Director of the Midwest DB2 Users Group and Technical Editor of the IDUG Solutions Journal.

Both authors are IBM Gold Consultants for DB2 and S/390 and co-authors of DB2 High Performance Design and Tuning (Prentice Hall PTR).

Read More Show Less

Table of Contents

Pt. 1 Introduction to DB2 UDB for OS/390 1
Ch. 1 Product Overview 3
Ch. 2 Environment 47
Ch. 3 Controlling Data Access 99
Pt. 2 Using SQL 129
Ch. 4 Database Objects 131
Ch. 5 Manipulating Database Objects 199
Ch. 6 Advanced SQL 235
Pt. 3 DB2 UDB for OS/390 and z/OS Administration 255
Ch. 7 Maintaining Data 257
Ch. 8 Database Recovery 321
Ch. 9 Data Sharing 355
Ch. 10 Performance Monitoring and Tuning 383
Pt. 4 Developing Applications 443
Ch. 11 Application Development Overview 445
Ch. 12 Development Considerations 491
Ch. 13 Advanced Functions 507
Ch. 14 Locking and Concurrency 535
App. A 557
App. B DB2 UDB for OS/390 and z/OS Certification 563
Bibliography 605
Index 619
Read More Show Less



This book is a complete guide to IBM's relational database server, known as DB2 Universal Database Version 7.1 for OS/390 and z/OS. In order to understand the DB2 family and all of the options you have for implementation, you need to be familiar with the fundamentals of all platforms. This book covers DB2 UDB for OS/390 and z/OS; for details on the other platforms, you will need to refer to the other certification guides. Perhaps you are planning to become certified, or you would simply like to understand the powerful new DB2 UDB database servers from IBM and the capabilities of DB2 for OS/390 and z/OS. Those interested in becoming an IBM Certified Professional will want to review the sample questions at the end of this book.

The book is divided into four parts:

  • Part 1—Introduction to DB2 UDB for OS/390 and z/OS (Chapters 1-3). The family of DB2 products, the DB2 environment, and access controls are covered in Chapters 1, 2, and 3.
  • Part 2—Using SQL (Chapters 4-6). The Structured Query Language (SQL) and database objects are -discussed in Chapters 4, 5, and 6.
  • Part 3—DB2 UDB Database Administration for OS/390 and z/OS (Chapters 7-10). DB2 UDB for OS/390 and z/OS common administration tasks and recovery issues are discussed in Chapters 7 and 8. Chapter 9 covers the architecture and implementation of data sharing in a parallel sysplex environment. Database monitoring and performance considerations are discussed in Chapter 10.
  • Part 4—Developing Applications with DB2 (Chapters 11-14). An introduction to application development for DBAs is given in Chapter 11. Chapter 12 deals with some of the addiconsiderations for application development. Many of the advanced functions and object relational extensions are covered in Chapter 13. Chapter 14 covers issues surrounding locking and concurrency.

This book can be used as a self-study guide to help you prepare for the DB2 Universal Database V7.1 for OS/390 and z/OS certification exam or simply as a guide to DB2 Universal Database V7.1 for OS/390 and z/OS. For information about the DB2 UDB Family, refer to the other certification books.

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
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 1 Customer Reviews
  • Anonymous

    Posted August 9, 2002


    This is a very good book that gives an overall picture of what to expect for the UDB 516 Examination. This book should be used as a guide and detailed study should be made from IBM Manuals.

    Was this review helpful? Yes  No   Report this review
Sort by: Showing 1 Customer Reviews

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