Home Page Icon
Home Page
Table of Contents for
Index
Close
Index
by Dwaine R. Snow, Sylvia F. Qi, Clara Liu, Raul F. Chong
Understanding DB2®: Learning Visually with Examples
Copyright
IBM Press
Foreword
Preface
Acknowledgments
About the Authors
Introduction to DB2 UDB
A Brief History of DB2
DB2 software and the IBM E-Business On-Demand Model
DB2 UDB Editions
DB2 UDB Clients
“Try and Buy” Versions
Host Connectivity
Federated Support
Replication Support
IBM DB2 Information Integrator
Special Package Offerings for Developers
DB2 Syntax Diagram Conventions
Case Study
Summary
Review Questions
DB2 at a Glance: The Big Picture
SQL Statements and DB2 Commands
DB2 Tools Overview
The DB2 Environment
Federation
Case Study: The DB2 Environment
Database Partitioning Feature
Case Study: DB2 with DPF Environment
Summary
Review Questions
Installing DB2
DB2 Installation: The Big Picture
Required User IDs and Groups
Installing DB2 Using the DB2 Setup Wizard
Silent Install Using a Response File
Installing DB2 Manually (Linux/UNIX Only)
Installing a DB2 License
Installing DB2 in a DPF Environment
Installing DB2 FixPaks
Case Study
Summary
Review Questions
Using the DB2 Tools
DB2 Tools: The Big Picture
The Command Line Tools
Development Tools
General Administration Tools
Information Tools
Monitoring Tools
Setup Tools
Other Tools
Tool Settings
Case Study
Summary
Review Questions
Understanding the DB2 Environment, DB2 Instances, and Databases
The DB2 Environment, DB2 Instances, and Databases: The Big Picture
The DB2 Environment
The DB2 Instance
The Database Administration Server
Configuring a Database
Instance and Database Design Considerations
Case Study
Summary
Review Questions
Configuring Client and Server Connectivity
Client and Server Connectivity: The Big Picture
The DB2 Directories
Supported Connectivity Scenarios
Configuring Database Connections Using the Configuration Assistant
Case Study
Summary
Review Questions
Working with Database Objects
DB2 Database Objects: The Big Picture
Databases
Partition Groups
Table Spaces
Buffer Pools
Schemas
Data Types
Tables
Indexes
Multidimensional Clustering Tables and Block Indexes
Views
Packages
Triggers
Stored Procedures
User-Defined Functions
Sequences
Case Study
Summary
Review Questions
The DB2 Storage Model
The DB2 Storage Model: The Big Picture
Databases: Logical and Physical Storage of Your Data
Database Partition Groups
Table Spaces
Buffer Pools
Case Study
Summary
Review Questions
Leveraging the Power of SQL
Querying DB2 Data
Modifying DB2 Data
Selecting from UPDATE, DELETE, and INSERT
The MERGE Statement
Recursive SQL
The UNION, INTERSECT, and EXCEPT Operators
Case Study
Summary
Review Questions
Implementing Security
DB2 Security Model: The Big Picture
Authentication
Data Encryption
Administrative Authorities
Database Object Privileges
Authority and Privilege Metadata
Windows Domain Considerations
Case Study
Summary
Review Questions
Understanding Concurrency and Locking
DB2 Locking and Concurrency: The Big Picture
Concurrency and Locking Scenarios
DB2 Isolation Levels
Changing Isolation Levels
DB2 Locking
Diagnosing Lock Problems
Techniques to Avoid Locking
Case Study
Summary
Review Questions
Maintaining Data
DB2 Data Movement Utilities: The Big Picture
Data Movement File Formats
The DB2 EXPORT Utility
The DB2 IMPORT Utility
The DB2 LOAD Utility
The db2move Utility
The db2relocatedb Utility
Generating Data Definition Language
DB2 Maintenance Utilities
Case Study
Summary
Review Questions
Developing Database Backup and Recovery Solutions
Database Recovery Concepts
DB2 Transaction Logs
Recovery Terminology
Performing Database and Table Space Backups
Database and Table Space Recovery Using the RESTORE DATABASE Command
Database and Table Space Roll Forward
Recovering a Dropped Table
The Recovery History File
Database Recovery Using the RECOVER DATABASE Command
High Availability Through Online Split Mirroring and Suspended I/O Support
High Availability Disaster Recovery
Using DB2 Tools to Inspect the Health of Your Database
Case Study
Summary
Review Questions
The DB2 Process Model
The DB2 Process Model: The Big Picture
The DB2 Engine Dispatchable Units
Tuning the Number of EDUs
Monitoring and Tuning the DB2 Agents
The Connection Concentrator
Commonly Seen DB2 Executables
Additional Services/Processes on Windows
Case Study
Summary
Review Questions
The DB2 Memory Model
DB2 Memory Allocation: The Big Picture
Instance-Level Shared Memory
Database-Level Shared Memory
Application-Level Shared Memory
Agent-Level Private Memory
The Memory Model
32-Bit Memory Model Considerations
64-Bit Memory Model Considerations
AWE Support with Windows
Case Study
Summary
Review Questions
Database Performance Considerations
Performance Fundamentals
System/Server Configuration
The DB2 Configuration Advisor
Configuring the DB2 Instance
Configuring Your Databases
Lack of Proper Maintenance
The Snapshot Monitor
Event Monitors
The DB2 Optimizer
The Explain Tool and Explain Tables
Using Visual Explain to Examine Access Plans
Case Study
Summary
Review Questions
Diagnosing Problems
Problem Diagnosis: The Big Picture
How Does DB2 Report Problems?
DB2 Error Message Description
DB2 First-Failure Data Capture
Receiving E-mail Notifications
The db2support Tool
The DB2 Trace Facility
Searching for Known Problems
Case Study
Summary
Review Questions
Solutions to the Review Questions
Chapter 1
Chapter 2
Chapter 3
Chapter 4
Chapter 5
Chapter 6
Chapter 7
Chapter 8
Chapter 9
Chapter 10
Chapter 11
Chapter 12
Chapter 13
Chapter 14
Chapter 15
Chapter 16
Chapter 17
Use of Uppercase Versus Lowercase in DB2
IBM Servers
Using the DB2 System Catalog Tables
DB2 System Catalog Tables
How to Extract Information from the System Catalog Tables
How to Use the SYSSTAT Tables to Perform What-if Modeling and Analysis
Setting Up Database Connectivity for DB2 UDB for z/OS and DB2 UDB for iSeries
Part I: Setting Up Database Connectivity for DB2 UDB for z/OS
Part II: Setting Up Database Connectivity for DB2 UDB for iSeries
Diagnosing DB2 Connectivity Problems
Diagnosing Client-Server TCP/IP Connection Problems
Resources
Glossary
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Z
About the CD-ROM
CD-ROM Warranty
Index
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Prev
Previous Chapter
CD-ROM Warranty
Index
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset