Sams Teach Yourself DB2 Universal Database in 21 Days 2nd edition [Pehme köide]

Introduction		1	(1)
Assumptions		2	(1)
How to Use This Book		2	(1)
Conventions Used in This Book		3	(1)
About the CD-ROM		3	(2)
Week 1 At a Glance		5	(186)
What DB2 Can Do for You		7	(24)
What Is DB2 Universal Database?		8	(7)
DB2's Various Flavors		8	(2)
DB2's Architecture		10	(1)
DB2 and Its Companion Products		11	(4)
Understanding How DB2 Universal Database Works with Data		15	(1)
DB2 Tools for Administering Databases		15	(4)
Managing Databases with the Control Center		16	(2)
Managing Communications on the Server		18	(1)
Managing Connections to Databases with the Configuration Assistant		18	(1)
Accessing Host Data from the Desktop		19	(2)
Developing Applications with the DB2 Developer's Editions		21	(2)
Accessing DB2 Data from the Web		23	(1)
Using Java Database Connectivity		23	(1)
Using DB2 Parallelism		24	(1)
Overview of the DB2 Enterprise Host Servers		25	(2)
DB2 Universal Database for z/OS and OS/390		25	(1)
DB2 Universal Database for iSeries		26	(1)
DB2 Server for VSE & VM		27	(1)
Summary		27	(1)
What Comes Next?		28	(1)
Q&A		28	(1)
Workshop		29	(2)
Quiz		29	(2)
Exploring the Capabilities of DB2 Universal Database		31	(36)
Major Components of DB2		32	(1)
What Is a Relational Database?		33	(9)
Tables, Columns, and Rows		33	(1)
Views		34	(2)
Schemas		36	(1)
Keys		36	(2)
Packages		38	(1)
Data Types		38	(3)
Functions		41	(1)
Data Integrity		42	(18)
Roll-Forward Recovery		43	(1)
Constraints		43	(2)
User-Defined Types (UDTs)		45	(1)
Triggers		46	(2)
System Catalog Tables		48	(1)
Instances		48	(1)
Directories		49	(1)
Storage Objects		50	(6)
Configuration Files		56	(1)
Recovery Objects		57	(3)
Application Programs		60	(3)
Embedded SQL		61	(1)
Open Database Connectivity (ODBC)		62	(1)
DB2 Call Level Interface (DB2 CLI)		62	(1)
Application Programming Interfaces (APIs)		63	(1)
System Management Facilities		63	(1)
Online Administrative Capability		64	(1)
Lightweight Directory Access Protocol (LDAP)		64	(1)
Summary		64	(1)
What Comes Next?		65	(1)
Q&A		65	(1)
Workshop		65	(2)
Quiz		66	(1)
Exercise		66	(1)
Installing and Configuring DB2 Server		67	(28)
Preparing for the Install		68	(2)
Hardware and Software Requirements		68	(1)
Creating a User Account for Installing DB2 Products		69	(1)
Performing a Typical Install		70	(10)
Performing a Custom Install		80	(10)
Performing a Compact Install		90	(1)
Installing the Product Information library		91	(1)
Modifying, Repairing, or Removing DB2		91	(1)
Summary		92	(1)
What Comes Next?		92	(1)
Q&A		92	(1)
Workshop		93	(2)
Quiz		93	(2)
Getting Started		95	(22)
Logging On to the System		95	(1)
Understanding the Desktop		96	(3)
Changing Passwords		99	(1)
Starting or Stopping DB2		100	(1)
Using DB2 First Steps		100	(11)
Creating the Sample Database		102	(1)
Viewing and Working with the Sample Database		103	(5)
Viewing the Product Information library		108	(2)
Organizing and Viewing Objects by Schema		110	(1)
Connecting to a Database		111	(1)
Granting Privileges to Other Users		111	(3)
Changing Default Privileges for Users		114	(1)
Summary		114	(1)
What Comes Next?		115	(1)
Q&A		115	(1)
Workshop		116	(1)
Quiz		116	(1)
Exercise		116	(1)
Setting Up DB2 Instances and Server Communications		117	(26)
Working with DB2 Instances		118	(5)
Setting Up Instances		118	(1)
Listing Available Instances		118	(1)
Adding Additional Instances		119	(1)
How DB2 Selects an Instance		120	(1)
Starting and Stopping a DB2 Server Instance		121	(1)
Running Multiple Instances Concurrently		122	(1)
Attaching to Instances		122	(1)
Removing Instances		123	(1)
Modifying the DB2 Communication Configuration of Server Instances		123	(3)
Viewing and Modifying Configuration Files		126	(5)
Viewing and Modifying Database Manager Configuration Files		126	(2)
Viewing and Modifying Database Configuration Files		128	(1)
Viewing and Modifying Registry Variables		129	(2)
Adding Systems Through the Control Center		131	(2)
The DB2 Administration Server		133	(4)
Setting Discovery on the Server		134	(1)
Setting Discovery Parameters at the DAS Level		135	(1)
Setting Discovery Parameters at the Instance Level		136	(1)
Setting Discovery Parameters at the Database Level		137	(1)
Server Profiles		137	(1)
Generating a Server Profile		137	(1)
Summary		138	(1)
What Comes Next?		139	(1)
Q&A		139	(2)
Workshop		141	(2)
Quiz		141	(1)
Exercises		141	(2)
Installing and Configuring DB2 Clients		143	(28)
Understanding the Different Types of DB2 Clients		144	(1)
Preparing for the Install		145	(2)
Hardware and Software Requirements		145	(1)
Creating a User Account for Installing DB2 Products		146	(1)
Performing a Typical Install		147	(4)
Performing a Custom Install		151	(4)
Performing a Compact Install		155	(1)
Configuring Client-to-Server Communications with the Configuration Assistant		155	(1)
Configuring Database Connections		156	(12)
Configuring Database Connections Using a Profile		156	(3)
Searching the Network for Databases		159	(2)
Manually Configure a Connection to a DB2 Database		161	(2)
Verifying the Connection		163	(1)
Creating Client Profiles		164	(4)
Summary		168	(1)
What Comes Next?		168	(1)
Q&A		168	(1)
Workshop		169	(2)
Quiz		170	(1)
Exercise		170	(1)
Ensuring Data Security		171	(20)
Authentication		172	(2)
Authentication Types		172	(1)
Setting the Authentication Level		173	(1)
Access to DB2 Universal Database		174	(3)
Access Within DB2		177	(9)
Authorities		177	(2)
Schemas		179	(2)
Privileges		181	(3)
Granting and Revoking Privileges and Authorities		184	(2)
Windows Security Considerations		186	(2)
Summary		188	(1)
What Comes Next?		188	(1)
Q&A		188	(1)
Workshop		189	(2)
Quiz		189	(1)
Exercise		189	(2)
Week 2 At a Glance		191	(144)
Designing the CDLIB Database		193	(18)
Deciding What Data to Store in the Database		194	(7)
The Category Table		196	(1)
The Recordlabel Table		196	(1)
The Artist Table		197	(1)
The Group Table		198	(1)
The Album Table		198	(1)
The Song Table		199	(1)
The Artistingroup Table		200	(1)
The Portrait Table		201	(1)
The Audioclip Table		201	(1)
The Albumcover Table		201	(1)
Defining Tables for Each Type of Relationship		201	(1)
Identifying the Primary Key		202	(1)
Identifying Constraints and Foreign Keys		203	(1)
Normalizing Your Table		204	(4)
First Normal Form		204	(1)
Second Normal Form		205	(1)
Third Normal Form		206	(2)
Summary		208	(1)
What Comes Next?		208	(1)
Q&A		208	(1)
Workshop		209	(2)
Quiz		209	(1)
Exercise		209	(2)
Creating Databases and Tables		211	(18)
Creating a Simple Database		212	(14)
Creating Tables		214	(5)
Adding Data to Tables		219	(1)
Setting Up Referential Integrity		220	(5)
Altering Tables		225	(1)
Summary		226	(1)
What Comes Next?		226	(1)
Q&A		227	(1)
Workshop		227	(2)
Quiz		227	(1)
Exercise		228	(1)
Creating Table Spaces		229	(20)
Managing Your Data in Table Spaces		230	(1)
Using the Create Table Space Wizard		230	(8)
Allocating Additional Space		238	(2)
Creating a Buffer Pool		240	(2)
Creating Table Spaces for Indexes and Large Data		242	(1)
Creating Tables in Table Spaces		243	(3)
Summary		246	(1)
What Comes Next?		246	(1)
Q&A		246	(1)
Workshop		247	(2)
Quiz		247	(1)
Exercises		248	(1)
Accessing the Data		249	(20)
Accessing Data Through the Control Center		250	(1)
Accessing Data Through the Command Center		251	(4)
Using the Command Line Processor		255	(1)
Entering Commands		255	(1)
Entering Commands in a Command Window		256	(1)
Accessing Data Through Microsoft Access		256	(3)
Accessing Data Through Java Applications		259	(3)
JRE/JDK Support		260	(1)
Setting Up the Windows Java Environment		261	(1)
Java Sample Programs		261	(1)
Accessing Data Through WebSphere Application Server		262	(1)
Accessing Data Through Your Own Applications		262	(3)
Binding Database Utilities		263	(2)
Summary		265	(1)
What Comes Next?		266	(1)
Q&A		266	(1)
Workshop		267	(2)
Quiz		267	(1)
Exercise		267	(2)
SQL Concepts		269	(28)
Data Manipulation Language		270	(17)
Selecting Columns		270	(1)
Selecting Rows		271	(2)
Sorting Rows		273	(1)
Removing Duplicate Rows		274	(1)
Using Expressions to Calculate Values		274	(1)
Naming Expressions		275	(1)
Selecting Data from More Than One Table (Join)		275	(1)
Using a Subquery		276	(1)
Column Functions		277	(1)
Scalar Functions		278	(1)
Grouping		278	(2)
Combining Queries by Set Operators		280	(2)
In, Between, Like, Exists, and Quantified Predicates		282	(3)
Inserting Data		285	(1)
Changing Data		285	(1)
Deleting Data		285	(1)
Using Views		286	(1)
How SQL Statements Are Invoked		287	(5)
Embedding SQL into Applications		288	(3)
Performance of Static Versus Dynamic SQL Statements		291	(1)
Developing Windows Applications		292	(1)
Summary		293	(1)
What Comes Next?		293	(1)
Q&A		294	(1)
Workshop		294	(3)
Quiz		295	(1)
Exercise		295	(2)
Advanced SQL		297	(24)
Object-Oriented SQL Concepts		298	(12)
Constraints		298	(2)
User-Defined Types (UDTs)		300	(1)
Triggers		301	(4)
Routines (Stored Procedures, UDFs, Methods)		305	(2)
Large Object Support		307	(3)
Development Center		310	(1)
DB2 XML Extender		311	(3)
DB2 Net Search Extender		314	(1)
DB2 Spatial Extender		315	(2)
Summary		317	(1)
What Comes Next?		317	(1)
Q&A		317	(1)
Workshop		318	(3)
Quiz		318	(1)
Exercise		318	(3)
Design Considerations		321	(14)
System Resources		322	(2)
Disk Space Management		322	(1)
Separating Different Data Types		322	(1)
Enabling Prefetch		323	(1)
Large Object Considerations		323	(1)
General System Recommendations		324	(1)
General SQL Guidelines		324	(2)
Stored Procedures		325	(1)
Compound SQL		325	(1)
General SQL Recommendations		325	(1)
Managing Concurrency		326	(4)
Row and Table Locking		327	(2)
General Concurrency Recommendations		329	(1)
Index Considerations		330	(1)
General Index Recommendations		330	(1)
Complex Query Application Considerations		331	(1)
Summary		331	(1)
What Comes Next?		332	(1)
Q&A		332	(1)
Workshop		333	(2)
Quiz		333	(1)
Exercise		333	(2)
Week 3 At a Glance		335	(190)
Using System Administration Tools		337	(26)
Using the Task Center		338	(9)
Creating a DB2 Command Script		338	(5)
Importing Scripts		343	(1)
Running Scripts		344	(2)
Scheduling Scripts		346	(1)
Using the Journal		347	(4)
Viewing the Results of a Job		348	(3)
Customizing Tools Settings		351	(3)
Making Your Database More Useful		354	(3)
Creating Indexes		354	(3)
Working with Directories		357	(1)
Managing Contacts		358	(1)
Managing Licenses		358	(1)
Summary		359	(1)
What Comes Next?		360	(1)
Q&A		360	(1)
Workshop		360	(3)
Quiz		361	(1)
Exercise		361	(2)
Recovery Concepts		363	(28)
Log Management		364	(6)
Backing Up Databases		370	(6)
Using the Backup Wizard		371	(5)
Forcing Users Off DB2		376	(1)
Recovering Data		376	(9)
Using the Restore Data Wizard		377	(8)
Database History File		385	(2)
Summary		387	(1)
What Comes Next?		387	(1)
Q&A		387	(2)
Workshop		389	(2)
Quiz		389	(1)
Exercise		389	(2)
Moving Data		391	(30)
Exporting Data		392	(4)
Performing a Simple Export		393	(1)
Specifying Column Names		394	(1)
Exporting Large Objects (LOBs)		395	(1)
Importing and Loading Data		396	(12)
Importing Data from Files		397	(11)
Loading Data		408	(9)
Setting Integrity Constraints		415	(2)
Summary		417	(1)
What Comes Next?		417	(1)
Q&A		418	(1)
Workshop		418	(3)
Quiz		419	(1)
Exercise		419	(2)
Replicating Data		421	(30)
Replication Concepts		421	(3)
Creating a Replication Environment		424	(25)
Step 1: Create the Capture Control Tables		424	(4)
Step 2: Register a Source Table		428	(2)
Step 3: Create the Apply Control Tables		430	(3)
Step 4: Create a Subscription Set		433	(8)
Step 5: Start the Capture Program		441	(1)
Step 6: Start the Apply Program		442	(2)
Replication Operations		444	(5)
Summary		449	(1)
What Comes Next?		449	(1)
Q&A		449	(1)
Workshop		450	(1)
Quiz		450	(1)
Exercise		450	(1)
Database Monitoring Tools		451	(26)
Health Monitor		452	(1)
Database System Monitor		453	(8)
Event Monitoring		455	(5)
Snapshot Monitoring		460	(1)
Using Visual Explain		461	(7)
Producing an Access Plan Graph		462	(3)
Analyzing an Access Plan Graph		465	(3)
Collecting Statistics		468	(3)
Reorganizing a Table		471	(2)
Storage Management Tool		473	(1)
Summary		474	(1)
What Comes Next?		474	(1)
Q&A		474	(1)
Workshop		475	(2)
Quiz		475	(1)
Exercise		475	(2)
Tuning DB2 Universal Database Performance		477	(30)
Controlling Your DB2 Environment		478	(2)
Controlling the DB2 Profile Registry		478	(1)
DB2 Registry Values and Environment Variables		479	(1)
Configuration Parameters		480	(5)
Setting Database Manager Configuration Parameters on a Client Instance		481	(1)
Setting Database Manager Configuration Parameters on a Server Instance		482	(1)
Setting Database Configuration Parameters on a Server Instance		483	(2)
Summary of Configuration Parameters Covered in This Book		485	(1)
Using the Configuration Advisor		485	(7)
Using the Design Advisor		492	(7)
Input/Output Performance		499	(4)
Indexes		499	(1)
Buffer Pools		500	(1)
Asynchronous Buffer Writer		501	(1)
Row Blocking		501	(1)
Prefetching Data Pages		502	(1)
Parallel Input/Output		503	(1)
Big Block Reads		503	(1)
Summary		503	(1)
What Comes Next?		504	(1)
Q&A		504	(1)
Workshop		504	(3)
Quiz		505	(1)
Exercise		505	(2)
Diagnosing Problems		507	(18)
Accessing Documentation		508	(1)
Online Messages		508	(1)
Error-Logging Facilities		509	(2)
Administration Notification Log		509	(1)
DB2 Diagnostic Log		510	(1)
Error-Logging Facilities		511	(1)
Inspect Command		511	(1)
Database Analysis and Reporting Tool		511	(1)
Configuration Files		512	(1)
Tracing Facilities		513	(7)
Trace Configuration		513	(1)
DB2 CLI Trace		514	(4)
ODBC Driver Manager Trace		518	(1)
DB2 JDBC Trace		518	(2)
Updating DB2 Products		520	(1)
Summary		521	(1)
What Comes Next?		521	(1)
Q&A		521	(1)
Workshop		522	(3)
Quiz		522	(1)
Exercise		522	(3)
Appendix A Getting Certified		525	(8)
What Is Certification?		525	(1)
Benefits of Becoming Certified		526	(1)
Am I Ready to Take the Exam?		527	(1)
Taking a Certification Exam		528	(1)
IBM Certified Database Associate DB2 UDB V8.1 Family Fundamentals		529	(2)
Certification Requirements		529	(1)
Exam Objectives for Exam 700, DB2 UDB V8.1 Family Fundamentals		529	(2)
Beyond Exam 700		531	(2)
Database Administrator Role		531	(1)
Solution Designer Role		531	(1)
Application Developer Role		531	(2)
Appendix B Answers to Quiz Questions		533	(18)
Day 1		533	(2)
Day 2		535	(1)
Day 3		536	(1)
Day 4		537	(1)
Day 5		537	(2)
Day 6		539	(1)
Day 7		539	(1)
Day 8		540	(1)
Day 9		541	(1)
Day 10		542	(1)
Day 11		542	(1)
Day 12		543	(1)
Day 13		544	(1)
Day 14		545	(1)
Day 15		546	(1)
Day 16		547	(1)
Day 17		547	(1)
Day 18		548	(1)
Day 19		548	(1)
Day 20		549	(1)
Day 21		549	(2)
Index		551

