Customer Review

4 of 4 people found the following review helpful
5.0 out of 5 stars An excellent starting point and a good reference guide, 3 Feb 2007
By 
This review is from: Understanding DB2: Learning Visually with Examples (Hardcover)
I started in a new Operations role in a software company that used DB2 as their target database. I had previoulsy used MySQL on other applications but after a short while trying to figure out DB2 I knew that it would take more than online manuals to get a good understanding of the architecture of DB2. I didn't find many books on DB2 (as opposed to the hundred or so for Oracle) but fortunately 'Understanding DB2' is one of the best technical books I've bought.

The first couple of chapters take you through the basics of DB2 such as it's admin and monitoring tools, DB2 environment and even and introduction into database partitioning. The language used is very clear without being overly wordy and the diagrams provide good aids to understanding the structure of DB2.

I was a bit cautious about the 'Learning Visually with Examples' subtitle of the book as I didn't want almost a thousand pages of useless Windows screen shots with little explanation. However the authors have done a good job to ensure all diagrams and screenshots are appropriate. In fact there a less GUI screenshots than you might expect because a lot of DB2 is operated from the command line. It is good that most time was spent with the command line because a GUI are not always available (I work with DB2 on Unix and Windows) and while it's easy to understand the GUI after knowing the command line, the reverse is not true.

I especially liked the practical nature of the book, including the case studies at the end of each chapter which take you through possible real life examples of what you've just learnt. The questions also help to make sure you've understood the chapters.

It should be noted that this is not a book to teach you SQL. While it has a chapter on SQL, this gives you an introduction to many of the commonly used commands. SQL is a big language and is best dealt in a book of it's own. But if you haven't used much SQL before, this book will give you enough to get by so I would rush out to buy a companion just yet.

To be honest, I can't really find a fault with this book. I've read about 2 thirds of it line by line and have used it when necessary to get me out of problems at work. I would recommend this book to beginners and intermediate DBAs. There are a number of references available from the IBM website, but only after gaining a good grounding of the nature of DB2 to these really make sense. And that is exactly what this book provides.
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No

Be the first person to comment on this review.

[Add comment]
Post a comment
To insert a product link use the format: [[ASIN:ASIN product-title]] (What's this?)
Amazon will display this name with all your submissions, including reviews and discussion posts. (Learn more)
Name:
Badge:
This badge will be assigned to you and will appear along with your name.
There was an error. Please try again.
Please see the full guidelines ">here.

Official Comment

As a representative of this product you can post one Official Comment on this review. It will appear immediately below the review wherever it is displayed.   Learn more
The following name and badge will be shown with this comment:
 (edit name)
After clicking on the Post button you will be asked to create your public name, which will be shown with all your contributions.

Is this your product?

If you are the author, artist, manufacturer or an official representative of this product, you can post an Official Comment on this review. It will appear immediately below the review wherever it is displayed.  Learn more
Otherwise, you can still post a regular comment on this review.

Is this your product?

If you are the author, artist, manufacturer or an official representative of this product, you can post an Official Comment on this review. It will appear immediately below the review wherever it is displayed.   Learn more
 
System timed out

We were unable to verify whether you represent the product. Please try again later, or retry now. Otherwise you can post a regular comment.

Since you previously posted an Official Comment, this comment will appear in the comment section below. You also have the option to edit your Official Comment.   Learn more
The maximum number of Official Comments have been posted. This comment will appear in the comment section below.   Learn more
Prompts for sign-in
 


Review Details

Item

5.0 out of 5 stars (1 customer review)
5 star:
 (1)
4 star:    (0)
3 star:    (0)
2 star:    (0)
1 star:    (0)
 
 
 
Used & New from: £5.51
Add to wishlist
Reviewer


Location: UK

Top Reviewer Ranking: 5,207,407