I can’t believe that it’s been so long since I blogged about the Best Practice papers! Kate Kurtz sent me four new ones today and I found that my last entry about this topic was posted April 2009: “Learn & Benefit from Others “. Here are the four newest ones:
Written by Matthias Nicola and Susanne Englert
Update Published January 2011
This paper provides principles and guidelines for using DB2® pureXML® to solve business problems effectively and to achieve high performance when managing XML data in enterprise applications. The examples illustrating the best practices are based on a real-world financial application scenario and demonstrate how to implement the guidelines. The examples can be easily adapted to other types of XML applications. The paper covers the following areas:
- Storage options for XML data to improve performance and storage efficiency
- Techniques for adding XML data into a DB2 database
- Techniques for querying and updating XML documents efficiently
- Techniques for using indexes over XML data with queries effectively
- Techniques for efficiently maintaining and monitoring an XML database
- Techniques for developing efficient pureXML applications
Written by Maksym Petrenko, Mike Winer, and Joyce Coleman.
Published February 2011
Summary: Data in a data warehouse can be classified according to its temperature. The temperature of data is based on how often it is accessed, how volatile it is, and how important the performance of the queries that access the data is. Hot data is frequently accessed and updated, and users expect optimal performance when accessing this data. Cold data is rarely accessed and updated, and the performance of the queries that access this data is not essential. Using faster, more expensive storage devices for hot data and slower, less expensive storage devices for cold data optimizes the performance of the queries that matter most while helping to reduce overall cost.
Learn about a strategy for managing a multi-temperature data warehouse by storing data on different types of storage devices based on the temperature of the data.
This article provides guidelines and recommendations for each of the following tasks:
- Identifying and characterizing data into temperature tiers
- Designing the data base in an IBM® Smart Analytics System environment to accommodate multiple data temperatures
- Moving data from one temperature tier to another
- Using DB2® workload manager (WLM) to allocate more resources to requests for hot data than to requests for cold data
- Planning a backup and recovery strategy when a data warehouse includes multiple data temperature tiers
The content of this article applies to data warehouses based on version 9.7 or later of DB2 for Linux®, UNIX®, and Windows®. All examples in the article refer to IBM Smart Analytics System and InfoSphere™ Balanced Warehouse® environments.
Written by Walid Rjaibi and Mark Wilding
Published February 2011
Summary: Public cloud computing is an emerging computing technology that uses the Internet and central remote servers to host data and applications. It allows consumers and businesses to use applications without installing them locally and access information from any computer with Internet access. Cloud computing allows for much more efficient computing by using centralized storage, memory, and processing. The benefits of cloud computing are clear, and so is the need to develop appropriate security for cloud implementations.
This article is important for all DBAs who are setting up or managing databases in a public cloud environment. The details and best practices in this article will help DBAs protect themselves and their companies from security leaks and exposures by applying a standard, high-grade security policy to all databases that are hosted in a public cloud.
The information in this article is organized into three main sections:
- The IBM data server security blueprint: The blueprint first positions data server security within the bigger enterprise security picture. This section also describes steps to develop and roll out a security plan.
- Threats and countermeasures: This section describes the most common threats that affect a data server, whether it is deployed in a traditional environment or a cloud computing environment. The section then recommends a set of countermeasures.
- Additional cloud-specific security challenges: This section examines the additional challenges posed to data security in a cloud environment, in particular the need for privileged user monitoring and data segregation.
Written by: Silvio Luiz Correia Ferrari, Marco Antonio Norbiato, and Joyce Coleman.
Published March 2011
Summary: The IBM Smart Analytics System family of offerings evolved from the InfoSphere Balanced Warehouse family of offerings. Both are based on the same storage and database design principles.
Learn about some of the frequently asked questions about system maintenance in IBM® Smart Analytics System environments and InfoSphere™ Balanced Warehouse environments.
The frequently asked questions are grouped into the following two categories:
- System administration
- Ongoing maintenance and upgrades
The questions and answers discussed here apply to several generations of IBM Smart Analytics System configuration. The article uses the term IBM Smart Analytics System except when referring to specific InfoSphere Balanced Warehouse configurations. Most content, however, applies to IBM Smart Analytics System configurations and InfoSphere Balanced Warehouse configurations. Unless otherwise indicated, all content applies to V9.5 and V9.7 levels of the InfoSphere Warehouse and DB2® software.
You can find all the best practice articles on the following website:
I hope you find this series of articles useful. I’ll keep the website bookmarked for updates and will blog as new articles are published.
The ITSO has been busy creating technical publications to help you deep your knowledge and hands on skills with IBM’s Information Management products. Here is a list of the Redbooks and Redpapers that have published in first three months of 2011:
Advanced Case Management with IBM Case Manager
Published 22 March 2011, last updated 26 March 2011, Rating: (based on 1 review)
This publication introduces IT architects and IT specialists to the case management concept, its benefits, and how it is different from traditional business process management or content management. In addition, this book introduces the IBM Case Manager product, designing a case management solution, setting up the appropriate environment, and building and deploying the solution. In addition, it serves as a practical guide for IT professionals who are responsible for designing, building, and deploying case management solutions.
Data Studio and DB2 for z/OS Stored Procedures
Published 15 March 2011
This IBM® Redpaper™ publication is devoted to tools that can be used for accelerating the development and debugging process, in particular to the stored procedure support provided by the latest and fastest evolving IBM product: Data Studio.
Information Server: Installation and Configuration Guide
Published 8 March 2011, Rating: (based on 1 review)
In this IBM® Redpaper™ publication we provide suggestions, hints and tips, directions, installation steps, checklists of prerequisites, and configuration information collected from a number of Information Server experts. It is intended to minimize the time required to successfully install and configure IBM Information Server.
IBM Smart Analytics System
Published 23 February 2011
This IBM Redbooks® publication introduces the architecture and components of the IBM Smart Analytics System family. We describe the installation and configuration of the IBM Smart Analytics System and show how to manage the systems effectively to deliver an enterprise class service.
Embedding IBM Informix
Published 17 February 2011
In this IBM® Redbooks® publication, we discuss and describe the capabilities for embedding Informix® into applications and software. We introduce the technological architecture and describe several of the functions and features that support Informix as a robust and powerful embeddable DBMS. Many of these features are unique in the industry today, enabling clients to create a business advantage.
IBM Optim Performance Manager for DB2 for Linux, UNIX, and Windows
Published 13 February 2011, last updated 17 February 2011
This IBM Redbooks® publication describes the architecture and components of Optim Performance Manager Extended Edition. We provide information for planning the deployment of Optim Performance Manager and detail steps for successful installation, activation, and configuration of Optim Performance Manager and the Extended Insight client.
Extremely pureXML in DB2 10 for z/OS
Published 28 January 2011, Rating: (based on 2 reviews)
In this IBM® Redbooks® publication, we document the steps for the implementation of a simple but meaningful XML application scenario. We have chosen to provide samples in COBOL and Java™ language. The purpose is to provide an easy path to follow to integrate the XML data type for the traditional DB2 for z/OS® user.
IBM Enterprise Content Management and IBM Information Archive: Providing the Complete Solution
Published 19 January 2011
This IBM Redpaper™ publication focuses on the benefit and technical details of the integration of ECM products and offering with the Information Archive device. We explain the need and concept behind the IBM Smart Archive strategy, provide an overview of the Information Archive device and ECM products and offerings, and discuss how integrating them can benefit an organization. The technical details that we provide include integrating the Information Archive device with the following ECM products and offerings:
-- IBM FileNet® P8
-- IBM Content Manager
-- IBM Content Manager OnDemand
IBM Scale Out Network Attached Storage: Architecture, Planning, and Implementation Basics
Published 1 January 2011, Rating: (based on 2 reviews)
In this IBM Redbooks® publication, we give you details of the hardware and software architecture that make up the SONAS appliance, along with configuration, sizing, and performance considerations. We provide information about the integration of the SONAS appliance into an existing network. We demonstrate the administration of the SONAS appliance through the GUI and CLI, as well as showing backup and availability scenarios. Using a quick start scenario, we take you through common SONAS administration tasks to familiarize you with the SONAS system.
DB2 10 for z/OS Technical Overview
Published 30 December 2010, last updated 10 March 2011, Rating: (based on 3 reviews)
This IBM Redbooks® publication introduces the enhancements made available with DB2 10 for z/OS. The contents help you understand the new functions and performance enhancements, start planning for exploiting the key new capabilities, and justify the investment in installing or migrating or skip migrating to DB2 10.
The following eBooks about key IBM Products are available at a 50% discount for the next two weeks, ending April 17. For all the details, click here. Note that the discount is automatic on these selected eBooks:
Manage and administer your WebSphere application server to create a reliable, secure, and scalable environment for running your applications
Build SOA-based flexible, economical, and efficient applications
Engineer a clear-cut strategy for achieving best-in-class results
Upgrade your system and embrace the exciting new features of the Lotus Notes and Domino 8.5.1 platform
Build scalable, high-performance software with IBM's data grid
Design, implement, and monitor a successful Q replication and Event Publishing project
Last week’s blog entry Budgeting for IDUG North America conference as viewed by the DB2 Locksmith by guest Rebecca Bond was very popular, so I’ve asked Rebecca back for a second entry. Actually Rebecca did one for me like this last year as well. I figure that DBAs would benefit more if they hear from a DBA saying what sessions she plans to attend rather than me telling you what sessions are available for you to attend. Rebecca is on the LUW platform, so I’ll try to find a willing guest blogger to do something similar for the z/OS platform so that I’m able to satisfy as many people as possible.
I heart IDUG NA. It’s like a geeky vacation where I learn much, smile and laugh a lot with old and new friends and go home armed with a suitcase full of technical material. This year is especially exciting since I’m going to be presenting two sessions and will be one of the featured speakers for the Dine Around!
As I do almost every year, I plan to take advantage of the free certification testing. I place great value in DB2 certifications and can certainly see evidence on job boards that employers prefer certified employees. The fact that I can take these exams for free helps makes the conference registration cost a bargain.
Monday, May 2 offers Full Day Seminars presented by DB2 Rockstars. True, these are not free, but given that they are being delivered by experts, these seminars offer great benefit for the price. If you are also registered for the full conference, you can add on one of these seminars for $425. See this link for a list of Rockstars and Full Day Seminars. I have some personal plans for Monday, so I will not be able to attend a full day seminar this year.
Typically, I approach planning my conference agenda from the standpoint of “what information will best help with my current job?” This year, however, I’m looking at it from “what sessions are going to be most valuable to increase my DB2 knowledge as I look for my next job?” This time, I’m looking for sessions that will help round out my resume.
The keywords for me for this IDUG are:
pureScale, Performance Tuning, XML, Cloud, and, of course, Security.
The good news is that there are plenty of opportunities to attend sessions on these topics. The bad news is that there are plenty of opportunities to attend sessions on these topics. Until I can get a personal DB2 Locksmith clone (no, not a database clone), I am going to have to make some difficult decisions about which sessions to attend in person. All is not lost, however, since I will definitely download the handouts from all the sessions for later review. I believe that recordings of most of the sessions will be available to attendees after the conference wraps up. So, I won’t really miss anything, I’ll just postpone taking advantage of some of the information.
I have to say though, this year is especially tough because I’ve heard most of these speakers before and I know how good they are. There are SEVERAL Best Speaker award winners in the group. I think Scott Hayes said it best, “DB2’s Got Talent”! That is an equally fitting designation for this year’s IDUG speaker list. (By the way, the winner of the first ever DB2’s Got Talent competition will be at IDUG!)
I’m not going to list my full agenda, because I like to keep a few secrets, or at least that’s my cover story. The truth is I simply cannot decide, but here are some sessions that are high on my personal list of “musts” this year.
Tuesday, May 3:
General Session: Jeff Jonas, Chief Scientist, IBM Entity Analytics and IBM Distinguished Engineer
S02: Choose DB2 LUW and Save Your Company Money, 10:15, Tim Vincent
F01: DB2 and Cloud Computing: Why Should I Care? 12:45, Leon Katsnelson
G02: DB2 LUW Security -- What If Your Firewall Catches Fire, 2:00, Rebecca Bond (DB2 Locksmith)
D03: Best Practices in Action -- The IBM Smart Analytics System, 3:15, Eddie Daghelian
C04: Understanding and Tuning Page Cleaning in DB2, 4:30, Matthias Nicola
Wednesday, May 4:
D06: The Latest from the Lab on DB2 pureScale - Part 1, 9:45, Matt Huras
D07: The Latest from the Lab on DB2 pureScale - Part 2, 11:00, Matt Huras
E08: Real-World XML Application Development Patterns for DB2, 2:45, Fred Sobotka
Thursday, May 5:
C10: Improve Performance by Analyzing DB2 LUW Access Strategies, 9:45, Melanie Stopfer
D11: Workload Optimized Systems - Don't Run a Marathon in High Heels, 1:30, Chris Eaton
Friday, May 6:
G14: Security Secrets for DB2 LUW DBAs, 9:15, Rebecca Bond (DB2 Locksmith)
G15: Monitoring and Troubleshooting Distributed Access to DB2 for z/OS, 10:30, Cristian Molaro
Of course, I also have to find time to meet friends, have interesting technical discussions in the hall, visit the expo, perform the “exchange of business cards ritual” and find some time to get in a run or two. It is certainly going to be busy week, but it will also be a highly educational and entertaining one. When you see me, I hope you will say “Hi” and let me know how you approached choosing your agenda.
Thanks Rebecca! I must say I’m feeling quite sad that I won’t be there! I’ll send all my friends to your Dine Around Night.
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.
About 6 weeks ago, IBM and Jeopardy made history by pitting a computer against human Jeopardy champions to see if IBM had created software that could “understand” the context in natural language. The project is dubbed “DeepQA”. Did you see the shows? There were three Jeopardy episodes and several on the background of creating the computer Watson. You can see the replays on Youtube.
The Face of Watson
IBM and the Jeopardy Challenge
IBM Watson Why Jeopardy
Jeopardy! IBM Watson Day 1, Part 1
Jeopardy! IBM Watson Day 2, Part 2
Jeopardy! IBM Watson Day 3
The day after IBM Watson won the match, we had one of the team’s engineers (Marshall Schorr) visit us at the Toronto Lab to tell us about the project and to answer questions. I stood up to ask a question, but first I made the following comment “If you’re looking for a sequel, get IBM Watson to help TV’s House with his very difficult medical cases".” I’ve seen similar comments from other people. Not that it will happen, but one of the best things about the software that was created is the possibility to help diagnose problems. After the Jeopardy show, it was announced that IBM would be working with Columbia University Medical Center and the University of Maryland Medical School on health care analytics research.
Of course the intention is NOT to REPLACE a physician, but only to assist a physician as you can read in this article “Why IBM’s artificial intelligence “Watson” could not replace a physician”. According to the video Perspectives on Watson: Healthcare, 20% of medical errors are diagnostic errors. Also, medical literature doubles every 7 years, making it physically impossible for any practitioner to read and absorb the information that they need.
I heard a story about a case that took medical professionals 6 months to diagnose. They fed the symptoms to Watson and diagnosed the issue in less than 30 minutes. Can you imagine how helpful this will be?
Another interesting thing that Watson would be able to do is to harness all the data generated by patients in hospitals around the world to determine if there are mini epidemics occurring or to see trends in medicines that might have unreported side effects. See articles “Dr. Watson, Please Report to the Health Care System” and “Treat the Patient, Not the CT Scan”.
Last year at the IBM Information on Demand Conference, we had guest speaker Dr. Atul Gawande speak to us. He did a book signing for his current book “Checklist Manifesto”. I liked the book so much that I’m now reading “Complications: A Surgeon's Notes on an Imperfect Science”. The book was published in 2003, but the chapter “The Computer and the Hernia Factor” could be read as a plea to have a supercomputer like IBM Watson helping to diagnose problems.
Personally I’ve seen times in my own medical experiences as a patient, where I would have completely welcomed my doctor consulting with Watson to help figure out what was going on.
My post yesterday featuring guest blogger Rebecca Bond was such a hit, that I thought I’d try again. My plan is to post something from each of the final contestants who took part in the DB2Night Show’s “DB2’s Got Talent” Competition. I’ve introduced you to the contestants in a series of blog entries, so I hope you feel like you “know” these people by now.
I would like to say a few words (I have a lot to say!, but I will try to keep it short) about the DB2 Night Show’s world wide db2 talent contest which concluded last Friday after several successful weeks and with many, many great DB2 tips and lots of useful information.
First, I would like to talk about my experience as a participant in this contest. This was my first time participating in such an event and it was such a positive experience for me. Apart from learning so many brilliant new ideas and creative ways of using DB2, this show has done so much to improve my personal skills in effective communication and has shown me how much more I can improve in that area just by listening to the other contestants.
I have listened to all the contestants from the beginning of the show and I am planning to do so again because some of the ideas were such brain teasers that I cannot resist going back to it. For example Ahmad’s tips on the high speed text search is going to be very useful to me and I am sure to everyone else working with XML data.
And I am going to miss Mary’s presentations, she has a unique style of presenting and I hope I can learn to be so creative in my future presentations. Norberto has a lot of expertise in visual communication skills apart from all his great technical tips and so on. I can keep going on all the contestants, everyone had something that I could learn from and I am sure all the audience feel that way too!
I want to thank the host of this event Scott Hayes and IDUG for a very unique experience! I think this was an innovative idea of conducting a contest through a webinar which I can predict is going to get very popular among all the technical communities!!
Thank you to all the judges Susan, Martin, Klaas and Cristian for their wonderful critique, it kept me motivated throughout this contest!
I still have a lot to talk about but I promised to keep it short , so I will stop here!
Susan, Thank you for letting me share my experience on this great show!
Have a great day everyone and don’t forget to register for the April 8th DB2Night Show event!
Hope to see everyone there!
She didn’t suggest that you watch the replays and vote, so I’ll do that! You’ll really enjoy the presentations and the tips you’ll learn. And as JB says, you can learn from the presenters to fine tune your presentation and teaching skills.
I've asked my good friend (and Information Champion) Rebecca Bond
to write a guest blog entry for me. She chose to write it about the upcoming IDUG conference
that is taking place May 2-5, 2011 in Anaheim California. As you will see, Rebecca is a gifted writer and I'm hoping she'll write another blog for me that talks about the sessions that she recommends.
Each year, in January, I look at my budget and try to determine if I can afford to go to IDUG. It occurred to me today that I am approaching this in the wrong way. The question I really should ask is “can I afford to NOT go to IDUG this year?” It paints the analysis in an entirely different way, doesn’t it?
Here’s why I think the IDUG value is … well … almost invaluable.
1. IDUG is an opportunity to learn from those who are “doing”. It’s not a sales convention. It’s not a marketing blitz. It’s just DB2 DBAs from all over the world doing what they do best….talking, presenting and learning about DB2.
2. The experience level of many of those attending is 20 years or more in their field. These DBAs have a LOT of practical DB2 knowledge and they are more than willing to share.
3. Since the sessions are related to 99% of my daily responsibilities, I am 100% sure I am going to learn tips, tricks and gotchas that will help keep me employed and employable.
4. The contacts I make are worth the conference cost. I can’t tell you how many times I have come back from IDUG with contact information for a new friend who was willing to share information long after IDUG was over. Ever had a puzzling DB2 question, but didn’t want to open a support ticket? These are the people who have the answers and I have never found a single one who wasn’t willing to help.
5. Free Certification Testing! Need I say more?
Ok, those were easy. Now let’s think about the cost of NOT going. That’s easy too.
1. I need knowledge to do my job effectively. I can’t go to training as often as I like, but at IDUG, I can get a LOT of information on a variety of relevant DB2 topics that will help me stay informed. It’s like multiple weeks of training rolled into one. That’s a cost advantage I cannot afford to miss!
2. Learning how other folks do things is going to give me solutions to make my tasks easier and potentially avoid errors. If I don’t attend IDUG, I’m missing out on these “lessons learned” opportunities.
3. I wouldn’t get access to those awesome presentation handouts that I am continually referring to. I save all my conference downloads, index them, and refer to them whenever I need to brush up on a skill. Not getting those would be a huge loss.
4. I wouldn’t find it as easy to stay “cutting edge”. We all know that technology is driven by innovation. Without access to “current”, how can I expect to think “future”?
I could go on, but these are the highlights. When I do the math, the cost of NOT going to IDUG North America is much greater than the conference cost! Hope I’ll see you at IDUG!
Here's some information about Rebecca that I'd like to share with you:
Books can be expensive… I know because I’m an avid reader and having go used to using a library! I tend to look for books on sale but also I have switched primarily to ebooks as the price is normally quite a bit lower than the printed book.
Check out the great prices offered by IBM Press for a wide selection of eBooks: There are 58 books in the list! Here are a few that I want to highlight:
Data Integration Blueprint and Modeling: Techniques for a Scalable and Sustainable Architecture
- List Price: $47.99
- Your Price: $28.79 (Save 40%)
New Era of Enterprise Business Intelligence, The: Using Analytics to Achieve a Global Competitive Advantage
- List Price: $35.99
- Your Price: $21.59 (Save 40%)
Art of Enterprise Information Architecture, The: A Systems-Based Approach for Unlocking Business Insight
- List Price: $47.99
- Your Price: $28.79 (Save 40%)
Understanding IBM SOA Foundation Suite: Learning Visually with Examples
- List Price: $39.99
- Your Price: $23.99 (Save 40%)
DB2 pureXML Cookbook: Master the Power of the IBM Hybrid Data Server, Adobe Reader
- List Price: $43.99
- Your Price: $26.39 (Save 40%)
Viral Data in SOA: An Enterprise Pandemic, Adobe Reader
- List Price: $31.99
- Your Price: $19.19 (Save 40%)
Enterprise Master Data Management: An SOA Approach to Managing Core Information, Adobe Reader
- List Price: $43.99
- Your Price: $26.39 (Save 40%)
Understanding DB2®: Learning Visually with Examples, Adobe Reader, 2nd Edition
- List Price: $51.99
- Your Price: $31.19 (Save 40%)
DB2 9 for Linux, UNIX, and Windows: DBA Guide, Reference, and Exam Prep, Adobe Reader, 6th Edition
- List Price: $51.99
- Your Price: $31.19 (Save 40%)
Enter coupon code IBMEBOOKS40 at step 3 of checkout to save 40% off all IBM Press eBooks in your shopping cart.
To help you decide, listen to a podcast featuring an author: Podcast Series, or get the e-Sampler with select chapters for you to read to decide. Still not sure about reading an e-book? Check out my blog, Can you possibly love reading more than you already do?
Another great show. Five more educational and entertaining presentations. What an excellent finale. You have two weeks to watch the replay and to vote for your favourite. Remember that the overall winner gets a free pass to an upcoming IDUG conference! The winner will be revealed on the next DB2Night Show, Friday, April 8.
Let me tell you about the presenters today:
Norberto – From DBA to DBA: Tips to Make your Life Easier
Another great presentation from Norberto, filled with amazing tips that will help any DBA. Luckily for us, Norberto has started to blog about his tips and experiences. I predict that you’ll want to follow his blog: Insights on DB2 LUW database admin, programming and more
Momi – Pressure Makes Diamonds
Momi’s presentation encourages DBAs to practice and prepare for possible problem areas that can cause a DBA to be under enormous pressure. Good advice in terms of preparing for a recovery after a disaster and more. Momi’s wise tips can also be found in a blog: B-Advised DB2 Blog
JB – CIO – Best Practices
Many of us, including me, thought that CIO was Chief Information Officer, but in the context of JB’s presentation it means Concurrent I/O. As usual JB covered the topic very thoroughly and very convincingly. I don’t think that JB has a blog, but don’t worry, I’m hoping to turn her into an author so she can share her talent of explaining complex topics with everyone.
Mary – How the DB2 Load Utility is Like Green Eggs & Ham
Mary is also an amazing presenter and is a pro at making topics very interesting with appropriate comparisons to popular interests. In this case, she encourages people to try something new, like was done in the Dr. Suess book “Green Eggs & Ham”. She encourages you to use named pipes to load data. Mary is a former Oracle user and has discovered the power of DB2 and has become a huge fan. I couldn’t find a blog for Mary… but she’d be good at it!
Thiru - Data
Thiru dug deep and found another command that is not very well known but is very useful. This time he taught us about using DB2cat. I also couldn’t find a blog for Thiru, but I do know that he attended the DB2 Symposium in Dallas earlier this week, so hopefully he’ll be active in local DB2 events in the future.
We judges, Martin Hubel, Klaas Brant, and myself had a very tough time deciding which of the bottom two presenters we were going to keep. There were many conversations going on between the judges. Then Scott did the poll and found that the audience was pretty split as well. In the end we chose Thiru. We really wanted to keep both, but needed to follow the rules. This ends Mary’s amazing run and anyone who saw her presentations over the past couple of months will agree with me that Mary will do very well at anything she chooses to do!
Once again 100% of the audience said that they learned something new that would be helpful in their job! What a big win/win experience this has been: audience is learning & contestants are fine tuning their presentation skills.
Please watch or re-watch the shows from the past 4-8 weeks and vote for one of the last remaining contestants to help us choose the overall winner. My sincere thanks to Scott Hayes for creating this entertaining and educational format for learning and training.
I know several patent holders and Master Inventors who work at IBM: Sam Lightstone, Mike Winer, Cathy McArthur, Joanna Ng, Arthur Ryman, Andrew Trossman, Mark Wilding, Danny Zilio, and Calisto Zuzarte. Did I ever tell you how much I like working at IBM? To be surrounded by so many smart people is incredible.
I read an interesting article today on eweek.com about IBM’s patents: IBM Patent: 100 Years of High-Tech Innovations. They listed 10 important patents and I was surprised by some of what they picked, including Ultraviolet Surgery! From the Centennial films we learned that IBM invented the punch card, UPC codes, airline reservation systems, and much more.
This is IBM’s 100th year in business and as a company, IBM has been earning many patents every year, but recently has surpassed 5000 patents in a single year! IBM inventors received a record 5,896 U.S. patents in 2010—which marked the 18th consecutive year the company topped the list of the world’s most inventive companies.
Even if you’ve watched the two Centennial films already, I encourage you watch them a second or third time. The films are well done, educational and very inspirational. The my blog for links to the films: Some Important / Cool IBM Events in 2011.
How do you keep up to date with the massive amounts of technology when your life is already filled to the max? Have you tried listening to a podcast? The advantages of podcasts is that they’re short, concise and portable. I think these three qualities are critical to making a podcast useful. Using a portable device for this learning content will allow you to listen in your car, on transit, while walking, or doing chores around the house.
Here are a few you might want to check out:
IBM Press Podcast series
Hear directly from an author about their book and the topic of the book. For example:
Technical Tips for Enterprise Business Intelligence by Mike Biere
Top Business Intelligence expert and author Mike Biere provides a blueprint for creating winning BI strategies and infrastructure, and maximizing the value of information throughout the enterprise. Two parts
developerWorks Podcast Series
Scott Laningham, editor of developerWorks podcasts, talks with thought leaders
in many fields, paying extra attention to the computing and software element with each
focus. This feed also features other developer-related podcasts from IBM. For example,
Steven Adler: The path to smarter data governance with collaborative structures
Steven Adler, Program Director for IBM Data Governance Solutions, talks about what companies face in the data governance space and some key elements in a successful program.
There are many other podcasts available. In my research I found it a bit overwhelming! On IBM’s home page, I did a search on podcast and come up 1.5m hits. You can get podcasts on Audible.com, itunes.com, and Books 24x7. So much choice!
I hope you have the desire to give it a try.
Check out this great offer by IBM Press (Pearson Education):
Chapter 4: Enterprise Information Architecture: A Conceptual and Logical View
Data Integration Blueprint and Modeling
Chapter 3: A Design Technique: Data Integration Modeling
Enterprise Master Data Management
Chapter 5: MDM Architecture Patterns
Viral Data in SOA
Chapter 1: Viral Data
The New Era of Enterprise Business Intelligence
Chapter 5: Elements of BI Solutions: The End User Experience
Mining the Talk
Chapter 2: Mining Customer Interactions
If you’ve been wondering about the content of these 6 books, getting this sampler is a great way to preview the content so you can determine whether you want to read the entire book. I have a Kindle and preview all of the books I purchase. You should no longer find yourself purchasing a book only to find out once you get home that it isn’t what you thought it would be.
If you like to “Try before you buy”, also consider the offer for trying education classes before you sign up for them.
You haven’t tried ebooks yet? Go outside your comfort zone with an ebook, you’ll be glad you did!
We’ve all heard the expression that practice makes perfect. I can prove that this is the case. Watch the seven episodes that we’ve done so far on the DB2’s Got Talent Competition on the DB2Night Show and you’ll see how each presenter and presentations gets better & better. You know what this show is actually doing? This competition is grooming many people to become future speakers at conferences such as IOD and IDUG.
The theme for today’s show was Personal DB2 Success Stories. Seven people presented. Let me tell you briefly about each:
Norberto – A Handmade ETL Solution
ETL = Extracting, Transforming, Loading. Like the pro he is now, Norberto laid out the problem, the need, and a creative solution using triggers, procedures and functions. Very well done.
Momi – Old School Table Partitioning
Momi used a fair amount of humour in today’s presentation and it worked very well. He clearly described the problem of having a table that continued to have more data coming in. Restrictions included a need to keep the table size constant and no time for maintenance. Momi gave us a few possible solutions and advantages of each.
JB – A Terabyte of Data & Trouble with I/O
This sounds like it could be a very common problem. JB showed us how she used the DB2 V9.7 rebalance feature to improve performance and contention by 90%.
Mary – Using SQL to Write SQL
Mary gave us a very creative way to use scripting. She gave very clear instructions with pointers as to what to watch out for. With a small amount of work, these scripts could be used on the mainframe as well.
Ahmad – Fix Runaway Job & Change Developer’s Mindsets
The SQL examples that Ahmad showed were very complex, but he did a nice job of taking us through the details. The suggestion that DBAs need to work with their developers was a good one.
Thiru – Influencing Optimizer for Success
Although this is a risky thing to do, Thiru did a fine job of taking us through how to create an optimizer profile that can improve performance of a statement that ran 4 hours. He succeed using the DB2CAEM utility (which he said is like a flight simulator) and now the statement takes 4 minutes to run.
Bob – Searching for the Needle in a CLOB Haystack
Last, but not least, Bob showed us how he created a Java application to do string manipulation to improve performance over using the LIKE option. This was a cookbook type of presentation that gave many tips on how to perform the actions.
This episode we had to send two people “home”, unfortunately. And just as it is on American Idol, this gets harder to do each week because the quality of each presentation is amazing and 100% of the audience said they learned something new during this show. The judges, Martin Hubel, Cristian Molaro (sitting in for Klaas Brant this week), and myself were in agreement with the results from the audience poll. We decide to send Thiru to the finals and said good bye & thank you to both Bob and Ahmad.
Now we need your help… now, more than ever. We need you to watch the replays and to decide which presentation you think is best. Vote for the best to decide who will go on and will get a free pass to an IDUG conference of their choice.
Click here to watch the replays.
To vote, use this URL: https://www.surveymonkey.com/s/DB2TalentFinals3
Thanks to Scott Hayes for putting this show together to Entertain and Educate us. Thanks to all the participants for your dedication to DB2 and for sharing your experiences with all of us. All of you are quite talented and should consider presenting to a live audience at a future IDUG event.
Join us next week for the final show of the competition. There will not be a show on April 1. The winner will be announced on the show on April 8.
I’m looking forward to listening to Sam Lightstone’s latest webinar about his best selling book “Making it Big in Software”. This webinar is presented by Safari Books Online and is free.
Date: Wednesday March 16, 2011
Time: 1:00 pm EDT (10:00 am PDT)
Register Now: Safari Books Online
This webcast is perfect for anyone who wants to jumpstart their career in software! Individuals are all too easily confined by the scope of their current position. Gain insight into how to create your own path toward greater success through inspiring advice and real-life stories from author Sam Lightstone. Discover how to:
- Accelerate your career, and promotions, with integrity
- Master the nontechnical skills crucial to your success
- "Work the org" to move up rapidly
- Successfully manage your time, projects and life
- Move up to "medium-shot," " big-shot" and finally "visionary"
The software business is constantly changing, to make it big you need a finger on the pulse of today's realities.
Sam Lightstone is the creator of MakingItBigCareers.com as well as Program Director and Senior Technical Staff Member with IBM’s Software Group, where he works on product strategy and R&D for one of the world’s largest software engineering teams.
Sam is a sought-after public speaker, author, and prolific inventor who still spends a good part of his professional time recruiting and mentoring software engineers.
If you’re a regular reader of my blog, you’ll remember a few other entries I’ve posted in relation to Sam’s book.
Campus visit - how to improve technical writing skills
Wine and Cheese and Sam Lightstone at IOD
Meet author Sam Lightstone “Making it Big in Sofware”
Making it Big .... Live on the DB2Night Show!
Two live sessions coming up with author Sam Lightstone...
Making it Big in Software
Yes, I have heard Sam speak about his book several times, but can tell you that he changes the topic for each talk. His book is so rich with advice that he could do quite a few more sessions before he runs out of topics.
Congratulations on the success of your book Sam!