DB2 Universal Database v7.1 for UNIX, Linux, Windows and OS/2 Database Administration Certification Guide / Edition 4

Paperback (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 (Paperback)
  • All (16) from $1.99   
  • New (4) from $39.50   
  • Used (12) from $1.99   
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 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 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)
Seller since 2008

Feedback rating:


Condition: New

Ships from: Chicago, IL

Usually ships in 1-2 business days

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


  • Gain DB2 Universal Database Certification!
  • Includes demonstration program covering new product features
  • Preparation for v7.1 Fundamentals and Database Administration Certification Exams
  • Contains many useful tips, techniques and guidelines for DB2 administrators and developers
  • The only comprehensive reference guide for DB2 UDB V7.1 certification
  • CD-ROM contains trial version of DB2 UDB V7.1 for Windows NT, Windows 2000, and Windows 95/98
  • Written by DB2 experts in IBM's Toronto Lab
  • The #1 guide and reference for IBM's powerhouse DB2 UDB V7.1 database
  • New DB2 UDB V7.1 features for all platforms: UNIX, Linux Windows, and OS/2!
  • Complete coverage for database administrators and application developers!
  • Sample test questions to assist in your preparation for IBM's new DB2 UDB V7.1 exams

IBM's DB2 Universal Database Version 7.1 for UNIX, Windows, and OS/2 delivers unprecedented power, scalability, e-business support, and much more! Now, there's a complete, authoritative guide to deploying, managing, and developing applications with DB2 UDB V7.1 — and preparing for IBM's updated DB2 UDB V7.1 certification exam!

This is IBM's definitive guide and reference for the newest, most powerful version of DB2 Universal Database ever: Version 7.1. DB2 Universal Database v7.1 for UNIX, Linux, Windows, and OS/2 Database Administration Certification Guide, Fourth Edition delivers end-to-end coverage for every DB2 UDB developer and administrator, on every platform: Windows, UNIX, or OS/2 — including the most complete IBM DB2 UDB certification review you canfind.

IBM DB2 experts present a detailed overview of the DB2 UDB family of products, key DB2 concepts, and terminology, plus in-depth coverage of installation, configuration, networking, security, data integrity, optimization, and more. Coverage includes:

  • DB2 administration: populating tables with import and load utilities, monitoring, logging, maintenance, and tuning
  • Security: Controlling data access through authentication, assigned authorities, user/group privileges, and more
  • Database backup and recovery, step-by-step
  • DB2 SQL, in depth: database objects, Data Definition Language (DDL), Data Manipulation Language (DML), triggers, outer joins, OLAP SQL, table hierarchies, concurrency, and embedded SQL

Whether you're deploying DB2 UDB V7.1, managing DB2 UDB V7.1, preparing for DB2 UDB V7.1 certification, or all three, The DB2 Universal Database v7.1 for UNIX, Linux, Windows, and OS/2 Database Administration Certification Guide, Fourth Edition will be your single most valuable resource.

About the CD

The CD contains a trial version of DB2 UDB v7.1 for Windows NT, Windows 2000, and Windows 95/98. The CD also includes the demo program DB2DEMO, which enables you to demonstrate and use various SQL features of DB2.

Read More Show Less

Editorial Reviews

A guide and reference to the newest version of IBM's DB2 Universal Database. Suitable for those deploying or managing the new version, or preparing for certification, this 2.25-inch thick guide presents a detailed overview of the whole family of products, concepts, and terminology, as well as coverage of installation, configuration, networking, security, data integrity, optimization, and other topics. CD-ROM contains a trial version of DB2 UDB v7.1for Windows versions NT, 2000, 98, and 95, as well as a demo program DB2DEMO. Annotation c. Book News, Inc., Portland, OR (booknews.com)
Read More Show Less

Product Details

  • ISBN-13: 9780130913661
  • Publisher: Pearson Education
  • Publication date: 10/30/2000
  • Series: IBM DB2 Series
  • Edition description: Older Edition
  • Edition number: 4
  • Pages: 822
  • Product dimensions: 6.99 (w) x 9.20 (h) x 2.12 (d)

Meet the Author

George Baklarz, IBM's Senior Program Manager for DB2 Technical Sales Support, works closely with customers to help them understand new DB2 technology, and to gain their feedback for improving DB2 products. He has spent 18 years at IBM working on various aspects of database technology.

Bill Wong is IBM's worldwide manager of DB2 UDB Technical Sales Support. He is responsible for assisting customers assessing the latest DB2 technology and understanding future directions of IBM's data management portfolio. He has spent more than 16 years in a variety of database roles including DB2 systems administrator, DBA, technical sales support, vendor enablement, and product planning.

Read More Show Less

Read an Excerpt

Chapter 1: Product Overview

In this chapter, you will be introduced to the DB2 Universal Database (DB2 UDB) family of products for UNIX and Intel platforms. DB2 has the ability to store all kinds of electronic information. This includes traditional relational data as well as struc-tured and unstructured binary information, documents and text in many languages, graphics, images, multimedia (audio and video), information specific to operations like engineering drawings, maps, insurance claims forms, numerical control streams, or any type of electronic information. This chapter will illustrate some of the ways to access data in a DB2 database using some of the interfaces provided with the products. A description of each of the DB2 products will be provided to illustrate some of the features and functions.

The DB2 database is an important part of IBM's e-business software portfolio. The e-business Application Framework provides an open blueprint on how to build e-business applications. Popular IBM e-business tools include Visual Age for Java for developing Java programs or components and Tivioli software for distributed systems management. As for application server software, IBM offers several types of servers depending on the business requirement, from Message Queuing (MQ) software to Java-based transaction processing with Websphere Application Server.

The DB2 Family executes on pervasive devices, Intel, UNIX, AS/400, and main-frame platforms. Supported operating environments include: OS/2, Windows 95/ 98/2000/NT, Linux, AIX, HP-UX, Sun Solaris, NUMA-Q, OS/400, VSE/VM, and OS/390. The DB2 code base is optimized for each platform to ensure maximum performance. The SQL API is common to all platforms, which allows applications written on one platform to access data on any platform. Internally, the OS/400, VM/VSE, and OS/390 differ from DB2 on the UNIX and Intel platforms, but it is the common SQL API that enables applications to work together. The DB2 code base on Intel and UNIX platforms are identical.

DB2 V7.1 for UNIX, Linux, Windows, and OS/2, provides seamless database con-nectivity using the most popular network communications protocols, including NetBIOS, TCP/IP, IPX/SPX, Named Pipes, and APPC.

DB2 and e-business

As a core component of IBM's e-business cycle, DB2 is a catalyst for deliving applications that transform a company's operations. Transform is the process that takes a business to an e-business, common applications in this area include: electronic commerce, Enterprise Resource Planning (ERP), Customer Relationship Management (CRM), and Supply Chain Management (SCM). Build is the process of exploiting the integrated Java and multimedia features of DB2. Run is the part of the e-business cycle that ensures performance and scalability; this is especially important with the new Internet-based companies. Finally, with respect to leveraging the data assests, DB2 offers a variety of business intelligence tools to enable end-users makers to make more effective business decisions.

In leveraging information in an e-business environment, IBM's Enterprise Information Portal (EIP) provides a secure foundation for a single pont of access to diverse information, business processes, and expertise. Today's high demand for complete and correlated information requires portal access not only to structured transactional and warehouse data, but also to a broader range of content, including XML, HTML, host computer-generated output, images, and audio/video. The IBM Enterprise Information Portal offers access to business data from sources such as spreadsheets, document libraries, company literature, databases, data warehouses, and unstructured information fromWeb pages. The information can also be searched using parametric or contextual search technologies, with results aggregated across multiple sources and relevant information presented in a context tailored to the user's needs.

DB2 Universal Database

