DB2 : The Complete Reference

by Melnyk, Roman B.; Zikopoulos, Paul C.

• ISBN13: 9780072133448
• ISBN10: 0072133449
• Edition: 1st
• Format: Paperback
• Copyright: 2001-10-01
• Publisher: McGraw-Hill Osborne Media

Summary

Get an inside look at the new version of DB2 using this in-depth reference. You'll get detailed coverage of SQL keywords and DB2 data structures, and learn to use DB2 to create powerful e-business solutions. Whether you're a developer or an administrator, you'll find this to be an invaluable resource.

Table of Contents

Part I Relational Database Concepts
Database Design	3	(14)
Database Objects	17	(22)
Part II Getting Started with DB2
Installing DB2 Products Across Your Enterprise	39	(22)
Connecting a DB2 Client to a DB2 Server	61	(48)
Controlling Data Access	109	(24)
Understanding Instances	133	(20)
Managing Data Storage	153	(12)
Creating Databases	165	(12)
Working with Tables	177	(40)
Part III Maintaining Data
Moving Data	217	(28)
Replicating Data	245	(12)
Recovering Data	257	(66)
Part IV Performance
Database Monitoring	323	(30)
Configuration Tuning	353	(44)
Problem Determination	397	(62)
Part V SQL
Basic SQL	459	(38)
Advanced SQL	497	(32)
Part VI Business Intelligence
Federated Systems	529	(30)
Data Warehousing	559	(12)
Online Analytical Processing	571	(12)
Part VII Application Development
Introduction to Application Development	583	(16)
Embedded SQL	599	(18)
Administrative Application Programming Interfaces	617	(14)
Call Level Interface and Open Database Connectivity	631	(30)
Java Support	661	(36)
SQL Procedures	697	(22)
Part VIII Reference
SQL Statements	719	(172)
Environment and Registry Variables	891	(36)
Introduction to DB2 Commands, Utilities, and Tools	927	(64)
Index	991