Keep on Learning
If you are trained on a database management system other than DB2, we have many resources available that can help you expand your skills to also include DB2. I've been told that it is quite easy to learn DB2 after Oracle or MS SQL Server have been mastered.
Why would you want to learn DB2? You may wish to broaden your skills to make you more marketable in case you are affected by your company downsizing. Perhaps your company will choose to install DB2 in addition to your current database system, or instead of your current system. Maybe you'll try using DB2 and prefer it to your current system because of specific features or due to ease of use. Whatever the reason, we have the resources for you. Please note that many of these resources are FREE.
For starters, I would like to thank Amyris Rada for helping me make this information as complete as it can be! Some of the articles that I'll be mentioning were written by Amyris and she has plans to use her talents in this area for future projects, so stay tuned.
DB2 Universal Database versus Oracle data movement
A comparative guide
Leveraging your Oracle 9i skills to learn DB2 UDB for Linux, UNIX and Windows V8
IBM DB2 UDB versus Oracle backup and recovery
A comparative guide
Converting Oracle Pro*C Programs to DB2 Universal Database
Migrating Recursive SQL from Oracle to DB2 UDB
Using DB2 routines to ease migration
Truncating tables, getting the client's host name, and calling stored procedures from UDFs
Oracle to DB2 UDB Conversion Guide
This IBM Redbook is an informative guide that describes how to migrate the database system from Oracle to DB2 UDB Version 8.1 on AIX, Linux, and the Microsoft Windows platform. This guide presents the best practices in migration strategy and planning, migration tools, and practical migration examples. It is intended for technical staff who are involved in an Oracle to DB2 UDB conversion project.
This redbook provides migration planning guidelines, with step-by-step instructions for installing and using IBM Migration Toolkits (MTK) to port the database objects and data from Oracle to DB2 UDB. It illustrates with examples how to convert the stored procedures, functions, and triggers. Application programming and conversion considerations are discussed along with the differences in features and functionality of the two products.
In addition, you can find script conversion samples for data loading, database administration, and reports, which are useful for DBAs. The testing section provides procedures and tips for conversion testing and database tuning.
SQL In A Nutshell, 2nd Edition
by Kevin Kline, Daniel Kline, Brand Hunt
This invaluable desktop quick reference drills down and documents every SQL command and how to use it in both commercial (Oracle, DB2, and Microsoft SQL Server) and open source implementations (PostgreSQL, and MySQL).
Understanding DB2(R) : Learning Visually with Examples
by Raul F. Chong, Clara Liu, Sylvia F. Qi, Dwaine R. Snow
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.
DB2(R) SQL PL : Essential Guide for DB2(R) UDB on Linux(TM), UNIX(R), Windows(TM), i5/OS(TM), and z/OS(R) (2nd Edition)
by Zamil Janmohamed, Clara Liu, Drew Bradstock, Raul F. Chong, Michael Gao, Fraser McArthur, Paul Yip
DB2 SQL PL, Second Edition shows developers how to take advantage of every facet of the SQL PL language and development environment. The authors offer up-to-the-minute coverage, best practices, and tips for building basic SQL procedures, writing flow-of-control statements, creating cursors, handling conditions, and much more. Along the way, they illuminate advanced features ranging from stored procedures and triggers to user-defined functions. Whether you're developing new SQL PL applications, migrating or tuning existing applications, or administering DB2, you'll find this book indispensable.
IBM MTK Toolkit Web
The IBM DB2 Migration Toolkit helps you migrate from Oracle (versions 7, 8i and 9i) to DB2 UDB V8.1 and DB2 V8.2 on Windows, UNIX and Linux.
Sample Database Migration Tutorial Using IBM DB2 Migration Toolkit
Automate the Switch to DB2 Using the IBM DB2 Migration Toolkit
The no-charge IBM DB2 UDB Migration Toolkit can simplify and improve your migration to DB2 Universal Database (DB2 UDB). This migration utility provides a wizard and an easy-to-use interface with only five steps to help you quickly convert existing Sybase, Microsoft SQL Server, Oracle, and Informix database objects to DB2 UDB.
There are a number of DB2 UDB Porting Guides and other documents available to assist you in moving your database and application from its existing DBMS to DB2 UDB.
DB2 Sample UDFs for migration:
PS: We have resources for those using SQL Server, Sybase, and other products, but I felt that I should cover those in a separate post.
Discover the best practices for IBM DB2 for Linux, UNIX, and Windows. Get practical guidance for the most common DB2 9 product configurations and use this knowledge to improve the value of your DB2 data servers.
Notice that updates and additions were made recently:
"Database Storage" (October 2008) Updated!Discover best practices for database storage including guidelines and recommendations for spindles and logical unit numbers (LUNs), stripe and striping, transaction logs and data, file systems versus raw devices, Redundant Array of Independent Disks (RAID) devices, registry variable and configuration parameter settings, and automatic storage.
"Physical Database Design" (May 2008)Learn about all of the design features that relate to the physical structure of the database such as datatype selection, table normalization and denormalization, indexes, materialized views, data clustering, multidimensional data clustering, table (range) partitioning, and database (hash) partitioning.
"Information Modeling with Rational Data Architect Version 7" (October 2008) New!Discover the best practices for information modeling based on the experiences of a team of data modelers using Rational Data Architect with DB2. Rational Data Architect is an information modeling tool that can help you establish and use standards in design based on proven design methodologies to create highly reusable models that satisfy business requirements.
"Data Life Cycle Management" (October 2008) Updated!See the best practices to design and implement scalable solutions that facilitate the continuous feed or roll-in and roll-out of data, with minimal interruption of data access.
"DB2 High Availability Disaster Recovery" (October 2008) New!Get recommendations for setting up and maintaining a DB2 High Availability Disaster Recovery (HADR) environment in ways that balance the protection HADR provides with performance and cost. This best practice explains optimizing for fast failovers, tuning parameters for network and logging performance, and understanding table reorganization methods and load operations in an HADR environment.
"Tuning and Monitoring Database System Performance" (October 2008) Updated!See best practices for the performance evolution of a Data Server. From important principles of initial hardware and software configuration to monitoring techniques that help you understand system performance under both operational and troubleshooting conditions. For troubleshooting performance problems, this paper provide a step-wise, methodical method for determining the problem.
"DB2 Workload Management" (October 2008) New!DB2 Workload Management helps prevent, detect, and resolve conflicting resource requirements on a DB2 data server based on defined business objectives. This paper details the current best practices for DB2 workload manager.
Another 200 exams taken on the second day of the conference! That brings our two day total of exams given to 400! We appear to be on our way to breaking our previous record of conference exams.
Lots of action in the bookstore as well. Many people are choosing to purchase one of the Sanders study guide or the certification guides rather than paying $10 to take an assessment exam. The study guides have a set of assessment questions that explain reason an answer is correct. This may be more helpful to prepare for the exam than taking the assessment exams on their own.
Another observation: For those of us in Canada, we're used to having two prices on any book we purchase: a US price and a Canadian price. These prices are set when the book cover is produced and the Canadian price is set based on the exchange rate at that time. Several of our very popular books were published 3 years ago when the Canadian dollar was very low compared to the US dollar. As a result, a $50 book in the United States costs $90 in Canada. The current exchange rate is about 20%, so these prices are very much out of whack. Unfortunately prices are not changed until a new edition is published, so the Canadian buyer must pay the price listed on the book. One way around this is for Canadians who are attending the conference to purchase the books while they are here. They will need to carry the book back with them, but they will pay the US price and get a 30% conference discount. So that $50 book will cost $35 US plus the exchange rate, so about $45 Canadian. What a great deal!
Yesterday morning I administered exams at the Content Management Techical Conference which is being held at the Swan. Business is slower here, but there is lots of interest in the new Content Management Exam 443: DB2 Content Manager V8.3. There was a course in the evening from 6:30 - 9:30 to help people prepare for this exam. I'll let you know tomorrow if that changes the results at all.
That's all for now. Back to networking with people at the conference.
svisser1 2700018UK9 4,005 Views
Join us for this webcast that will help you understand where DB2 is headed in the future...
IBM DB2 Chat with the Lab - Thursday, April 12th at 11 AM Eastern, 10 AM Central, 8 AM PacificBeyond DB2 Viper - Technology Trends and Directions
The next offering in IBM's Chat with the Lab series will feature Sal Vella, Vice President of DB2 Development for Linux, Unix and Windows and Les King, Program Director of the Data Services Portfolio, who will talk about the next release of DB2 on the distributed platform. A detailed look at key requirements that drive product plans in areas such as XML exploitation, manageability, scalability and performance, optimization and warehousing will be discussed.
Click here to register for the chat.
The other day I had a request for Don Chamberlin's book that was published 9 years ago: A Complete Guide to DB2 Universal Database. I know the book is EXCELLENT, especially since it was written by one of the inventor's of SQL! But, like most books, I figured that it was out of date and not very useful at this point. But when I made this comment, here was the response back to me:
The Don Chamberlin book is more of a complete DB2 SQL manual that many JDBC developers will need.
I'm not a JDBC developer, so I'm looking for comments on this one. Where do you go for SQL help???
svisser1 2700018UK9 3,998 Views
If you are attending the IOD conference at the end of the month, consider maximizing your learning experiences by taking one of the pre-conference classes that are available. There is an extra fee, but well worth the money given the quality of the classes and the speakers.
I've added a new discussion (Pre-Conference Classes)in the group IOD Conference on ChannelDB2 to provide the published details of the classes along with other interesting facts about the class material or speaker. Take a look!
Here are the classes that are offered:
IBM Cognos 8 BI: Essentials for Managing BI Projects (version 8.3) Accelerated
Speaker: Norm Goddard
IBM Cognos 8 BI: Essentials for Managing BI Projects (version 8.3) is a one-day, instructor-led course that provides participants with essential knowledge to ensure the success of their Cognos 8 BI implementation. Participants will be introduced to the Cognos Solutions Implementation Methodology (Cognos SIM), the elements of IBM Cognos 8 BI, and the underlying architecture. They will examine the process of creating an IBM Cognos 8 BI solution, and discuss how IBM Cognos 8 BI relates to the other parts of IBM Cognos 8. Participants will be shown a range of resources to help them successfully manage their implementations.
DB2 Migration, How To Move Forward and Never Fall Back
Speaker: Albert Grankin
Production system migration, whether hardware or software is a task that requires very detailed and careful preparation. This session will go over aspects of database migration that are usually not covered in our migration guides. We’ll cover topics including how to prepare your production system for migration and what additional information to collect before starting. It will also cover important steps after migration including comparative performance monitoring, identifying and resolving issues.
DB2 V9/V9.5 for Linux, UNIX and Windows Problem Determination
Speakers: Aman Lalla, Pavel Sustr
Learn how to identify and resolve problems such as database hangs, locking problems, crashes and optimizer/performance problems. DB2 V9 also provides various problem determination facilities and tools such as db2fodc (First Occurrence Data capture). Knowing how and when to use these tools is critical in resolving problems quickly.
DB2 Operational Performance, Success Without Stress
Speaker: Rajib Sarkar
This session will demonstrate effective ways to monitor a DB2 database system for performance and provide tips & tricks in analyzing & monitoring data. The session will also focus on diagnostic tools and techniques used by IBM support personnel and how some of them could be used by DB2 Database Administrators, IT Specialists and Developers for identifying and solving operational performance issues.
Speakers: Hyun-Ju Vega, Suma Vinod, Mark Jamison, Ron Privett Learn more about troubleshooting from the experts – the IBM Informix advanced support team. Attendees will learn Informix diagnostic methods and tools, how to troubleshoot and diagnose performance problems, connectivity and network issues, memory problems, ER/HDR problems, and Windows specific issues.
Leveraging DB2 Optimizer
Speaker: Yasir Warraich & Samir Kapoor
Learn everything there is to know about the optimizer architecture. We start with discussion about basic concepts such as optimization levels and timer ons. Advanced topics such as data access methods, join methods, analyzing the optimizer access plans will be covered and additionally we'll describe different operators and help identify problematic areas to look into in an access plan. We'll also show how to take counts at different branches in an access plan. Having understood how to analyze an access plan, we'll also demonstrate usage of STATVIEWS, CGS ger,and OPTIMIZATION GUIDELINES to improve query performance.
DB2 for z/OS DBA Certification Crammer (Exam 732)
Speaker: Susan Lawson
This high level certification preparation review is intended to help you take IBM Certification Test 732, DB2 9 DBA for z/OS. Gain an intense overall review of those areas that are on the certification exam.
DB2 9 for Linux & Windows DBA Certification Crammer (Exam 731)
Speaker: Roger Sanders
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 DBA for Linux, UNIX, and Window certification exam (Exam 731). The material for this course is aligned with the 731 exam objectives.
Insuring Data Privacy in Your Test Environment using Optim
Speaker: Tom Bauch
Data in your testing environment is often not as tightly controlled or audited as your production data. This 1-day class provides an overview of how to mask your test data to eliminate the risk of data loss and comply with privacy standards using Optim. The class will also review how to simplify the creation and management of your test data, easily creating a subset of your test data to minimize disk requirements, and simplify your ability to create and manage test data environments.
See you in Vegas!
We'd like to personally invite you to the 2nd Annual Women in Technology reception at IOD 2008 in Las Vegas. We are excited to announce that this year's event will be hosted by Debbie Landers, VP IBM WW Client Support for Information Management and Nancy Pearson, VP IBM Information Management Marketing. Given the success of last year's event, we've decided to structure this year's in a similar manner.
If you have any specific suggestions on the session, please do not hesitate to provide comments on my blog so I can let Jennifer Gibbs and Katherine Franklin know.
Please find details of the event below along with the link to enroll via the IOD website.
Event Details:Session: BOF-2267A Women In Technology: Leveraging Our Unique Abilities to Build SuccessTime: Wed, 29/Oct, 06:00 PM - 07:00 PMLocation: Mandalay Bay South Convention Center - Jasmine A
Please spread the word to your women colleagues. Many thanks for your participation and support of this reception!
Looking forward to seeing you there. Don't forget your business cards!
Thanks to Jennifer for sending this information to me:) I'll definitely be attending!
Are you aware of the IDUG Online Learning Center?
IDUG Learning Center offerings are download-on-demand streaming media files featuring original presenter audio synchronized with presentation slides, along with some audio only offerings. Using standard desktop controls within an Internet browser, users can pause, rewind, fast-forward, stop and resume sessions from the Learning Center at their convenience. Offerings from the IDUG Online Learning Center session can be viewed an unlimited number of times for three months from the date of purchase.
Select offerings from the Online Learning Center are available at no cost. For others, IDUG Membership is required to access. (Basic Membership in IDUG is free-of-charge, requiring only completion of our membership application.) The majority of Learning Center offerings are available at a cost of $5 per (USD) for Premier Members and $10 per for Basic Members. IDUG Premier Members also enjoy complimentary access to keynote presentations, spotlight sessions and panel discussions hosted in the Learning Center, while these sessions are available for a fee to Basic Members.
The IDUG Online Learning Center is a leading-edge resource to make technical education from IDUG events available anytime, anywhere through your Web browser. Experience the Learning Center with a free introductory sample of the Best User Presentation from IDUG 2007 - North America.
The IDUG Online Learning Center library features more than 220 in-depth sessions captured at IDUG 2007 - North America, which took place May 6-10 in San Jose, California, U.S.A. The sessions captured at IDUG Europe 2007 - Athens will be added to the library very soon.
Among the titles now available in the Learning Center are the following:
Session F13/G10: Magic of V8 RebindBonnie Baker, Bonnie Baker Corporation
Session F03: Hard Lesson Learned when OO Meets RelationalJohn Campbell, IBM DB2 for z/OS Development
Session F06: Put a Smile on Your DBA's Face - Performance for the Developer (and You Know It All DBA's)Rob Crane II and Marc Costa, FedEx Freight System
Session C02: Application Performance Tuning in DB2 9 for z/OSGene Fuh, IBM Silicon Valley Lab
Session E10/E11: A Sneak Peak at the Next Release of DB2 Linux, Unix and WindowsMatt Huras and Aamer Sachedina, IBM Toronto Lab
Session B08: Top 10 Ways to Waste CPUSusan Lawson and Daniel Luksetich, YL&A
Session A03: The Effect of Distribution and Correlation Statistics on the DB2 OptimizerTom Moulder, TREX Associates, Inc.
Session G06: More Ways to Challenge the DB2 z/OS OptimizerTerry Purcell, IBM Silicon Valley LabVoted Best Overall Presenter at IDUG 2007 - North America
Session B01: Availability Enhancements in DB2 for z/OSHaakon Roberts, IBM DB2 for z/OS DevelopmentBest attended session at IDUG 2007 - North America
Session J01: IBM DB2 Utilities: What's New in DB2 9 and Often Overlooked Features Before 9Bryan Smith, IBM Silicon Valley Lab
To commemorate the launch of this vital new resource and to encourage use of the Online Learning Center, IDUG is pleased to make the session voted Best User Presentation (as selected conference by attendees) available free-of-charge for a limited time. To access the file, simply click on the session title below:
DB2 9 for z/OS: John Deere's Early Ship Pilot (ESP) ExperiencePresenter: Bryan Paulsen, John Deere
IDUG invites you to benefit from this new, exciting program as we extend the organization's boundaries as the worldwide DB2 user community. Enjoy!
I'm busily preparing for the IDUG 2008– North America Conference taking place in Dallas in approximately 6 weeks, May 18-22, 2008 at the Hyatt Regency Dallas.
The early-bird discount expires on April 16, so register now to save $200. See the online conference schedule to see what the conference has to offer you. Here are a few of the highlights:
1) Once again... free certification exams. This provides you a savings of $150 per take... pass or fail. If you are looking to upgrade to V9 certifications, you have 6 exams to choose from: 730, 731, 732, 733, 734, and 736. Even if you took only five exams, that would be a savings of $750! Could this be the justification that you need to go to the conference?
2) Prepare for the exams now... and/or take one of the Pre-conference Crammer classes by exam developer / authors: Roger Sanders or Susan Lawson.
3) Discounted books: I'm putting together a list of books to suggest to the bookseller, Breakpoint books. In creating this list, I'm trying to ensure that you have the latest books with the highest ratings. If there is a book that you'd like to suggest that I add to my list, let me know. I believe the normal 10% discount will apply at the conference.
4) Skills Hub: I will be located at the bookstore for the week, or right next to it, at the Skills Hub. This is a new area for an IDUG conference and is based loosely on what we did at IDUG Athens last November. We encourage people to come and ask questions, browse the books, talk to us about your particular needs, and if possible, pick up a freebie or two.
5) Authors who will be speaking at the conference. I don't know if I have a complete list yet, but here's what I was able to pull together from the Advance Program:
* Roger Sanders* Susan Lawson* Daniel Luksetich* George Baklarz* Leon Katsnelson* Dwaine Snow* Chris Eaton* Craig Mullins* Phil Gunning
6) Presentations / Education - there are at least 150 hours of education provided by experts and users.
7) Exhibit Hall: eight hours available for you to meet related vendors who can help with your specific needs for products or services.
8) Keynote speakers: Arvind Krishna, Curt Cotner and Chad Fowler.
9) IBM Panel discussions.
10) Special Interest Groups
and last, but not least.... networking opportunities!
Looking forward to seeing you!
I blogged about this new voucher promotion last week.... we now have a link to this promotion on the amazon page for the book: IBM DB2 9 New Features and we're getting amazing response. Make sure you don't miss out!
Here is my original post:
Buy a book... get 50% off a certification exam! We only have a limited number of vouchers, so we're expecting to run out quickly. Be one of the first to get a voucher by buying a copy of the IBM DB2 9 New Features by Paul Zikopoulos, George Baklarz, Leon Katsnelson, and Chris Eaton. You don't need to buy the book from amazon, but you do need to send us proof of purchase.
Normally exams cost about $150 ... so this is a savings of $75. For full details, read: Voucher Promotion Details
These days it seems that most DBAs are in the position where they need to know multiple database products. I know that in many cases that means a non-IBM database such as SQL Server or Oracle, in addition to one of IBM's database products, but for many DBAs, the reality is multiple IBM products. I've attempted to pull together useful information for DBAs who are in this position.
Zone: DBA Central Products: DB2 Family
DB2 9 for Linux, UNIX, WindowsDB2 9 for Linux, Unix and Windows is a hybrid data server for both XML and relational data that is enabled for SOA and optimized for SAP.Viper: DB2 9 for Linux, UNIX, Windows DB2 podcast series: Voice of the Community Recommended reading list: DB2 for Linux, UNIX, and Windows database administrationCerts, Education, Books, Tutorials: Education ResourcesRedbook: DB2 9 pureXML GuideRetail book: IBM DB2 9 New FeaturesRetail book: Understanding DB2 9 Security
DB2 9 z/OSUse DB2 on the mainframe to run powerful enterprise applications, and make e-commerce a reality.Products: DB2 for z/OS and OS/390 Redbook: Data Integrity with DB2 for z/OSLaunch page: DB2 for z/OSTool site: DB2 and IMS Blog: Willie Favero'sMost resources coming soon... Certs, Education, Books, Tutorials: Education Resources
IDSExceptional, low maintenance online transaction processing (OLTP) data server for enterprise and workgroup computing.Zone: IBM Informix Launch site: IDS Cheetah Blog: Cheetah ExpertsWebcast: Integrated Data Solutions for Information On Demand using IBM Informix Cheetah Article: How to go hand-in-hand with DB2 and InformixRedbook: Informix Dynamic Server V10 . . . Extended Functionality for Modern BusinessTest Run: IDS CheetahChat with the Lab Series: IDSMost resources coming soon... Certs, Education, Books, Tutorials: Education Resources
Oracle or SQL ServerConsider switching... it's easy with these resources:Redbook: Oracle to DB2 UDB Conversion Guide Redbook: Microsoft SQL Server to IBM DB2 UDB Conversion GuideZone: Porting to DB2 for Linux, UNIX, and Windows Station: Migration
svisser1 2700018UK9 3,976 Views
As part of a continuing series, Claudia Imhoff has created a paper that describes the impact the emerging Information Producer role can have on warehouse environments and IT organizations.
In a recent blog, Rachel Bland of IBM sees that the Information Producer role in organizations has the potential to cause angst for IT. The Information Producer’s need for self-service must to be balanced against other needs such as governance, system stability and performance, and the need to sustain services for other end users.
To address these competing needs such as these, IT can look to innovative technologies that speed deployment and query performance, simplify maintenance and offer affordability.
One IBM advantage is having a broad perspective and a portfolio of products that includes The IBM Business Intelligence Pattern with BLU Acceleration. Aligning with these objectives, this pattern offering can help to reduce the burden on IT and provide every user who interacts with the system with a “speed of thought” response.
Read more of Rachel’s blog – http://www.ibmbluhub.com/info-producer/
Thanks to Cindy for sharing!
Happy 2009 to one and all! May it be a joyful and prosperous year for you and your loved ones!
The last week of December the following announcement was made and I wanted to make sure that you didn't miss it: DB2 Express-C for Mac OS X is finally available for download.
This beta release will no doubt be of interest to developers, particularly those who use scripting languages like Ruby, Python and PHP. These communities are in fact, increasingly embracing Mac OS X as their operating system of choice.
If you haven't already seen it, see also an announcement from Antonio Cangiano.
Funny side note.... I own a Mac myself and when I tell people, they treat me like I'm a traitor to IBM! I'm quite pleased that IBM is not tying their software to a single platform and that we long term IBMers can happily and proudly say that we use a Mac... and our top tier software runs quite nicely on it.
svisser1 2700018UK9 3,966 Views
Join Raul Chong at 11 EST for a Technical Overview of DB2 9.7.
Join Chris Eaton, Scottt Hayes, and Rebecca Bond for SQL Fun at 12 EST.
Click the links for details.
Since I volunteer to proctor exams to employees of the Toronto Lab, I quite often get questions about how to get certified. At this point the most common question is whether people who have not received any DB2 certifications, where should they start? Here is the path I recommend.
If you are using DB2 V8, start there. The exams are experienced-based, so you'll likely have an easier time preparing for the exam since you are using that level of product. The V8 exams are: 700, 701, 702, 703, 704, and 706
If you are using DB2 V9 and have little experience with previous releases, stay with the V9 path. The V9 exams are: 730, 731, 732, 733, 734, and 736
Exam 700 and 730 are equivalent in that they are fundamentals exams for their respective version and they are valid prerequisites for EITHER the V8 or V9 exams. But at least one of these must be taken.
If you want to be certified on BOTH V8 and V9, start with Exam 700 and follow the V8 path. Then all you need to do is to take the upgrade exam, 736 to upgrade to a DB29 DBA certification.
Exam 706 and 736 are upgrade exams. Exam 706 allows those certified as a DBA on DB2 V7 to upgrade with a shorter test. Exam 736 can only be taken by people who already have their V8 DBA cert. So you will not take this exam unless you wanted to get certified on both versions.
As for study materials, both versions have free tutorials. Book availability is a more difficult issue. The V8 certification guides were published by Pearson Education, and most of them are now out of print. Long story as to why they are out of print, but I'm trying to find a workaround. So if you are trying to buy a book and find that it isn't on amazon, you'll need to look for a used copy. If you have V8 books that you no longer need, consider passing them on to those who may need them.
Only one of the V9 study guides has published so far... the one for Exam 730. More are coming, but you'll have to wait till fall.
If you weren't able to follow all these exam numbers, you can find roadmaps and legends on www.ibm.com/certify. For all book information, see www.ibm.com/software/data/education/bookstore/.
As always, feel free to contact me if you need further information.
I've pretty much caught up with my work after a two week vacation to Tuscany, so hopefully I'll be able to post regularly again.