DB2: Universal Database Certification Guide / Edition 2

DB2: Universal Database Certification Guide / Edition 2

by Calene Janacek, Dwayne Snow
     
 

ISBN-10: 0130796611

ISBN-13: 9780130796615

Pub. Date: 12/09/1997

Publisher: Prentice Hall Professional Technical Reference

The only official handbook for IBM's DB2 Certification program

Completely updated for DB2 Universal Database

Covers both database administration and application development

IBM's Professional Certification program provides a mark of excellence recognized around the world. Prepare for DB2 Certification with the manual created by IBM's own team of

Overview

The only official handbook for IBM's DB2 Certification program

Completely updated for DB2 Universal Database

Covers both database administration and application development

IBM's Professional Certification program provides a mark of excellence recognized around the world. Prepare for DB2 Certification with the manual created by IBM's own team of experts.

This self-paced guide familiarizes you in-depth with administering databases and developing applications for DB2 Universal Database. Incorporating all the latest enhancements present in Version 5, this handbook shows you how to use all of DB2's powerful tools, including the new Control Center.

  • Learn from IBM's own team of expert trainers
  • Master all aspects of DB2, from the basic architecture to application programming
  • Discover how DB2 performs in a variety of environments, from small LANs to the entire Internet
  • Fine-tune your SQL programming skills
  • Get real hands-on experience with the interactive exercises included on the CD-ROM

While this second edition of DB2 Universal Database Certification Guide is intended primarily for users who are preparing for certification, it is also an invaluable resource for anyone who wants to gain a deeper understanding of DB2's wide-ranging capabilities.

The accompanying CD-ROM offers hands-on exercises for every chapter in the book. A trial copy of DB2 is included, along with product README files and libraries. The software runs under Windows™ 95, Windows NT® and OS/2®.

Product Details

ISBN-13:
9780130796615
Publisher:
Prentice Hall Professional Technical Reference
Publication date:
12/09/1997
Series:
IBM DB2 Series
Pages:
770
Product dimensions:
7.03(w) x 9.24(h) x 1.20(d)

Table of Contents

