search for books and compare prices
Tables of Contents for DB2 Universal Database V6.1 for Unix, Windows, and Os/2
Chapter/Section Title
Page #
Page Count
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