In the distributed environment, DB2 offers several packaging options:
  • Enterprise Edition - This offering is often used to build e-business applications and to support large departmental applications. It offers the most connectivity options and can share data with third-party databases and DB2 on heterogeneous platforms.
  • Workgroup Edition - This offering is often used smaller departmental applica-tions or for applications that do not need access to remote databases on the OS/ 400, VM/VSE, or OS/390 platform.
  • Enterprise Extended Edition - This offering is used most often to support very large databases. Popular applications include supporting large data warehouses. By providing intra- and interquery parallelism, databases can scale to multiple terabytes. DB2 UDB EEE can exploit clusters or massively parallel hardware architectures.
  • Personal Edition - This full-function database offering is for single-users and will not accept remote database requests. This offering is available on Windows, OS/2, and Linux.
  • Satellite Edition - This offering is for single-users and has a smaller footprint than Personal Edition. It will not accept remote database requests. This offering is available on the Windows platform.
  • Everyplace - This is a mobile computing offering that gives mobile workers access to DB2 data sources in the enterprise through handheld devices such as personal digital assistants (PDAs) and handheld personal computers (HPCs).

The new DB2 Everyplace executes on a number of pervasive operating environments, including: Palm OS, Windows CE, and EPOC.

DB2 Enterprise Edition

DB2 Enterprise Edition is a relational database management system that is the foundation of many mission-critical systems and the primary focus of this certification guide. It is fully Web enabled, scalable from single processors to symmetric multiprocessors and to massively parallel clusters; and supports unstructured data such as image, audio, video, text, spatial, and XML with its object capabilities.

Applications for DB2 Enterprise Edition can scale upward and execute on massively parallel clusters or can scale downward with applications executing on single-user database systems.

DB2 Enterprise Edition is available on the Windows, OS/2, Linux, and UNIX platforms....

Read More Show Less

Table of Contents

