A DB2 Symposium is a three day training event with one day seminars presented by industry leading consultants. The DB2 Symposium fills the gap between a conference and a multi-day training. The DB2 Symposium is unique because you can join us for 1, 2 or 3 days, depending on your needs and budget. In the past I’ve seen many IBM Champions on the schedule including Bonnie Baker, Martin Hubel, Bryan Paulson, and IBMers such as Melanie Stopfer, Matt Huras, and Tim Vincent.
The team that brings you the DB2 Symposium wants to know what you like and what you don’t like by answering this survey.
What is a Symposium?
In ancient Greece a Symposium was a meeting where they discussed a topic. So is the DB2 Symposium. These one day seminars began in 1999 and have been very successful. The feedback over the years has been very positive. But times are changing and the team wants to be sure that they are still fulfilling your needs.
I haven’t attended a DB2 Symposium, but I’ve worked at several that have taken place in Toronto. I like the format and find that many people attend for a day or two allowing them to get excellent education, but with fewer interruptions to their home life. This is of course if the Symposium is taking place in the city where you live or work. You can help influence this by filling out this survey. This survey is for USA DB2 users, so don’t even attempt if you are outside the USA. Perhaps the events outside of the USA are already located in convenient locations… like the one in Toronto.
Another reason to fill out the survey is to win a prize. Everyone who completes the survey will be entered to win a full 3-day DB2 Symposium Pass or another prize. The survey closes Sunday December 18, 2011, so don’t delay.
The questions on the survey will ask you about the topic you want covered as well as where you want the event to take place. For a symposium to work well, the right balance of topics needs to be scheduled. You can influence the agenda by filling in the survey, saying what you would like to see in the sessions. The 2012 schedules will be adjusted to what you want, so be sure to send this survey to others in your area who may also to attend the symposium.
See http://www.db2-symposium.com for details. Results for this survey, including the winner, will be made public in the DB2Night Show of 20 December (Eggnog party and Scott’s 50th birthday).
Pass this information on to ensure that you continue to have world class education brought to you by experts.
What is DB2University
Essentially this is a very inexpensive way for people to build their skills on DB2. As DB2 grows in marketshare, there will be more jobs available for people to work with DB2 databases and we need to make sure that there is a strong pipeline in place to ensure that people every where in the world have the proper skills.
DB2university.com is still in beta, so if you have feedback, send it to us so that we can make the necessary improvements. I’ve already seen a few excellent comments come in.
Currently you can find these courses (which are also still in beta):
- SQL Fundamentals I (Instructor-led)
- DB2 Essential Training I (self-paced)
- DB2 Essential Training II (Instructor-led)
- Data Studio Essential Training I (self-paced)
The Instructor-led courses are monitored more frequently by instructors, which means more active participation in the corresponding course forums. They also require students to submit assignments, and are the only ones eligible for the promotion that is offering the following benefits:
- FREE certification vouchers
- 50% discount certification vouchers
- FREE hard copies of books shipped to you
The top 20 students on each of the instructor-led courses will receive something of the above.
The DB2 Essential Training I course is offered in English, Spanish, Portuguese and Russian!
Note that much of this work is done via a community of volunteers, so if you are interested in helping, there may be an opportunity for you.
Other places you should look at that are related:
DB2 on Campus Blog
Thanks to Raul and his team of volunteers for pulling this together. What a major achievement!
One thing about IBM is that there is NO shortage of options for you to choose to increase your skills and learn about IBM products and technologies! You can find options that are free and easily accessible to custom designed courses to suit the specific learning needs of your employees.
Why are there so many options? Learning is one of the most important things you will do in your lifetime and is something that you do from the day you are born until you die. We don't all learn the same way though, so having a choice of options is very important so that you can find the learning method that is best for you.
Here are articles and white papers that I've read that emphasize the importance of continued learning:
Whitepaper The Value of Training
shows that by cutting skills development and training budgets in the hopes of improving gross margins will cause higher attrition, higher support costs, and the risk of falling behind in technological advances.
Whitepaper DBA Certification: Is It Worth It?
by Howard Fosdick
compares the costs to the benefits of earning a DBA certification. This white paper is a few years old, but the message is still valid.
Article "Is certification valuable, or not? We have the definitive answer
by Linda Musthaleris
says that companies need high-functioning teams that are able to transform and grow the business like never before. These teams consist of highly skilled professionals who have current and relevant knowledge. Certifications are designed to encourage people to keep learning and then to validate their skills.
Here is a list of the learning options that are available for the Information Management products and technologies.
- Many choices are available ... many are free, but you can also read books on electronic reading devices such as Kindle. See my blog entry "The Year of the e-Book
- The PDF versions can be downloaded for free and books are available for a very wide range of topics. See the IBM Redbooks web page
and my blog entry
with a few IBM Redbook recommendations.
White papers - A white paper is an authoritative report or guide that often addresses problems and how to solve them. White papers are used to educate readers and help people make decisions. For a list of whitepapers, google search "db2 whitepapers".
Instructor-Led Training (ITL)
classes are traditional classroom courses where students are in the same room as the instructor who guides the students through classroom material and hands-on lab exercises. Students are able to interact with fellow students and the instructor and are provided with printed course material.
Instructor-Led Online (ILO)
classes are equivalent to ILT classes in terms of classroom material, labs, instructor and fellow students, only you won't need to leave your home or office as you will connect to the classroom via your computer. See my blog entry about ILO classes
Self-Paced Virtual Classes (SPVC)
are for students who don't need the instructor or don't want to be tied to a class schedule. These classes are typically lower priced than ILO or ILT classes meaning that you save on travel and tuition costs. Content, labs and instructors are the same as ILO and ILT classes, but it is recorded so the class can be taken at your pace, where and when you want it. See my blog entry about SPVC.
Web-Based Training (WBT)
are standalone courses on the web that provide 6-8 hours of instruction. These are typically voice over power-point format.
are available for companies that want training to take place on their premises with course material that is taken from multiple existing courses and changed to suit specific needs.
Just a reminder that I will cover this information and more in my upcoming webcast - Feb 12 at 11 am EST on The DB2Night Show Episode #12
- "The Wild Wonderful World of DB2 Resources
IBM officially calls them Information Champions, but I call them “IBM’s Best Friends”.
Who are our Information Champions, what do these people do, and how can you become one yourself? These questions are answered very well on the official website which I’ve reposted here in my blog:
IBM Welcomes 2010 group of Information Champions from Cognos, Data Management, Enterprise Content Management and InfoSphere segments
Technical communities, Web sites, books, conference speakers and blogs all contribute to the success of IBM’s Information Management products. But these activities don’t run themselves. Behind the scenes there are dedicated and loyal individuals who put in their own time to run user groups, manage community Web sites, speak at conferences, post to forums and write blogs. Their time is uncompensated.
IBM honors the commitment of these individuals with a special designation - Information Champion - as a way of showing our appreciation for the time and energy these exceptional community members expend.
Information Champions are objective experts. They have no official obligation to IBM. They simply share their opinions and years of experience with others in the field, and their work contributes greatly to the overall success of IBM Information Management.
What does an Information Champion receive?
- Featured profile on the IBM Information Management Web site
- Special invitation to events
- Customized crystal honoring Information Champion status
- IBM contacts within the Information Management product development teams to facilitate communication with IBM labs
- Technical resources such as early access to Information Management software
I’d like to specifically mention a few of these champions by name who have worked with me to publish books and create DB2 certification exams. I give each of these people my personal recommendation for the work that they do.
First the authors of retail books that were recently published:
Craig is the author of two books: DB2 Developer’s Guide, currently in its fifth edition; and Database Administration: The Complete Guide to Practices and Procedures.
Co-author of the DB2 9 for z/OS Database Administration Certification Study Guide.
Co-author of Flashbook: DB2 10 for z/OS:Cost Savings… Right out of the Box.
Author of DB2 9 for Developers.
Author of DB2 9 System Administration for z/OS: Certification Study Guide: Exam 737.
Member of Certification Development team for Exam 737.
Co-author of Flashbook: DB2 10 for z/OS:Cost Savings… Right out of the Box.
Lead author of Understanding DB2 9 Security
Member of Certification Development team for many DB2 exams.
Author or co-author of the following books plus many more:
Member of Certification Development team for many DB2 exams.
Co-author of the DB2 9 for z/OS Database Administration Certification Study Guide and other books.
Member of Certification Development team for many DB2 exams.
Information Champions continue to help me review books that are in production and I’d like to help many more of the people who are Information Champions become authors. If you’re interested… please let me know.
Winning a free trip to an IDUG conference of your choice is the first prize in this year’s “DB2’s Got Talent” Competition. The IDUG locations that you’d choose from are Denver, Berlin or Sydney. It would be pretty difficult to choose from such wonderful places, but that’d be a tough problem to have!
What do you have to do to win?
You will need to create short technical presentations about DB2 and present them to attendees on the DB2 Night Show’s webinar. If the judges choose you, you’ll get yet another chance to create a presentation. In the finals, your peers vote to select the ultimate winner.
Sound easy? If you know DB2 well, it should be easy. Beyond winning a trip to IDUG, you’ll be improving your technical and presentation skills, building a very strong network, and making a name for yourself as an expert.
Learn from past presenters. Those who take part in this year’s competition have it much easier than last year’s contestants. Those who participate this year can review all the great presentations (especially those from the top 5: Mary, JB, Thiru, Momi, and Norberto)that were delivered last year and can learn from them. Here are my blog entries with links to the replays:
First Episode of “DB2 has Talent”
Second Episode of DB2 has Talent
Third Episode of “DB2 has Talent”
Fourth Episode of "DB2 has Talent"
DB2's Got Talent - March 11 Episode
DB2's Got Talent - 3rd Episode of the Finals
DB2’s Got Talent Finale
DB2, DB2Night Show and IDUG as viewed by JB
Tips for DBAs from Guest Blogger Norberto.... DB2's Got Talent contestant
And the winner of the DB2's Got Talent Competition is….
Interested? I hope so! Here are all the nitty gritty details: DB2’s Got Talent.
This year there are also great runner up prizes:
- 1st Prize: One FREE IDUG Conference Registration to any IDUG Conference in 2012 (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
- 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 Triton Consulting.
Once again I’ve been asked to be a judge for this competition. I’m thrilled to be invited and am looking forward to meeting the many talented people who will take part in the show.
Good luck to all!
If you were at the IOD11 Conference last week and tried to get a copy of the latest Flashbook “Understanding Big Data: Analytics for Enterprise Class Hadoop and Streaming Data”. If you weren’t at the conference, here’s what happened: I had 3000 printed copies of this book by IBM experts Paul Zikopoulos, Chris Eaton, Tom Deutch, George Lapis, and Dirk Deroos. We scheduled 2 time periods for the giveaways and author signings… Monday & Tuesday outside the event center after the opening session. None of the books were remaining after the first giveaway. Yes, it is true that we handed out 3000 copies on that Monday morning in what seemed like a mere 30 minutes!
I had an additional 1000 copies of this book delivered for Wednesday morning and had no trouble finding people who were eager to get a copy of the book to read. I’ve given out books at many conferences over the years and must say that this was the most exciting of all. More about the book: Flashbook: Understanding Big Data: Analytics for Enterprise Class Hadoop and Streaming Data http://ibm.co/pVhiw2
#iod11 #bigdata #analytics
If you didn’t get a copy, I’m happy to announce that you can get the free e-version of this book on my bookstore page: ibm.com/software/data/education/bookstore. The book will be on that page later today or tomorrow… so don’t be discouraged if you don’t find it right away.
If you’re an IBMer and want a box of these books for an event, contact me via my IBM email address and I’ll give you instructions on how to get the books.
Want more? Here are other ways that you can build your knowledge and skills on this hot new technology:
1) Join Paul Zikopoulos this Friday, Nov 4 on the DB2Night Show, Episode #62 – Big Data Overview. The space for this free webinar is limited, so register now! Thanks again to award-winning IBM Champion Scott Hayes for doing such a great job of entertaining and educating the public!
2) Read Jeff Jonas’ blog entries about Big Data:
3) Dive into the best wiki in the world! BigInsights Technical Enablement Wiki: ibm.com/developerworks/wiki/biginsights/
4) Read this technical intro to IBM BigInsights, IBM’s Big Data platform, by Cynthia Saracco: Understanding InfoSphere BigInsights: An introduction for software architects and technical leaders.
5) One of the 82 Web-based Training Courses available for IM is BigInsights Essentials.
6) Want to learn Hadoop, MapReduce, HBase or other Big Data topics? Join free BigDataUniversity.com.
7) Read the excellent article by Lisa Stapleton that published in a recent edition of the IBM Data Management Magazine BigData - Volume, Variety, and Velocity. How do you attack something *that* big?
8) Read the article Big Data Impacts Data Management: The Big Vs of Big Data by IBM Champion Dave Beulke.
9) Follow the blogs and tweets that are happening real-time via the Big Data Daily.
10) Read the article by IBM Champion Craig Mullins Big Data and 150 Trillion Calculations Per Second at Vestas
Read, attend and learn!
Modified on by svisser1
Last year at IDUG in Berlin, I met Sue Sterling from MetLife. We have a shared love of books & DB2! I’m looking forward to seeing Sue at IDUG in Orlando next week where she will be presenting at the following session:
C05 - Highlight Zone-MetLife DB2 LUW-Tooling Time
It’s not always easy for employee of a company as large as MetLife to get approval for talking about their experience with a software product. So, take this rare opportunity to learn from Sue as to how MetLife has benefited from using DB2.
At MetLife we “create time” for our DBAs with performance, availability, cost reduction, and expense avoidance tools. The presentation shares our DB2 LUW footprint with easy-to-follow examples illustrating OPM 5, STMM, WLM, ROS and V10 Oracle-compatibility
Date, Time & Location
Attend this session on Wednesday May 1 in the Grand Sierra Rooms H&I from 9:15 AM - 10:15 AM
Sue Sterling is a Database Director and IBM Certified Solution Expert with a deep database background at MetLife as the enterprise continues to expand and globalize. Sue owns the health and stability of DB2 LUW engineering and architecture for nearly 2000 DB2 LUW databases. She has worked with databases for 15 years and in IT for 30 years, with DB2 LUW since its inception, and DB2 zOS before that. Sue is an early adopter of Optim Performance Manager (OPM), Netezza, Guardium, and a key member of the DB2 LUW Customer Council. Sue has authored and delivered technical presentations internationally in such locales as Nice, Hamburg, Berlin, San Jose, Orlando, Anaheim, Dallas and New York City.
During this session, you will learn:
Objective 1: Using a portrait of MetLife real applications, teach how to implement and use Optim Performance Manager 5.1 to very quickly allow DBAs to analyze and tune health and performance more quickly, eliminating the need for home-grown scripting and analysis.
Objective 2: Illustrate MetLife's experience, challenges, and shaping of Self-Tuning Memory Manager to free DBA time, more effectively distribute memory on hundreds of systems, and in some cases improve performance and ease CPU use.
Objective 3: Show MetLife's first implementation of Work Load Manager: our goals, our successes, and our challenges, including business rule definitions.
Objective 4: HADR has become mainstream at MetLife. Automated Client Reroute (ACR) is also popular. In 9.7 Read on Standby (HADR ROS) has become available. Here we will convey our experiences and practical tips with ROS considering the strengths and restrictions.
Objective 5: In DB2 LUW V10 Oracle-Compatible Mode is said to be 99% transparent, up from 95% in V9.7 without developer intervention. Describe our Oracle-Compatible proof of concept and findings which have helped us target Oracle database applications to convert to DB
I hope you can attend this session!
Also about IDUG:
IDUG DB2 Tech Conference in Orlando, Florida, USA 2013
April 29th - May 3rd, 2013
Published books featured at IDUG 2013
IBM Certification Exams at IDUG 2013 by IBM Champion Rebecca Bond
Blog Sessions at IDUG by IBM Champion Troy Coleman
Free - Technical Immersion Workshop: DB2 10.5 with BLU
IBM Champions at IDUG, Orlando - April 29 - May 3
New Flashbook: The Business Value of DB2 for z/OS: IBM DB2 Analytics Accelerator and Optimizer
All about IDUG 2013 - from the DB2Night Show
New to DB2? Why you should attend IDUG 2013
Attend IDUG DB2 Tech Conference 2013 - Apr 29 - May 3, 2013 in Orlando, Florida
DB2 Tech Talks Now in ReplayWere
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 10Get
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 warehousingJames 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 ExamTogether, 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 ExamTogether, 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 restChris
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 10Matthias
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 10Learn about new storage optimization features: Adaptive Compression, Multi-Temperature Data Management, and Workload Management.8. Oracle Database and PL/SQL Compatibility Features of DB2 10With 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 10This
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
Be sure to follow my blog to learn about all the Tech Talks that will take place throughout the coming year.
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.
Modified on by svisser1
What do you know about Column Masking? And why should you use it?
DB2 10 Column masking is a significant security tool that can be used to enable greater protections for sensitive data.
IBM Champion Rebecca Bond has a session at IDUG this year called
DB2 10 LUW -- Securely Hiding Behind the Mask
It takes place in the Grand Sierra H&I on Tuesday, Apr 30, 2013 from 2:00 PM till 3:00 PM.
This session begins with a general overview and gradually moves to a more detailed discussion. Covered are: Use Cases, Examples and Implementation Instructions. The session summary answers the question, “Why use column masking?”
Objective 1: Introduce the new column masking functionality of DB2 10 LUW.
Objective 2: Answer the Question, "Why Use Column Masking?"
Objective 3: Provide examples of appropriate uses for column masks,
Objective 4: Provide implementation steps and instructions for building column masks
Objective 5: Discuss ‘profiting’ from column masking (benefitting the organizational bottom line)
Also by Rebecca:
Understanding DB2 9 Security
The book may not be at the current level, but it contains very detailed instructions on how to create a sound security plan for your data. Maybe Rebecca should update the book??
Today is Earth Day, so you can get a discount if you buy this book in eformat... along with one other IBM Press book. For details see Earth Day Sale.
17 Database Journal Articles by Rebecca
Articles and Appearances on the DB2Night Show
Video filmed at IOD 2012 starring Rebecca
A blog post by me about Rebecca
Rebecca’s website that includes her blog & more: securedb2.com/
If you’re attending IDUG, be sure to meet Rebecca in person... I guarantee that you’ll like her! And attend her session, DB2 10 LUW -- Securely Hiding Behind the Mask. She’s a great speaker and you’ll be sure to walk away just a bit smarter!
Rebecca Bond, an IBM Information Champion, industry recognized independent consultant and author of the only published book specific to DB2 LUW security, "Understanding DB2 9 Security", enjoys sharing technical lessons learned from her experiences in government, healthcare and financial consulting roles. Rebecca holds numerous advanced IBM certifications covering all aspects of DB2 and is an expert at balancing the twin needs of robust security and accelerated performance. Her unique background provides a wealth of pertinent database and security puzzlers, which she delights in helping us understand and solve via articles, blog posts and presentations. Her website is www.securedb2.com.
For IDUG, see also:
Two new Information Management IBM Redbooks were published in August: IBM High Availability Solution for IBM FileNet P8 Systems
DB2 Optimization Techniques for SAP Database Migration And Unicode Conversion
Many organizations require almost
continuous availability of their mission-critical, IBM® FileNet® P8
systems. Loss of system resources and services can translate directly
into lost revenue and lost customers. The goal, therefore, is to design
and implement IBM FileNet P8 systems that are highly available by
compensating for both planned and unplanned system outages and
eliminating single points of failure.
IBM FileNet P8 Platform
provides availability features that are built-in to the core
components. With these features, high availability of an IBM FileNet P8
system can be achieved through redundancy: redundant components,
redundant systems, and redundant data. Hardware and software components
might fail. With redundancy, the failure can be eliminated or minimized.
IBM Redbooks® publication describes strategies and options for core IBM
FileNet P8 system components. In addition, the book provides detailed,
step-by-step procedures that we used to implement high availability for
our case study IBM FileNet P8 system. This book serves as a practical
reference when you design and implement highly available IBM FileNet P8
This book is intended for IT architects, IT specialists,
project managers, and decision makers identifying the best high
availability strategies and integrating them into the IBM FileNet P8
system design process.
SAP® migrations are a standard
process nowadays. This IBM® Redbooks® publication describes
optimization strategies and best practices for migrating SAP systems
toward IBM DB2 for Linux, UNIX, and Windows, as well as for performing
Unicode conversions. We discuss DB2-specific recommendations and best
This book is intended for experienced SAP migration
consultants involved in operating system and database migrations or
Unicode conversions, choosing IBM DB2 as a target database platform. It
addresses the advanced SAP migration techniques, considerations for
database layout and tuning, and unique DB2 capabilities such as
compressing the target database while loading data.
provides in-depth information about the best practices and
recommendations for the source system database export, the advanced
migration techniques, database layout and configuration, database
import recommendations, SAP NetWeaver Business Warehouse, as well as
background information about Unicode. We summarize our recommendations
in one chapter that can be used as a quick reference for experienced
migration consultants. Keep up with the latest technology with IBM Redbooks, which you can download for FREE!
Yesterday I published the blog entry NOW is a good time to upgrade to DB2 10.5! and I had a comment asking me how people can quickly upgrade their skills. The person asking was focused on those who have Oracle skills and now want to work on DB2, but new skills need to be taught to those who are skilled in DB2 9.7 and now need to move to DB2 10.5. Here is what I suggest:
Three Easy Steps to Learn BLU Acceleration
Step1: BLU Acceleration Technical Deep Dive
IBM Distinguished Engineer, Sam Lightstone , (1.5 hours)
Step 2: DB2 10.5 with BLU Acceleration free flash book
New analytics for the era of big data
Step 3:Try it using one of these options
BLU Acceleration for Cloud - OR – 90-day free trial software
My biggest tip: Be active in social to get the very latest in what is published. Social channels like blogs, twitter and facebook are used to promote the ever growing list of learning materials. You’ll find links to white papers, articles, best practices, videos, books, and even formal education. If you’re on twitter, there is really only one place to follow: https://twitter.com/IBM_DB2 This is the official DB2 account and posts will tell you everything you need to know, including activities generated outside of IBM. Although IBM produces a ton of great content, we rely our partners, IBM Champions, and IBM Gold Consultants to also publish content about our products. I’ll do a separate blog post on the incredible learning opportunities provided by our user groups and partners.
We have a dedicated website called ibmbluhub.com that is the go-to place for all things BLU. My intern Tori McClellan just published her first blog entry about what you can find on the “BLU Hub”: Steps toward the Future: How IBM DB2 is changing the Game.
DB2 is something like 99% compatible with Oracle. Danny Arnold does a great job summarizing the areas of compatibility: Simplifying Oracle Database Migrations. As you are aware, mastery comes through practice. It may take a bit of habit changing and practice to master the skills you need to be efficient at using DB2, even if the skills are similar. If time is not your friend, you may benefit by joining a bootcamp session: http://ibm.co/DB2BLUBootcamp. You may also find this education roadmap useful, especially if you can arrange to have Melanie Stopfer teach a class for you.
I hope this helps! I look forward to more comments and perhaps suggestions on future blog posts.
Join Scott Hayes and Klaas Brant on the last show of this season.
The DB2Night Show Episode #36
HIGH AVAILABILTY: Comparing DB2 (pureScale), Oracle (RAC), and SQL Server (Cluster)
Friday, December 17, 2010 11:00 – 12:00 EST
DB2 has some great high availability options like HADR and Pure-Scale. But how about the competition? How does DB2 compare to Oracle and SQL Server? In this episode we will look at the architectures that enable high availability and show you why DB2 Pure-Scale is superior to Oracle RAC and SQL Server Cluster.
Special guest Klaas Brant, IBM DB2 GOLD Consultant & Owner KBCE, returns to our show for a second appearance. You might recall Klaas was on our show earlier this year (Episode #18 on 7 May 2010) talking about the Top 10 DB2 LUW mistakes that people make - an Episode that was extremely popular with viewers. Watch the replays on the DB2Night Show website.
If you'd like to learn about DB2 PureScale and competing technologies, then this show is for you! Also, take a look at a previous blog entry I did where I compiled a collection of DB2 Purescale resources: More on DB2 pureScale.
Personal Tidbit: For those keeping score, my blog views are now over 980,000! Lately I’ve been getting nearly 20,000 new views every week, so there is still a chance that I can get to 1M before the end of the year. Thanks for all your support this year!
Don’t miss the chance to save $200 per exam. The conference offers free exams to attendees. Impress your boss by coming home with shiny new certifications!
FREE Information Management Certification testing at the Information on Demand Conference (IOD11) continues to be very popular. Earning an industry-recognized IBM Information Management certification is a great way to validate your skills on our newest products. So, if you are a registered Information On Demand attendee, you'll want to start preparing now for your upcoming certification exam.
All attendees are eligible for three complimentary exams at the conference. Complimentary exams apply to all Information Management, Business Analytics and Enterprise Content Management Professional Certification and Technical Sales Mastery exams. A 50% discounted fee for all subsequent exams will apply. We will also be offering the discounted price of $100 for all Lotus, Rational, Tivoli, WebSphere, SOA, and XML Certification exams.
Don't miss this opportunity to validate your skills and demonstrate your proficiency in the latest IBM software technology and solutions. Ensure your success on exam day with the help of our preparation resources. Arrive early and take advantage of pre-conference crammer and training classes on Sunday offered at preferred attendee pricing of US $499.00. With 7 courses to choose from, you should not miss this opportunity to advance your skills with a full day of education, delivered by professional IBM instructors. The certification testing will be located at Surf DEF.
View a complete list of IBM SWG certification exams.
Certification at IOD11 will be available during the following hours:
- Sunday 10:00 a.m. - 4:00 p.m.*
- Monday 10:00 a.m. - 4:00 p.m.*
- Tuesday 7:00 a.m. - 5:00 p.m.*
- Wednesday 7:00 a.m. - 6:00 p.m.*
- Thursday 7:00 a.m. - 5:00 p.m.*
* Please note: The closing times listed above are for the last exam seating available on that day.
In the new podcast series “IM Skills Cast”, Susan Weaver, the program manager for the IBM Information Management Certification Exams and I discussed the exams and the procedure to take them for free at the IBM Information on Demand Conference. Listen now: Conversation with Susan Weaver.
Judy Nall, Susan Lawson, and Roger Sanders who are IBM Champions, famous authors… and instructors of Certification Crammer courses will once again be teaching their popular crammer courses on Sunday October 23 to help you prepare to pass your exam. For details, see my blog entry Certification Crammer Courses: IOD pre-conference training.
Come to the Conference Bookstore to see the growing collection of Certification Guides that are available to help you study: Bookstore Activities – IBM Information on Demand Conference.
Remember that doing well on your exam will pay off in more ways than one. If you get the Daily Top Score on your Cert test you could win a gift certificates for the Logo Store.
As mentioned in a previous post, there are several deep technical courses that you can take immediately prior to IBM’s Information on Demand (IOD11) Conference this year. My previous post described the 6 certification crammer courses that are offered. If you aren’t interested in cramming for a certification, consider this one:
The popular troubleshooting seminar is back, this time with updated information on the newest DB2 release - 9.7 Cobra! 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 DB2PD. Knowing how and when to use these tools is critical in resolving problems quickly.
Take this class to learn how to identify and resolve problems such as database hangs, locking problems, crashes and optimizer/performance problems. Learn about the tools and techniques that you can use to identify performance problems caused by resource bottlenecks, locking and poor query access plans.
As a result of the class, you’ll be able to
- Characterize a problem in order to expedite resolution
- Learn how and what data to collect during intermittent hangs, slow-downs and other problems in order to decrease problem resolution time
- Understand DB2 Support's methodology in troubleshooting DB2 problems.
The instructor for this class is Aman Lalla from the IBM Toronto Lab. Aman is a senior development manager and analyst at the IBM Toronto Lab in Canada. He has 13+ years of experience with DB2 on the distributed platforms. He has worked at IBM for 15 years. His areas of expertise include DB2 problem determination in a single and muti-partition environment. Aman is currently the development manager for the IBM Smart Analytics System. He has previously written an IBM Redbooks publication on DB2 Data Links Manager and DB2 Database Partition Feature.
This is a special one-day offering being presented on Sunday, October 23, 2011 in conjunction with the IBM Information on Demand 2011 Conference in Las Vegas, Nevada. Registration for the IOD Conference is NOT required to attend this Sunday class. For details on the price and class objectives, see (9Q072) Deep dive into DB2 LUW Problem Determination and Troubleshooting
Other posts about the IOD Conference:
Today we had a very interesting tweetchat that was organized by our friends at @DB2Geek. The theme today’s debate was “Is the role of a DBA dead?”
If you weren’t able to join us, I’ve managed to pull together many of the comments in a really need way called “storify”: Is the Role of a DBA dead? http://sfy.co/r57H
A few comments came in after I built this story that I wasn’t able to include. The result of today’s debate: The DBA is definitely not dead... but are “Dedicated, Energetic, Advanced and Dynamic!”
Thanks to all who participated and we all hope to have more people join us for the next DB2Debate on June 18 “Is the database a commodity?”
On behalf of the entire DB2 community, I’d like to thank all those who took part.. in particular:
DB2 Users Group@IDUGDB2
Norberto G Filho@norbertogf
Hint: If you’re new to twitter.... follow these people if you’re interested in DB2 content!
I heard from several people who wanted to join this chat but were getting errors that twitter was down for maintenance. I did get that message as well, but was able to contribute by logging into tweetchat.com. This opens up a new window and once you sign in and search on #db2debate, you are able to see the entire conversation and can contribute without adding the hashtag. It works very well!
Articles by Craig Mullins
Craig wasn’t able to join us for this event, but he has written many articles on this topic that he recommended after the event was over:
Are DBAs Obsolete?
The Guide to Being a Successful
What is the role of a DBA?
Intelligently Automating DBA Tasks
DBA Best Practices?
Craig’s book: Database Administration: The Complete Guide to DBA Practices and Procedures (2nd Edition)
Inside Craig’s Data Reading Room
All DBA related articles from Craig.
Keep writing Craig! We all benefit from your knowledge and insight!
Other articles suggested during the debate:
Your DBA Role is Changing. Are you Ready?
The changing roles of developers and DBAs
Does the Role of the DBA Need to Evolve?
What would you ask a BigData expert if you could? Maybe the same as Marc Blaise asked Leon Katsnelson?
DB2 DBAs are not dead! They are watching The DB2Night Show for FREE Education! Over 264000 downloads!
The IBM Data Magazine - it's all about the data! Great articles. Come often.
The DB2 Facebook page continues to grow and I hope it has content DBAs find useful.
IDUG Facebook page.
DB2Geek Facebook page.
developerworks is full of great content for DBAs.
IDUG Specific Discussions:
Calling all non-Dead #DB2 DBAs! Don't miss @dbisoftware & HLS party at #IDUG Tues Night 8pm Visit Booth #103 for Free Invite! #DB2Debate
#DB2Debate reminder for #IDUGNA attendees: Bookmark bit.ly/idugna13 for a Twitter Search Feed of all #IDUG and #IDUGNA Tweets!
Let's #DB2Debate this further at #IDUG ow.ly/klhQk Plenty of Networking Opportunities and Tech Sessions. Alive DBAs welcome!
@susvis will be at #IDUGNA next week. If you want to give an opinion on this topic... she will be happy to listen & record. #DB2Debate