DB2 Universal Database V6.1 for Unix, Windows and OS/2 Certification Guide / Edition 3

DB2 Universal Database V6.1 for Unix, Windows and OS/2 Certification Guide / Edition 3

by Jonathan Cook, Tetsuya Shirai, Robert Harbus, Tetsuya Shirai
     
 

ISBN-10: 0130867551

ISBN-13: 9780130867551

Pub. Date: 11/12/1999

Publisher: Pearson Education

  • The #1 guide and reference for IBM's powerhouse DB2 UDB V6.1 database
  • New DB2 UDB V6.1 features for all platforms: UNIX, 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 V6.1 certification exams

Overview

  • The #1 guide and reference for IBM's powerhouse DB2 UDB V6.1 database
  • New DB2 UDB V6.1 features for all platforms: UNIX, 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 V6.1 certification exams

IBM's DB2 Universal Database Version 6.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 V6.1 - and preparing for IBM's updated DB2 V6.1 certification exams!

This is IBM's definitive guide and reference for the newest, most powerful version of DB2 Universal Database ever: Version 6.1. DB2 Universal Database Version 6.1 for UNIX, Windows and OS/2 Certification Guide, Third Edition delivers end-to-end coverage for every DB2 developer and administrator, on every platform: Windows, UNIX, or OS/2 - including the most systematic IBM DB2 certification review you can find.

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, application development, 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
  • Database access techniques using ODBC, JDBC, and ADO

Whether you're deploying DB2 UDB V6.1, managing DB2 UDB V6.1, preparing for DB2 UDB V6.1 certification, or all three, DB2 Universal Database Version 6.1 for UNIX, Windows, and OS/2 Certification Guide, Third Edition will be your single most valuable resource.

Product Details

ISBN-13:
9780130867551
Publisher:
Pearson Education
Publication date:
11/12/1999
Series:
IBM DB2 Series
Edition description:
3RD BK&CDR
Pages:
1014
Product dimensions:
6.99(w) x 9.20(h) x 1.53(d)

Table of Contents

