Finally the most essential DB2 book for DBAs has been updated for the latest release of DB2: DB2 9 for Linux, UNIX, and Windows: DBA Guide, Reference, and Exam Prep (6th Edition).
Congratulations to both George Baklarz and Paul Zikopoulos! As you may know, Bill Wong was George's co-author for the fourth and fifth editions to this book (as well as one of mine :). Bill had moved to a job in Tivoli, but is now back in DB2... which I'm quite happy about. Paul joined the team and I'm sure that this edition follows the tradition of the previous editions: well-written, easy to read, thorough, and essential!
What can you find in this book? Well, 1136 pages, for starters! As you can tell from the sheer size of the book is that you'll find much more than exam prep details! In fact, I would suggest that you continue to buy / read the Exam Study Guides by Roger Sanders to prepare for DB2 Certification Exams, but buy this book as your way to learn what you need to know, beyond the exams.
The sections of the book that I'd like to draw your attention to include:
1) Security. Although it doesn't cover the topic as thoroughly as Understanding DB2 9 Security does, it does include important security and resiliency enhancements, including advanced access control; fine-grained, label-based security; and the new security administrator role
2) SQL. There is an entire section of the book devoted to SQL. In my mind, there IS no other book you need for SQL beyond this one. Coverage includes pure XML, advanced SQL, and yes, even SQL for beginners. George is somewhat of an SQL expert and creates examples of all sorts to demonstrate a variety of SQL. But, George and Paul rarely rely solely on their own knowledge alone. They are well-connected with the entire development team and the book benefits from additions and reviews by the top experts in the area.
3) Autonomics. Want to make your environment more automatic? Learn about the operational improvements that can enhance your efficiency. Coverage includes self-tuning memory allocation, automated storage management, and storage optimization.
4) Partitioning. Perhaps an advanced topic, but important none-the-less. Learn about the new table-partitioning features that improve scalability and manageability.
5) Development. My dream would be to publish a book for this area alone, but since that isn't in the cards right now, read this book to learn about the powerful improvements for more agile and rapid development, including the new Eclipse-based Developer Workbench and simple SQL or XQuery access to all data.
I plan to work with both George and Paul to further feature unique aspects about their book, so stay tuned.
Interestingly, this book is not on special on amazon.com. I'm not sure why that is, but I'll keep watching to see if they put a sale on this book that matches their usual 37% discount. You may buy the book from the IBM Press websites at a discount:
United States - Use the coupon code DB2SAVE to get 35% off this and other books.Canada - 35% off all IBM Press titlesEMEA - 35% off all IBM Press titles.
IBMers may choose to purchase the book through an Internal Site.
Buy today and keep up to speed on the latest features.
Keep on Learning
The best book to buy right now for a beginner's look at DB2 is the Understanding DB2 book. The one that is available today is for V8.2, but it covers everything that you need to know about DB2 in a very easy to understand way. I like the way the authors added a mini case study at the end of each chapter to solidify the material covered in the chapter. There are also 5 or more study questions at the end of each chapter that can also help ensure that you've grasped the concepts.
The subtitle of the book is "Learning Visually with Examples" and the authors did a fine job of including many diagrams and screen captures throughout the book to make learning a bit more interesting. Check out the positive reader feedback that is posted on the amazon.com site linked above.
Also, I've had feedback from people who were trained on our databases or platforms (Oracle or DB2 for z/OS) and mentioned that they found it amazingly easy to transfer their skills to DB2 Linux, UNIX, Windows with the help of the book.
The newest version of this book comes out in the next month, Understanding DB2 Second Edition so you may want to wait till it is available, or you can buy the 8.2 version now at a reduced price. The best place for a European to buy this book is from Pearson Education EMEA Bookstore where this book is now available for £27.94; free shipping in Europe.
Another site worth checking is our IBM Information Management Bookstore where we have information about a deal where you can get 35% off all IBM Press books ordered before the end of December. Free shipping in the US.
If you're a book lover like me... then you have many bookshelves filled to the brim with books, many of which have been read, but many others waiting to be read. And then there is the inevitable purchase of more books every time you walk into a bookstore! But how can you choose which one is best for you?
If you are looking for technical books, you should try either Safari or Books 24x7 (or really, both!). These online book engines allow you to search across an entire collection of books helping you pinpoint the information that you need RIGHT NOW! If you like, you can simply just continue to search, as you do on Google, and then read the sections that come up. Or you may choose to read the entire book electronically. Your choice.
A few years ago I ran a pilot of Safari in the Toronto Lab. Some of the feedback I received then was that this tool helped them discover a book that they didn't know existed. The person then went to an online bookstore and purchased the printed version of the book. So, not only can you read the entire book online, but you can use these tools as a way to screen / filter the unbelievably large collection of tech books to find what is best for you.
Now is a great time.... as Safari is offering a 10-day free trial to use the tool. If you work for IBM, you should already know that you have a free subscription to Books 24x7. The internal link can be found on the page w3.ibm.com/learning.
So, what's the difference between these two tools? The primary difference is the selection of books. Safari is jointly owned by O'Reilly and Pearson, so you'll find all of their titles in Safari. Books 24x7 typically covers all other books from a variety of publishers. The good news for IBM Press books is that these titles can be found in both.
I hope that you're able to take advantage of these trial offers and that you find the book you need! See our IBM IM Bookstore for the books that I'd suggest.
The DB2 Chat with the Lab series continues. Listen to the DB2 experts, including Sal Vella, Drew Bradstock, Chris Eaton, Pat Bates, Paul Bird, Bill Minor, John Hornibrook, and Les King who develop breakthrough technology and get your questions answered.
Here are some of the topics that you can find:
* DB2 Warehouse 9.5 - What's New in the Platform for High Performance DB2 Analytics* Workload Management in Viper 2* Deep Dive into Deep Compression - a look into Compression in Viper and Viper 2* DB2 for LUW Security Enhancements: Making Database Security Management and Compliance Easier* Viper 2 Features and Open Beta Program* Webcast: Premiering DB2 Express-C: The Truly Free Database* Improved Query Optimization with Statistical Views* Beyond DB2 Viper - Technology Trends and Directions
New chats are added all the time, so keep watching for chats that you can take part in live.
I blogged about IBM DB2 Gaming last month, and when at the IDUG Athens conference last week, I handed out many DVDs that contain these games. I hope all those who received a DVD find it useful.
One of the suggestions I made to the attendees last week is that the games can be suitable for a teenaged audience. I was part of the pilot team and personally taught a classroom full of high-school students using the DB2 Detective Game. I was very pleased to see the awe in the students at the end of the session with comments like "oh, that's a database!" or "SQL is REALLY powerful". I hope you have similar experiences with either teenagers or new employees. Please let me know your experiences.
IBM DB2 Detective GameIBM DB2 Business Game
Congratulations to the authors for completing this book for DB2 Express-C 9.1: Getting Started with DB2 Express-C
Getting started with DB2 couldn't be easier. Read this book to:
* Find out what DB2 Express-C is all about * Understand DB2 architecture, tools, security * Learn how to administer DB2 databases * Write SQL, XQuery, stored procedures * Develop database applications for DB2 * Practice using hands-on exercises * Prepare for the DB2 on Campus exam
This book is ideal for developers, consultants, ISVs, DBAs, students, or anyone who wants to get started with DB2. While this books is focused on DB2 Express-C, the no-charge edition of DB2, the concepts and content are also very applicable to other DB2 editions on Linux, UNIX, and Windows.
Authors of the book include: Raul Chong, Rav Ahuja, and Ian Hakes.
Did you know that Viper 2 brings new capabilities to you as a developer, whether you're using SQL, XML, PHP, Ruby, .NET, or Java™?
As a developer it is difficult to stay on top of what is going on in the industry as technology is constantly changing. Learn how Viper 2 brings new productivity capabilities to you as a developer regardless of what programming environment you are in. In this webcast, you'll get all the details about what's new for developers in the latest release of IBM® DB2® for Linux®, UNIX®, and Windows®.
Grant and Chris will discuss trends in the industry that affect developers and describe what IBM Information Management is doing to help your development. You probably already know that DB2 Express-C is free for developers to develop, deploy and distribute. Now, Viper 2 provides a variety of means that help move your application from the development stage to deployment more rapidly.
New features will be covered in the following areas:
* The latest developer tools * Java development productivity * XML and XQuery * SQL * Database driver support * Web services creation and deployment
Date: November 7, 2007, 11am Eastern (10am Central, 8am Pacific)
* Grant Hutchison, Product Manager, IBM Data Server Clients and Tools * Chris Gruber, IBM >Developer Initiatives
Click here to register for this webcast: Webcast: What is new in Viper 2 for developers?[Read More]
svisser1 2700018UK9 3,155 Views
Roger told me that he had completed this podcast... and today an article about the podcast and a link can be found in the DB2 Advisor from SearchDataManagement.com.
About the podcast:
This 20-minute podcast is relevant to those seeking more information about DB2 9 certifications, as well as to those who are already certified, but who wish to strengthen their resumé with additional certifications. Listeners will:
* Learn about the IBM DB2 9 certification process * Hear how IBM DB2 9 certifications compare to job experience – and whether certifications are worth it for industry veterans * Get information about the potential benefits – both personal, professional and financial-- of IBM DB2 certifications * Find out what an IBM DB2 9 certification really means to an employer and which ones are hot in the job market today * Learn whether it's beneficial to get multiple IBM DB2 certifications
svisser1 2700018UK9 3,145 Views
I've blogged about ILO (Instructor-led online) training before, but I wanted to tell you that we've now added a demo so you can see how it will work. Note that you need to have a flash player installed to view this demo.
Take advantage of our special offer and receive a complimentary headset !
Receive a handy headset to enhance your instructor-led online learning experience. Your headset will be mailed when you enroll in any IBM Information Management ILO course while supplies last.
For those of you who are not yet sure what ILO is... here are the basics:
Let your desk become a classroom. Let the instructor come to you. When you take an online course, do you miss the benefits of being in a classroom: live instruction, hands-on labs and group interaction? Now you don't have to. IBM offers our most popular courses in a new format we call instructor-led online. This format means you get the benefits of being in a classroom with the convenience and cost savings of online training.
How instructor-led online training works
Instructor-led online courses are taught by a live instructor on a specific day and time. These courses are exactly the same as their classroom equivalent, including the course length, content and student materials. You receive the course materials in advance. To participate on the day of the class, all you need is a broadband Internet connection. This allows you to connect to a virtual classroom that lets you interact directly with the instructor to ask questions or clarify the material ... just as you would in a physical classroom.
And since the best way to learn is by doing, you'll have access to the same hands-on labs available in the classroom course. Our Citrix®-enabled lab environment is available 24x7 for the duration of the class. The instructor can shadow you as you work through the lab exercises, provide guidance and address questions or issues.
If your team is geographically-dispersed you can also request that our instructor-led online format be delivered as a private class for your company. This is very cost effective, minimizes travel, and enables you to receive training customized to your unique needs - all with this alternative method of delivering education in multiple locations simultaneously.
Benefits of this format
* No travel costs or travel time * Same content as in the classroom version of the course * Live instructor with whom you can interact and ask questions using Voice Over IP (VOIP) * Modest connectivity requirements let you participate from anywhere * Thin client implementation for easy system preparation * Hands-on labs reinforce concepts learned * Purchasing is even easier with an IBM Education Pack - online account
Many of the IBM Information Management courses are currently being offered in this format, including:
DB2 9 Database Administration Workshop for Linux DB2 9 Database Administration Workshop for UNIX DB2 9 Database Administration Workshop for Windows DB2 9 for Linux, UNIX, and Windows Transition DB2 9 for Linux, UNIX, Windows DBA Certification Crammer DB2 9 for LUW Advanced Database Administration for ExpertsDB2 9 for LUW Advanced Recovery DB2 9 for LUW Quickstart for Experienced Relational DBAs DB2 Data Warehouse Edition 9 Components DB2 Family Fundamentals DB2 for z/OS Data Sharing ImplementationDB2 SQL Workshop DB2 UDB for z/OS Data Sharing Recovery and Restart Informix Dynamic Server 11 Transition Informix Dynamic Server Database Administration: Managing and Optimizing Query XML data with DB2 9 Using Rational Data Architect
svisser1 2700018UK9 3,181 Views
Along the same lines as my last post, I'd like to give you a suggestion as to how you can prepare to pass for Exam 733. We do NOT have a book in the works to accompany the DB2 9 Application Development Exam 733. If you are getting ready to take the exam, here are a few ideas to help you prepare for the test despite the lack of a dedicated book.
Read the book by Roger Sanders: DB2(R) Universal Database V8.1 Certification Exam 703 Study Guide. This book prepares people to pass the V8 Application Development Exam 703. If you want this book... buy it right away. The series of V8 study guides published by IBM Press are considered out of print by the publisher, so the only copies of the book that you can get are the ones that are sitting in inventory. No reprints are possible.
Tip: You may be able to save 35% on the purchase of this and any other books at the IBM Press Bookstore. For a limited time, you can save 35% off your order when you make a purchase at the IBM Press Bookstore on or between October 15, 2007 and December 31, 2007. PLUS you can receive FREE ground shipping in the U.S. To take advantage of this special offer, simply visit the IBM Press Bookstore, select your books and enter case-sensitive coupon code SAVEDB2 at Step 3 during checkout. See IBM Information Management Books for links and details.
Read the IBM DB2 9 New Features book to learn the new functions for DB2 9. I'd pay particular attention to the XML sections.
Exam 733 also has a series of tutorials that were created to help you prepare to pass it: DB2 9 Application Development Certification Exam Preparation TutorialsThis series of nine tutorials has been developed to help you prepare for the DB2 for Linux, UNIX, and Windows Application Development Certification Exam (733). Each tutorial includes a link to a DB2 for Linux, UNIX, and Windows trial download at no charge to you! These tutorials provide a solid base for each section of the exam. However, you should not rely on these tutorials as your only preparation for the exam. After a quick registration, you can begin a tutorial. Each tutorial should take about an hour to complete. You can take the tutorials online, or download a PDF.
For this exam, I recommend that you gauge your readiness by taking the assessment exam.
I've had quite a few people in the Toronto Lab successfully pass Exam 733 using this strategy.