DB2
The Complete Reference
Published on 1. January 2001
Book
Paperback/Softback
1000 pages
978-0-07-213344-8 (ISBN)
Description
DB2 is the number two database server next to Oracle and is a highly underpublished area. Written by two members of IBM's DB2 team, this title provides an inside and first look at this version. It should appeal to both administrators and developers as it provides comprehensive coverage.
More details
Series
Language
English
Place of publication
New York
United States
Publishing group
McGraw-Hill Education - Europe
Target group
College/higher education
Professional and scholarly
Illustrations
250ill.
Dimensions
Height: 235 mm
Width: 183 mm
Weight
1780 gr
ISBN-13
978-0-07-213344-8 (9780072133448)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Persons
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).
Content
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