Keep on Learning
The IDUG DB2 Tech Conference in Orlando is a MUST attend event for database experts and those aspiring to be an expert! And this year is special beyond special! Why? DB2 is 30 years old and IDUG is 25 years old. Come and celebrate these amazing accomplishments while you’re learning.
There are many things to learn about... here are a few for you to consider:
1. Robust Technical Session Schedule
Sessions are designed to fit your needs. You will have no problem filling your agenda with the right education for your job role and organization's priorities!
2. Celebrations for IDUG's 25th Anniversary
As mentioned above, IDUG is 25 this year! Join us to look back at where we have come from and see where IDUG is headed in the future.
3. IBM DB2's 30th Anniversary
IBM DB2 will also celebrate a significant milestone in 2013. Stay tuned for more information about celebrations for IBM DB2's 30th anniversary.
4. One Day Seminars
The perfect opportunity to learn more about specific aspects of DB2 that you deal with on a day-to-day basis.
5. Certification Exams
Take advantage of this opportunity to gain IBM professional certifications at no additional cost. All IDUG DB2 Tech Conference attendees are eligible to take two complimentary certification exams.
6. Save on Registration, Be an IDUG Mentor
IDUG offers an incomparable loyalty reward program for those who have attended three or more IDUG conferences, are an IBM Champion or are a member of a Regional User Group.
7. Complimentary Wi-Fi
Throughout the meeting space and in each hotel guest room at the Caribe Royale All-Suite Hotel and Convention Center.
8. Easy-to-Navigate Meeting Space
The Caribe Royale All-Suite Hotel and Convention Center is compact and easy to navigate.
While in Orlando, gain access to old and Stay Connected new connections. Trade business cards with industry leading vendors, your DB2 peers and speakers at the Exhibit Hall and networking events sponsored by some of IDUG's top vendors
10. Hot Industry Topics
Hear from experts regarding their opinions on important topics. Key sessions include:
Explaining Tuning Results to the C-level
Thomas Baumann, Swiss Mobiliar:
DB2 10 LUW Securely Hiding Behind the Mask
Rebecca Bond, SAP DBA Contractor
The 10 Commandments of Supporting E-commerce Databases
Ember Crooks, Rosetta
The Top Ten Things You Need to Know: For DBAs, Developers and Managers
Craig Mullins, Mullins Consulting, Inc.
Register before March 22 and save on registration!
I have much more to say on this topic, so be sure to follow my blog to avoid missing any updates.
The IDUG DB2 Tech Conference 2013 is scheduled for April 29 - May 3, 2013 in Orlando, Florida. Make your plans to attend now. The IDUG.org website has been updated with detailed information about the conference, including:
This year’s conference will be special for a number of reasons. First of all, this year is the 25th anniversary of IDUG. That’s right, 25 years of great technical education for users, by users. This is also the 30th anniversary of DB2. You can be sure that attendees and organizers will be in celebratory moods throughout the event! Why not come out and join the celebrations?
Also, any IDUG conference that takes place in Orlando tends to be special? Why? Many people like to attend conferences in Orlando so that they can bring their families for part of the week to combine the business travel with a bit of vacation. Orlando has plenty to offer, so while you’re learning, enjoy the weather and the attractions.
Full Day SeminarsIDUG One Day Seminars allow you to take a deep dive into specific aspects of DB2 with some of the most renowned speakers in our industry. Listen to these speakers and ask them your specific questions as well. This year the seminars will be held on Monday, April 29 2013 and the full day experience includes lunch as well as hard copies of the course materials. There is an additional registration fee for these seminars. For details and to register, see: Full Day Seminars at IDUG.
Here are the topics and speakers you can choose from:
Complementary WorkshopsYes, these are free, but be sure to register quickly since they tend to fill up very fast! There are two to choose from and they take place after the official conference is over, on Friday, May 3; from 8 - 2.
For details and to register, see Complementary Workshops.
Technical SessionsThere are hundreds to choose from over 6 different tracks. The list can be found on Agenda, but follow my blog to get highlights and details of many of the sessions.
The first step is for you to get funding from your boss to come to the conference. If you need help with your justifications, see:
Stay tuned for more highlights and details!
DB2 Tech Talks Now in Replay
Were you able to watch any of the DB2 Tech Talk webinars this year? There have been many excellent topics covered in the past year with a variety of experts sharing their knowledge with you.
If you missed any of these, you can watch them at your convenience. To help you filter through all the shows, I’ve come up with a list of the top 10 most popular talks:
1. Technical Tour of DB2 10 for LUW and InfoSphere Warehouse 10
Get the details behind these new product releases as announced on April 3. Learn about powerful new features such as: Adaptive Compression, Multi-Temperature Data Storage, SQL Compatibility with Oracle, Time Travel Query, Real-time operational data warehousing, and NoSQL capabilities.
2. Technical Tour of PureData Systems for transactions and operational warehousing
James Cho goes through the technical features of PureData for Transactions and PureData for Operational Analytics, showing you how these systems ease deployment, management and development.
3. Part One Certification Prep for DB2 10 Fundamentals Exam
Together, the two parts will cover everything you need to pass Exam 610 - DB2 10.1 Fundamentals.
4. Part Two Certification Prep for DB2 10 Fundamentals Exam
Together, the two parts will cover everything you need to pass Exam 610 - DB2 10.1 Fundamentals.
5. Compression Comparison: DB2 vs. Oracle Database and The rest
Chris Eaton compares DB2 10 for LUW to Oracle Database and other industry databases, explaining the features and advantages that help to maximize valuable storage resources.
6. Temporal Data Management Features of DB2 10
Matthias Nicola of IBM labs covers the bi-temporal data management features which let you manage data at past or future points in time, consistently and cost-effectively.
7. Optimize Storage Utilization and Minimize Administration with DB2 10
Learn about new storage optimization features: Adaptive Compression, Multi-Temperature Data Management, and Workload Management.
8. Oracle Database and PL/SQL Compatibility Features of DB2 10
With DB2 10 for Linux, UNIX, and Windows, you’ll find the PL/SQL Compatibility features and other enhancements make it even easier for you to switch. Learn about why and how to switch.
9. Inside Row and Column Access Control in DB2 10 and InfoSphere Warehouse 10
This talk will help you learn more at the technical level about the new Row and Column Access Control (RCAC) features in DB2 10 for Linux, UNIX and Windows and InfoSphere Warehouse 10.
10. Database Application Performance Management Best Practices
In this episode of the DB2 Tech Talk Series Cliff Leung and Holly Hayes discuss how you can use Optim Query Workload Tuner and Optim Performance Manager to easily get to the bottom of common database problems. For those who have not looked at OPM and OQWT in a while, prepare to be amazed.
Be sure to follow my blog to learn about all the Tech Talks that will take place throughout the coming year.
What’s happening in your DB2 world? I asked this question to many of the people I’m connected with on twitter and I got many responses that I’d like to share with you.
Rebecca Bond@DB2locksmith hasn’t had time to update her blog (http://www.securedb2.com) lately, but is thinking of topics she could write about. Is there something you want Rebecca’s opinion on? I’m sure she’d love to have some suggestions to help her write something.
Kohli Kshitij @kohli83 had a great year! He won the “DB2’s Got Talent Competition” from the DB2Night Show, he attended IDUG in Denver and IDUG in Berlin, he says that his favourite sessions were:
Sanjeev Datta @1dsanjeev is very pleased with the publication of his new book: IBM Cognos Insight (http://www.packtpub.com/ibm-cognos-insight/book). He recommends Chapters 1 for anyone who is new to IBM Cognos and IBM business vision and strategy. Chapters 4 & 5 will help finance, sales, & marketing departments in usingCognos Insights to develop their own workspaces. If you find the book sold out on amazon, contact Sanjeev through twitter and ask him for other buying options & discounts.
Michael Schulz @mikeondb2 says DB2 is rockin' and rollin' and PureData for Transactions is taking it to a new level. Don’t forget to read this article that Mike recently wrote for IBM Data Management Magazine: "Achieving High Availability and Disaster Recovery with IBM DB2" .
@DB2Geek The DB2Geeks had a very successful year and celebrated at IDUG Berlin. Take a look at their blog and Beat The Geek photo gallery.
@CuneytG has just published another article in the IBM Data Management Magazine: “Gear up with IDAA: IBM DB2 Analytics Accelerator”
Sunil Soares @SunilSoares1 just finished the Data Governance Winter Conference. He’ll be speaking at IDMA conference in April 2013 on best practices for insurance data governance. He’s very happy with the publication of his latest books and the sales of all three of his books:
Philip Gunning @db2luw is finishing off his latest book that will publish in 2012 as well as performed a DB2 upgrade with TSAMP, HADR & wrote an article on Temporal Tables that will published on http://enterprisesystemsmedia.com/..
Vijay Sitaram @vijaykarti is organizing the IDUG 2013 conference in Orlando. Lots of exciting news: Complimentary workshops and Cert Crammer courses! Check out http://www.idug.org/NA
Craig Mullins @craigmullins Craig not only published two books this year, he’s also written many articles including this “presentation” style article “Ten Breakthroughs That Changed DB2 Forever” which let Craig talk about a lot of DB2 things without worrying about how I tie them together.
If you have an answer to my question “what’s happening in your DB2 world” and would like to share with me and others, either send me a tweet @susvis or post on the DB2 Facebook page.
How would you like to share your expertise with others at a conference? While at the conference, you can attend sessions and learn about other areas and encourage other speakers.
I’m sure many people have mixed emotions about the prospect of speaking at a conference because public speaking is still one of the number one fears in the world. Even people who you think are natural at speaking in front of thousands of people have fears. Ask Jeff Jonas!
This fear can be overcome, and thanks to the DB2Night Show’s “DB2’s Got Talent” Competition, you can slowly build up the skills you need to create a presentation that conveys content you want to share and to speak in front of others. You’ll get feedback, you’ll be recorded, and you can learn from your mistakes and do it again. I can’t think of a better way to build presentation skills.
This will be my third year acting as a judge on the competition. I must say that I learn an incredible amount simply by listening to the presentations and offering feedback.
I hope you’ll consider joining our cast of contestants this year in our quest to build more talent in the DB2 pool of experts.
Here are the details of how the contest works along with a few tips: Contest Information
Why should you take part in this competition?1) To win a great prize
2) To become better at public speaking
3) To build a network of talented people in the DB2 world
4) To become better at your current job or to help you get promoted to your next job
5) To share the knowledge that you’ve created that will likely help someone else.
There are plenty of tips on the internet to help you overcome the fear of public speaking, but here are a few tips from me for those who wish to take part in this competition.
First, watch the replays of the past two competitions. This will give you an idea on the topics that you can choose for your presentations and you’ll quickly see the difference between good slides and not-so-good slides. A good presentation vs a not-so-good presentation. Simply by watching you’ll improve your skills.
Secondly, you’ll be asked to create a short presentation and speak to the attendees on the webinar. Speaking in person versus speaking on the phone can be quite different and hopefully you’ll find speaking on the phone less intimidating to start.
Third, you’ll be given feedback from the judges as well as host Scott Hayes. Our intention is to encourage you, so you won’t be publicly trashed like Simon Cowell does to the contestants who face him! You can use the feedback to improve your slides, your style, and your choice of topics.
Here are links to the past shows.
We HAVE a winner! DB2’s Got Talent Competition
Session 1 of the DB2’s Got Talent 2012 Competition
Session 2 of the DB2’s Got Talent 2012 Competition
Session 3 of the DB2’s Got Talent 2012 Competition
Session 4 of the DB2’s Got Talent 2012 Competition
DB2’s Got Talent Finals – Round 1
DB2’s Got Talent Finals – Round 2
DB2’s Got Talent Finals – Round 3
Summary of 2011 Competition
Sample presentationIn Session 4 of the 2012 competition, Klaas Brant gave a presentation and tips to help you. Here is what I wrote in my blog about his presentation:
Extra Special Presentation – Klaas
DB2 LUW Prefect IO Configuration
This was a real presentation and a good one, at that. Klaas gave this primarily to show the contestants a well organized presentation, that is interesting and informative. If you are moving on, or if you simply want to improve your presentation skills, take a look at what Klaas did to get some ideas. The first thing I noticed and mentioned on the show is how appealing graphics are. I’m not sure if I would have said that before, but after today’s amazing 8 presentations I can say that the ones that captured my attention to the fullest were the ones that had graphics. And not complex graphics, rather simple ones that are make a connection to the technical material being discussed. Here’s a summary of the tips we gave over the past month:
And for good measure, here’s an article I found on the internet from Forbes: “How to Conquer the Fear of Public Speaking” by Nick Morgan.
I hope I’ve convinced you to give it a try. You have nothing to lose, but much to gain!
svisser1 2700018UK9 Tags:  analytics idug euro books_for_europeans discounts db2 1 Comment 8,875 Views
Next week I’ll be in Berlin promoting books at the IDUG event:
IDUG DB2 Tech Conference in Berlin, Germany 2012
Estrel Hotel, Berlin, Germany
4 - 9 November 2012
I wasn’t able to set up a bookstore for this event, but I hope you will like and benefit from what I was able to arrange.
I have a single copy of each book that I want to promote being shipped to me at the conference. I’ll set these up in the EXPO area for you to take a look at what is available. Browse through the books as well, but leave them with me so others may take a look as well.
I’ll then provide you information as to how you can order a copy of the book for yourself. I’ve taken into account that buying from a US-based publisher can be expensive, especially for shipping, and all of my recommendations are for you to buy the book in either electronic format or from a European source. Several of the publishers have also agreed to sell the books at a discount so IDUG attendees can get the best price possible.
Here are the books I’ll be promoting:
Pearson / IBM Press
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.
IBM Press books are available in epub and kindle formats as well.
The books ship from the UK, and they will offer free shipping on all orders to Germany during November.
MC Press books are available in epub and kindle formats as well.
Use the discount code: DALLBK for a 20% discount, valid till 30th November, 2012.
Packt books are available in epub and kindle formats as well.
The best prices for these books can be found on http://www.amazon.co.uk/ where you can currently get 50% off of each title.
McGraw-Hill books are available in epub and kindle formats as well.
In addition to these books, we’ll also be handing out a limited number of free printed Flashbooks.
Another great IDUG conference is about to begin. This one takes place in Sydney, Australia, 12-14 September, 2012.
There is still time to register and many reasons why you should attend.
Sessions available for you to choose from:
John Campbell - DB2 for z/OS - Trends and Directions
John Campbell - Enterprise Application Development with DB2 for z/OS
John Campbell - Enterprise Application Development with DB2 for z/OS
Saghi Amirsoleymani - The Truth about Data Studio 3.1
Neale Armstrong - Bringing Analytics to the Data - Data Warehousing and
Business Analytics on System z
John Tobler - Leveraging the Instrumentation Facility on DB2 for z/OS:
Tracing and Monitoring Fundamentals
Phil Grainger - ALTER in DB2 10 - Things got easier didn't they?
Nenad Vasiljevic - In the land of traces
Scott Hayes - DBI Software Presentation
Terry Purcell - Runstats Challenges for Optimal Query Performance
Terry Purcell - Do these DB2 10 Optimizer Enhancements Apply to Me?
Terry Purcell - Optimizing DB2 Applications Using Extended Explain Tables
I hope you can attend!
Conferences are a great way to learn a great deal in a short period of time and also a great way to meet people in the industry. Unfortunately, not many people are able to get budget to travel to the big conferences such as IDUG or IOD. The next best thing is to attend regional user conferences that bring the best of the best speakers to a location close to your home or office.
The are many regional user groups that take place regularly across the world, but the one I’ll tell you about is the one in my local: Toronto / Markham: Central Canada DB2 Users Group.
This year’s meeting takes place June 11-12, 2012 at the Institute for Learning.
What can you expect at this meeting? As usual, great speakers, great topics, networking opportunities, certification exams, and I may even show up to give people copies of the latest DB2 Flashbook.
Summary of Sessions and Speakers:
"Half Day with Bonnie Baker"
"What Can I Do To Protect DB2 Against Warehousing, WebSphere, and
"A New Catalog and Directory Structure in DB2 for z/OS"
"Looking Behind the Curtain of DB2 for z/OS 10 Performance and
Scalability: Storage Monitoring and Control"
"Gain Insight into DB2 for z/OS 10 Performance Updates and SAVE
"The Importance of Being Consistent - DB2 for z/OS and Remote Copy
Services for IBM System z"
"The Many Uses of Flash Copy with DB2 for z/OS"
"Temporal Data - An Insurance Policies Life"
"Application Performance - Tuning, Trending and Testing"
"Switching – What IS Access Path Stability?"
"It Could Happen To YOU – Scary Disaster Stories, Lessons Learned,
NOTHING is Impossible"
"DB2 for z/OS Utilities Update"
“Goin' Mobile [Beep Beep]"
“Take a REST from Using SOAP"
“Which DB2 High Availability Technology is Right for You?"
“Deep Dive into DB2 10 Query Performance Optimization: Statistics and
“Storage for DB2 Server"
“DB2 10 for LUW - Early Experiences with Storage Management and
“Upgrade Best Practices to DB2 10 for LUW”
“Stuffed with Great Enhancements DB2 9.7 Fix Pack New Features”
IBM Certification Exams :Tuesday June 12th
Come for the learning, but have a bit of fun while your at it! Looking forward to seeing everyone!
I am looking forward to going to Denver this weekend in preparation of IDUG NA which starts on Monday, May 14. I’m hoping to blog and tweet from there, so regardless if you are at the conference or not, you can follow what’s going on. Here are some key links:
IDUG’s Facebook page will also be pretty busy during the conference too: www.facebook.com/IDUGDB2
More information about this year’s IDUG Conference:
On Tuesday in the Exhibit Hall, we'll be handing out a limited supply of signed copies of the New Flashbook for DB2 10. For those of you not at the conference, follow my blog for information on how you can download a copy for free.
Two other books will be launching at IDUG this year. We don’t have a bookstore, but be sure to speak to the authors for information on ordering a copy for yourself at a discount offered to IDUG attendees:
The winner of this year’s DB2’s Got Talent competition was Kohli (We HAVE a winner! DB2’s Got Talent Competition) and he chose to attend IDUG Denver as his prize. I’m looking forward to meeting Kohli. If you were also a competitor, please find me at the show and introduce yourself.
If you’re interested in writing articles or books, or reviewing any of the upcoming books… also find me and let me know. I may have some interesting opportunities for you!
I hope you’re taking part in some of the learning opportunities available now that DB2 10 & InfoSphere Warehouse 10 have released. Check out my blog from yesterday about all kinds of options: April 30, 2012: GA of Version 10 products: DB2 for LUW and InfoSphere Warehouse.
Today I want to expand on a couple of webinars that I mention in that post. First off, the DB2 Night Show. Last Friday, May 4, host Scott Hayes invited IBMers Danny Arnold and Glen Sheffeld to talk about the latest release: DB2 LUW 10.1! STOGROUPS, WLM, RCAC, and More. If you missed it, be sure to watch the replay. Replays available in WMV and M4V formats.
There is so much to talk about that this was just part 1, and was a deep dive into What's New in DB2 LUW V10. Storage Groups, Workload Manager Enhancements, and Row and Column Access Controls were covered, and many example SQL commands were shared to illustrate the concepts.
According to Scott’s website, 100% of the audience learned something new! “Danny and Glen were terrific guests. I appreciated all of the SQL and command examples that they shared while discussing STOGROUPS, WLM Enhancements, and RCAC. Their presentations offered significant technical depth - this wasn't just a DB2 10 marketing pitch. I am delighted that 100% of our studio audience indicated that they learned something.”
Register now for Part 2: Episode #81 will discuss DB2 10 compression enhancements, HADR, time travel queries, index jump scans, zigzag joins, and more. Special guests from IBM share breaking news about vNext. Part 2 of 2. This will be a 90 minute show. Yes, there is A LOT to talk about.
Secondly, The DB2 Tech Talk Series, hosted by Serge Rielau. The next show, DB2 Tech Talk: Optimizing Storage Utilization for DB2 10 , takes place May 11, 12:30 EST to 2PM EST.
Learn about the new storage optimization features in the newly available DB2 10 product.
We will cover three areas including:
This technical tour is the second DB2 Tech Talk on the DB2
10 and InfoSphere Warehouse 10 product releases.
The first of the series was DB2 Tech Talk: Technical Tour of New DB2 10 and InfoSphere Warehouse 10, which took place April 26. Watch the replay. Serge Rielau, Conor O’Mahony, and Cindy Fung took you on a tour of DB2 10 & InfoSphere Warehouse 10.
Mark your calendar for the 3rd in the series, DB2 Tech Talk: Oracle Database and SQL/PL Compatibility, which takes place on May 31.
See also my other blog entries about DB2 10 and InfoSphere Warehouse 10: