OK, I thought I had produced a pretty good list of free resources, but of course, as soon as I post, I realize that I’ve forgotten to mention some really key resources. Let me try again and hope that I don’t miss anything else! (Of course if I do… please tell me!!)
PlanetDB2.com – Allow us to filter through all the blogs that are on the web to bring you only the bloggers that talk about our favourite subject: DB2, InfoSphere, Warehouse, and other Information Management technologies.
ChannelDB2.com – The single largest community of people working on DB2 and Information Management products, world-wide. You’ll be able to build your network of professionals who work in your country or who are interested in the same technology as you. The best feature is the incredibly large selection of videos of people presenting about this products. Once in awhile, save your eyes and tune into these videos.
DB2Express-C – Maybe you’ve just heard of DB2 or maybe you use a competitor’s product. No worries… give DB2 a try for free. Find out for yourself how easy it is to learn and how much better it is than the product you may be using.
Information Center – Perhaps I’m biased since I worked for 6 years on the Information Development team that produces product documentation, but I really think you’ll find the completeness and the quality of this information to be outstanding. All of the information is online, for every release, for free, and is updated regularly. The benefit of the content being online is that you can search and easily find the information you need.
developerWorks – You’ll find more articles, blogs, tutorials and other training resources than you could possibly consume in a lifetime! The link I’ve provided is for the DB2 Professional Community, but you’ll be able to find technical information about all IBM software products. Endless :)
MeetDB2 – One of the interesting things you’ll find on developerWorks is this utility that will help you analyze your Oracle database to estimate the level of compatibility with DB2. My link will take you to an article written by Serge Rielau that will help you understand how the utility works, and it provides a link the utility.
Read through my previous blog entries for more free or almost free resources:
Not quite free….
DB2Night Show - DB2 for z/OS
Coming up fast is the 3-day Information Management Technical Conference (IMTC India 2011) that is taking place in Bangalore, India. The conference starts Wednesday May 4 and goes until Friday May 6. If you’re in the region, you should attend for many reasons.
- This is a 3-day deep dive technical conference, specializing on the Information Management area.
- Choose from 58 technical sessions & 8 hands on Labs.
- Free certification: one free IBM certification exam per participant on IM brand only.
- Networking opportunities with peers, product and industry specialists, and like-minded professionals.
- Get your technical questions answered by experts.
There are four tracks that you can follow:
- Data Management
- ECM Enterprise Content Management (FileNet + DB2 CM)
- IP and S (Information Platform and Solutions - Datastage, MDM - Infosphere)
- Business Analytics and Optimisation
You can keep up to date with all the latest news by following the Training team on Facebook or Twitter.
To register and for full conference details, see the IMTC India 2011 web page.
See a previous blog I wrote about the resources that you can find in India that are related to Information Management.
Last week I blogged about some of the excellent training resources that you can get for free. Today I’ll tell you about some of the deals you can get to bring down the price of a resource to something closer to free:
- DB2University.com – Some of the courses are free, but not all. The idea behind DB2University is to offer you very low cost training opportunities.
- Membership to IDUG is free. If you are a member, you can get 45% off the retail price of any of the IBM Press books. Go to IDUG’s home page and click on the icon on the bottom right corner. This will give you the instructions needed to get your discount. See a previous blog entry for more information on IDUG: IDUG = International DB2 User Group
- If you’re not a member of IDUG and don’t wish to join, you can take advantage of the following offer: New and Best-Selling Information Management Books at 35% off; Enter coupon code INFOMGMT during checkout to receive discount.
- Looking for an ebook? Get 40% off IBM Press titles. See “eBooks from IBM Press “ for details.
- Buy your DB2 Certification Guides directly from MC Press’ Online bookstore to save as much as 54% on a book.
- Best book about how you can improve and thrive in your career: Making it Big in Software. Still 35% off at amazon.com.
- Save $100 and refresh your skills with Assess and Save – Take a sample test and get $100 off the normal price of an exam.
I’ll keep looking for offers to share with you that are free or nearly free… so keep coming back for more information.
Monday April 25 is the Kickoff
for DB2 for z/OS
shows on the DB2Night Show. As a reader of my blog, by now you know the DB2Night Show and Scott Hayes
very well. Just to be sure, here’s what you need to know about the DB2Night Show:
Scott Hayes of DBI started a series of free webinars in September 2009 with the goals to: Educate, Entertain, and Inform. There have been 48 shows already and 98% of the attendees said that they learned something new from the show. I’ve personally been involved in the past few months as part of the “DB2’s Got Talent” competition and I must say that I was blown away with the quality, variety, and depth of the education provided.
Each episode has a DB2 educational theme and speakers have been IBM experts, top consultants, IBM DB2 Gold Consultants, IBM Information Management Champions, and experienced users.
Klaas Brant of KBCE and organizer of DB2 Symposium Education has decided to turn Mondays into a must attend learning session for people who work with DB2 for z/OS. There are already 5 amazing shows on the schedule with more to come.
Remember, the DB2Night Show is completely free for participants, but there is a limit to how many attendees can attend. Make sure you register immediately so you don’t miss out. Replays will be available following each show.
Here is the current schedule:
The History of DB2
Monday April 25, 2011, 11EDT
The kickoff of the DB2Night Show z/OS Edition features legendary Roger Miller. This event shows much of the history of DB2 with milestones of new versions, new inventions, and showcases some of the people who contributed key inventions and innovations in DB2.
The Future of DB2
Monday May 9, 2011, 11 EDT
Edition #1 was a look at the history of DB2, so it is fitting to have the second show centered around the future of DB2 z/OS. Special guest Jeff Josten will share the latest new with DB2 V10 and will offer his insights into what may be coming in future releases.
DB2 10 Performance
Monday May 16, 2011, 11 EDT
This episode will look at performance in DB2 10. Special guest Cristian Molaro was recently a co-author on a new IBM Redbook about DB2 performance that will publish soon. Cristian will share his hands-on experience with DB2 10 performance during the show.
DB2 10 SQL Enhancements
Monday, May 23, 2011, 11EDT
DB2 10 is packed with new SQL features like temporal data and many others. Join special guest Terry Purcell as he walks us through these great new features and explains how to get the best from them.
DB2 10 Customer Experiences
Monday, June 6, 2011, 11EDT
Many customers are already using DB2 10 in production. Special guest John Campbell will talk about migration planning and share lessons learned from people who have already migrated.
Are you looking for more quality educational ideas? See my previous blog entries:
- FREE – Flashbook “DB2 10 for z/OS - Cost Savings ..... Out of the Box“ available; find out how to get yours: http://bit.ly/fjR4x2
- FREE - Ten new IBM Redbooks that you may be interested in: http://ibm.co/hZDwXV
- FREE - Learn from experts via Best Practice articles for DB2 for z/OS: http://ibm.co/eTXbRd
- FREE – 3 certification exams for attendees of IDUG Tech Conference: http://ibm.co/giLoQA
- IDUG Tech Conference: http://ibm.co/gqaA35
- DB2 for z/OS Events & Resources: http://bit.ly/hZDPbf
Learning is a life-long journey, so take advantage of the outstanding resources that are available for you.
Last week I blogged about the Best Practice Papers that were available for DB2 Linux, UNIX, and Windows: DB2 Best Practices – New or Updated for 2011. As a result of that entry, I found out that there are also Best Practices resources for DB2 for z/OS as well. Not only articles though, but lectures, podcasts, and publications. Thanks to Janet Ikemiya and David Salinero for providing me with this information!
The DB2 for z/OS best practices developerWorks webpage contains many of the recommendations and guidance of DB2 for z/OS subject matter experts. Material from frequent conference speakers such as John Campbell, Roger Miller, Bonnie Baker, Willie Favero and several others is located on this site. Over 25 web lectures (slides with audio), articles, and publications are organized into categories such as administering, security, and tuning.
The most recent additions are:
John Campbell's two part series of recommendations regarding optimizing DB2 insert performance. This web lecture includes a video with slides and audio by John. The slides and transcript are also available separately:
Optimizing insert performance, Part 1 (February 2011)
by John Campbell
This webcast presents trade-offs made between optimizing DB2 insert for better throughput versus space reuse. It explores questions regarding inserting rows sequentially or randomly, whether to sort into clustering order and the effects of indexes on insert performance. Learn best practices for the different types of DB2 table spaces and get the details on DB2 parameters and recommended values.
Optimizing insert performance, Part 2 (March 2011)
by John Campbell
This second webcast on optimizing insert performance reviews additional techniques for speeding up the process of inserting rows into DB2. Learn about methods such as using a large index pagesize, random index keys, removing unused indexes, logging, and efficiently creating unique identifiers. The webcast covers enhancements specific to DB2 10 (such as index I/O parallelism, unique index with INCLUDE, and in-line LOBs) that impact insert performance. Finally, the presenter summarizes the best practices from both part 1 and part 2.
Also added in 2011:
DB2 Statistics Data Collection, DB2 System Address Space CPU Time and WLM Settings, Data Set Open/Close Activity (January 2011)
by Florence Dubois
There are many choices when collecting statistics about the DB2 system environment. This webcast will give guidelines on which statistics to gather and how to analyze your system's health. The data collected from IFCIDs, CPU time from monitoring tools, WLM metrics, and data set open and close activity will all be explored. The recommendations given will lead to improved DB2 performance.
Hard Lessons Leaned From Customer Health Check Studies (January 2011)
by John Campbell
This webcast presents practical advice from DB2 health checks at customer installations. It describes problems encountered when dealing with WLM, disaster recovery, continuous availability, data sharing, DB2 restart, and storage tuning. It discusses the most common issues and proven methods to prevent problems.
Additional material is posted throughout the year so bookmark this page!
If you have a suggestion for additional best practice content, please send an email to the contact firstname.lastname@example.org.
Can you tell that I love IDUG yet? OK, one more post and then maybe you’ll be convinced.
Cristian Molaro, an IBM Best Friend from Belgium (my mom’s home country :) sent me a link to a blog that he did similar to the one I posted from Beth yesterday. Like Beth, he’s listing the sessions that he’d like to go to given his affinity to DB2 for z/OS. Cristian’s blog entry: “A Travel Guide to IDUG DB2 Tech Conference – Anaheim 2011”.
Instead of repeating any of his post, or the other posts, let me tell you a few things that I’ve learned about the IDUG conference thanks to my guest bloggers:
A link to the Conference Event Grid.
A link to the Online Conference Schedule.
Budgeting tip: Did you know that if you attended an IDUG Regional Event in 2010, you can use the monies paid as a credit towards the IDUG 2011 NA conference?
Bryan Paulsen and Paul Turpin:
The DineAround event is very popular and spots fill up very fast! See post (All about IDUG DB2 Tech Conference - Anaheim )for a list of restaurants, leaders, and how you can sign up.
The name of the conference has changed to the IDUG DB2 Tech Conference to help people get funding to attend the conference.
There won’t be a bookstore on site at this event. Instead, order the books you need directly from the publisher at a discount. Members of IDUG get 45% off IBM Press books.
She loves IDUG as much as I do and considers it her Geeky Vacation.
The keywords for me for this IDUG are: pureScale, Performance Tuning, XML, Cloud, and, of course, Security.
This time, she’s looking for sessions that will help round out her resume.
When I do the math, the cost of NOT going to IDUG North America is much greater than the conference cost!
I hope you’ve found this set of posts helpful to you. If you are going to IDUG, I hope you have a wonderful and educational week.
I found a guest blogger for today who can navigate through all the amazing IDUG sessions and recommend the best for a person who is from the z/OS side of the house. Thanks to Rebecca Bond for being my guest blogger for the LUW sessions: IDUG NA – The Geeky Vacation!
Before I pass the baton to my guest blogger Beth Zlotky, I’d like to thank Suresh Sane for connecting me to Beth. Now, here’s Beth:
Greetings IDUG bloggers. As an IDUG NA attendee for the past two years, I'm very much looking forward to a repeat great experience in Anaheim. The friendly atmosphere in the hallways, at the sessions, and, let's face it, while dining too, has made the week very comfortable and enjoyable for me in the past. For those of you perhaps new to the conference, you may be surprised at how quickly you start recognizing familiar faces. The value of the information presented in the sessions and while networking with peers makes this a fantastic learning experience.
My particular role at Blue Cross and Blue Shield of Kansas is that of a DB2 for z/OS systems programmer; thus, my session choices tend to lean towards overall subsystem performance, migration experiences, etc. That said, I'm always eager to also get familiar with those new features available to the DBAs and developers in new releases. (Of note, for you developers – I've had the privilege of hearing both of Suresh Sane's sessions in our area User Group meetings: B15 – DB2 Design Selected (Controversial?) Topics and E10 – DB2 10 Application Topics – A Sneak Preview. Go. It'll be well worth your time).
I'm fortunate this year to be able to attend one of the Monday sessions: Z03 – Optimizing DB2 for z/OS System Performance Using DB2 Statistics Trace, with John Campbell. By the way, did you know that if you attended an IDUG Regional Event in 2010, you can use the monies paid as a credit towards the IDUG 2011 NA conference? In our case, the credit nearly covered the cost of the Monday session.
In these days of ever-tightening budgets, I feel very thankful for the opportunity to use precious training dollars. I want to say thank you to my employer by thinking, "what sessions will best help me to help our company?" Of course, my track leans heavily towards z/OS, and our shop in particular has embraced (and is continuing to develop in this direction) distributed Java apps running under WebSphere on UNIX, using DB2 on Z as the data server. I'm constantly trying to better understand how those apps access DB2 on Z and how we can improve performance from a subsystem perspective. There are some great sessions along those lines this year. I've yet to completely flesh out my week's agenda, but have identified these for sure:
- Z03: Optimizing DB2 for z/OS System Performance Using DB2 Statistics Trace. John Campbell
- B02: Mastering Distributed Access to DB2 for z/OS. Cristian Molaro.
- A03: Continuous Monitoring of Dynamic Queries. Thomas Baumann.
- A04: IBM Reorg Utility and RTS – A Smooth Transition. Paul Walters.
- B05: The DB2 V10 Catalog – A Revolution. Steen Rasmussen.
- B06: DB2 for z/OS Migration Planning Survival Guide. Linda Claussen.
- F07: DB2 10 for z/OS – John Deere's Beta Experience. Bryan Paulsen.
- G08: Early Experiences with DB2 10 Metrics/Metadata. Terry Berman.
- B10: DB2 10 for z/OS Planning and Very Early Experiences. John Campbell.
- A11: A DB2 Hitchhikers Guide to RMF and SMF. Frank Petersen.
- B12: Omegamon PDB – Exploit the Power of the PDB to Solve Performance Issues. Billy Sundarrajan.
- A14: Cost Control Methods for DB2 for z/OS Workloads. Mary Beth Jeffords.
- G15: Monitoring and Troubleshooting Distributed Access to DB2 for z/OS. Cristian Molaro.
If you see a "Beth Zlotky" name tag, please say hello. It's always nice to compare notes and share experiences. See you in Anaheim.
Thanks so much Beth! I’m sure this will help people choose the best sessions out of the wonderful selection that is available. For details on the sessions, see my blog entry All about IDUG DB2 Tech Conference – Anaheim.
Drum roll, please!!
The winner is: Norberto!
#4 = JB (7.3% of the vote). Shocking!! But considering the competition, #4 is outstanding. We’ll all remember her amazing presentations and value the knowledge we learned from her.
#3 = Momi (16.7% of the vote). Momi will be back in the fall with his great topics.
#2 = Thiru (31.1% of the vote). Thiru had to be saved a few times, but his topics were technical and thorough, and clearly pleased the audience.
#1 = Norberto (46.8% of the vote). Not surprised. He has a lot of knowledge, enthusiasm, and charisma. Very well done! I would very much like to see Norberto presenting at future conferences. He would like to attend the IDUG Anaheim Conference, but he may not have his Visa in time, and may have to choose Melbourne or Prague as backups. What a difficult choice that would be.
Comments from listeners was amazing… 1231 votes: 97.6 % indicated that they learned something that would help them in their job!
Congratulations to all of the contestants who took part in this 8-week series! Through the course of this very entertaining and educational experience, I can say will full confidence that we ALL learned something. Personally, as a judge for the competition, I learned how to critically watch each presentation and to make comments on it. This isn’t nearly as easy as you think it is! I also learned that there are amazingly talented people working on DB2 and a show like this can dramatically improve the presentation skills through practice.
I’ve known Scott Hayes, Martin Hubel, and Klaas Brant for some time now, but working with them on this show only improved my already high view of these people. This is true also for Cristian Molaro, although I only met him about 6 months ago. With all sincerity, I would highly recommend each of these gentlemen for there skills and knowledge. IBM is lucky to have such partners to work with.
And now for the contestants… Some of them created and presented 5 times. And this isn’t simply polishing up the same presentation and presenting it 5 times, this was creating a NEW presentation each time! Sure, they were only to be 5 minutes in length, but still very hard to do. I could see improvements being made by all presenters based on the judge’s comments.
Here are some of the amazing presentations that were delivered. I highly recommend that you watch the replays to get this education.
- DB2 Concurrent I/O - Best Practices
- A Terabyte of Data and Trouble with I/O
- Using HADR to migrate data
- Pressure Makes Diamonds (and Practice makes Perfect)
- A Different Approach to Table Partitioning
- DB2 z/OS report utility
- Managing z/OS DB2 REORGS
- "DATA" and the db2cat command
- Influencing the Optimizer for Success
- Explain from Actuals
- Green Eggs and Ham and the DB2 LOAD Utility
- Using SQL to Write SQL
- Using Sequences
- Fixing a Run Away Job and changing Developer's Mindsets
- High Speed Text Search
- Searching for the "Needle" in a CLOB "Haystack"
- SQL Tuning
Next Friday DB2Night Show returns to regular programming. See the full schedule.
April 15: DB2 LUW Workload Manager Hints, Tips, & How-to's from the IBM Developer
April 21: DB2 LUW vs Oracle Usability Study Part 1
April 25 Kickoff - The History of DB2 for z/OS
April 28: DB2 LUW vs Oracle Usability Study Part 2
Another DB2’s Got Talent Competition is planned for the Fall. I would love to be asked to be a judge again!
Here are my related blog entries:
Tips for DBAs from Guest Blogger Norberto.... DB2's Got Talent contestant
DB2, DB2Night Show and IDUG as viewed by JB
DB2’s Got Talent Finale
DB2's Got Talent - 3rd Episode of the Finals
DB2's Got Talent - March 11 Episode
Fourth Episode of "DB2 has Talent"
Third Episode of “DB2 has Talent”
Second Episode of DB2 has Talent
First Episode of “DB2 has Talent”
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
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.
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.