I: Introduction to DB2 UDB
1: Product Overview
DB2 and e-business
DB2 Universal Database
DB2 Enterprise Edition
DB2 Workgroup Edition
DB2 Enterprise - Extended Edition
DB2 Personal Edition
DB2 Satellite Edition
DB2 Everyplace
DB2 Connectivity
DB2 Universal Database Clients
DB2 Connect
DB2 Replication
DB2 Net.Data
DB2 Relational Connect
DB2 DataJoiner
IBM WebSphere Application Server
DB2 Application Development
DB2 Universal Developer's Edition
DB2 Stored Procedure Builder
DB2 Relational Extenders
DB2 OLAP Server Starter Kit
DB2 Data Warehouse Center
DB2 Warehouse Manager
DB2 Data Links Manager
DB2 Administration
Control Center
Other Tools Available from the Control Center
The Command Line Processor (CLP)
Visual Explain
2: Getting Started
Product Installation
Windows and OS/2 Installation
UNIX and Linux Installation
DB2 Client Installation
Distributed Installation
The DB2 Environment
DB2 Profile Registry
Environment Variables
Using the Command Line Processor
DAS and DB2 Instances
DB2 Administration Server (DAS) Instance
DB2 Instances
Using First Steps
3: Getting Connected
Roadmap to Distributed Communications
DB2 Discovery
Automated Configuration Using Discovery
Automated Configuration Using Access Profiles
Manual Configuration
DB2 Directories
Examining DB2 Directories
Configuring DB2 Clients
Automated Configuration Using Discovery
Using Access Profiles
Manual Configuration
Summary of Configuring Connections
Configuring Communications
Configuring the DB2 Instance for Communications
Configuring the DAS Instance
Configuring DB2 Discovery
Binding Utilities
Binding Utilities Using the CCA
Instance Administration
Local Instance Administration
Attaching to an Instance Using the Control Center
4: Controlling Data Access
Overview of Security
Authorities and Privileges
Windows NT/2000 Considerations
II: Using SQL
5: Database Objects
Understanding Database Objects
Data Types
Table Spaces
Buffer Pools
Log Files
Creating a DB2 Database
Managing Database Objects
Using SQL Data Definition Language (DDL)
Data Types
Database Design and Implementation
DB2CERT Database Table Descriptions
Define User-Defined Data Types
Defining Columns
Defining Primary Keys
Defining Unique Keys
Defining Foreign Keys
6: Manipulating Database Objects
Data Retrieval
Retrieving the Entire Table
Projecting Columns from a Table
Changing the Order of the Columns
Restricting Rows from a Table
Predicate Evaluation for UDTs
Restricting Rows Using Multiple Conditions
Selecting Columns from Multiple Tables
Using Correlation Names
Sorting Your Output
Derived Columns
DB2 Functions
Grouping Values
Eliminating Duplicates
Searching for String Patterns
Searching for Data in Ranges
Searching for Null Values
Searching for Negative Conditions
Searching for a Set of Values
Quantified Predicates
Case Expressions
Nested Table Expressions
Scalar Fullselect
Common Table Expressions
Set Operators
Data Modification
Inserting Data Records
Updating Data Records
Removing Data
View Classification
Deletable Views
Updatable Views
Insertable Views
Read-Only Views
Inoperative Views
7: Advanced SQL
Trigger Usage
Trigger Activation
Trigger Example (After Trigger)
Trigger Example (Before Trigger)
Recursive SQL
Outer Join
Left Outer Join
Right Outer Join
Full Outer Join
Combining Outer Joins
OLAP Features
STAR Schemas
OLAP Indexes
STAR Joins
Super Grouping
Moving Functions
Advanced CASE Expressions
Using CASE Expressions to Group Values
Using CASE Expressions in Functions
Structured Types and Typed Tables
Creating Structured Types
Altering Structured Types
Creating Typed Tables
Dropping Typed Tables
Inserting Rows into a Typed Table
Selecting a Row from a Typed Table
Updating and Deleting Rows from Typed Tables
Physical Implementation of Typed Tables
Reference Columns
View Hierarchies
SQL Functions for Typed Tables and Typed Views
TYPE Predicate
Considerations When Using Typed Tables and Views
Examples of a Typed Table Hierarchy
Summary Tables
Creating a Summary Table
Considerations of Using Summary Tables
System Catalog Information for Summary Tables
8: Concurrency
Concurrency Considerations
Isolation Levels
Uncommitted Read
Cursor Stability
Read Stability
Repeatable Read
Choosing an Isolation Level
Lock Attributes
Lock Conversion
Lock Escalation
Lock Wait Behavior
Lock Table Statement
LOCKSIZE parameter of ALTER TABLE statement
III: DB2 UDB Administration
9: Data Storage Management
Processor, Memory, and Disk Resources
DB2 Storage Model
Buffer Pool
Table Spaces
Table Space Design
Regular Table Space
Long Table Space
System Temporary Table Space
Performance Considerations
Long Field Data
Large Object Data
Implementation Examples
Creating a Database
Creating Buffer Pools
Creating Table Spaces
Creating Tables
Dropping Table Spaces
Dropping Buffer Pools
Dropping a Database
Creating Table Spaces Using the Control Center
Table Space Maintenance
Database Files
Listing Table Spaces
Listing Table Space Containers
Table Space States
System Catalog Information About Table Spaces
Adding Containers to DMS Table Spaces
10: Maintaining Data
Moving Data
Delimited ASCII Files
Non-Delimited ASCII Files
PC/IXF Files
Worksheet Format Files
Data Movement Utilities
The Export Utility
The IMPORT Utility
The Load Utility
The LOAD QUERY Command
The DB2MOVE Utility
The DB2LOOK Utility
Data Maintenance
Analyzing Data's Physical Organization
Table Reorganization
Generating Statistics
The Rebind Utility
Data Maintenance Process
Modeling a Production Environment
11: Database Recovery
Database Recovery Concepts
Unit of Work
Types of Recovery
Crash Recovery
Version Recovery
Roll-Forward Recovery
Recovery Strategies
Recoverable and Nonrecoverable Databases
Online and Offline Access
Use of Log Files
Log Buffers
Primary and Secondary Log Files
Types of Logging
Log File Usage
Version Recovery Using Backup and Restore
Roll-Forward Recovery
Managing Log Files
Other Recovery Considerations
12: Monitoring and Tuning
Elements of Performance
Tuning Guidelines
Performance Improvement Process
How Much Can a System Be Tuned? A Less-Formal Approach
DB2 Architecture Overview
Process Model
Query Parallelism
DB2 Memory Usage
SQL Compiler Overview
DB2 Sorting Methods
Database Monitoring
Obtaining Database Access Information
Database Monitors
Snapshot Monitoring
Event Monitoring
Visual Performance Monitors
DB2 Governor
SQL Monitoring
Explain Tables
Gathering Explain Data
Examining Explain Data
Guidelines on Using Explain Output
Index Advisor Facility
Configuring Database Resources
Configuring Intra-Partition Parallelism
Performance Tuning Scenario
Diagnostics and Problem Determination
Error Messages and SQL Codes
Tracing Problems in DB2 Universal Database
IV: Developing Applications
13: Application Development Overview
DB2 Application Development Environment
Software Requirements
DB2 Programming Interfaces
Embedded SQL
Call Level Interface and ODBC
Java Interfaces (JDBC and SQLJ)
Native DB2 APIs
Microsoft Data Objects (DAO, RDO, ADO, OLE-DB)
Other Interfaces and Tools
14: Development Considerations
Embedded SQL Overview
Creating Packages
Binding Applications
Support for CLI and ODBC Programming
Embedded Dynamic Versus Call Level Interface
Setting Up the CLI Environment
Support For Java Programming
JDBC Programming
SQLJ Programming
Stored Procedure Builder
15: Development SQL
User-Defined Functions
SQL-Bodied Scalar Functions
SQL-Bodied Table Functions
Structured Datatypes
Schemas and Aliases
V: Appendices
DB2 UDB V. Certification Test Objectives
DB2 Family Fundamentals (512)
DB2 for OS/2, Windows, and UNIX Database Administration (513)
Sample Questions (Fundamentals - Exam 512)
Sample Questions (Administration - Exam 513)
CD-ROM Installation
Read More Show Less


