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.
Objective 1: Provide the student with an overview of the DB2 Certification Exam testing program.
Objective 2: Introduce the student to basic DB2 9.7 Database Administration fundamentals.
Objective 3: Provide the student with information on new features and functionality that were introduced with DB2 9.7.
Objective 4: Provide the student with the information needed to correctly answer questions they are likely to see on the DB2 9.7 for Linux, UNIX and Windows Database Administration Certification Exam (Exam 541).
Objective 5: Provide the student with an overview of the certification testing software.
Z01: DB2 9 for z/OS DBA Certification Crammer Course
Date: May 10, 2010 09:00 AM – 04:30 PM
This is a high-level certification preparation course intended to help you take DB2 9 Family Fundamentals exam (730) and DB2 9 for z/OS Database Administration exam (732). Passing of these exams will result in certification as an IBM Certified Solutions Expert - DB2 V9 z/OS Database Administration. Participants are expected to have fundamental knowledge of relational principles in addition to applied working knowledge of DB2 z/OS V8 and basic knowledge of V9 features. This will be a lecture-only class with no labs.
This session offers an intense, overall review of those areas that will be on the certification exams (both the 730 – DB2 9 Family Fundamentals and the 732 – DB2 9 for z/OS), providing a comprehensive review for those planning on taking the certification exams to become an IBM Certified Solutions Expert - DB2 9 for z/OS Database Administration.
Objective 1: Present information to help students pass the 730 and 732 exams to become a DB2 9 for z/OS Certified DBA.
Objective 2: Relevant Database Administration Topics
Objective 3: Relevant Application Programming Topics
Objective 4: Relevant System Administration Topics
Objective 5: Relevant SQL Topics
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
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.
Paul Zikopoulos - DB2 Evangelist and Award Winning Speaker is the guest on the DB2Night Show, Friday, Feb 19 at 11 EST
Paul's Topic: DB2 Compression Updates
PS... thanks to Kate for blogging about this!
Good luck Paul!
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
IDUG's pre-conference educational seminars provide in-depth DB2 education that both enhances your professional development and offers the information you need to better achieve significant business results. Pre-conference educational seminars are available to both conference and non-conference attendees, so don’t miss out on this great opportunity of fantastic one-day education.
Register today for one of the nine educational seminars before it’s too late. Registration is based on a first-come, first-served basis.
|Conference Attendee Seminar Fee:||$425|
|Non-Conference Attendee Seminar Fee:||$475|
The 2010 Pre-Conference Educational Seminars are:
- Z01: DB2 9 for z/OS Cert Exam, Susan Lawson
- Z02: Save CPU Costs by Tuning your SQL, Bonnie Baker
- Z03: SQL: What To Use When You Can and Cannot Touch It, Sheryl Larsen
- Z04: DB2 9.7 for Linux, UNIX and Windows DBA Certification Exam Preparation (Exam 541), Roger Sanders (EMC)
- Z05: Deep dive into DB2 LUW Problem Determination and Troubleshooting, Pavel Sustr (IBM)
- Z06: DB2 for LUW Performance Analysis and Tuning Workshop, Scott Hayes (DBI)
- Z07: DB2 9 for z/OS In-depth, Phil Grainger (Independent Consultant)
Join the webcast TODAY: 11 EST. Replay will be available. Register now.
This news is from The World of DB2 for z/OS
Don't Miss our webcast today - 11 EST - 4 PM GMT. Even if you can not attend today you can register now and listen to the replay at your leisure !
Are you looking to reduce costs like many other organizations? DB2 9 for z/OS includes major enhancements to help you reduce workload, improve employee productivity so you can increase efficiency and directly impact the bottom line.
Listen to how Land Registry, a UK Government organization
successfully upgraded to DB2 9 and is reaping the business benefits.
This presentation will take you through the journey from start to
finish, highlighting the risk-mitigating activities that were
undertaken during the project lifecycle that contributed to a virtually
impact free migration. The topics explored are:
The business drivers and perceived benefits for upgrading;
Planning, preparation Testing and other pre-requisite activities;
The upgrade itself problems / lessons learned;
Benefits realisation and early experience of the new functions.
Speaker: Maria McCoy, Database Administrator on DB2 for z/OS, UK Government
Visit The World of DB2 for z/OS at: http://db2forzos.ning.com/?xg_source=msg_mes_network
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.
- Assessment tests are delivered by the Prometric Web-based test delivery tool.
- Tests cost $10 USD per attempt. VISA, Master Card and American Express credit cards are accepted, and entered directly into the Prometric system.
- Assessment exams are similar to the certification exam in that it is in the same format (multiple choice), done on the same testing software, and score reports that break down your score by section.
- There is an assessment exam that corresponds to each certification exam.
- Website: Assessment Exams
2) Use one of the published Certification Study Guides.
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'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.
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.
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 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:
I strongly encourage you to try the study guides again. The series from MC Press is much different than any we've had in the past. First of all, the authors were part of the exam development team, so they were able to create their own assessment questions that are similar to what you'll see on the official IBM cert exam or assessment exam.
Second, the books were designed to only cover what is tested on the exam... with the natural exception that the material must make sense. So if it isn't on the exam, but is needed for you to understand the concepts, it is covered. At the same time, you'll find all topics that are covered on the test to be covered in the study guide. No exceptions. Read the comments on amazon. For people who truly used the study guide to learn ... they passed the exam.
Third, the study guides explain why the correct answer is correct and why the incorrect answer is incorrect. There is no other way to get this kind of depth in the material.
There is a study guide specifically for the very difficult Advanced DBA exam. Take a look at this one, and I don't think you'll be disappointed:
DB2 9 for Linux, UNIX, and Windows Advanced Database Administration Certification: Certification Study Guide by Dwaine Snow and Roger Sanders.
I call this the "purple" book.
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 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!
|Using EMC TimeFinder to Backup and Restore DB2 for Linux, UNIX, and Windows Databases (EMC ebook)||By Roger Sanders, Paul Pendle, Dale McInnis, Michele Backstrom||2009|
|Break free with DB2 9.7: A Tour of Cost-Slashing New Features (Flashbook)||By Paul Zikopoulos, Belal Tassi, Chris Eaton, George Baklarz||2009|
|SAP DBA Cockpit - Flight Plans for DB2 LUW Administrator (ebook)||by Eduardo Akisue, Jeremy Broughton, Patrick Zeng, Liwen Yeow||2009|
|DB2 pureXML Cookbook (IBM Press)||by Matthias Nicola and Pav Kumar-Chatterjee||2009|
|Beginning DB2: From Novice to Professional ||Grant Allen||2008|
|Understanding DB2®: Learning Visually with Examples, 2nd Edition ||Raul F. Chong, Xiaomei Wang, Michael Dang, Dwaine R. Snow||2008|
|DB2 9 for Developers||Philip Gunning||2008|
|Physical Database Design: the database professional's guide to exploiting indexes, views, storage, and more||Sam S. Lightstone, Toby J. Teorey, Tom Nadeau||2007|
|IBM DB2 9 New Features||Paul Zikopoulos, George Baklarz, Leon Katsnelson, Chris Eaton||2007|
|Understanding DB2 9 Security||Rebecca Bond, Kevin Yeung-Kuen See, Carmen Ka Man Wong, Yuk-Kuen Henry Chan ||2006|
|DB2 Explained for Sybase Professionals||Vijay Saradhi||2006|
|DB2 V9 for z/OS Certification Guide - Systems Administration – Test 737 (MC Press)||By Judy Nall ||2010|
|DB2 Developer's Guide, Fifth Edition||Craig Mullins||2004|
|The Official Introduction to DB2 UDB for z/OS Version 8||Susan Sloan||2004|
|Database Administration: The Complete Guide to Practices and Procedures||Craig Mullins||2002|
|An Introduction to IMS: Your Complete Guide to IBM's Information Management System||Dean Meltz, Rick Long, Mark Harrington, Robert Hain, Geoff Nicholls||2005|
|Informix Dynamic Server Application Development – Getting Started (ebook)||By Jacques Roy||2009|
|Administering Informix Dynamic Server: Building the Foundation||Carlton Doe||2008|
|SQL The Complete Reference, 3rd Edition||James Groff, Paul Weinberg, Andrew Oppel||2009|
|SQL for DB2 (29th Street Press)||by James Cooper and Paul Conte ||2009|
|SQL Bible||Alex Kriegel, Boris Trukhnov||2008|
|SQL in a Nutshell||Kevin Kline||2008|
|Introduction to SQL: Mastering the Relational Database Language (4th Edition)||Rick F. Vander Lans||2006|
|SQL Pocket Guide||Jonathan Gennick||2006|
|DB2 SQL Procedural Language Guide for Linux, UNIX and Windows, 2/e||Michael Gao, Zamil Janmohamed, Fraser McArthur, Clara Liu||2004|
|SQL Performance Tuning||Peter Gulutzan|