10 Best Books on DB2 UDB Database

“DB2 for Windows for Dummies” Book Review: This book provides a complete guide to DB2 version 6. It explains how to install the DB2 servers and clients and how to establish a connection between them. Readers will learn how to create their own database and access data from it. The book also covers how to perform typical administrative tasks in a database. Additionally, a trial version of the software is included on the accompanying CD-ROM.

“DB2 9 Fundamentals: Certificate Study Guide” Book Review: This book teaches all the basic ideas of DB2 9 that are necessary to pass the DB2 9 Fundamentals certification exam (Exam 730) and obtain the IBM Certified Database Associate certification. Important subjects like preparing, securing databases, and creating database objects are covered along with the fundamentals of SQL, XQuery, and XML. The book also explains tables, views, and indexes, and advanced topics such as database concurrency are also discussed. The book also includes practice questions and a complete sample exam with 150 questions, and an answer key with clear explanations of the solutions.

“A Complete Guide to DB2 Universal Database” Book Review: This book serves as a comprehensive guide to all the fundamental aspects of DB2 UDB Version 5. Both basic and advanced features of UDB are covered including user-defined data types, recursive queries, stored procedures, constraints, triggers, parallel databases, and graphical tools for database administration. Replete with practical tips and examples, this book is complementary to the IBM product documentation and explains the incorporation of the features of DB2. The book is suitable for end users, application developers, and database administrators who work on the supported interfaces of this software.

“DB2 SQL PL: Essential Guide for DB2 UDB on Linux, UNIX, Windows, i5/OS, and z/OS” Book Review: This book examines the DB2 SQL PL improvements that are introduced as part of DB2 8.2. Additionally, the book analyzes a method associated with DB2 8.2 for resolving performance issues and describes how to monitor and identify bottlenecks and provide alternatives for resolution. Readers also learn to set up the development environment and use all language elements of SQL PL through solid examples and discussions of XML, SQL procedures, stored procedures, and triggers. Tips and tricks as well as best-practices are also included for achieving optimal performance and code manageability. This book is an ideal read for SQL PL code syntax and troubleshooting.

“DB2 9 for Linux, UNIX, and Windows Database Administration: Certification Study Guide” Book Review: This book covers all the fundamental and advanced concepts of DB2 9 required to pass the DB2 9 UDB DBA Certification Test (731) and earn the IBM Certified Database Administrator certification. Readers will learn to effectively implement and administer a DB2 database with XML data along with creating, maintaining, and administering database objects like tables, views, and indexes. Advanced topics like data placement, database access, DB2 activity analysis, server management, DB2 utilities, high availability, security, etc. are discussed in detail. Each chapter contains a set of practice questions with solutions provided by the creators of the exam. About 150 sample questions based on the exam’s format are also provided along with an answer key.

“DB2 UDB for OS/390 Developer’s Quick Reference Guide” Book Review: This book provides a detailed treatment of all utility syntax, DB2 commands as well as SQL syntax including SQLCODE/SQLSTATE with a cross-reference. Layouts for new PLAN, new STATEMENT, and DSN_FUNCTION_TABLE are also provided in this text. The book also covers the entire Catalog Table with column names and descriptions. Advanced topics like DSNTIAR, read-only cursor, Resource Limit Facility, COBOL SQLDA, etc. are discussed in detail.

“DB2 Udb for z/OS Version 8 Technical Preview” Book Review: This book introduces the major changes and enhancements made available with DB2 UDB for z/OS V8. The book elaborates all the functions offered by DB2 V8 and provides the required information to start evaluating their applicability to the reader’s environment. Readers will also learn how to start planning for the installation of DB2 V8 or the migration from DB2 V7. Key improvements such as enhanced scalability, application porting, security architecture, continuous availability, enhanced Java and Unicode support, enhanced utilities, SQL improvements, schema evolution, etc. are also analyzed.

“DB2 Explained for Sybase Professionals” Book Review: This book presents a detailed treatment of DB2 to Sybase professionals by leveraging their Sybase knowledge and experience. The book acts as a map between Sybase and DB2 concepts. The functionality of DB2 tables and how they are different from Sybase tables are also explained. New table concepts such as materialized query tables, replicated summary tables and typed tables are also covered in detail. The book also includes a CBT – DB2 Simulated Training for Sybase Professionals.

“Scaling DB2 Udb on Windows Server 2003” Book Review: This book is a guide on how to scale DB2 UDB V8.1 with Windows Server 2003. The book introduces scalability features of DB2 UDB, Windows Server 2003, and IBM xSeries Servers. It also provides design considerations for scaling and covers running DB2 UDB on 64-bit Windows, installation, configuration, and 64-bit migration techniques. The book discusses scaling up and how to use large memory support in a 32-bit environment, scaling out, and adding logical and physical database partitions. This guide is intended for database and system administrators.