This book is a complete guide to the IBM's relational database servers, known as DB2 Universal Database Version 7.1. DB2 Universal Database (DB2 UDB) Version 7.1 is available on many operating systems, and the book has been written with this in mind. Any significant differences in the implementation of DB2 UDB on various operating systems are highlighted. If you are planning to become certified, or you would simply like to understand the powerful new DB2 UDB database servers from IBM, then read on. 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 (Chapters 1-4).
Installing and configuring DB2 UDB servers and clients are covered in Chapters 1, 2, 3, and 4.
Part 2—Using SQL (Chapters 5-8).
The Structured Query Language (SQL) is discussed in Chapter 5, 6 and 7. Database concurrency is discussed in Chapter 8.
Part 3—DB2 UDB Database Administration (Chapters 9-12).
Creating a DB2 UDB database and its related table spaces is covered in Chapter 9. The common administration tasks are discussed in Chapters 10 and 11. Database monitoring and performance considerations are discussed in Chapter 12.
Part 4—Developing Applications with DB2 UDB (Chapters 13-14).
An introduction to application development for DBAs is given in Chapter 13. Chapter 14 deals with some of the DBA activities that are related to application development. SQL used in a programming environment is discussed in chapter15.

This book can be used as a self-study guide to help you prepare for the DB2 Universal Database V7.1 certification exams or as a guide to DB2 Universal Database V7.1.

The test objectives are provided in Appendix A. These should be used as a guide to ensure that you are fully prepared to take the DB2 UDB V7.1 exams.

Experience with DB2 Universal Database Version 7.1 is the best way to prepare for any of these DB2 UDB V7.1 certification exams. Use this Certification Guide in conjunction with your day-to-day use of DB2 UDB V7.1 to assist you in preparing for exams 512 and 513. A companion book, DB2 Universal Database Version 7.1 Application Development Certification Guide, will help you prepare for exam 514.

The DB2 Family Fundamentals (512) exam covers these skills:
  • Understanding DB2 products and components
  • Creating database objects
  • Understanding various DB2 data types
  • Using SQL to manipulate database objects
  • Describing DB2 concurrency
For more details on the test objectives of this exam, see "DB2 Family Fundamentals (512)" on page 744.The DB2 for OS/2, Windows, UNIX, and Linux Database Adminstration (513) exam covers these skills:
  • Managing DB2 instances
  • Creating and maintaining database objects
  • Managing table spaces
  • Using utilities: IMPORT, LOAD, REORG, RUNSTATS
  • Managing recovery procedures (BACKUP/RESTORE)
  • Analyzing resource problems

For more details on the test objectives of this exam, see "DB2 for OS/2, Windows, and UNIX Database Administration (513)" on page 746.

Note: More information about DB2 UDB certification can be found at http://www.ibm.com/certify.

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

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