Have you ever been to a DB2 Symposium? They are quite different than
a normal conference since they provide 3 full days of learning. This one takes
place in Chicago from October 16-18 and provides three-days of training with
three parallel tracks.
Each day there are three one day seminars presented by industry leading
consultants. You may join for 3, 2 or just 1 day(s), depending on your needs
There are nine great sessions lined up with award-winning speakers:
- Bonnie Baker
- Susan Lawson
- Craig Mullins
- Cristian Molaro
- Klaas Brant
Tuesday 16 October
Wednesday 17 October
Thursday 18 October
October 16-18, 2012 – Chicago DB2 Symposium
- Location: Downers Grove – Chicago, IL
For further information, use the menu on the left hand side of the DB2 Symposium webpage where you
can navigate to the sessions, pricing, location and more.
Thanks to Klaas Brant, KBCE – DB2 Symposium Organizer, for
providing me with this information.
The next Chat with the Lab session will
focus on DB2 pureScale:
DB2 pureScale - Always-on, Elastic Database
Date: Tue, August 31, 2010
Time: 11:30 AM - 1:00 PM Eastern
10:30 AM Central / 8:30 AM Pacific / 16:30hrs London /
17:30hrs Frankfurt, Paris / India 9 PM
Speakers: Sal Vella (IBM),
Drew Bradstock (IBM)
Host: Rav Ahuja
Last year IBM released DB2 pureScale, an integrated database cluster solution
that provides continuous data availability, virtually unlimited capacity,
elastic scalability, and all this with easy setup and management but without
requiring any applications changes. IBM has recently updated DB2 pureScale and
announced that it will now also be available to run on Intel-based commodity
hardware and Linux. In this webcast we will cover various DB2 pureScale related
topics including: architecture, benefits, demos, experiences, and getting
To learn more and get your questions answered, join Sal Vella (VP,
Development), and Drew
Bradstock (Product Manager) on Tuesday August
31, 2010 at 11:30 AM Eastern.
Presentation charts for this Chat will be available for download from
ibm.com/db2/labchats 1-2 days prior to the event.
To register and receive instructions for attending this webinar,
point your browser to:
If you are attending the IBM Information on Demand conference this October,
you are eligible to pick up the latest Flashbook about DB2:
DB2 pureScale: Risk Free Agile Scaling
by Paul Zikopoulos, Matthew Huras, Paul Awad, and Aamer Sachedina
This succinct guide will show you how DB2 with pureScale can provide you
transparent application scalability, the ability to deliver agile-like computing
to your transaction systems, and extreme availability.
Also check out these sites for details about DB2 pureScale:
DB2 pureScale Unlimited capacity with continuous availability
A Technology Preview
pureScale: Scaling Databases without Limits
DB2 pureScale - Always-on, Elastic Database
Cluster – **NEW**
Application Scaling with IBM DB2 pureScale
databases size does matter: introducing DB2 pureScale
unveils DB2 pureScale on IBM Power Systems
pureScale Technology Redefines Transaction Processing Economics
DB2 pureScale to Eliminate Over-Provisioning of Database Software
As always, if you think I’ve missed something… let me know. I’ll be happy to
promote any resource related to this new technology.
by Doug Vucevic and Wayne Yaddow
About the book:
quality of a data warehouse (DWH) is the elusive aspect of it, not
because it is hard to achieve [once we agree what it is], but because it
is difficult to describe. We propose the notion that quality is not an
attribute or a feature that a product has to possess, but rather a
relationship between that product and each and every stakeholder. More
specifically, the relationship between the software quality and the
organization that produces the products is explored. Quality of data
that populates the DWH is the main concern of the book, therefore we
propose a definition for data quality as: "fitness to serve each and
every purpose" Methods are proposed throughout the book to help readers
achieve data warehouse quality.
About the authors:
Vucevic: Upon an early retirement from the IBM Development Lab in
Toronto, where he had worked as a software developer, Doug has been
working as an independent consultant to major banks, insurance and
retail companies in Toronto, in the field of Software Engineering.
Doug's consulting assignments have been in leading quality assurance and
testing efforts for: data warehousing, BI and Data Mining in financial,
insurance and retail industries. Doug holds Masters' Degree in
Electronics and Telecommunication and is a member of the Registered
Professional Engineers of the province of Ontario.
Yaddow: Wayne Yaddow has spent more than twenty years developing and
testing operating system code at IBM. During the most recent ten years,
he devoted his time as an IT consultant, conducting QA on data migration
and data integration for large data warehouse projects in the financial
industry. While working as a consultant, he shared his data warehousing
knowledge with many colleagues on the Internet and in work assignments
in New York City.
More blog entries about Data Warehouse:
DB2Night Show, Nov 30: IBM DB2 LUW Data Warehouse & DPF Performance
Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition
Largest data warehouse – Guinness World Record
April 30, 2012: GA of Version 10 products: DB2 for LUW and InfoSphere Warehouse
Best Practices: Active Data Warehouse Topology using InfoSphere Warehouse
The Data Warehouse Mentor: Practical Data Warehouse and Business Intelligence Insights
Apparently this is happening to many of our customers. They move from Oracle
to DB2 and achieve improved performance. Could this happen to you as well?
Here are some of the details of this particular case study:
JSC Rietumu Banka achieves faster database performance moving from
Oracle and Sun to IBM DB2 on Power Systems
With the worldwide recession placing pressure on banks to reduce costs, JSC
Rietumu Banka's CIO was concerned with total cost of hardware, software
and administration supporting the company’s online banking
applications. The bank’s web applications ran on Oracle Database and Sun servers
and it found that the annual fees were costly and administration time consuming.
With its migration to IBM DB2 on IBM Power Systems, it
reduced the total cost of ownership for its online banking
infrastructure and dramatically improved query performance and
data availability. On average, user queries are now executed up to 3 times
faster, with some queries completed up to 30 times faster (for
example, some queries that before took 30 seconds now take less than one
second). During the migration process, the bank reported an out-of-the-box
compatibility rate of more than 90 percent.
Thanks to the solution, JSC has:
• Reduced total cost of ownership by
• Achieved 3-30 times faster query performance
Improved data availability by 200 percent
"By migrating to IBM DB2 on IBM Power systems, and using IBM services, we
expect to decrease total cost of ownership for our mobile device banking
applications by 20-30 percent." - Sergey Golubev, Head of IT Maintenance
and Networking Department, JSC Rietumu Banka
To learn more about how JSC Rietumu Banka addressed its business challenges,
read the full case study.
I get the impression that this type of improvement is happening in many
shops. I base this impression on some of the comments that have been expressed
on the DB2Night Show. Has this happened to you as well? Do you want to share
Thanks to Dave Pittman and Paula Williams for providing me with the details
of this case. Watch for a few more that I’ll write about.
Monday April 25 is the Kickoff
for DB2 for z/OS
shows on the DB2Night Show. As a reader of my blog, by now you know the DB2Night Show and Scott Hayes
very well. Just to be sure, here’s what you need to know about the DB2Night Show:
Scott Hayes of DBI started a series of free webinars in September 2009 with the goals to: Educate, Entertain, and Inform. There have been 48 shows already and 98% of the attendees said that they learned something new from the show. I’ve personally been involved in the past few months as part of the “DB2’s Got Talent” competition and I must say that I was blown away with the quality, variety, and depth of the education provided.
Each episode has a DB2 educational theme and speakers have been IBM experts, top consultants, IBM DB2 Gold Consultants, IBM Information Management Champions, and experienced users.
Klaas Brant of KBCE and organizer of DB2 Symposium Education has decided to turn Mondays into a must attend learning session for people who work with DB2 for z/OS. There are already 5 amazing shows on the schedule with more to come.
Remember, the DB2Night Show is completely free for participants, but there is a limit to how many attendees can attend. Make sure you register immediately so you don’t miss out. Replays will be available following each show.
Here is the current schedule:
The History of DB2
Monday April 25, 2011, 11EDT
The kickoff of the DB2Night Show z/OS Edition features legendary Roger Miller. This event shows much of the history of DB2 with milestones of new versions, new inventions, and showcases some of the people who contributed key inventions and innovations in DB2.
The Future of DB2
Monday May 9, 2011, 11 EDT
Edition #1 was a look at the history of DB2, so it is fitting to have the second show centered around the future of DB2 z/OS. Special guest Jeff Josten will share the latest new with DB2 V10 and will offer his insights into what may be coming in future releases.
DB2 10 Performance
Monday May 16, 2011, 11 EDT
This episode will look at performance in DB2 10. Special guest Cristian Molaro was recently a co-author on a new IBM Redbook about DB2 performance that will publish soon. Cristian will share his hands-on experience with DB2 10 performance during the show.
DB2 10 SQL Enhancements
Monday, May 23, 2011, 11EDT
DB2 10 is packed with new SQL features like temporal data and many others. Join special guest Terry Purcell as he walks us through these great new features and explains how to get the best from them.
DB2 10 Customer Experiences
Monday, June 6, 2011, 11EDT
Many customers are already using DB2 10 in production. Special guest John Campbell will talk about migration planning and share lessons learned from people who have already migrated.
Are you looking for more quality educational ideas? See my previous blog entries:
- FREE – Flashbook “DB2 10 for z/OS - Cost Savings ..... Out of the Box“ available; find out how to get yours: http://bit.ly/fjR4x2
- FREE - Ten new IBM Redbooks that you may be interested in: http://ibm.co/hZDwXV
- FREE - Learn from experts via Best Practice articles for DB2 for z/OS: http://ibm.co/eTXbRd
- FREE – 3 certification exams for attendees of IDUG Tech Conference: http://ibm.co/giLoQA
- IDUG Tech Conference: http://ibm.co/gqaA35
- DB2 for z/OS Events & Resources: http://bit.ly/hZDPbf
Learning is a life-long journey, so take advantage of the outstanding resources that are available for you.
Modified on by svisser1
DB2 for Linux, UNIX and Windows 10.5 with new BLU Acceleration
Technical Immersion Workshop
Fees: No Charge
Date: Friday, May 3, 2013
Hours: 8 AM to 2 PM
Presenters: Chris Eaton, Danny Arnold and Eric Alton
IBM is sponsoring a technical DB2 workshop at the upcoming IDUG DB2 Tech Conference in Orlando, Florida. Taught by IBM DB2 technical experts Chris Eaton, Danny Arnold and Eric Alton, this workshop covers key features from the recently announced DB2 10.5 with BLU Acceleration as well as the compression features of DB2 10.1 as previously announced.
This FREE technical workshop is an ideal way to extend your technical skills to include the best capabilities of DB2 for Linux, UNIX and Windows. Specifically:
DB2 10.5 with BLU Acceleration - This hot new technology helps deliver decision-making information to your organization with precision that is termed “speed of thought” analytics. We’ll explain how BLU Acceleration implements new column organized tables and how compression works on these tables along with other new processing techniques to deliver superior performance for analytic workloads.
New improvements in DB2 pureScale that handle maintenance and capacity expansion needs more easily—plus new integration with HADR capabilities to support always available transactions.
SQL and Oracle Database compatibility enhancements added in DB2 10.5
DB2 compression technologies introduced in DB2 10.1 that offer key advantages in managing and better utilizing costly storage resources.
And of course there will be time for your questions and active discussion with these DB2 experts. Don’t miss what is sure to be a lively session. It is an excellent opportunity to update your knowledge of DB2 for LUW and the techniques that are increasingly required in a Big Data world.
If you are planning to attend the conference, make your travel arrangements so you can take advantage of this workshop. If you cannot attend the IDUG conference, you can still attend the workshop only at no charge.
Full details and registration. Register soon, as space is limited and filling quickly.
What an exciting week! With Watson winning on Jeopardy, meeting a member of the Watson team, and then today, the 3rd episode of the DB2Night Show’s competition DB2 has talent.
Today’s episode was particularly high quality. I think many of today’s contestants have enough knowledge to write books with very valuable content! Let me tell you about the contestants we met today:
John - “How to Move Data from Mainframe to LUW”
John has 39 years experience using various databases from IBM – IMS, DB2 for z/OS, DB2 for LUW, and maybe even SQL/DS… and his expertise showed. He provided scripts that could actually be used by people who are trying to accomplish what he did. His presentation was easy to follow, gave actual examples as to how he was able to move the data, and he finished in time.
Bob (Robert) – SQL Tuning Tricks – Perils of Using “not in”
OK, we didn’t actually hear from Bob, but we did see the first page of his slides. There were many technical issues with the meeting software today (I know first hand!) so hopefully Bob is able to come back next week. His topic sounds interesting and his first slide was promising. Let’s hear from you Bob!!
Naveen – Improving Database Performance by Choosing the Right Index
Naveen gave a very thorough and relevant presentation on indexing. His figures and cautions made the content very easy to follow. The only criticism is that Naveen failed to tell us that DB2 9.7 takes away the need for much of what he presented.
Ramesh – Determining which Indexes can be dropped
Ramesh was slightly less easy to understand than Naveen, but he did include information about how DB2 9.7 changes the indexing story. It’s too bad that we had back to back presenters discussing nearly the same topic, but that just tells us how important this task is.
Sameer – Optimizing Application Performance with DB2
This was Sameer’s second appearance on the DB2 has Talent competition. He was asked to cut his material down significantly and to re-present. Sameer took the challenge and excelled! His content could fill a book with truly amazing tips along with understandable explanations.
Jefferson – SAP and BufferPools
I’m sorry Jefferson, but I missed part of the title of your presentation. Jefferson gave a very detailed presentation about an important topic. He was able to gather examples that involved a very large amount of data and to demonstrate how to use bufferpools with SAP.
Thiru – Explain from Actuals
I think we all went away from this presentation realizing that Thiru had very nicely demonstrated a very little used stored procedure. It made me realize that there are problem many un-mined functions and features that DB2 offers that are not well known or well used. What an opportunity for future contestants!
Yogesh – Troubleshooting DB2 Work Load Manager
I think the only issue with Yogesh’s presentation was the sheer magnitude of the size of this topic. Yogesh wasn’t quite able to finish his presentation, but did a good job of showing the benefits of using WLM. My suggestion to Yogesh is that his presentation would have been more impactful if they had told a story from beginning to end. The way it was, there was too much time spent on the definition. Brave attempt!
Really this was a very high quality set of presentations and 96% of the attendees said that they learned something new. The tips that we were given were very much worth the price of admission! If you missed this show or the previous two, you can get the replays on the DB2Night Show page.
After much deliberation, we judges, Martin Hubel, Klaas Brant, and myself were able to inform host Scott Hayes that the following contestants should move on to the next round:
John, Sameer, and Thiru
Way to go! We are very much looking forward to seeing you present at the next round.
See also my previous blogs about the DB2 has Talent Competition:
First Episode of “DB2 has Talent”
Second Episode of DB2 has Talent
had 4 great presentations again this week! I’d really like to thank
all participants... I know it isn’t always easy to present, but it is
very important for us to share our knowledge with others!
Mikko - Summary Table Design & Monitoring
A little trouble following the story of the problem & solution. Summary tables are a huge topic. Well presented.
Umesha - Detailed steps to configure DB2 Distributed Data Facility (DDF) for z/OS
Good slides. Not practised? Went over time. Missing the “why”. Only “how” was covered in presentation.
Sreeharsha - High Data Availability: solutions and techniques
clearly defined. Problem clearly defined. Presentation was well put
togetehr and rehearsed. This is the way it’s done!
Armando - Dare to be Different (Against all Dogmas) SQL Performance Tuning
Be open minded on how to solve problems. You may find a creative solution that wasn't’ expected
Entertaining and engaging presentation with a great amount of style.
Congratulations to Sreeharsha, Armando, and Mikko for moving to the next level.
sure to join us next week to hear presentations from me, Martin, Klaas,
and Martin. Your turn to evaluate us! Just for fun, of course. Come
and have some fun!
Over 219,000 downloads of past DB2Night Show episodes! Congratulations Scott!!
If you missed the show, see the replay!
sure to fill out the survey when you do... you may be the lucky winner
of a $25 certificate to use at Amazon.com. Perhaps there is a DB2 book
you’d like to purchase?
The DB2Night Show Episode #2
We're going to talk about Index Design Best Practices for both DB2 LUW and
Oracle! So far we have one special guest lined up:
Independent Oracle Consultant specializing in Oracle performance
optimization (amongst many other things). We're going to look at Oracle
Index Best Practices and see how they compare to DB2. We're also working
on a special guest from the IBM Toronto Lab to spice up this lively
Are you "Joe the DBA"? Do you have a performance challenge you'd like to
discuss? Contact The DB2Night Show per the instructions found at left.
RESERVE YOUR Studio Audience FREE SEAT:
Thursday, October 1, 2009 at 10am CENTRAL.
We will be broadcasting at your favorite screen resolution. For audio,
VoIP and local country telephone numbers will be available for US, Canada,
European countries, Australia, and New Zealand. You are responsible for your
transportation to our "Studio", popping your own popcorn, and your favorite
Save the date for the third episode:
The DB2Night Show Episode #3
HIGH Availability or CONTINUOUS Availability? Join us as we discuss and
debate HADR, HACMP, and Xkoto Gridscale. Ask questions of the experts.
And find out some configuration settings and best practices to sustain
Show guests will include IBM Toronto and Xkoto experts - TBD.
RESERVE YOUR Studio Audience FREE SEAT:
Thursday, October 15, 2009 at 10am CENTRAL.
Did you miss the first episode? Catch it in re-runs:
Did you miss our Webinar on IBM DB2 LUW Index Design Best Practices and Case Studies? Access a recorded replay at
Watching TV is good!
Educate. Inform. Entertain.
Modified on by svisser1
Kevin Spacey, the awesome actor, star of great movies such as “American Beauty” and “The Usual Suspects” and star and producer of the “House of Cards” series is the keynote at the IBM Insight Conference. Does that sound strange to you? I’ve mentioned Kevin’s involvement to a few people and they wondered what an actor has to do with a conference about data??
Lucky for me, I was at an IBM Conference earlier this year and had the opportunity to see Kevin Spacey in action. My point of view: Kevin is brilliant! He apparently met with conference organizers to get an idea of what the main topics of the conference were and built his own speech. He delivered his speech with humour, insight, and with many sound bites. I was one of the people live tweeting during the event and I was thrilled to see the excitement on twitter.
Kevin focused on the way Netflix handled the “House of Cards” series: they analyzed data and realized that political dramas tend to be quite popular. They realized that it often takes more than a single season for a show such as this to find its audience. Audiences will look for inexpensive ways to get great content and often like to binge watch a TV series. What do you think? This sounds right to me, and clearly the success of “The House of Cards” shows that many people agree with the Netflix model.
I must admit that I hadn’t watch “House of Cards” before I saw Kevin’s keynote, but I have since and really like the show. I was a fan of Spacey’s before, but became more of a fan after seeing him at the conference.
I was so impressed with the great tweets that I created a summary via Storify. Check it out: http://bit.ly/SpaceyatImpact I hope this makes you feel like you were there in the audience! I often get to meet guests of the conference, and I hope I’m able to meet Kevin at IBM Insight, but since he’s not an author doing a book signing, the chances are slim.
Remember, Kevin’s keynote takes place Wednesday October 29, 8:15 – 9:30 am. You won’t want to miss it… and I can predict.. the room will be full!
Modified on by svisser1
Congratulations to Jacques Roy for the completion of his latest book:
The Power of Now
Real-Time Analytics and IBM InfoSphere Streams
This book will launch at the IBM Insight conference in Las Vegas. You can get a free book and have it signed by Jacques if you are an attendee of the conference. Jacques will be signing the books at the IBM Insight Conference Bookstore on Tuesday October 28 from 9:30 – 10:30 am. There are only a limited number of copies at the conference, so if this is a book you want, you should make sure you put the day and time in your schedule.
What’s the book about? It is about the really great product from IBM called InfoSphere Streams. I attended a few tweetchats in the past year and was happy to see the number of people who mentioned this product and the value it brings to them as they analyze data-in-motion. InfoSphere Streams is the world’s fastest and most flexible platform for streaming data. Sounds interesting, doesn’t it!
I was asked to help write the content for the covers of this book and read several chapters of the book and I find the topic quite interesting. Here is what we put on the cover of the book:
Read this book to:
Understand how the integration of multiple technologies form a big data architecture that can process data, both at rest and in motion
Learn how real-time distributed analytics can provide insights to create a business advantage and currently unseen opportunities
Discover the ways to implement a data-in-motion solution that works for your environment
Explore the characteristics that make a good real-time distributed analytics platform
Learn understand how to apply InfoSphere Streams technology to your business problems to get solutions faster
IBM InfoSphere Streams provides a new approach to processing information by providing an easy-to-program platform for distributed real-time analytics that can answer the need to generate information from the huge amount of data that comes at businesses rapidly.
In “The Power of Now: Real-Time Analytics and IBM InfoSphere Streams”, discover how distributed real-time analytics can uncover opportunities in your enterprise providing more efficiency and a business advantage. Technology is changing rapidly, and there is so much of it to learn. This book gives you a shortcut to becoming proficient with InfoSphere Streams so that you can dive into implementing a solution for your enterprise.
About the author:
If you’re not going to be at the conference, you’ll still have a chance to get a copy of the book, but in electronic format. I’ll write a new blog entry when the PDF version is available so you can download your free copy.
Today on the DB2Night Show, host Scott Hayes introduced us to the first 5 contestants on the “DB2 has Talent” competition. Scott tapped fellow IBM Gold Consultants Martin Hubel and Klaas Brant to be judges, as well as me. I must say it was put together very professionally and I think all participants and listeners had fun.
Here’s the lowdown on what we experienced.
First contestant Ramesh presented about db2top. Ramesh was clearly very skilled and passionate on this topic and it showed. Unfortunately for Ramesh, he went first, on the first show, so he was at a big disadvantage. Ramesh included too many slides to cover in the measly 4 minutes that he had available. As a result, we were not able to see his conclusion. There is much interest in the topic, so maybe we’ll have to have Ramesh back with a smaller set of slides.
Contestant two was JB. JB is clearly an experienced presenter since she didn’t sound nervous and she did a fabulous job. Here presentation was about using HADR to migrate low level hardware, OS, and software to more current levels. JB’s experience is something many people can learn from and she did a very nice job of explaining the problem, how she convince the team leads to try her solution and the amazing conclusion.
Mary was the third contestant and she presented on Identity vs Sequence. Mary as well was very comfortable with presenting and with her material. It was laid out very nicely giving the pros and cons of using each. I found her presentation to be very educational.
Norberto was the next contestant and he was from hot Brazil. He chose to present on the DB2Night Show instead of going to the beach, and we thank him for that! Norberto said that he learned English by becoming a DB2 DBA. We all know and love the database, but now we can give it credit for encouraging people to learn and become proficient in English. I really liked the humour that Norberto used in his slides, but Klaas cautioned him on using humour when the audience got really big and diverse. You don’t want to offend people! Norberto gave tips on improving SQL statements. His presentation led us through his journey of having very poorly written code to him debugging it and finally finding a way to improve the code so now it runs in 5 minutes versus the previous 10 HOURS! Way to go!!
The final contestant for today was Rob. Rob clearly reads self-help books, like I do, and chose to do a parody on a famous book by entitling his presentation “The 7 Habits of a Highly Effective DBA”. I thought the presentation showed much promise one of the first pieces of advice was to “not sweat the small stuff”. But Rob got too detailed in explaining the power of the db2diag.log and ran out of time. Rob could have used an entire hour to present his material and it would have been very well done. I hope that Rob is able to boil his material down to 4 minutes and that Scott allows him to redo his presentation… it has real promise. I suggested he write a book… but he could certainly turn this into a presentation that IDUG would be happy to have on it’s conference agenda.
All in all I was very happy meeting the contestants today and working with Scott, Martin and Klaas. In the end we invited 3 of the presenters back for a second presentation of the same material. This will allow them to fine tune their work and show us again. The three who are moving on are Mary, JB, and Norberto. Not to be sexist… but doesn’t that mean that the ladies rule????
If you weren’t able to take part in today’s show because of a conflict, I encourage you to get the replay. There are 3 more episodes like today’s and then the finale for 4 weeks in March. Hope you can join us! Oh, I think Scott is still looking for a few more contestants as well. Join in the fun.
Oh, if you do want to be a contestant, make sure you have headphones with a mic for your computer. Unfortunately there were two other people who we tried to hear from, but they weren’t set up correctly. I hope they are able to try again for one of the other weeks.
A reminder about the other shows in this series:
DB2 Night Show in February & March: DB2'S GOT TALENT CONTEST.
Join us on the following dates:
Feb 11, 2011 11:00 AM - 12:30 AM EST
Feb 18, 2011 11:00 AM - 12:30 AM EST
Feb 25, 2011 11:00 AM - 12:30 AM EST
Mar 4, 2011 11:00 AM - 12:30 AM EST
Mar 11, 2011 11:00 AM - 12:30 AM EST
Mar 18, 2011 11:00 AM - 12:30 AM EDT
Mar 25, 2011 11:00 AM - 12:30 AM EDT
We’re looking for contestants…. are you up for it? Check the site for eligibility. Maybe this will convince you to become a contestant: the prizes!
- 1st Prize: One FREE IDUG Conference Registration to any IDUG Conference in 2011 (North America, Europe, or Australia) provided by IDUG, plus up to $1,500 USD travel expense allowance provided by DBI. Approximate value of prize package: $3,500 USD
- 2nd Prize: Xbox 360 250GB Console with Kinect (approximate value $500) provided by IDUG.
- 3rd Prize: $100 Amazon.com Gift Certificate provided by DBI.
- Finalist Prizes: Each of the top 10 Contestants that are invited by the judges to participate in Finals Shows will win $50 Amazon.com Gift Certificates provided by DBI.
call them IBM’s Best Friends! One of the reasons is that they are so
knowledgeable about our products and another is that they tend to make
excellent authors. Take a look at this list and you’ll see:
Craig has published two books this year! What a great accomplishment.
Craig on Tuesday, October 23 from 12:00 – 1:00 pm at the IOD
bookstore. These books can be purchased at the IOD bookstore for a 20%
Brian Green, John Boyer, Kay Van De Vanter
Roger is a prolific author with more books to come:
books should be available at the IOD Bookstore at a 20% discount. If
you are a champion and have a book idea, drop me a line!
Here are a few tips I’ve gathered over the years that may help you with your quest to get certifed:
- Most of the IM certification exams have a time limit of 90 minutes, except the upgrade exam which has a time limit of 60 minutes. The number of questions and the cutscore for each exam varies. For example, exam 730 has 64 questions and you must score 59 percent or higher to pass it.
- Make sure you check out the exam objectives before you study. Every question on the exam relates directly to one or more of the exam objectives. You can find the exam objectives by going to the specific page for the exam on this site: IBM Professional Certification.
- If you are experienced with DB2 and feel that you are prepared to pass the exam based on what you saw in the exam objectives, take an assessment exam. You'll get a report after taking the assessment exam that can help you pinpoint your weaknesses. Assessment exams cost $10 per take, so if you really think you are ready, come and take the exam to see.
- If you are NOT experienced with DB2, download a free version of DB2 Express-C and give it a try!
- Decide on how you want to increase your skills:
a) Consider buying one of the Certification Study Guides to refresh and deepen your skills: ibm.com/software/data/education/bookstore.
The 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.
b) For self-study, also check out the free tutorials that IBM provides for most of the exams. The tutorials are broken into hour long segments of information based on the exam objectives. If you have a great deal of experience, this may be all you need to prepare for the exam. To see the full set of exam prep tutorials that are available, see ibm.com/software/data/education/selfstudy.html.
c) Take an education class from IBM or one of its partners. These classes typically have a fee, even for employees, so check with management to see if you can take one of these classes. Classroom education is an excellent way to learn, but may be difficult to justify due to costs. Don't forget to look into ILO training as this type of training gives you all the benefits of classroom education, but eliminates the travel costs. The best place to start to determine the classroom education that best fits your needs is with the training roadmaps: ibm.com/software/data/education/roadmaps.html.
- If this is your first time taking a certification exam, review the steps on this site: ibm.com/certify/process/t_proc.shtml
Can I gain experience by reading DB2 Forums and Blogs?
Absolutely! There are several DBAs who firmly believe helping out on the various forums have helped us gain a deeper understanding of subjects that were on the exams. So, contribute to those forums. You're not only helping other people, you're helping yourself as well! Most likely you'll find members of the DB2 development team actively taking part in the forums as well.
Here are the sites that I recommend, at the least:
I hope you find this information useful! Good luck on your journey towards certification!
See other blog entries about this topic:
PS… If you like this content, please follow by blog :) Next week’s theme? Either Best Practices or Books.
time for the annual IBM Press book sale, which is on from now until
Friday December 28, 2012. This is a perfect time to stock up on great
books that will help you become more effective at your job. Here’s a
list I put together along with reasons why you’d want to read this book.40% off from IBM Press: —save
40% on print books, eBooks, and videos during our this Sale. Also, as a
special reward for purchasing, you will automatically receive one free
month's access to Safari Books Online via email confirmation. Use
discount code HS2012 and start shopping now!
- "DB2 Developer's Guide"
book by IBM Champion Craig Mullins is in its 6th edition. Clearly that
means the book is a favourite to many people. This book was fully
revised to cover all the latest features in DB2 V10 and is the perfect
book for anyone using DB2 for z/OS. This comment from amazon.com sums
up the book’s value: “5.0 out of 5 stars -
The best book for DB2 developers. It is not a manual; it teaches
"philosophy" of the relational database and gives a lot of good tips.”
- "DB2 SQL Tuning Tips for z/OS Developers"
is a very short book and focuses on the most valuable tuning tips for
writing SQL for DB2 for z/OS. Written by IBM Champion Tony Andrews.
book fully reflects the latest SQL programming best practices for DB2
V9 and DB2 V10 on z/OS: techniques that are taught in no other book and
are rarely covered in general DB2 SQL courses. Drawing on his extensive
consulting experience and highly praised training with Themis Inc., Tony
also presents practical checklists and an invaluable 15-step
methodology for optimizing virtually any DB2 application.
- "An Introduction to IMS, 2nd Edition"
is the original BIG DATA database and even though some applications
were written 50 years ago, they are still working and critical to many
business transactions. Someone once told me, if you use a bank machine,
then you use IMS! Written by a team of IBM IMS experts.
you’re a DBA, database developer, or system programmer, it brings
together all the knowledge you’ll need to succeed with IMS in today’s
mission critical environments.
this book, a team of IBM’s leading information management experts guide
you on a journey that will take you from where you are today toward
becoming an “Intelligent Enterprise.”
- FREE eSampler PDF is available.
- Enterprise Master Data Management: An SOA Approach to Managing Core Information
very interesting story about this book! I spoke with several of the
authors at the IBM IOD conference this fall and learned that when they
visit customers to help them implement complex MDM solutions, they find
that their clients are using this book as the ultimate guide.
read the book cover to cover and can see why it is so valuable. The
authors have put great care into creating “patterns” for specific
industries that cover every conceivable detail about the data and the
world around it. I think this is a must read for anyone with a complex
Reminder: If you’re in Europe, find these books are featured on the www.pearson-books.com/ibmpressbookshop website
that offers 35% off and free shipping within the UK. Shipping fees to
the rest of Europe are not free, but very small. Be sure to bookmark
this page and share with others who buy technical books in Europe.Susan