Sams Teach Yourself DB2 Universal Database in 21 DaysSams Teach Yourself DB2 Universal Database in 21 Days About the Author Susan Visser has worked on the DB2 product for more than 12 years. First as a technical writer creating product documentation, then as a service consultant answering customer questions on the phone, and finally as the leader of the DB2 certification program creating certification exams to validate DB2 product skills. Five years ago, Susan wrote and published the first edition of Teach Yourself DB2 Universal Database in 21 Days. Since then she has helped other authors write and publish their books. In many cases, she has reviewed their books and provided guidance as to the style and topics to cover. As part of her job as certification lead, Susan speaks to many people who are trying to learn DB2 either for the first time or for a new release. She has gathered ideas from them to learn how people like to learn and the books they like to learn from. She also helps people get the skills they need to pass the certification exams and understand what is necessary both in terms of content and the different styles of learning. Bill Wong has spent the last 18 years working in various positions within IBM. Bill has worked with the DB2 product since its inception, working as a systems programmer, DBA, product planner, and as a technical sales specialist. Bill has also spent time teaching courses on database technology, strategic I/T planning, systems analysis and design, and decision theory. He is the author of many articles on DB2 technology and speaks frequently at technical conferences and customer sites around the world. Bill is currently the Program Director for Information Grid Solutions, and is responsible for helping customers understand IBM's latest directions in Grid computing, and how DB2 might fit into that environment. © Copyright Pearson Education. All rights reserved.