Keep on Learning
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.
Do you ever wonder what everyone else is making, and how your salary measures up? The CertMag’s 2007 Salary Survey was recently released... and guess what? IBM Certified DBAs are on top!
* IBM Certified DBA / Application Developer - $87,390 * Microsoft MCDBA - $78,420 * Oracle DBA OCA - $79,730 * Oracle DBA OCP - $84,520 * Oracle Developer OCP - $78,250
So... if you are working as a DB2 DBA.... I hope you're making this much and are happy that you are on top. If you are not working with DB2 yet.... there is always time to make a conversion.
Craig Mullins also blogged about this news, so make sure you read his perspective as well.
The book DB2 9 for Linux, UNIX, and Windows Advanced Database Administration Certification: Certification Study Guide by Roger Sanders and Dwaine Snow is going through its final tech review right now.... and the reviewers are loving the book! Order your copy now... amazon.com is offering a 37% discount for pre-orders.
This new book is essentially an update to the very successful book that was published to support DB2 V8: Advanced DBA Certification Guide and Reference for DB2(R) Universal Database v8 for Linux, UNIX, and Windows by Dwaine Snow and Thomas Phan.
1) We changed publishers... This book will join the series of V9 study guides published by MC Press. These books are very successful and are excellent resources to prepare people for the V9 cert exams.
2) We changed one of the authors: Roger Sanders teamed with Dwaine Snow... so together they bring their talents to this one book. Roger with his amazing writing skill and the creator of the study guide format that you will recognize throughout his books.... and Dwaine for his deep technical knowledge in the advanced DBA area.
3) Sample questions were added that are similar to the actual exam... along with explanations for the correct answers.
What's the same?
1) Much of Dwaine's content is the similar to the old book... and if the exam doesn't cover certain topics, the content has been included in an appendix of the new book.
2) The first book had 14 5-star reviews... and one 4-star review. Of course there are no reviews of the new book yet... but I'm asking the reviewers to give their feedback so you can see it.
MC Press, publisher of our best-selling cert prep series is offering a really good discount if you pre-order the new Advanced DBA Certification Study Guide.
Expert Preparation for Exam 734DB2 9 for Linux, UNIX, and Windows Advanced Database Administration Certification Study Guideby Roger Sanders, Dwaine Snow
Why do you want this book?
1) The credibility of the authors! Roger has written 17 books about DB2. Dwaine is no slouch himself!
2) Both authors took part in creating the questions for Exam 734. Who else would you want to get study information from?
3) Sample questions.... and more! Yes, the book has sample questions for each chapter... lots of them. And.... you will learn the correct answer and reasons why that answer is correct. Perfect way to learn!
4) Reference beyond the exam... once you've passed the exam, you'll want to refer to this book over and over and over.... for the valuable insight it brings you on advanced topics.
5) No where else can you find this kind of information in a single book. No other book covers the advanced DBA content to this depth.
6) You cannot pre-order from amazon.com.... or likely any other website.
7) If you are planning to attend the IOD conference, you'll want to get this book as early as possible, so that you can pass the exam when taking it at the conference.
Add your own reasons!
If you are a DBA and only want to buy a single book to have as a reference, here's what I suggest:
DB2 for Linux, UNIX, and Windows
DB2 9 for Linux, UNIX, and Windows: DBA Guide, Reference, and Exam Prep (6th Edition)
Written by long time DB2 experts and DB2 evangelists, George Baklarz and Paul Zikopoulos, this book is the reference and guide that you will use over and over as you do your job!
DB2 for z/OS
DB2 Developer's Guide (5th Edition) by long time DB2 expert and consultant, Craig Mullins. This book keeps on selling and selling... so it may be that everyone who works on DB2 for z/OS already owns a copy! If you don't, you should!
Informix Dynamic Server
Administering Informix Dynamic Server: Building the Foundation by long time IDS expert Carlton Doe. At this point, this is the ONLY up to date IDS book that is available! Buy it because it WILL update you on all the changes in the product, but also, the more books that sell, the more likely it is that we'll have more IDS books published!
If you do not find that these books fill your needs... don't worry... we have many others! See our IBM IM Bookstore and the channelDB2.com DB2inBooks discussion group.
Today I received my copies today.... what a great book!
Expert Preparation for Exam 734 - DB2 9 for Linux, UNIX, and Windows Advanced Database Administration Certification Study Guide. This book contains everything you'll need to study for Exam 734 AND is full of reference details that go far beyond the exam!
With this book, you will:
• Gain the knowledge necessary to pass the DB2 9 Advanced Database Administration for Linux, UNIX, and Windows exam (Exam 734)
• Receive an explanation of every topic included on the test…by experts involved in the creation of the actual exam
• Find appendices with information beyond the test requirements on monitoring buffer pool activity, using MQTs, employing advanced joining techniques, and using the Explain Tools.
• Discover over 100 sample questions plus a 120-question practice exam, all with comprehensive answers and explanations
Congratulations to authors Dwaine Snow and Roger Sanders on the release of their latest book!
Thanks also to the team of reviewers who ensured that the book was accurate and had the quality that you demand:
Bob BernardRoger ArchambaultMelanie StopferMatthew RheaDan TuckAdil SardarNick TchervenskiEmilia CifaniSalma ElshatanoufyTariq Al-OmariKevin See
I received amazing feedback from a reader that I want to share with you:
This person took Exam 734 and didn't pass. She asked me for a recommendation, so I gave her an early version of the book on the condition that she would give me feedback. She read the book and tried the exam again... and this time passed. She says the book was essential to her passing the exam!
I can't send out an early version of the book to everyone, but this testimonial is very encouraging to me in my quest have quality, useful books published. I hope everyone who reads the book can say the same thing... and please say it publicly as we all benefit from your feedback.
If you are attending IOD, you can purchase a copy of the book while at the conference for a discount that is offered for attendees.
You can also meet the authors Roger E. Sanders and Dwaine R Snowand have them sign YOUR copy ofDB2 9 for Linux, UNIX, and Windows Advanced Database Administration...on Wednesday Oct 29, 1:30 – 2:30at the Book Signing Area in Bayside Foyer.
Enjoy the book... and make sure you get your copy ASAP... they'll go fast!
I'm not sure where to start today... yesterday was such a momentous day! Obama's inauguration speech inspired much hope around the world (remember, I'm a Canadian and wasn't able to vote).. I can almost feel the change happening around me!
IBM released their 4th quarter results... and guess what? They were fantastic! I'm sure there are lots of reasons for such results, but maybe a part had to do with the Smarter Planet initiative which... again is inspiring change in organizations world wide.
On a much smaller level... let me try to inspire some hope.. and perhaps change.
Craig Mullins recently blogged about Ten Tips for DBAs to Get a Raise based on the article DBAs: Get a Raise! 10 Tips for Success at Review Time by Bob Zurek. When reading the article, I realized that it isn't very difficult to achieve what Bob suggests, especially since my team works tirelessly at providing you the tools that you need.
1. Expand your knowledge beyond the “Big 3” commercial databases to include popular open source database systems.
OK... for starters.. do you know all the "Big 3" commercial databases? If you don't yet know DB2... the best place to start is the book Understanding DB2(R): Learning Visually with Examples (2nd Edition). If you do know all three and are looking for an open source database to learn... look into DB2 Express. Technically it isn't "open sourced", but it is free and easy to use.
2. Get certified.
Now this is an easy one! I've been encouraging people to get certified for nearly 10 years now! We have an excellent program that allows you to go very deep in a technical way. You'll find everything you need on our Training and Certification page. And don't forget the series of certification guides that we have published to help you deepen your skills and pass the exam. See a discussion of the books in the DB2 in Books group on ChannelDB2.
3. Learn about high availability, clustering, and replication.
I don't know of a recent book on replication... but you can learn more about high available with this book: High Availability Guide for DB2 by Chris Eaton and Enzo Cialini. And clustering with this book: DB2 9 for Linux, UNIX, and Windows Advanced Database Administration Certification by Roger Sanders and Dwaine Snow.
4. Enrich your database administration skills with expertise and experience in data security.
Ah... security... it keeps coming up, doesn't it? Here is the best book on the market to help you as a DBA figure out what you need to know: Understanding DB2 9 Security. Rebecca Bond, the lead author, is a DBA and a security expert. Learn from her and her many experiences, including Katrina.
5. Know about data quality and how to implement a data quality and auditing solution in conjunction with your database projects.
6. Drive the adoption of metadata management capabilities across the organization including establishing a metadata business glossary.
For both of these points, I would suggest the book Enterprise Master Data Management: An SOA Approach to Managing Core Information .
7. As a DBA, you might not be writing any application code, but you will need to become a SQL expert over time.
There are many resources available in this area. See my blog entry about SQL resources. Soon a book on pureXML will publish, so stay tuned.
8. Become a member of the customer advisory board of your company’s database vendor.
This item fits loosely in the category of joining a community. See my blog entry on several communities that you might wish to join. Also remember that those who do get involved could get rewarded via the IBM Data Champion Program.
9. Mentor other DBAs in your organization.
See this brand new book for some tips on mentoring: Intelligent Mentoring: How IBM Creates Value through People, Knowledge, and Relationships.
10. Dig into the topic of database analytics.
There are several choices, but my suggestions are the following:
Competing on Analytics by Tom Davenport Managing Your Business Data: From Chaos to Confidence by Maria Villar and Theresa Kushner
Also, I recently watched Baseline's Career Slideshow: 10 Hot IT Jobs for 2009. Again, I was pleasantly surprised to see that I am able to recommend books that may suit a few of these jobs.
1. Business Intelligent Experts
See these two books:
Competing on Analytics by Tom Davenport Managing Your Business Data: From Chaos to Confidence by Maria Villar and Theresa Kushner
5. Enterprise Architects
See this book:
Enterprise Master Data Management: An SOA Approach to Managing Core Information
6. ITIL Managers
Check out this book:
Implementing ITIL Change and Release Management by Larry Klosterboer
8. Security Architects
See this book:
Understanding DB2 9 Security
9. AJAX Developers
In the description for this job, they also mention XML Developers. There will be a book published this year specific to XML, but in the meantime, check out these resources listed in previous blog entries.
I wish you much success in this year of change!
svisser1 2700018UK9 Tags:  security tampa sessions books idug rebecca_bond dba conference 5,967 Views
I asked my wonderful friend Rebecca Bond to give me her
I had to make some REALLY difficult decisions. There are some EXCELLENT speakers and sessions this year.
These are the ones I finally decided to attend. I seriously hope that the ones I am going to miss will be presented at IOD so I can try to attend them then. IDUG has outdone themselves with this line up.
I may look at taking one of the classes on Monday. Just depends on how my writing projects are going and if they have any available spaces left when I make the determination.
I can't decide on which restaurant to sign up for on the Dine Around evening. Several good choices and I want to have dinner with everyone so I think I'll just have to put a blindfold on and throw darts at the sign up board....you might want to warn your readers to steer clear of the sign up board if they see a crazy lady in great shoes start to put on her blindfold.
May 11, 2010
8:00 K01: DB2 INNOVATION: POWERING INFORMATION WORKLOADS FOR SMARTER IT
10:00 S02: DB2 FOR LINUX, UNIX AND WINDOWS - TRENDS AND DIRECTIONS
12:30 D01: CAPITALIZING On DB2 LUW V9.7 Capabilities - A Data Management Feature Presentation
1:45 D02: Varsity SQL for the Busy DBA
3:00 C03: Enabling Oracle Applications on DB2 - an Early User Experience
4:15 D04: A VISUAL TOUR OF DB2 9.7 SQL AND PL SQL ENHANCEMENTS
May 12, 2010
8:30 C05: An Indepth Technical Look at DB2 pureScale
9:45 D06: DB2 SECURITY – AMMO FROM THE TRENCHES -- Presenting
11:00 D07: UPGRADING DB2 9.7 – BEST PRACTICES AND LESSONS LEARNED
1:30 V05: You Killed the ELEPHANTS but MOSQUITOES are Killing YOU!
2:45 D08: STUFFED WITH GREAT ENHANCEMENTS - DB2 9.7 FIX PACK 1 NEW FEATURES
4:00 I01: Data Privacy, Security and Audit Compliance -- Panel Participant
May 13, 2010
8:30 C09: pureScale - Why It's So Much Better than Oracle RAC
9:45 D10: LOCKING - WHAT LOCKING? CURRENTLY COMMITTED AND OTHER LOCK AVOIDANCE ENHANCEMENTS TO INCREASE PERFORMANCE AND THROUGHPUT
11:00 V10: END-TO-END MONITORING & PROBLEM DETERMINATION WITH OPTIM PERFORMANCE SOLUTION
1:30 D11: ENABLING FROM ORACLE TO DB2 COBRA THE EASY WAY.
2:45 F12: DB2 Back and Recovery - What Do I Really Need to Know?
4:00 I05: DB2 FOR LUW - HIGH AVAILABILITY & DISASTER RECOVERY
May 14, 2010
8:30 E13: All the FREE Things you can Do with Data Studio
9:45 E14: Diagnosing & Curing? Lock, Wait and Performance Bottlenecks
11:00 B15: Auditing options on DB2 for z./OS (Moderator)
Thanks Rebecca! I wish I was going so I could attend all these amazing sessions with you!
If you missed my posts in the past week, here's the rest of the IDUG coverage that you can find:
A list of all the IBMers who are presenting sessions.
A list of all the
The educational seminars
Don't forget about the
Check out the bookstore that will be onsite where you can purchase the book that Rebecca wrote:
Thanks to Norberto for accepting my invitation to be a guest blogger on my site today. Norberto was one of our finalists in the DB2Night Show's "DB2's Got Talent" Competition". As in his presentations, you'll find this post very full of incredibly useful information. Norberto was concerned that his post was too long, but I assurred him that it perfect as is. I hope you'll agree.
It’s a pleasure to be here in Susan Visser’s blog today. I’ll talk about the contest, with special focus on my last presentation.
After showing my past tips/lessons learned, I introduced some tips I use daily - which are not specifically related to DB2, but will surely be useful to any DBAs and other people. Here they are:
The Win+M key
After that, I focused on DB2, introducing some technical tips:
After those technical tips, I also gave some educational/networking advice.
Don't overlook the cloud - you can take advantage of it right now! BTW, I met Raul Chong here in Curitiba this week, and he showed us DB2 on cloud in a very nice presentation.
I’m sure all contestants did their best showing their tips and lessons learned. We all have many roles, and finding time to present such info is a really hard task. I confess I went to sleep very late some nights to have my presentations ready!
I’m now in touch with some of the other contestants, and really like the idea of having such highly skilled DBAs in my network. Audience/replay watchers also added me on LinkedIn and started following my twitter and my blog. Thank you all! I’ll do my best to fill my blog with useful information!
I’ll finish saying it was a great pleasure to participate on this contest, and I encourage other DBAs to do the same in the future. I’m sure Scott will want to repeat this success :)
Thanks Norberto! I enjoyed your post very much.
Once again I'll encourage you to
Voter comments about Norberto:
You can see all voter comments on Scott’s Blog.
svisser1 2700018UK9 Tags:  db2 study certification sanders exam dba books objectives 3 Comments 11,036 Views
It’s finally here!
by Roger Sanders
I can’t tell you how many people have asked for this book in the past few years! And look at the great price: Less than $15!
What’s in the book?
What do you need to know to pass the exam?
This is an outline of the Exam Objectives. You can see the details on the website: Exam 541 Objectives
Section 1 - DB2 Server Management (10%)
Section 2 - Physical Design (20%)
Section 3 - Business Rules Implementation (5%)
Section 4 - Monitoring DB2 Activity (15%)
Section 5 - Utilities (15%)
Section 6 - High Availability (20%)
Section 7 - Security (10%)
Section 8 - Connectivity and Networking (5%)
Roger Sanders was featured in the latest edition of the DM Magazine.
The Man to See About Certification - The guru of DB2 certification tests talks about how he puts them together—and how they can help your career
by Howard Baldwin
Q&A with Roger Sanders who has helped IBM develop 17 DB2 certification exams, more than any other individual. Want to know why certification is important? Roger Sanders is the man to ask. We talked to him about how the tests are put together, how they can help a DBA’s career, and—oh yes—about the certification test he failed.
I wrote an entry on my blog some time ago that I still recommend: Certification 101. I do need to update the entry to include the DB2 9.7 exams such as Exam 541, but the content is still accurate in most ways:
Benefits of Earning a Certification
Good luck on your exams!