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

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

by George Baklarz, Bill Wong

ISBN-10: 0130913669

ISBN-13: 9780130913661

Pub. Date: 10/30/2000

Publisher: Pearson Education

  • 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


  • 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.

Product Details

Pearson Education
Publication date:
IBM DB2 Series
Edition description:
Older Edition
Product dimensions:
6.99(w) x 9.20(h) x 2.12(d)

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


Customer Reviews

Average Review:

Write a Review

and post it to your social network


Most Helpful Customer Reviews

See all customer reviews >