DB2

Paul C. Zikopoulos (Toronto, Canada) is a Database Specialist with the DB2 Sales Support team at IBM. He has written numerous magazine articles and books about DB2. Most recently, he co-authored the books A DBA's Guide to Databases on Linux (Syngress Media) and DB2 for Dummies (IDG Books). Zikopoulos is a DB2 Certified Advanced Technical Expert (DRDA and Cluster/EEE) and a DB2 Certified Solutions Expert (Business Intelligence and Database Administration). Roman B. Melnyk, PhD (Toronto, Canada) is a Senior Member of the DB2 Information Development team at IBM, specialising in database administration and DB2 utilities. During more than six years at IBM, Melnyk has written numerous DB2 books and other related materials. Melnyk recently co-authored DB2 for Dummies (IDG Books).

Introduction Part I - Relational Database Concepts Database Design Database Objects Introducing Structured Query Language (SQL) Part II - Getting Started with DB2 Installing DB2 Migrating Databases Connecting Clients to Servers Controlling Data Access Understanding Instances Managing Data Storage Creating Databases Working with Tables Part III - Maintaining Data Moving Data Replicating Data Recovering Data Part IV - Performance Database Monitoring Configuration Tuning Problem Determination Part V - SQL Basic SQL Advanced SQL Part VI - Distributed Databases New features in 7.2 that will require outlining on beta Part VII - Business Intelligence Federated Systems Data Warehousing OLAP Part VIII - Administration GUI Tools (To be outlined on release of the GUI for 7.2) Part IX - Application Development Introduction to Application Development Embedded SQL Administrative Application Programming Interface (API) Call Level Interface (CLI) and ODBC Java Support Introduction to Stored Procedures and the Stored Procedure Builder Part X - Availability The Pillars of Availability Setting up FailOver Support on DB2 Advanced Topics of Availability Part XI - Reference SQL Keywords Special Registers Catalog Views System Commands CLP Commands Data Structures