Foreword xv
Preface xvii
PART ONE - Introduction to DB2 UDB 1(228)
Product Overview
3(54)
DB2 Universal Database-The Scalable Database
4(3)
DB2 Universal Database Products
5(2)
DB2 Universal Database
7(4)
DB2 UDB Personal Edition
7(1)
DB2 UDB Workgroup Edition
8(2)
DB2 UDB Enterprise Edition
10(1)
DB2 UDB Enterprise-Extended Edition
11(1)
DB2 Connect
11(3)
DB2 Connect Personal Edition
13(1)
DB2 Connect Enterprise Edition
14(1)
DB2 Developer's Edition
14(2)
DB2 Satellite Edition
16(10)
Satellite Components
17(3)
Logical Components
20(3)
Model Office
23(2)
Maintenance of Satellite Systems
25(1)
DB2 Data Links Manager
26(9)
DB2 Data Links Manager System Overview
30(1)
Components of a Data Links Server
31(1)
Data Links Manager Facilities
32(3)
DB2 Query Patroller
35(5)
DB2 Licensing
39(1)
Client/Server Communication Protocols
40(1)
DB2 UDB Resource Usage
41(1)
Features and Functions
41(11)
The Control Center
43(2)
Other Tools Available from the Control Center
45(1)
The SmartGuides
46(3)
Other DB2 UDB Tools
49(2)
The Command Line Processor (CLP)
51(1)
Summary
52(1)
Questions
53(2)
Answers
55(2)
Getting Started
57(50)
Product Installation
59(22)
Windows NT/9x and OS/2 Installation
59(10)
UNIX Installation
69(7)
DB2 Client Installation
76(1)
Distributed Installation
77(4)
The DB2 UDB Environment
81(6)
DB2 Profile Registry
81(3)
Environment Variables
84(1)
Using the Command Line Processor
85(2)
DAS and DB2 Instances
87(6)
DB2 Administration Server (DAS) Instance
87(2)
DB2 Instances
89(4)
Creating the Sample Database
93(6)
Using the Command Line
93(2)
Using First Steps
95(4)
Summary
99(1)
Questions
100(1)
Answers
101(1)
Exercises
102(5)
Getting Connected
107(62)
Roadmap to Client/Server Communications
109(2)
Automated Configuration using Discovery
109(1)
Automated Configuration Using Access Profiles
110(1)
Manual Configuration
110(1)
DB2 Discovery
111(2)
DB2 Directories
113(3)
Examining DB2 UDB Directories
114(2)
Configuring DB2 Clients
116(27)
Automated Configuration using Discovery
116(12)
Using Access Profiles
128(6)
Manual Configuration
134(8)
Summary of Configuring Connections
142(1)
Configuring Communications
143(13)
Configuring the DB2 Instance for Communications
143(7)
Configuring the DAS Instance
150(2)
Configuring DB2 Discovery
152(4)
Binding Utilities
156(5)
Binding Utilities Using the CCA
158(3)
Instance Administration
161(4)
Local Instance Administration
162(2)
Attaching to an Instance using the Control Center
164(1)
Summary
165(1)
Questions
166(1)
Answers
167(2)
Controlling Data Access
169(60)
Security
170(42)
Overview of Security
170(1)
Authentication
170(16)
Authorities and Privileges
186(17)
Windows NT Considerations
203(9)
Auditing
212(6)
Summary
218(1)
Questions
219(2)
Answers
221(1)
Exercises
222(7)
PART TWO - Using SQL 229(238)
Database Objects
231(80)
Understanding Database Objects
233(6)
Data Types
233(1)
Tables
234(1)
Schemas
234(1)
Table Spaces
235(1)
Views
235(1)
Indexes
236(1)
Packages
236(1)
Buffer Pools
237(1)
Transactions
237(1)
Locks
238(1)
Log Files
238(1)
Creating a DB2 UDB Database
238(1)
Managing Database Objects
239(50)
Using SQL Data Definition Language (DDL)
239(2)
Data Types
241(22)
Tables
263(14)
Views
277(7)
Indexes
284(5)
Database Design and Implementation
289(12)
DB2CERT Database Table Descriptions
290(3)
Define User-Defined Data Types
293(1)
Defining Columns
294(2)
Keys
296(1)
Defining Primary Keys
297(1)
Defining Unique Keys
298(1)
Defining Foreign Keys
299(2)
Summary
301(1)
Questions
302(2)
Answers
304(1)
Exercises
305(6)
Manipulating Database Objects
311(60)
Data Retrieval
312(36)
Retrieving the Entire Table
312(2)
Projecting Columns from a Table
314(1)
Changing the Order of the Columns
314(1)
Restricting Rows from a Table
315(1)
Predicate Evaluation for UDTs
316(1)
Restricting Rows Using Multiple Conditions
317(1)
Selecting Columns from Multiple Tables
318(5)
Using Correlation Names
323(1)
Sorting Your Output
324(2)
Derived Columns
326(1)
DB2 Functions
327(2)
Grouping Values
329(2)
Eliminating Duplicates
331(1)
Searching for String Patterns
331(1)
Searching for Data in Ranges
332(1)
Searching for Null Values
333(1)
Searching for Negative Conditions
334(1)
Searching for a Set of Values
335(1)
Sub-Queries
335(2)
Quantified Predicates
337(2)
Case Expressions
339(1)
Nested Table Expressions
340(1)
Scalar Fullselect
341(2)
Common Table Expressions
343(2)
Set Operators
345(3)
Data Modification
348(9)
Inserting Data Records
348(4)
Updating Data Records
352(3)
Removing Data
355(2)
View Classification
357(4)
Deletable Views
358(1)
Updatable Views
358(1)
Insertable Views
359(1)
Read-Only Views
359(1)
Inoperative views
360(1)
Summary
361(1)
Questions
362(2)
Answers
364(1)
Exercises
365(6)
Advanced SQL
371(64)
Triggers
372(4)
Trigger Usage
372(1)
Trigger Activation
372(1)
Trigger Example (After Trigger)
373(1)
Trigger Example (Before Trigger)
374(2)
Recursive SQL
376(4)
Outer Join
380(6)
Left Outer Join
381(1)
Right Outer Join
382(1)
Full Outer Join
382(2)
Combining Outer Joins
384(2)
OLAP Features
386(11)
STAR Schemas
386(2)
OLAP Indexes
388(1)
STAR Joins
388(1)
Super Grouping
389(8)
Advanced CASE Expressions
397(2)
Using CASE expressions to Group Values
397(1)
Using CASE expressions in Functions
398(1)
Structured Types and Typed Tables
399(25)
Creating Structured Types
401(2)
Altering Structured Types
403(1)
Creating Typed Tables
403(2)
Dropping Typed Tables
405(1)
Inserting Rows into a Typed Table
406(1)
Selecting a Row from a Typed Table
407(1)
Updating and Deleting Rows from Typed Tables
408(1)
Physical Implementation of Typed Tables
409(2)
Reference Columns
411(2)
View Hierarchies
413(1)
SQL Functions for typed tables and typed views
414(1)
TYPE Predicate
415(1)
Considerations when using Typed tables and views
416(1)
Examples of a Typed Table Hierarchy
416(8)
Summary Tables
424(5)
Creating a summary table
424(2)
CURRENT REFRESH AGE Special Register
426(1)
Considerations of using Summary Tables
427(1)
System Catalog Information for Summary Tables
428(1)
Summary
429(1)
Exercises
430(5)
Concurrency
435(32)
Concurrency
437(9)
Concurrency Considerations
438(8)
Isolation Levels
446(3)
Uncommitted Read
447(1)
Cursor Stability
447(1)
Read Stability
448(1)
Repeatable Read
448(1)
Choosing an Isolation Level
448(1)
Locking
449(7)
Lock Attributes
449(2)
Lock Conversion
451(1)
Lock Escalation
452(1)
Lock Wait Behavior
453(1)
Lock Table Statement
454(1)
LOCKSIZE parameter of ALTER TABLE statement
454(2)
Summary
456(1)
Questions
457(1)
Answers
458(1)
Exercises
459(8)
PART THREE - DB2 UDB Administration 467(310)
Data Storage Management
469(56)
Buffer Pools
470(1)
Table Spaces
470(2)
SMS Table Spaces
471(1)
DMS Table Spaces
471(1)
Regular Table Spaces
472(1)
Long Table Spaces
472(1)
Temporary Table Spaces
472(1)
Containers
472(3)
Directory Containers
474(1)
Device Containers
474(1)
File Containers
475(1)
Extents
475(1)
Pages
476(2)
Long Field Data
476(1)
Large Object Data
477(1)
Planning and Design
478(10)
Sizing the Processor, Disk and Memory
478(2)
Table Space Design
480(8)
Implementation
488(8)
Creating a Database
488(4)
Creating Buffer Pools
492(1)
Creating Table Spaces
492(1)
Creating Tables
493(1)
Dropping Table Spaces
493(1)
Dropping Buffer Pools
493(1)
Dropping a Database
494(1)
Creating Table Spaces Using the Control Center
494(2)
Table Space Maintenance
496(9)
Database Files
496(1)
Listing Table Spaces
497(1)
Listing Table Space Containers
498(1)
Table Space States
498(2)
System Catalog Information About Table Spaces
500(1)
Adding Containers to DMS Table Spaces
501(4)
Summary
505(2)
Questions
507(3)
Answers
510(1)
Exercises
511(14)
Maintaining Data
525(98)
Moving data
526(3)
Delimited ASCII Files
526(1)
Non-Delimited ASCII Files
527(1)
PC/IXF Files
528(1)
Worksheet Format Files
528(1)
Data Movement Utilities
529(53)
The Export Utility
529(11)
The IMPORT Utility
540(15)
The Load Utility
555(22)
The LOAD QUERY Command
577(5)
The SET INTEGRITY Statement
582(5)
The DB2MOVE Utility
587(2)
The DB2LOOK Utility
589(5)
Data Maintenance
594(17)
Analyzing Data's Physical Organization
594(6)
Table Reorganization
600(4)
Generating Statistics
604(6)
The Rebind Utility
610(1)
Data Maintenance Process
611(2)
Modelling a Production Environment
611(2)
Summary
613(1)
Questions
614(3)
Answers
617(1)
Exercises
618(5)
Database Recovery
623(52)
Database Recovery Concepts
623(45)
Unit of Work
624(1)
Transaction
624(1)
Types of Recovery
624(2)
Recovery Strategies
626(1)
Recoverable and Non-Recoverable Databases
626(1)
Online and Offline Access
626(1)
Use of Log Files
627(1)
Log Buffers
628(1)
Primary and Secondary Log Files
628(1)
Types of Logging
629(3)
Log File Usage
632(2)
Version Recovery using Backup and Restore
634(15)
Roll-Forward Recovery
649(8)
Managing Log Files
657(2)
Other Recovery Considerations
659(7)
Summary
666(2)
Questions
668(1)
Answers
669(1)
Exercises
670(5)
Monitoring and Tuning
675(102)
Elements of Performance
676(4)
Tuning Guidelines
676(2)
Performance Improvement Process
678(1)
How Much Can a System Be Tuned?
678(1)
A Less Formal Approach
679(1)
Monitoring Methods in DB2 UDB
680(1)
Obtaining Database Access Information
680(1)
Explain Facilities
680(21)
Overview of the SQL Compiler
681(3)
Explain Tables
684(1)
Gathering Explain Data
684(6)
Examining EXPLAIN Data
690(8)
Guidelines on Using EXPLAIN Output
698(2)
Index Advisor Facility
700(1)
Database Monitoring
701(30)
Snapshot Monitoring
701(11)
Event Monitoring
712(8)
Visual Performance Monitors
720(11)
DB2 Governor
731(1)
Performance Issues
732(8)
Configuring Database Resources
735(5)
DB2 Sorting Methods
740(5)
DB2 Server Resources
744(1)
Query Parallelism
745(6)
Intra-Partition and Inter-Partition Parallelism
745(4)
Setting Up Intra-Partition Parallelism
749(2)
Performance Tuning Scenario
751(3)
Diagnostics and Problem Determination
754(13)
Error Messages and SQL Codes
754(7)
Tracing Problems in DB2 Universal Database
761(6)
Summary
767(1)
Questions
768(3)
Answers
771(2)
Exercises
773(4)
PART FOUR - Developing Applications 777(186)
Programming Overview
779(40)
DB2 UDB Application Development Environment
780(3)
Software Requirements
780(3)
Application Development Considerations
783(1)
Choosing a DB2 UDB Programming Interface
783(13)
Embedded SQL
784(3)
Call Level Interface and ODBC
787(2)
Java Interfaces (JDBC and SQLJ)
789(2)
Native DB2 UDB APIs
791(1)
Microsoft Data Objects (DAO, RDO, ADO)
792(1)
Other Interfaces and Tools
793(3)
Choosing DB2 UDB Server-Side Features
796(5)
DB2 UDB Application Overview
801(5)
Using Schemas and Aliases
806(4)
Schema
806(1)
Alias
807(3)
Summary
810(1)
Questions
811(5)
Answers
816(3)
Embedded SQL Programming
819(74)
Embedded SQL Overview
820(12)
Creating Packages
821(4)
Binding Applications
825(7)
Static Embedded SQL
832(27)
Host Variables
832(3)
Connecting to Databases
835(4)
Error Handling - Using and Interpreting the SQLCA
839(3)
Error handling - Message Retrieval
842(2)
Indicator Variables
844(2)
Data Retrieval Methods
846(4)
Using Cursors
850(9)
Dynamic Embedded SQL
859(14)
First Look at Dynamic SQL
860(3)
Dynamic SQL Phases
863(1)
Other Concepts
864(1)
Types of Dynamic SQL Statements
865(1)
SQLDA Data Structure
866(7)
Summary
873(1)
Questions
874(11)
Answers
885(3)
Exercises
888(5)
Other Programming Methods
893(70)
Support for CLI and ODBC Programming
895(24)
Embedded Dynamic versus Call Level Interface
895(1)
ODBC versus CLI
896(2)
Setting Up the CLI Environment
898(6)
Coding a DB2 UDB CLI Application
904(15)
Support For Java Programming
919(11)
JDBC Programming
920(4)
SQLJ Programming
924(3)
Building, Distributing and Running Java Programs
927(3)
Other Application Interfaces
930(3)
Programming with ActiveX Data Objects
930(3)
Advanced DB2 UDB Programming Features
933(20)
Stored Procedures
933(8)
User Defined Functions
941(5)
Large Objects
946(6)
Compound SQL
952(1)
Summary
953(2)
Questions
955(2)
Answers
957(1)
Exercises
958(5)
PART FIVE - Appendices 963(40)
Appendix A - DB2 UDB V6.1
Certification Test Objectives
965(1)
DB2 UDB V6.1 Fundamentals (509)
965(3)
DB2 UDB V6.1 Database Administration (510)
968(2)
DB2 UDB V6.1 Application Development (511)
970(3)
Appendix B - Example DB2 UDB Source Code
973(30)
Index 1003

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >