|DB2 V9 for z/OS Certification Guide - Systems Administration – Test 737 (MC Press)||Judy Nall||2010|
|DB2 9 Database Administration Certification Study Guide for Exam 732||Susan Lawson and Daniel Luksetich||2008|
|DB2 9 Advanced Database Administration Certification Study Guide for Exam 734||Roger Sanders, Dwaine Snow||2008|
|DB2 9 Fundamentals Certification Study Guide||Roger Sanders||2007|
|DB2 9 Database Administration Certification Study Guide for Exam 731||Roger Sanders||2007|
|DB2 9 Database Administration Upgrade Certification Study Guide for Exam 736||Roger Sanders||2007|
|DB2 9 for Linux, UNIX, and Windows: DBA Guide, Reference, and Exam Prep (6th Edition)||George Baklarz, Paul Zikopoulos||2007|
|Raul Chong, Ian Hakes, Rav Ahuja||2009|
|Getting Started with IBM Data Studio for DB2 (Part of the DB2 On-Campus Series) (ebook)||By Debra Eaton, Vitor Rodrigues, Manoj Sardana, Michael Schnenker, Kathryn Zeidenstein, Raul Chong||2009|
Keep on Learning
svisser1 2700018UK9 4,314 Views
In addition to the books listed in my previous post, I also have these books. Right now they are in a separate list... and for the Certification Study Guides, even on a different tab than the rest of the DM books. I wonder if this is the best way to present the books. Your suggestions?
svisser1 2700018UK9 4,184 Views
I hope you are aware that we have a Bookstore website where we showcase the books that are related to IBM's Information Management products. Nicole from my team is in the process of redesigning the site and has asked me to update the content. I'm glad we're doing this as I noticed that there are quite a few changes that are needed!
I'd like to ask for your help to make sure that I have the right set of books listed in each of the categories. Today's post is for the Data Management area. Let me know if you think there are books that should be deleted from this list or if there are some that you think should be added.
I'll be posting more lists in my blog each day until I'm finished.
Thanks for your help!
The DB2Night Show Episode 14: 12 March 2010
Back by popular request, the DB2Night Show is doing another CRUNCHING THE NUMBERS episode wherein a live performance health check will be performed for a real DB2 LUW production database. If you would like to see how this works, watch the replay of Episode #9.
Obviously, to make this show successful and educational for participants, YOUR snapshot data is needed! If you would like a free performance health check analysis completed for your database, please send the text outputs (in a zip file) from these commands to db2nightshow at dbisoftware .com:
* db2 get snapshot for database on DBNAME
* db2 get snapshot for bufferpools on DBNAME
* db2 get snapshot for tablespaces on DBNAME
* db2 get snapshot for tables on DBNAME
As you will see in Episode #9, care will be taken to not reveal the organization that provides the data - your contributions will be anonymous unless you specifically request to be identified.
One studio audience member will be randomly selected to win an Amazon.com gift certificate - use this towards a new USB thumb drive, a new book, or anything you like!
I've been posting information about the DB2 Certifications in the past couple of weeks and am very pleased with the interaction I've been receiving on several LinkedIN groups that I'm a member of. The two most active groups that I posted information in were DB2 Professionals and IDUG The World Wide DB2 User Community.
A couple of the comments were about how difficult the Advanced DBA exam was. Here is my response that I want to share with everyone:
Join Sal Vella and Matt Huras from the Toronto Lab to learn how to leverage the latest DB2 for LUW features such as DB2 pureScale and Storage Optimization. Sal and Matt will be broadcast in high definition directly to select IBM Technical Exploration Centers across North America.
Date: March 12, 2010
Time: 12:30pm to 3:30pm EST
Location: IBM Technology Exploration Centers across North America
12:30pm – 1:00pm Welcome
1:00pm – 2:00pm Break Free with DB2,
2:00pm – 3:00pm DB2 pureScale
3:00pm – 3:30pm Refreshment Break
3:30pm – 4:30pm DB2 Storage Optimization
Where you can attend:
San Francisco, CA;
Costa Mesa, CA
This event is the first that I've heard of that is using the IBM Technology Exploration Centers which are high-quality facilities across North America that allow our customers to explore IBM software technology and collaborate with our subject matter experts.
ABOUT THIS EVENT:
Attend this seminar to learn how to leverage the latest DB2 for LUW features such as DB2 pureScale and Storage Optimization. DB2 pureScale provides unlimited capacity, continuous availability and application transparency. It delivers levels of database scalabililty and availability previously unmatched on distributed systems. The DB2 Storage Optimization Feature gives you the ability to transparently compress data on disk in order to decrease disk space and storage infrastructure requirements.
WHO SHOULD ATTEND:
This event has 3 hours of content, and has been organized to be of interest to database administrators, data architects, and anyone who has an interest in running OLTP systems without having to worry about changing their application code when adding system capacity. Interested in Active-Active? Come and learn more.
Sal Vella is the Vice President, Development, Distributed Data Servers and Data Warehousing based in the IBM Canada Laboratory in Toronto, Canada. In this role, he is responsible for the world-wide development of DB2 for Linux, UNIX and Windows and for solidDB.
Matt Huras, Distinguished Engineer, is the lead architect of the DB2 pureScale feature. Matt has had extensive experience with DB2 for LUW storage engine, including indexing, data management, buffering, memory management, threading and scheduling, utilities and high availability.
Thanks to event organizer Lily Ryzebol for this information.
I've already given you many reasons why I'm a huge fan of Rebecca Bond's, but did I tell you about her brillance at coming up with cool analogies or her incredible sense of humour?
Read Rebecca's latest article IBM DB2 9.7, DBADM and my Rubik's Cube published in the Feb 19, 2010 edition of Database Journal explains the changes to DBADM autthority in DB2 9.7 and twist by twist, helps you understand the changes and how to benefit from them. Wonderful article, Rebecca!
If this article is leaving you wanting more Rebecca, you're in luck! Her website has just gone live, so you can easily find out more about Rebecca and what she's up to... but best of all, you can read her blog entries.
I've had a few people ask me about assessment exams lately, so I thought this would make a good blog entry.
My most viewed blog entry to date is
With this checklist, you can track your progress on following the steps required to earn a certification. One of those steps is called Assess. Studying can take a lot of time and energy, and certification exams are usually $200!...so how can you make the most of your time and money?
1) Take an assessment exam for $10 (USD) to find out if you are prepared and if not, where to focus your studying.
2) Use one of the published Certification Study Guides.
DB2 9 Fundamentals Certification Study Guide by Roger Sanders
DB2 9 Database Administration Certification Study Guide for Exam 731 by Roger Sanders
DB2 9 Database Administration Certification Study Guide for Exam 732 by Susan Lawson and Daniel Luksetich
DB2 9 Database Administration Upgrade Certification Study Guide for Exam 736 by Roger Sanders
DB2 9 Advanced Database Administration Certification Study Guide for Exam 734 by Roger Sanders and Dwaine Snow.
All five of these certification prep guides were written by members of the exam development team. That is, they created the questions for the certification exam that you are about to take! Also, each chapter of the book corresponds directly to a section on the exam. So, if you take the assessment exam and find out that you are week on a single topic, you simply need to read the chapter that corresponds to the topic where you need improvement. Lastly, the authors created a set of sample questions for the book that provides you with the correct answer to the question as well as an explanation as to why the correct answer is correct and the incorrect ones are not.
For reference and guidance beyond the exam, I suggest the following: DB2 9 for Linux, UNIX, and Windows: DBA Guide, Reference, and Exam Prep (6th Edition)
by George Baklarz and Paul Zikopoulos
All six of these books... and many more, can be read and searched electronically. Safari Online and Books 24x7 are two popular electronic book engines where these books are available. Why would you want to read a book electronically? You might not want to read an entire book electronically, but if you are browsing books to find out which one you should buy in print, searching and reading parts of the book electronically makes sense and may help you make the best choice on your purchase.
Also, if you are mostly prepared for the exam, but just want to do a bit of review before taking the exam, you might consider doing the review electronically. At the very least, I'd suggest reading the summary for each chapter, answering the sample questions that are found in the book, and reading the description for the answers. This can be done quite easily electronically.
Safari Books Online is a great electronic book engine and right now, you can receive a free 15-day trial. With Safari Books Online, you can search for a particular keyword, read the entire book cover to cover, or simply ensure that this is the book you need before you buy the printed version. Hurry! This offer has been held over until the end of 2009.
Books 24x7 is another great electronic book engine. IBMers world-wide can access books via this engine, free of charge. You can reach the site through many internal home pages. Many other companies and schools also have subscriptions to Books 24x7. Check with your company to see if you have a free subscription.
Be prepared for your exam... and good luck!
I'm sorry that I missed the fact that there IS a fee for the Crammer courses. Please see the CORRECT information below. I'm sorry for any confusion I may have caused. Thanks to Bryan for pointing out my mistake in this matter.
IDUG Pre-Conference Educational Seminars
The 2010 Pre-Conference Educational Seminars are:
IDUG's annual North American conference is taking place in Tampa Florida this year. May 10 - 14, 2010. Have you been able to get funding to attend the conference yet? If not, maybe this information will help you.
The educational opportunities available at the conference will help make you smarter! And if you're smarter about your job, you'll be more effective, make fewer mistakes and be a real asset to your employer! Right?
Take a look at the conference schedule that is now available online. With this tool, it is now easier for you to build your conference curriculum by allowing you to search by program or project to find sessions specific to your area of expertise.
Here is a sample of the sessions you’ll find this May in Tampa:
D06 (DB2 for LUW): "DB2 Security – Ammo From the Trenches", Rebecca Bond, Author of "Understanding DB2 9 Security"
B10 (DB2 for z/OS): "Package Versioning for High Availability", John Maenpaa, Health Care Service Corporation
C08 (DB2 for LUW): "Successfully Managing the DB2 LUW Workload Manager", Scott Hayes, Gold Consultant, DBI Software
C09 (DB2 for LUW): "DB2 pureScale: Why It's So Much Better than Oracle RAC", Paul Zikopoulos, IBM Corporation
S03 (Cross-platform): "The Vision of Integrated Data Management - Past, Present and Future of Tooling", Curt Cotner, IBM Fellow, IBM Corporation
New this year at IDUG, you will also find a full-offering of hands-on labs. Available all four days of the conference, the labs include individual work-stations that allow you to explore new DB2 features and try out products without the hassle of obtaining and setting up software. This year’s hands-on labs include:
DB2 Lab 1: DB2 for LUW - All About DB2 9.7
DB2 Lab 2: DB2 for z/OS - Getting Started with DB2 for z/OS pureXML
DB2 Lab 3: DB2 for LUW - DB2 9.7 Performance Metrics and Monitoring
DB2 Lab 4: DB2 for z/OS - Develop High-Performance Java Applications on z/OS Using IBM pureQuery
DB2 Lab 5: DB2 for LUW - Workload Management
DB2 Certification Exams:
Do you have your current certifications yet? The exams are available free of charge to attendees of the conference (3 exams per attendee). This is a HUGE savings of $200 PER EXAM!
Make sure you are ready to pass the exam by taking a crammer course on May 10 for last-minute preparation for the exam. These full day seminars require an additional fee.
Z04: DB2 for Linux, UNIX and Windows - DBA Certification (541) Preparation Course
Date: May 10, 2010 09:00 AM – 04:30 PM
This training is designed to introduce the student to the concepts a test candidate must know in order to take and pass the DB2 9.7 DBA for Linux, UNIX and Windows certification exam (Exam 541). The material for this course is aligned with the 541 exam objectives.
Z01: DB2 9 for z/OS DBA Certification Crammer Course
Register now to qualify for discounts on your conference fees:
Early Bird Discount: Register on or before March 26, 2010 and save $150 on your full-conference registration.
IDUG Mentor Program: Need to get thrifty with your training dollars this year? Through this incomparable loyalty reward program, IDUG members who have attended five or more IDUG conferences in the past ten years have the opportunity to bring a first-time attendee from the same company for an unprecedented 80% discount!
Visit IDUG.org/na to learn more about IDUG 2010 North America.
Do you need more help justifying your attendance at this confernece? See IDUG.org/na for further tips.
Thanks to everyone who joined me on Friday while I presented on the DB2Night Show: The Wild Wonderful World of DB2 Information Resources. If you missed the show, you can catch it in reruns.
I have now posted my slides.... and have added back the one that I discovered was missing during the show.
You can find the slides on developerWorks as a public file.
I've also posted them on ChannelDB2.com.
You may need to join these sites if you are not yet a member. If you do join, remember to make me your friend! I can never have TOO many friends!
Join me (as Scott's special guest) on Feb 12 at 11 am EST on
Books, websites, podcasts, training options, tutorials, certification, white papers, social networking and more!
My webinar will be recorded if you can't make it to my session. Also remember that Paul Zikopoulos is Scott's guest next Friday, Feb 19.
I was planning to blog about IBM's Academic Initiatives today, but while doing research I keep being reminded about how important it is to have excellent writing skills.
In the Certification Magazine in the article "Buzzwords your Resume Doesn't Need" I read the following:
Written skills are becoming more and more important for IT professionals to possess, especially as tech workers communicate with others throughout the organization on projects and proposals. But as the old saying goes, show, don’t tell, the hiring manager about your abilities. Demonstrate with your resume and cover letter that you know how to get your ideas across on paper — or on the computer screen — through clear and concise writing and by carefully checking for any typos or grammatical errors before submitting your application materials.
Yesterday I attended a web seminar called "Unwritten Rules: What You Don't Know Can Hurt Your Career" and found that communication is very important in career advancement. Communication in this presentation was largely focused on discussing your expectations with management regarding your career advancement options and expectations, but communication to gain visibility was also a key point. Tell people what you have accomplished and get noticed by writing well.
Then of course Jeff Jonas making the following plea on facebook: "Note to universe: emails over 200 words are very hard to find time to read. Do summarize!"
My favourite was the Macleans article "Do your prof a favour; Write Better!"
A few weeks ago I was invited to be a guest lecturer to a Masters of Computer Science class at York University about how the can improve their writing skills. This is my second time delivering this presentation that was created by Roger Sanders who is also writing a book about the same topic. The presention is entitled "The Art of Technical Writing" and the book will be published this year by MC Press. I don't see a link on the web for this book yet, but will be sure to tell you about it when it is released.
I won't tell you everything that I passed onto the students, but here are a few general guidelines:
1) Go as deep into your TOC or outline as you can... before you begin writing. This will ensure that you have a plan and can help prevent writer's block.
2) Keep your audience in mind when creating the outline and as you write. I guess I should have said "define your audience" first as this is a key step. Don't fall into the trap that what you are writing will appeal to EVERYONE! It won't... and shouldn't.
3) Don't try to impress with a large vocabulary or difficult sentences. Even sophisticated readers like to read concise, well-written sentences rather than complicated words and sentences where they may have to read them twice to get the proper meaning.
4) Vary the size of your sentences. Some long, some short. If you do all the same, it may be boring to read.
5) Avoid the passive voice... stay active. This can be hard to do.
6) Review your own work. Read what you wrote... out loud to yourself, out loud to others, have the computer read it to you... whatever it takes. If you hear the words spoken you can easily spot the parts that are difficult and need revision.
7) I like Roger's recommendation to reveiw your manuscript several times, each time with a specific purpose. For example, read through looking for where you used the passive voice and fix those. Then review again for grammar. Then to make sure lists and headings are parallel. Then to ensure that diagrams and tables are properly labelled. And on and on. It is easier to be consistent if you look for specific problems each time through your manuscript.
8) Be sure that you need to include a diagram or table before including it. I tend to skip diagrams and tables unless it makes it much easier to understand the concepts that are being discussed. I've heard other people admit to skipping them as well. Don't include diagrams and tables as filler.
9) Have someone else (or several other people) review the manuscript for you. When you get feedback... do not take it personally. Your reviewer is NOT critisizing you as a person... but is giving you feedback to improve what you wrote. You don't have to make all the changes that are recommended to you, but do take the feedback seriously. If you don't get feedback at all.. don't assume what you wrote is perfect. It never is! All authors have been shocked to find simple errors in their books even after they were reviewed endlessly by experts.
10) Learn from your mistakes and actively look for ways to improve your writing skill. Writing is a skill and can be learned by paying attention and learning from your mistakes and from others. I strongly encourage you to read Roger's book when it publishes as it will help you in ways that you can't yet imagine.
While I'm on the topic of writing, I should point out that my job is Publishing Program Manager for IBM Information Management. I'm happy to say that I am continuously meeting people who have a desire to write a book. I can help you with that goal if it is one of yours. The first thing you'd want to look at if you are interested in writing a book is this site that gives help on writing a proposal for your book: Proposal Guidelines.
Writing is an important skill for you to have, regardless of your career, so I hope I've helped on some small way to encourage you to continually improve this skill.
If you're reading this blog entry, then you're probably knee deep into the social networking that is available. Personally I'm very much into social networking and can't remember what I did before these tools were available.
In this entry I give details on the sites that I am aware of ... and use on a regular basis. I know my list is not complete... so if there is something that you think I should be aware of, please let me know!!
There are so many blogs these days with more being added all the time.... so how can you find the best blogs to read? I suggest that you use aggregator sites where you summaries of many blog entries so you can choose which appeal to you the most. For the IM world the best place to go is PlanetDB2.com. My blog is there as well as blogs from Kate Dawson, Leon Katsnelson, Chris Eaton, Craig Mullins, Grant Hutchison, and many many more! Of course once you begin reading some of these blogs, you can become a fan and can get the entries sent to you directly through RSS feeds.
For a broader range of topics, I suggest looking at the developerWorks blogs. My blog is hosted by developerWorks, so you can find it there as well, but you will find many interesting entries on a wide range of topics.
The difficult thing about Facebook is whether to use it for personal or business reasons. There seems to be quite a few lines being crossed which may cause discomfort for some people. For most of us who write blogs and have Facebook accounts, we automatically pull our entries into our Facebook profile. There are many product fan pages that you can join as well including many from IBM. Some groups you can join are:
I've always had a LinkedIN account for business reasons but only recently have I started to use the groups that are available. I've been very impressed with the amount of interaction taking place in these groups. My only regret is that I don't have enough time to read all the articles that I'm interested in! One of the pros about LinkedIN is that you could separate personal from business by keeping Facebook for personal uses and LinkedIN for business purposes. There are at least two levels available when joining LinkedIN. I have the basic membership and find it incredibly useful. Here are some groups that I like:
This is such a rich site, it is hard to figure out where to start! You can make connections with other devWorks users and create a profile for your personal accomplishments. There are many groups and communities that you can join. I mentioned the wide variety of blogs that are available. The richness of devWorks lies in the content that you can access. Tutorials, Skills Kits, ekits, articles, videos, checklists, downloads, and much more. developerWorks covers a huge variety of topics that covers every software brand and technology that IBM cares about. To find something specific, use the amazing search engine in developerWorks to find what you need. Join developerWorks and then check out these groups:
I call this site a hybrid of many of the sites listed above. It calls in the blog entries from PlanetDB2.com; you can have a network of friends like Facebook; there are groups that you can join to discuss topics with other interested parties like LinkedIN; you'll find a collection of presentations, videos, and links like developerWorks. One thing that is unique about this site is the amount of representation from academic environments. You can find groups for specific countries as well as specific universities. Here are a few of the groups that I follow:
This is the one piece of social networking that I do not use. I understand how powerful it can be, but just don't think that I have the time to get involved with tweeting at this time. Here are a few that I've heard of:
Books on Social Networking
Like all popular topics, you can find a book to read that can teach you how to go deeper in any or all of these topics. Here are a couple of recent titles from IBM Press that you may find interesting:
Reminder: Join me on the DB2Night Show... Friday, Feb 12 at 11:00 EST. The DB2Night Show Episode #12