Thanks to Norberto
for accepting my invitation to be a guest blogger on my site today. Norberto was one of our finalists in the DB2Night Show's "DB2's Got Talent" Competition". As in his presentations, you'll find this post very full of incredibly useful information. Norberto was concerned that his post was too long, but I assurred him that it perfect as is. I hope you'll agree.
It’s a pleasure to be here in Susan Visser’s blog today. I’ll talk about the contest, with special focus on my last presentation.
On the final round, at the beginning of our presentations, we contestants showed more info about our lives. It was nice to show the world more about our personal info. That made people feel closer to us I think.
I started talking about all my past presentations. I turned off my mobile, all messaging/mailing applications from my laptop, and even put Calopi (our cockatiel) in a room far from my office, BUT during that slide, my home phone started to ring! That messed up with that slide a bit, as I lost concentration.
After showing my past tips/lessons learned, I introduced some tips I use daily - which are not specifically related to DB2, but will surely be useful to any DBAs and other people. Here they are:
- Log everything you do on PuTTY. There are times you have to know something you did in the past. With the help of PuTTY logs, you can retrieve that.
- PuTTY Connection Manager - can be very useful when you have to have several sessions open at the same time.
- You can use PuTTY from your mobile - That can really help with situations when you don't have a computer near. (But you will have to have access to your server's network from your mobile.)
- This is an old set of executables that enables anyone to issue very nice Unix commands like grep, tail and so on.
- Very useful to write SQL queries, procedures and functions. It's built-in functions enable users to do complex text changes with just a few clicks.
The Win+M key
- You can clean your Windows screen by just pressing those 2 keys. Very useful (if you use dozens of apps at same time like me) .
After that, I focused on DB2, introducing some technical tips:
- For any problem you have, the best start is always the DB2 InfoCenter (in the same version you have your DB2).
- Next, a tip about changing several passwords on several servers quickly. I know user/password management can be a cumbersome task which can take a lot of time. Usually, the DBA team owns all DB2 users (instance owner, fenced, DAS), so they are responsible to keep them secure. With the approach I showed, and with some automation using the ATTACH command, the task can be extremely simplified. I'm planning to create a stored procedure to do that automatically, based on a table having server names, instance names and ports, user IDs and old/new passwords. When I have it created I'll post in my blog.
- Put DB2 environment variables in the right place - Most of the DB2 DBAs I know are not aware that using ~/sqllib/userprofile is the most correct place to put any environment variable and customization which would normally be on the instance owner's .profile. By using that, other users who call ". $INSTHOME/sqllib/db2profile, will have the same configs as if they were the instance owner.
- Using scripts to save your time - I commented about some scripts that I wrote in the past. They are really useful for me, and I wanted to share them in my blog. Some are already there, others are not (but I'll add all them there soon).
- Next I focused on how to execute SQL generated by SQL through a unique command line. Through help of sed, this very useful tip works smoothly on Linux and Unix. I’ll post that in my blog soon.
After those technical tips, I also gave some educational/networking advice.
Don't overlook the cloud - you can take advantage of it right now! BTW, I met Raul Chong here in Curitiba this week, and he showed us DB2 on cloud in a very nice presentation.
Another nice tip is about reading everything you can about new implementations and behavior changes on new versions of DB2 (through the InfoCenter). I mentioned that, for example, from DB2 v9.5 on, you don't need to issue db2iupdt, migrate database or even bind packages for all databases when applying fixpacks. If you know that, you can save time!
After that, I advised people to stay tuned by:
Regarding DBA skills, certifications are always welcome (you can see I showed the ones I achieved at the beginning of my presentation). Buying a good book for that is one of the best paths for ensuring your success on the exam. I also put a link to DB2University, a very complete website where you can find some free and other inexpensive courses, as the name suggests, all about DB2.
Putting all that together and presenting in just 6 minutes was not easy, so I had to hurry a bit.
That’s all about my presentation on the DB2’s Got Talent Finale.
I’m sure all contestants did their best showing their tips and lessons learned. We all have many roles, and finding time to present such info is a really hard task. I confess I went to sleep very late some nights to have my presentations ready!
I’m now in touch with some of the other contestants, and really like the idea of having such highly skilled DBAs in my network. Audience/replay watchers also added me on LinkedIn and started following my twitter and my blog. Thank you all! I’ll do my best to fill my blog with useful information!
I’d like to thank Scott Hayes for the opportunity he gave us, and also the judges – Susan, Martin, Klaas, and Cristian – your comments always brought value to the presentations.
I’ll finish saying it was a great pleasure to participate on this contest, and I encourage other DBAs to do the same in the future. I’m sure Scott will want to repeat this success :)
Thanks Norberto! I enjoyed your post very much.
Voter comments about Norberto:
- Very impressive presentations! I liked all of them, but Norberto's tips where simple and extremely usefull!
- Norberto's presentation, though had no out of box tool/new db2 functionality but he shared the tools n tips that surely gonna help any naive or even a seasoned dba
- Norberto is the best DB2 DBA ever!
- Vai Norberto Vai !!
- Norberto's presentation was fantastic!
- It has been quite interesting walking through the presentation and appreciate the way information has been compiled together and presented. I wish all 4 contestants the very best and especial mention for Noberto for making life really easier one :)
- Way to go , Norberto :D. You have been great. Fingers crossed. Good luck for the final round !
- Great presentation from Norberto, he deserves be the winner
You can see all voter comments on Scott’s Blog.
I just got a random call that was very interesting that I want to share with you. The man calling got my name and number from some IBM webpage and he called to ask if there were basic training courses that cover Information Management.
Way back in university, I took many “Information Management” courses and they were high level courses that covered how information passed through an organization and were taught through the engineering faculty. In doing an online search, I see that many universities (UofT, Berkeley, Wharton) are offering degrees and advanced degrees in this discipline.
According to wikipedia, Information management (IM) is the collection and management of information from one or more sources and the distribution of that information to one or more audiences. This sometimes involves those who have a stake in, or a right to that information. Management means the organization of and control over the structure, processing and delivery of information.
According to IBM, Information Management is a set of solutions that deliver trusted information throughout your information supply chain and help you analyze your information to gain insights, identify breakdowns, and make better decisions that will optimize your business. Find Information Management products by category, by A-Z, or by keyword search.
What we offer
Data Security & Privacy
Data Warehouse Appliances
Data Warehousing & Analytics
Master Data Management
Big Data Analytics
Software & appliances
Enterprise Content Management
IBM doesn’t have overall IM courses that teach the flow of information along with an introduction of the products beneath the different types of flows, but maybe we should. BUT, what we do have, is an awesome book that published in 2010:
The book covers:
Defining your Enterprise Information Architecture from conceptual, logical, component, and operational views
Using information architecture principles to integrate and rationalize your IT investments, from Cloud Computing to Information Service Lifecycle Management
Applying enterprise Master Data Management (MDM) to bolster business functions, ranging from compliance and risk management to marketing and product management
Implementing more effective business intelligence and business performance optimization, governance, and security systems and processes
Understanding “Information as a Service” and “Info 2.0,” the information delivery side of Web 2.0
Does this sound like it might match the requirement that was given to me by my caller? I think so. I recommended the book and he’ll look at it on Safari and plans to call me back to tell me if the book was helpful.
If you’d also like to take a look, check out this current promotion: New and Best-Selling Information Management Books at 35% off.
If you like what I tend to share, I encourage you to “follow” my blog. As of writing this entry, I have 197 followers and thank every single one of you. I’m in the midst of reading Antonio Cangiano’s book: Technical Blogging: Turn Your Expertise into a Remarkable Online Presence and am learning tips from his expertise. I would like to put many of his tips into practices in the next few months…. I wonder if you’ll notice? Asking you to follow my blog is just one of his tips!
Besides announcing Mohan as the winner of the 2013 “DB2’s Got Talent” competition,
Vijay Sitaram and Bob Vargo, volunteers from IDUG joined the DB2Night
Show today to provide information as to what is taking place at IDUG
Orlando. The conference begins April 29 and ends May 3 and there are
plenty of reasons to attend the conference.
are two milestones being celebrated this year: IDUG celebrates 25 years
of amazing learning and DB2 has been a product for 30 years. Can you
imagine the number of people who have been involved in the conferences
over the years as well as the number of hours of learning that has taken
place? Definitely great reasons to celebrate! I salute all
volunteers IDUG and creators of DB2!
On Tuesday Apr 30:"DB2: Database Software for the Era of Big Data" with Bob Picciano & Judy Huber
On Wednesday Wed May 1:"The Latest News on DB2 Application Development Technology" with Curt Cotner & Bill Bireley
There are over 100 sessions spread over 8 tracks.
Big Data Sessions at IDUG
New to DB2? Why you should attend IDUG 2013
Full Day Seminars - Monday, April 29
DBA Administration Cert Crammer Course with IBM Champion Susan Lawson
DB2 for z/OS System Admin Cert 617 Crammer Course with IBM Champion Judy Nall
DB2 10 LUW DBA Cert Exam 611 Preparation with IBM Champion Roger Sanders
DB2 Developer's Guide comes Alive with IBM Champion Craig Mullins
DB2 for LUW Top Gun Perf Workshop with IBM Champions Scott Hayes & Martin Hubel
Improving Query performance in DB2 LUW Warehouses with Calisto Zuzarte
Matching Indexes to SQL with IBM Champion Bonnie Baker
Spotlight sessions - Tuesday, April 30
Tip... you will learn about exciting new product announcements in these sessions!
DB2 for LUW: Recent Enhancements & Trends with Matt Huras
DB2 for z/OS: Recent Enhancements & Trends with John Campbell
What is Big Data in 90 Minutes vs 1,000,000,000 Google Search Results with Paul Zikopoulos
Technical Networking Opportunities (formerly called SIGs) Wednesday, May 1
Seven great opportunities for you to choose from : meet experts & speakers.
BI & Data Analytics - Tooling & Challenges with Jon Lind, James Cho, Clifford Austin
DB2 Security Challenges with IBM Champions Rebecca Bond & Roger Sanders, Walid Rjaibi
Fun With SQL: Sheryl Larsen, Calisto Zuzarte, Matthias Nicola, Bonnie Baker, Dan Luksetich, Kurt Struyf
Nuts & Bolts of DB2 LUW Performance: Melanie Stopfer & Brent Gross #TechSession
Oracle to DB2 Migration: Robert Goodman, Tony Leung, Chris Eaton, Eric Alton #TechSession
Social Networking for the Database Professional with Surekha and Willie Favero
Tips & Tricks for the Systems DBA with Judy Nall, John Campbell & John Iczkovits
Two Mini-Panels - Thursday, May 2
your questions in advance, online. We’ve listed likely people who will
take part, but past experience has shown that many other experts show up
and take part in these discussions.
DB2 LUW with Matt Huras, Paul Zikopoulos, Melanie Stopfer, Calisto Zuzarte, Chris Eaton
DB2 for z/OS with John Campbell, Haakon Roberts, Randy Ebersole, Jeff Josten, Terry Purcell
Free Workshops - Friday, May 3
are free and take place from 8 am - 2 pm. There are other technical
sessions taking place at the same time, so if you attend these, you will
miss those. Be sure to book your flights for late afternoon so you
don’t miss these!
“DB2 10 for LUW Immersion Workshop" with Chris Eaton
"Data Warehousing: DB2 Analytics Accelerator Deep Dive Workshop" with Gary Crupi
More information about these events will be released closer to the event.
Monday - CA event
Tuesday - DBI & HLS event - Shining Star Band will be playing
Wednesday - IBM event
Thursday - DineAround - These fill up quickly, so register immediately!
Meet with Willie Favero & others at "Benihana"
Meet with Sheryl Larson & Bonnie Baker at "Fulton's Crab House"
Meet with Dave Beulkeat "Johnnie's Hideaway"
Meet with John Iczkovitz at "Moonfish"
Meet with John Campbell at "Portobello"
Meet with Dan Luksetich at "Raglan Road Irish Pub"
Meet with Melanie Stopfer at "Wolfgang Puck Cafe"
Meet with Kelly Schlamb & Scott Hayes at "Vito's Chop House"
Free Certification Exams
Each attendee can take up to 2 exams for free. All others are $25 each. There are many exams available, along with many hours that the exam room is open. Exams are normally $200 each, so this is a huge savings.
will not be for sale at the conference, but stop by booth 316 to see a
sample of the books that you can purchase at a discount if you purchase
online and directly from the publisher. IBM Press books are available
to IDUG members at a 45% discount!
Booth 316 is also where you can pick up copies of free Flashbooks.
Use social media to stay in touch
Once again, Scott Hayes has set up an aggregator so that you can see all conference related tweets in one spot: bit.ly/idugna13.
you want to tweet, use the hashtag #idugna for any conference related
messages and your message will be included in the aggregator feed.
Screens at the conference should also be showing the tweet messages as
they are sent, so you can stay in touch with your ipad, smart phone, or
screens at the conference.
created tweet messages for each session and will include information
about the location, time, and speaker, so watch my twitter site to stay
in touch as well: @ibm_db2.
Access to new products
IBM’s announcements took place on April 3,: so IDUG provides you with the FIRST opportunity to see DB2 10.5 features and Big SQL features.
Follow my blog for more information on this conference & more!
These are books that I’ve worked on one way or another in the past year. In most cases the links are to the e-version of the book… usually Kindle. I have a Kindle and really like to read my books using this device. With the prices of Kindles this year, I’m sure there will be many more people with a book reader in the coming year. Also, the popularity of iPads only increases with time.
Note that some of these books haven’t published yet, but will soon. I haven’t noted which to encourage you to click the link to find out.
I know that MC Press is having a big sale on all of their stock until the end of December and it wouldn’t surprise me if the other publishers are also offering special prices. I suggest that you look for the best price before buying!
Agile IT Security Implementation Methodology
by Jeffrey Laskowski
Decision Management Systems: A Practical Guide to Using Business Rules and Predictive Analytics to Build Adaptive, Agile, Intelligent Systems
Get Bold: Using Social Media to Create a New Type of Social Business
IT Virtualization Best Practices: A Lean, Green Virtualized Data Center Approach
by Mickey Iqbal, Dr. Mithkal Smadi, Chris Molloy, Jim Rymarczyk
Making the World Work Better: The Ideas That Shaped a Century and a Company
Kevin Maney, Steve Hamm, Jeffrey O'Brien
IBM Cognos 10 Report Studio: Practical Examples
Roger Johnson and Filip Draskovic
Data Integration Blueprint and Modeling: Techniques for a Scalable and Sustainable Architecture
DB2 10 for z/OS Database Administration: Certification Study Guide
Susan Lawson and Dan Luksetich
Selling Information Governance to the Business: Best Practices by Industry and Job Function
DB2 9.7 for Linux, UNIX, and Windows Database Administration: Certification Study Notes
From Idea to Print - How to Write a Technical Book or Article and Get It Published
MDM for Customer Data - Optimizing Customer Centric Management of Your Business
Kelvin K. A. Looi
DB2 9 System Administration for z/OS (Exam 737)
Netezza Transformation: Taming the dragon without alchemy, sorcery or strange potions
The Data Warehouse Mentor: Practical Data Warehouse and Business Intelligence Insights
Database Modeling and Design: Logical Design, Fifth Edition
Sam S. Lightstone, Toby J. Teorey, Tom Nadeau, H.V. Jagadish
Getting Started with IBM FileNet P8 Content Manager
Technical Blogging: Turn Your Expertise into a Remarkable Online Presence
IBM DB2 9.7 Advanced Administration Cookbook: RAW
Adrian Neagu, Robert Pelletier
Unleashing the Power of IBM Cognos Business Intelligence v10
DB2 Developer's Guide: A Solutions-Oriented Approach to Learning the Foundation and Capabilities of DB2 for z/OS (6th Edition)
IBM DB2 9.7 Advanced Application Developer Cookbook: RAW
An Introduction to IMS: Your Complete Guide to IBM Information Management System, 2nd Edition
Barbara Klein, Diane Goff, John Butterweck, Kenny Blackman, Margaret Wilson, Moira McFadden Lanyi, Rick Long, Sandy Sherrill, Steve Nathan
The New Era of Enterprise Business Intelligence
by Michael Biere
Master Data Management and Date Governance, 2/E
by Larry Dubov & Alex Berson
Making it Big in Software
by Sam Lightstone
Enterprise Master Data Management: An SOA Approach to Managing Core Information
by Allen Dreibelbis, Eberhard Hechler, Ivan Milman, Martin Oberhofer, Paul van Run, and Dan Wolfson.
The Art of Enterprise Information Architecture
by Eberhard Hechler, Martin Oberhofer, Steve Lockwood, Michael Schroek, Mario Godinez, Klaus Koeig
IBM Cognos TM1 The Official Guide
by Karsten Oehler, Jochen Gruenes and Christopher Ilacqua
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:
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?
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:
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.
- DB2 10.5 for LUW Immersion Workshop - with new BLU Acceleration
- Data Warehousing with DB2 for z/OS: IBM DB2 Analytics Accelerator Deep Dive Workshop
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.
first step is for you to get funding from your boss to come to the
conference. If you need help with your justifications, see:
- Need help justifying expense of your 2013 IDUG conference? We have resources to help. http://ow.ly/gpfn6
- Great blog entry about tech conferences: "Technical Conference – It’s a skill builder, not a trip to Vegas" http://bit.ly/WRRkan
Stay tuned for more highlights and details!
IDUG Solutions Journal July 2009 : Volume 17 Issue 2 provides Chapter 11 (Chapter 11 - Converting XML to Relational Data
) for free from the book:
DB2 pureXML Cookbook: Master the Power of IBM's Hybrid Data Server
Authors: Matthias Nicola
, Pav Kumar-Chatterjee
In DB2 pureXML Cookbook,
two of IBM's leading experts provide the single most comprehensive
coverage of DB2's pureXML capabilities. This book explains DB2 pureXML
in over 700 practical examples, including 250+ XQuery and SQL/XML
queries, taking the reader from simple introductions all the way to
advanced scenarios. The authors have distilled their hands-on
experience with many pureXML applications so that you can benefit from
best practices, tips & tricks, performance guidelines, and other
gems that are not documented elsewhere.
This book is invaluable for database administrators and application
developers, beginners and DB2 experts. The topics are organized by
typical user tasks throughout the life cycle of XML database projects,
from planning, designing, and implementing databases all the way to
tuning, problem determination, and application development. It includes
code samples for Java, .NET, COBOL, PL/1, C, PHP, and Perl programmers.
The DB2 pureXML Cookbook
provides proven recipes rather than a mere reference of ingredients.
- Unique and comprehensive coverage of pureXML on all supported
platforms: DB2 9.x for Linux, UNIX, and Windows and DB2 9 for z/OS.
- Written for database administrators and application developers, beginners and advanced DB2 users.
- More than 700 "recipe-style" examples of XML queries, updates,
schemas, indexes, storage objects, application code, and database
- DB2 pureXML best practices, tips, and tricks based on the author's extensive hands-on experience in pureXML deployments.
- Coverage of brand-new XML features that IBM intends to make available in the current release of DB2 (http://www.ibm.com/software/data/db2/technology-sandbox/)
Save 35% when you purchase this book!!
DB2 pureXML Cookbook: Master the Power of the IBM Hybrid Data Server
Use Coupon Code when checking out:
I'm expecting this book to be a BEST SELLER this year! Make sure you get your copy before they run out! Also, meet Matthias Nicola and get your book signed at theIOD Global Conference.
One of the things that I love most about the IBM Information on Demand
Conference is the buzz on books. Every year we have a giant bookstore that
showcases all the latest books related to DB2, Analytics, Big Data, and more.
My job is to arrange to have the right set of books at the conference and to
invite authors to be available to sign copies of their books for attendees.
All books purchased at the bookstore are discounted by 20% off the retail
Here are the featured books and authors that we have planned for this
There are many other new books available to purchase at the bookstore this
year, but I was only able to arrange signings for the authors who are attending
the conference this year. Stop by and check out all the great knowledge that is
You've heard of IBM
& Cloud Computing
.... what do the three have in common? For one, IBM & Amazon have joined together to bring you a FREE webinar about Cloud Computing.Why?
DB2 database software running on Amazon EC2 lets you get the most out
of your IT budget . IBM and Amazon Web Services provide a lot of
flexibility for cloud computing, including free DB2 AMIs, low cost
by-the-hour production-ready DB2 AMIs, and the ability to bring your
existing DB2 licenses to the cloud.
Attend the event to learn more about DB2 AMIs and the
unique capabilities in DB2, including the new features in DB2 9.7 that make it
much easier to move applications from Oracle to DB2.
Even better.... attend the event and get $35 in Amazon Web Services credits to practice
everything you learned.
start your skills to build Software as a Service (SaaS) offerings.
selecting a combination of industry-leading IBM software running on Amazon Web
Services (AWS) allows you to focus all your resources on innovation instead of
- 10:00AM-10:30AM EDT – Becoming a Cloud
- 10:30AM-12:00PM EDT – Cloud Computing with Amazon
- 12:00PM-01:00PM EDT – IBM DB2 – Using the most flexible enterprise-class
database on Amazon EC2
- 12:00PM-01:00PM EDT – IBM Informix Dynamic
Server (IDS) on Amazon EC2
- 01:00PM-02:00PM EDT – Using WebSphere
Application Server on Amazon EC2
- 01:00PM-02:00PM EDT – Portals and web
content management in The Cloud – Less effort, reduce costs
- 02:00PM-03:00PM EDT – Develop a Situational
Application with WebSphere sMash on Amazon EC2
- 02:00PM-03:00PM EDT – eForms in the Cloud –
Optimize Your Business and Solutions
- 03:00PM-04:00PM EDT – Elastic Scaling with
WebSphere eXtreme Scale on Amazon EC2
- 03:00PM-04:00PM EDT – Mashups in the Cloud – speed
up the creation of your business applications
- 04:00PM-05:00PM EDT – Cloud Quickstart –
Accelerating your path to cloud computing
- 04:00PM-05:30PM EDT – Lotus on AWS – Partner
Solutions Show and Tell
Be sure to register for and attend the DB2 session at noon – 1pm Eastern Daylight Time where Mark
Wilding and Leon Katsnelson will talk
about a set of capabilities that are unique to DB2 and make it the best database
for use on the Cloud.
Can't make it? Replays will be available but register to be sure you get notified when the replay is available!
Good luck Leon, Mark & others. I hope the event is a huge success! I'll be there!
DB2 9.7 brought the biggest infusion of SQL features since DB2 V2.1. In this presentation, learn about features that lead to a ten-fold reduction in enablement costs when Oracle-based applications are enabled for DB2. The virtual tech briefing covers the following:
- Business drivers to move Oracle applications to DB2
- SQL enhancements in DB2 9.7
- Tooling support to enable applications from Oracle to DB2
- PL/SQL support in DB2 9.7
- Library extensions in DB2 9.7
The next DB2 Tech Talk will take place on May 8th and will explore the exciting technology in the DB2 10.5 for Linux, UNIX and Windows with BLU Acceleration product announcement.
This includes BLU Acceleration designed to deliver actionable information from data analytics workloads with the speed and precision that is terms "Speed of Thought" analytics.
Find out about enhancements to DB2 pureScale that make it even more able to deliver always available transactions. Of course like many releases there are updates to SQL and Oracle Database compatibility we will tell you about. You will find out about business-ready NoSQL technology and additional NoSQL plans. And much more!
Join Berni Schiefer and host Rick Swagerman for a technical tour of the all new DB2 10.5 with BLU Acceleration software. You will learn about new features such as:
BLU Acceleration designed to deliver decision-making information from data-intensive workloads with precision that is termed “speed of thought” analytics
New DB2 pureScale capabilities that enhance maintenance, capacity management and disaster recovery capabilities
SQL and Oracle Database compatibility enhancements that began in DB2 9.7 are updated again in DB2 10.5
Enhancements to NoSQL technology that are now business-ready in DB2 10.5
New packaging editions of DB2 that that handle either OLTP or data warehousing needs
DB2 tools advances that support these new functions
Join us for this TechTalk to find out about these exciting enhancements and how they can help you deliver the data analytics your organization needs while providing tools to keep your OLTP systems in top shape.
Don't miss this Tech Talk, as it is an excellent way to ensure that your DB2 skills stay current in an increasingly Big Data world.
More information and registration.
See you online for this webcast!
For more information about this new technology see Do you know BLU? - my blog entry that links to many articles and videos about BLU.
DB2 TechTalk: Query Performance Enhancements and More
Super Analytics, Super Easy
Borrowing from Science to Revolutionize Business Analytics
DB2 Tech Talk: Compression Comparison, DB2 vs. Oracle and the Rest
DB2 Redbook – Unleashing DB2 10
Today was the first show of the finals for the DB2’s Got Talent 2012
Competition. If you didn’t participate live, I strongly encourage you to watch
the replay. We
had the top 10 contestants from February present 4-minute technical
presentations to us. Again, the caliber of the presentations blew me away. At
least 3 times the phrase “That’s the way you do it!” came to my mind as
contestants were presenting. Not only were their slides well done, but so were
their presentations of the material. To all 10: well done!
The control is now in the hands of you, the audience. You
must vote for who you think should go on in the upcoming shows. Here’s what you
need to do. If you were in the audience today, vote in the survey provided for
today’s show for who you thought was the best . You can find the URL for the
survey by watching the replay. If you weren’t able to make it to the show
today, watch the replay, and then VOTE. Don’t watch just to vote, watch to
learn great DB2 tips as well as examples of excellent presentation skills.
Here’s a summary of what happened today.
Contestant 1 – Douglas
Protecting SQL Code: Hidden New DB2 LUW 9.7 Feature
Douglas presented in February and provided excellent Oracle compatibility
tips, and he’s done it again. This presentation showed how DB2 has provided
support for Oracle’s DBMS-DDL.Wrap. This was a wonderful presentation about a
very useful feature. The presentation was only 4 minutes, as were the rest of
them, but it was short and sweet and direct to the point.
Contestant 2 – Yonghang
Inter-Process Communication & Multitasking: Let’s talk about wait
in DB2 9.7
Very interesting presentation about how DB2 uses stored procedures to provide
multitasking. Yonghang ran out of time, unfortunately, but had a great
Contestant 3 – Kohli
A Pragmatic Approach for Importing Data and Physical
Watch the show to see “how” you do it. The slides were great, but Kohli
clearly put a lot of thought into the topic and provided notes and tips that are
far beyond anything you’d read in a manual. Very well done!
Contestant 4 – Rodolfo
DB2 Security: Tips to Protect Data & Avoid Issues
Rodolfo provided security tips for protecting data on DB2 for z/OS. Very
important topic, but a large topic. It is hard to do the topic justice in just
4 minutes as it may leave the audience with more questions than answers.
Rodolfo did a great job with his presentation. You can follow Rodolfo on
Contestant 5 – Kingo
DB2 for z/OS Performance Tuning Tips: Drill Down
Kingo was presenting from Japan, in English of course. If he does this well
in English, imagine how good he is in his native language! He chose a huge
topic, but did very well narrowing it down with a case study. This is the
perfect kind of presentation for a user conference such as IDUG. I really
liked the way Kingo showed in his charts how he analyzed data. He made it very
easy to follow the approach that he took to come to his conclusions.
Contestant 6 – Brian
Fragmentation Found and Fixed
Brian is clearly a master at presenting as we’ve seen on previous shows and
he showed off his skills again today, but he out did himself! Not only did he
provide a very clear presentation in 4 minutes, but he included a demo as well.
I was wowed by the charts and would love to get my presentation skills to that
level. Beyond the charts, he told a “story”. Storytelling is a great
presentation and writing skill and is known for drawing people in. If you want
to see another example of “how” to do it, study what Brian is capable of. We
can all learn plenty from Brian. Brian tweets at https://twitter.com/#!/fairchild_db2
and blogs at http://bit.ly/yGpae2 .
Contestant 7 – Ember
DB2 9.7 Deadlock and Lock Timeout Analysis: The New
We judges were all wondering if Ember was a trained teacher. If not, she is
a natural. Her presentation was very easy to follow and I liked the way she
discussed the changes in each of the releases. This is a pretty common topic,
but it was unique in the way it was an update on what people are actually
doing. Ember also tweets ember_crooks & blogs http://db2commerce.com/.
Contestant 8 – Jean
Real 24x7 Enhancement
Jean worked with her colleague Chuck to create this presentation, but she
presented on her own. This was a follow on to her previous presentation, so in
effect allowed her to discuss one topic in 8 minutes. It is a very complicated
and complex topic, but Jean was able to make it easy to understand, especially
with her diagrams. This is an enhancement that works with DB2 LUW and DB2 for
z/OS, so should be of great interest to many people.
Contestant 9 – Elder
Declare Cursor: The Untold Story
Elder showed a feature that is not well documented in the manuals. Elder put
together a solid presentation and gave a great tip that you shouldn’t miss.
Elder seemed either nervous or not well prepared and as a result there was a
lack of flow in his delivery.
Contestant 10 – Richard
Automatically Generated Identity Columns
I wish we could have a “do-over” day, just for Richard. He saw an accident
on his drive into work and was a witness for police. As a result, he was late
showing up for today’s show, had a few technical issues with his mic, and didn’t
know what the “finish” sound of the day was. His presentation went quite a bit
over. But despite all these challenges, Richard did well and presented great
content in his presentation. Oh well, life happens and the show must go on.
Great job Richard!
The judges, Martin Hubel, Klaas Brant, and myself don’t get to
choose who goes on… you have the control. After you watch the replay, VOTE!
I’m glad I don’t get to choose… there is such great talent appearing on this
show that it will be very difficult to choose.
March has two more shows for the finals where those who have moved on will
present a second time and the audience can choose the winner rather than the
judges. Be sure to join us March 16 and 30. If you get reminders for March 9
and 23, please ignore these reminders.
Thanks to host Scott Hayes for this opportunity for me as a judge and
for the contestants for helping them build technical presentation skills that
are so valuable.
For details on the prizes for this competition… and a summary of last year’s
event… see my blog entry: http://ibm.co/AnZxb4
See also: Session 1 of the
DB2’s Got Talent 2012 Competition
See also: Session 2 of the
DB2’s Got Talent 2012 Competition
See also: Session 3 of the
DB2’s Got Talent 2012 Competition
See also: Session 4 of the
DB2’s Got Talent 2012 Competition
PS… If you are in the NY area, make sure you look into attending the DB2
Symposium that is taking place March 28-30 in this area. See
Congratulations to Judy Nall whose first book is about to publish.
The book goes to the printer today!
DB2 9 System Administration for z/OS:
Certification Study Guide: Exam 737
by Judy Nall
This is an addition to the series of Certification Guides published by MC
Press to support DB2’s popular certification program.
Not only was Judy part of the exam development team, but she is well known in
the DB2 area as an internationally recognized lecturer, consultant, writer,
educator, and DB2 expert. She is the president of Computer Business
International, Inc., a member of the IBM DB2 Gold Consultants Group, and the
recipient of an IBM Data Champion award for contributions to the IBM Data
This book was written with system administrators in mind, this reference
offers information about both DB2 and z/OS operating systems as well as guidance
for preparing for the IBM Certification Test
737. Helpful and thorough, this technical guide summarizes the new features
of DB2 9 environments and provides essential system administration information,
such as installation and maintenance procedures. With chapters on
troubleshooting, performance and tuning, and securing and auditing, as well
as practice questions, this reference is a one-stop shop for DB2 system
At the time of writing this blog entry, the book did not have a special price
on either amazon or MC Press. I’m hoping that changes, so check
both links for the best price.
Other books that are part of this series are:
9 Database Administration Certification Study Guide for Exam 732
Lawson and Daniel Luksetich
9 Advanced Database Administration Certification Study Guide for Exam
Roger Sanders, Dwaine Snow
DB2 9 Fundamentals
Certification Study Guide
9 Database Administration Certification Study Guide for Exam 731
9 Database Administration Upgrade Certification Study Guide for Exam
All of these books were authored by experts who were part of the exam
development team, the structure of the book matches the exam objectives, and
there are sample test questions to help you prepare for the exam.
Congratulations to Judy! Job very well done!
Flashbooks can be downloaded in PDF format for free. Here are the Flashbooks that were featured at events in 2013:
Customer Experience Analytics: Fast, Intelligent and Action-Packed
by Arvind Sathi
- Book information on blog
- Link to an online
- Electronic Version (6.98 MB)
Today’s customers have the ability to use a variety of media (including Facebook or Yelp) to broadcast their good and bad experience in real time. You must match their velocity! This book will help your organization create the capabilities to sense, isolate and alter the customer experience to your competitive advantage – creating a real time, adaptive relationship with your customers.
Analytics is one of the hottest IT topics of interest among organizations world wide. It has attracted not only the interest of IT organizations, but also has grown considerably in the minds of sales and marketing professionals. Applying analytics to customer experience provides the highest business value and is often the most sought after application area for Analytics. IBM has declared Analytics to be one of the four most important areas of growth towards our 2015 plan.
The role and business capabilities offered through analytics are rapidly changing. Customers are increasingly connected with their suppliers using a variety of electronic touch points – Web browsers, Interactive Voice Response, wireless devices, kiosks, etc. Customer experience can be altered through these electronic touch points in real-time. Also, Customers can use a variety of ways to express their satisfaction or lack thereof, publicly, in real time world wide. The associated data is accumulated by the supplier organizations in peta bytes. This data must be sorted, correlated and analyzed rapidly and intelligently to make a positive long lasting impact on the customer. Last but not the least; it is no longer sufficient to report customer problems to an analyst who routes to business owners on a monthly basis. The actions must be inserted in appropriate customer facing customer service, sales, billing or operational functions to alter the customer experience – often in near real time. While the internet has provided enormous power to the consumers, the business markets have also gained an enormous amount of sophistication in multi-supplier management, electronic gateways and use of customer and product data across the supply food-chain.
The book includes four major segments. First segment introduces the concept of Customer Experience Analytics using a series of customer experience scenarios. It also establishes the scope and focus for the book in types of customer experiences covered linking it to the Customer Life Cycle and a variety of communication touch points. The second segment introduces business value for Customer Experience Analytics. It frames the measurement dimensions, sensitivity across geographies, organizational life cycle and industries, and ways to quantify the business value. Customer Experience Analytics is a journey across maturity levels. We establish here the levels of maturity and what an organization can expect at each level of maturity. The third section covers the solution architecture for CEA solution with components offering real-time processing, intelligence and autonomics. It includes components for data collection, storage, modeling, reporting, and integration with action. This section includes choices that must be made to keep the solution simple and easy to implement. The fourth section concludes our findings and discusses some of the changes we see in the architecture as new disruptive technologies evolve.
This book is intended for semi-technical audience. It uses a series of scenarios (real as well as imaginary), case studies and allegories to illustrate the CEA business opportunity, solution and program to senior and mid level business and IT management. The technical terms are defined and indexed for easy reference. Hopefully, sales executives will also use this book to make their audience aware of the opportunities, and get their interest in exploring a solution for CEA.<
About the Author:
Dr. Arvind Sathi is the Global Communication Sector Lead Architect for Information Agenda team. He is a seasoned professional with twenty-plus years of leadership in Information Management architecture and delivery. His primary focus has been in the delivery and architecture oversight of IT projects to Communications organizations. He has extensive experience with many domestic as well as international Communications service providers as well as with other Services Industries. At Carnegie Group, he was the pioneer in developing knowledge-based solutions for CRM. At BearingPoint, he led the development of Enterprise Integration, Master Data Management and OSS/BSS (Operations Support Systems / Business Support Systems) solutions for the Communications market and also developed horizontal solutions for Communications, Financial Services and Public Services. At IBM, Dr. Sathi has led several Information Management programs in MDM, Data Security, Business Intelligence and related areas and has provided strategic Architecture oversight to IBM’s strategic accounts. Dr. Sathi has also delivered a number of workshops and presentations at industry conferences on technical subjects including Master Data Management and Data Architecture and holds patents in data masking. Dr. Sathi received his Ph.D. in Business Administration from Carnegie Mellon University and worked under Nobel Prize winner Herbert Simon.
IDUG is already filled with amazing learning opportunities, as mentioned in
my blog entry: IDUG Denver – May
, but here are more for you to consider. At the IDUG DB2 Tech Conference in
Denver, Colorado, USA
, taking place May 14-18, 2012 at the Colorado Convention
, you can take advantage of specialty Full-Day Seminars
for an in-depth look at a topic that is relevant to
Seminars are held on Monday, May 14 and provide a great start to
your IDUG week by giving you access to some of the top speakers in the DB2
industry. The additional fee includes breakfast, lunch and course materials for
the seminar you attend.
- Educational Seminar With Full Conference Registration: $425
- Educational Seminar Without Full Conference Registration: $475
Select from these 6 topics of interest:
DB2 10 for z/OS DBA Certification Crammer Course:
Susan Lawson, YL&A
This course is a certification preparation
course intended to help you take DB2 9 Family Fundamentals exam (730) and DB2 10
for z/OS Database Administration exam (612). Passing of these exams will result
in certification as an IBM Certified Solutions Expert - DB2 10 z/OS Database
Administration. Participants are expected to have fundamental knowledge of
relational principles in addition to applied working knowledge of DB2 9 for z/OS
and basic knowledge of DB2 10 features. Susan’s latest book will also be
available, for sure before the conference and hopefully at the conference.
Recommended Best Practices from Customer DB2 Health Check
Studies: John Campbell, IBM DB2 for z/OS Development
one day seminar will introduce and discuss the major lessons to be learned from
customer DB2 Health Check Studies carried out by DB2 for z/OS Development and
provide recommended best practices in each area. The objectives are to:
introduce and discuss the most common issues, share the experience gained from
customer health check studies, share the experience from live customer
production incidents, provide proven recommended best practice, and to encourage
proactive behavior. The following topics will be covered: WLM Policy Setup,
Balanced Design across CICS and DB2 Disaster Recovery, use of Flashcopy,
Continuous Availability vs. Fast Failover, Preventative Software Maintenance,
Multiple Data Sharing Groups., Running Multiple DB2 Subsystems on same LPAR,
Normal DB2 Warm Restart vs. Restart Light, Storage Tuning. Download John’s
Flashbook for free: DB2 for z/OS Planning Your Upgrade: Reduce Costs. Improve
DB2 9.7 for Linux, UNIX and Windows DBA Certification
Crammer (Exam 541): Roger Sanders, EMC Corporation
training is designed to introduce you to the concepts a test candidate must know
in order to take and pass the DB2 9.7 DBA for Linux, UNIX and Windows
certification exam (Exam 541). The material for this course is aligned with the
541 exam objectives. After completion of this class, you will be familiar with
the concepts you will be expected to know and understand in order to take and
pass the DB2 9.7 for Linux, UNIX and Windows Database Administration
Certification Exam (Exam 541). Get Roger’s book about this exam: DB2 9.7 for
Linux, UNIX, and Windows Database Administration: Certification Study Notes
DB2 LUW Problem Determination and Trou bleshooting
Workshop: Pavel Sustr, IBM Toronto Lab
The popular DB2 LUW
troubleshooting seminar, updated with 9.7 techniques and LIVE DEMOS! Learn how
to identify and resolve problems such as database hangs, locking problems,
crashes and optimizer or performance problems. Get familiar with diagnostic
tools. Learn how and when to use these troubleshooting tools for a quick problem
resolution. Topics covered: Performance; Optimizer; FODC; Hangs;
Locking/Latching; and Crashes/Traps. Attendees will 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 frequent problems, and
understand DB2 Support’s methodology in troubleshooting DB2 and even non-DB2
hiccups. The seminar contains live demos, during which the audience will be
given an opportunity to perform an interactive investigation of selected
DB2 for LUW Performance Analysis and Tuning Workshop -
Everything You Need to Know: Scott Hayes, DBI
performance rules and best practices are changing as DB2 LUW advances.
Configuration parameters we used to have to care about are now AUTOMATIC, but
are the AUTOMATIC settings ideal? And what about Self Tuning Memory Manager best
practices? Most importantly, what ISN'T automatic and what DO you need to pay
attention to? What should you measure and how? What are the “new” and most
important configuration and design techniques that will deliver optimized
performance results for your organization? Participants will be encouraged to
run certain commands in advance and bring performance data to the class. We’ll
discuss your numbers, what they mean, and what to do next and all participants
should expect to “learn vicariously” through the seminar experience. Attendees
will receive over 36 SQL Snapshot commands that can be used against DB2 9.1, 9.5
and 9.7 databases.
I Didn't Know DB2 did THAT!: Bonnie Baker,
Bonnie Baker Corp.
Have you ever wondered what goes on inside DB2
when your SQL is being executed? This seminar is designed to answer exactly that
question and more by taking a look at DB2 Components and the Optimizer's
instructions for various SQL access paths. While simple paths will be reviewed,
this class will also focus on those difficult to understand access paths. Topics
include RIDPOOL failures, Hybrid Joins and a "Type C" Hybrid Join, coding both a
GROUP BY and an ORDER BY on the same columns to insure that my GROUPs are
returned in ORDER, using a 64-partition DPSI for SORT Avoidance, how does DB2
know if Index-Only data is "clean" or "dirty", result sets built at OPEN CURSOR,
DSNZPARMs affects on access path selection and operation and much, m uch more!
Platform: DB2 for z/OS
Take advantage of this additional conference option and register
Be an IDUG Mentor
IDUG is proud to offer an incomparable loyalty reward
program for those who have attended three or more IDUG conferences
- the opportunity to bring a first-time attendee for an unprecedented
80% discount! For IBM Champions, the number of years of
attending a conference and the restriction that the mentor must pay a full
conference registration, is being waived. If they are a speaker or volunteer,
using thier well-deserved speaker or volunteer discount no longer prevents them
from applying for the discount to mentor a first time attendee. To learn more,
visit the IDUG Web