Foreword xi(2)
Preface xiii
Conventions xv(2)
How this Book was Created xvii(2)
Acknowledgments xix
Chapter 1 -- Product Overview
1(36)
DB2 Universal Database -- The Scalable Database
2(2)
DB2 Products
2(2)
DB2 Universal Database (UDB)
4(5)
DB2 UDB Personal Edition
4(1)
DB2 Workgroup Edition
5(2)
DB2 Enterprise Edition
7(1)
DB2 Universal Database Enterprise-Extended Edition
8(1)
DB2 Connect
9(3)
DB2 Connect Personal Edition
10(1)
DB2 Connect Enterprise Edition
11(1)
DB2 Developer's Edition
12(3)
Licensing Scenarios
15(5)
DB2 Client/Server Environment
20(1)
Supported Communication Protocols
20(1)
DB2 Resource Usage
21(1)
Features and Functions
21(12)
DB2 Universal Database Administrator's Tools
24(1)
The Control Center
25(2)
The SmartGuides
27(4)
The Command Line Processor (CLP)
31(2)
Summary
33(1)
Questions
34(2)
Answers
36(1)
Chapter 2 -- Getting Started and Connected
37(48)
Product Installation
38(23)
Intel Installation
38(9)
UNIX Installation
47(9)
DB2 Client Installation
56(5)
The DB2 Environment
61(5)
DB2 Profile Registry
61(2)
Environment Variables
63(1)
Using the Command Line Processor
64(2)
DAS and DB2 Instances
66(11)
DB2 Administration Server (DAS) Instance
66(2)
DB2 Instances
68(4)
Creating the Sample Database
72(5)
Summary
77(1)
Questions
78(1)
Answers
79(1)
Exercises
80(5)
Chapter 3 -- Controlling Data Access
85(80)
Security
86(21)
Overview of Security
86(1)
Authentication
87(4)
Authorization Levels
91(4)
Security Considerations
95(2)
DB2 Privileges (Data Control Language)
97(1)
Database Object Privileges
97(10)
Establishing a DB2 Client/Server Connection
107(17)
Configuring a DB2 UDB Server
108(8)
DB2 Directories
116(4)
DB2 Discovery
120(4)
Generating a Server Access Profile
124(1)
Configuring DB2 Clients
124(29)
Using the Client Configuration Assistant
126(7)
Configuring a Connection to a DB2 Database
133(15)
Instance Administration
148(5)
Summary
153(1)
Questions
154(3)
Answers
157(1)
Exercises
158(7)
Chapter 4 -- Using SQL
165(130)
Understanding Database Objects
166(34)
Data Types
166(1)
DB2-Supplied Data Types
167(1)
Large Objects (LOBs)
167(3)
String Data Types
170(1)
Numeric Data Types
171(2)
Datetime Data Types
173(2)
User-Defined Data Types
175(4)
Code Page Considerations
179(2)
Selecting the Correct Data Type
181(1)
DB2 Certification Database Design and Implementation
182(9)
Tables
191(9)
Using SQL Data Definition Language (DDL)
200(12)
Creating a DB2 Database
202(1)
Views
203(5)
Indexes
208(4)
Data Manipulation Language (DML)
212(38)
Data Retrieval (SELECT)
212(6)
Selecting Columns from Multiple Tables
218(8)
DB2 Functions
226(20)
Data Modification (INSERT/UPDATE/DELETE)
246(4)
Removing Data
250(8)
View Classification
254(4)
Business Rules
258(7)
User-Defined Defaults
258(1)
Check Constraints
259(2)
Triggers
261(4)
Advanced SQL
265(15)
Recursive SQL
265(3)
Outer Join
268(4)
OLAP Features
272(5)
Advanced Case Expressions
277(3)
Summary
280(1)
Questions
281(2)
Answers
283(1)
Exercises
284(11)
Chapter 5 -- Database Concurrency
295(26)
Concurrency
296(8)
Concurrency Considerations
296(1)
Lost Update Problem
297(4)
Uncommitted Read
301(1)
Non-Repeatable Read
301(2)
Phantom Read Problem
303(1)
Isolation Level
304(2)
Uncommitted Read
305(1)
Cursor Stability
305(1)
Read Stability
305(1)
Repeatable Read
306(1)
Choosing an Isolation Level
306(1)
Locking
306(7)
Lock Attributes
307(2)
Lock Conversion
309(1)
Lock Escalation
310(1)
Lock Wait Behavior
311(2)
Summary
313(1)
Questions
314(1)
Answers
314(1)
Exercises
315(6)
Chapter 6 -- Data Placement
321(58)
Containers
322(1)
Table Spaces
322(23)
Extents
324(1)
System Managed Storage (SMS) Table Spaces
325(2)
Database Managed Storage (DMS) Table Spaces
327(3)
Planning a Table Space Environment
330(6)
Creating Table Spaces
336(9)
Performance Considerations
345(18)
Buffer Pool
345(1)
Extent Size
346(1)
NUM_IOSERVERS
347(1)
I/O Prefetch
347(1)
Page Cleaners
348(1)
System Catalogs in DB2
349(4)
Managing Table Spaces
353(8)
States of Table Spaces
361(2)
Summary
363(1)
Questions
364(2)
Answers
366(1)
Exercises
367(12)
Chapter 7 -- Data Management
379(124)
Populating Tables
380(22)
The LOAD Utility
380(3)
Using The LOAD Utility
383(3)
Syntax of the LOAD Command
386(16)
The IMPORT/EXPORT Utility
402(12)
The EXPORT Utility
403(7)
The IMPORT Utility
410(4)
Data Maintenance
414(16)
Analyzing Data's Physical Organization: REORGCHK
415(5)
Table Reorganization: REORG
420(5)
RUNSTATS
425(5)
The REBIND Utility
430(1)
Data Maintenance Process
431(3)
Modelling a Production Environment
432(2)
User Maintenance
434(4)
Fenced and Not Fenced Procedures and Functions
434(4)
Database Recovery
438(41)
Use of Log Files
439(4)
Types of Logging
443(4)
Backup and Restore
447(15)
Restore Database SmartGuide
462(11)
Summary of Backup/Restore Consideration
473(2)
The QUIESCE Command
475(1)
The Recovery History File
476(3)
Administration Tools for Data Maintenance
479(8)
The Script Center
480(3)
The Journal
483(4)
Data Replication
487(3)
Summary
490(5)
Answers
495(1)
Exercises
496(7)
Chapter 8 -- Database Monitoring and Tuning
503(94)
Monitoring Methods
504(1)
Obtaining Database Access Information
504(1)
Explain Facilities
504(17)
Query Compilation
505(3)
Gathering Explain Data
508(5)
Examining EXPLAIN Data
513(8)
Database Monitoring
521(30)
Event Monitoring
531(7)
Visual Performance Monitors
538(4)
Performance Monitor
542(8)
DB2 Governor
550(1)
Performance Issues
551(7)
Configuring Database Resources
553(5)
DB2 Sorting Methods
558(13)
DB2 Server Resources
561(1)
Query Parallelism
562(6)
Performance Tuning Scenario
568(3)
Diagnostics and Problem Determination
571(14)
Error Messages and SQL Codes
571(6)
Tracing Problems in DB2 Universal Database
577(4)
Database Analysis and Repair Tool
581(4)
Summary
585(1)
Questions
586(5)
Answers
591(2)
Exercises
593(4)
Chapter 9 -- DB2 Application Programming
597(76)
DB2 Application Development Environment
598(3)
Client/Server Platform
598(3)
Choosing a DB2 Programming Method
601(5)
Static Embedded SQL
601(1)
Dynamic Embedded SQL
602(1)
Call Level Interface (CLI)
603(1)
DB2 Application Programming Interfaces (APIs)
604(2)
Accessing Data from an Application
606(11)
Using Schemas
606(1)
Using an Alias
607(1)
Creating Packages
608(3)
Binding Applications
611(4)
Binding Utilities
615(2)
Parts of a DB2 Embedded Static SQL Application
617(21)
Host Variables
617(9)
Indicator Variables
626(5)
Using Cursors
631(7)
Handling Application Termination
638(2)
Interrupt Handling
638(2)
Large Objects
640(6)
Direct LOB Reference
640(1)
References by LOB Locator
641(3)
LOB File Reference Variables
644(2)
Unique Keys and Referential Integrity
646(2)
Online Analytical Processing
648(6)
STAR Schemas
648(2)
OLAP Indexes
650(1)
Dynamic Bitmap Index ANDing
650(1)
STAR Joins
651(2)
OLAP SQL
653(1)
Summary
654(1)
Questions
655(13)
Answers
668(3)
Exercises
671(2)
Chapter 10 -- DB2 Advanced Application Programming
673(40)
Writing Dynamic Programs
674(25)
First Look at Dynamic SQL
675(2)
Dynamic SQL Phases
677(3)
Types of Dynamic SQL Statements
680(5)
Dynamic SQL -- Callable SQL Interfaces
685(1)
ODBC vs. CLI
686(1)
Embedded Dynamic vs. Call Level Interface
687(1)
Setting Up a CLI Development Environment
687(4)
Stored Procedures
691(1)
User Defined Functions
692(4)
Support For Java Programming
696(1)
Compound SQL
697(2)
Summary
699(1)
Questions
700(8)
Answers
708(3)
Exercises
711(2)
Appendix A -- Test Objectives DB2 UDB V5 Fundamentals (503) 713(4)
Appendix B -- Test Objectives DB2 UDB V5 Database Administration (504) 717(4)
Appendix C -- Test Objectives DB2 UDB V5 Application Development (505) 721(4)
Appendix D -- DB2 Tools and Utilities 725(2)
Appendix E -- DB2 Example Source Code 727(30)
Index 757
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 >