The Easy, Visual Guide to IBM DB2 V8.2

IBM DB2 Universal Database™ V8.2 for Linux®, UNIX®, and Windows® is a flexible, scalable, cost-effective, and easy-to-use enterprise database. Now, one book makes DB2 even easier. Understanding DB2 teaches DB2 V8.2 visually, step by step, with dozens of examples and case studies drawn from the authors' unsurpassed experience as DB2 consultants at IBM.

Understanding DB2 doesn't just present the big picture. It thoroughly introduces every DB2 concept, procedure, and tool you'll need to get results as an administrator, user, or developer. You'll find authoritative coverage of installation, configuration, objects, database instances, storage, connectivity, security, performance, backup and recovery, SQL fundamentals, and much more. Virtually every new concept is explained with screenshots, diagrams, or tables, all designed to help you learn faster and remember more.

For those preparing for certification, this book also contains over a hundred sample questions crafted by the authors to reflect the content and format of the IBM DB2 UDB Database Administration Certification exams, with answers and detailed explanations.

Coverage includes

• Understanding the DB2 product family, DB2 commands, and the DB2 environment

• Configuring client and server connectivity: walkthroughs of four typical scenarios

• Managing DB2 storage: partitions, tablespaces, buffer pools, and more

• Leveraging the power of SQL: queries, inserts, deletes, and updates

• Implementing security: encryption, authentication, and authorization

• Administering and maintaining data, from LOAD and EXPORT to backup/recovery

• Providing high availability with online split mirroring and suspended I/O

• DB2 architecture: process and memory models

• Managing database performance and troubleshooting

Amazon.com® Reader Reviews (Ranked by Helpfulness)

Average Amazon.com® Rating:  Based on 22 Ratings

Disappointed - 2008-09-20
Reviewer Rating:
I bought this book solely on the strength of the positive reviews here (stupid, I know). Unfortunately, my opinion doesn't most everyone else's. I needed a book that would give me a quick look at using DB2 SQL as an application programmer. This book devotes 1 chapter to SQL, and the information is very basic. The rest is study guide stuff (architecture, DBA stuff, etc.) that simply isn't very helpful to someone trying to learn how to actually work with the database. I come from an Oracle background, and the transition to DB2 is anything but instinctive or easy. It's a real pain, actually.
If anyone knows of any good, practical DB2 books for database/ETL programmers, I would love to hear about them.
Thanks,

bk

Excellent Book for DB2 !! - 2008-05-16
Reviewer Rating:
This is an excellent book for DB2 if you are a beginner or even an intermediate skilled user. This book covers not only DB2 9, it covers DB2 9.5 and the facts that pertain only to v9.5 are duly bulleted/annotated with the version number. This book treats DB2 from a DBA point of view so the SQL examples are pretty basic if you are a hardcore SQL programmer. If you are looking only for SQL programming for DB2 this is not the book to buy. But for an administrator, this is one of the best reference books on the desk. Since this book has lot of visual examples, you see what the authors are talking about rather than forming a mental image. Also, it covers XML/XQuery in DB2 in detail. Moreover, this book is an excellent reference if you are taking certification in DB2.
If you are on the lookout for the one book that will kickstart your DB2 career; this is the one.

Excellent DB2 Resource - 2008-08-06
Reviewer Rating:
this book is an excellent information source for both professionals in need for a reference on a db2 topic/ students trying to get into db2 / certification hunters interested in ibm 730 exam db2 administrator for V9 .
very well written.

awesome book for any db2 dba - 2008-05-11
Reviewer Rating:
if you looking for a db2 beginners book...its a right choice...even if you are a exp. dba, this book can come handy anytime for any reference or as a guide..

Great book for learning Db2 - 2008-03-06
Reviewer Rating:
If you are new to DB2 this is the book you need.
It covers all the basic information you need to start working with db2, in a easy way.
If you also want to get certified get the DBA guide or one of Sander's book, and you are all set to go.

Browse Similar Topics

Top Level Categories:
Databases

Sub-Categories:
Databases > DB2