DB2: The Complete Reference - Softcover

Zikopoulos, Paul; Melnyk, Roman B.

Softcover

ISBN 10: 0072133449 ISBN 13: 9780072133448

Publisher: Osborne/McGraw-Hill, 2001

Synopsis

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.

About this title

About the Author

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).

From the Back Cover

The most in-depth guide to DB2 available

Design and manage well-organized DB2 databases and applications using this comprehensive resource. Including details on the new features of version 7.2, this guide covers commands, SQL keywords, administration, data replication, performance tuning, and much more. Find out how to embed SQL in your applications, recover data, and troubleshoot DB2. Also covered are IBM's business intelligence features including data warehousing and OLAP. Written by members of the DB2 development team, this thorough guide gives you an inside look at this powerful and efficient database management system. Whether you're a DB2 application developer or an administrator, this hands-on guide belongs on your desk.

-Create well-designed databases and effectively manage data storage
-Find out how to connect clients to servers
-Replicate, recover, and move data
-Work with tables, understand instances, and control data access
-Use the Create Index Wizard to achieve optimal performance
-Learn about configuration tuning
-Get an introduction to database monitoring and problem determination
-Understand the Administrative Application Programming Interface (API) and the Call Level Interface (CLI)

Edition details

• Publisher: Osborne/McGraw-Hill
• Publication date: 2001
• ISBN 10: 0072133449
• ISBN 13: 9780072133448
• Binding: Paperback
• Language: English
• Number of pages: 1000