Keep on Learning
Are you overwhelmed by the amount of technical information that is available for DB2? I don't blame you if you are! IBM produces many different types of training resources to suit individual preferences for learning.
The DB2 Skills Kit from developerWorks is a good place to begin your quest to learn more about DB2. Skill kits are FREE and make it easy to learn introductory concepts and usage procedures with demonstrations, step-by-step tutorials, technical articles, webcasts, podcasts, and presentations. No need to search for information: The DB2 Skills Kit has what you need in one kit: how to install, configure, and administer IBM® DB2®.
Increase your knowledge and skills whether you are a database administrator or application developer. This kit is aimed at IT professionals that have a basic understanding of database principles and design that are looking for “just in time DB2 skills.” Topics covered include: Overview, installation, configuration, database creation, and administration.
For detailed information on how to download the kit, see these step-by-step instructions.
Join the next complimentary webinar in the DB2 Chat with the Lab series:
Time: 12:30 AM - 2:00 PM Eastern Time (ET)
Speakers: Sal Vella, Leon Katsnelson, Rav Ahuja, Chris Gruber
PS. For me, this is Cloud month. After I listen to this webinar, it will be the third full cloud talk I’ve heard this month :)
New Book: The Art of Enterprise Information Architecture: A Systems-Based Approach for Unlocking Business Insight
The Art of Enterprise Information Architecture: A Systems-Based Approach for Unlocking Business Insight
This book is currently being written by the following author team:
Mario Godinez, Eberhard Hechler, Klaus Koenig, Steve Lockwood, Martin Oberhofer, Michael Schroeck
•This book is designed to reach out to a wide client audience on a global basis leveraging IBM‘s vision and products in the Information Management area.
•Through a true cross brand author team (GBS, GTS, SWG) with high ranked contributors with proven track records and external visibility this book will promote IBM‘s expertise and implementation engagements in this area.
•This book covers the next generation of IBM‘s Smarter Planet vision in addition to Information Agenda and Information on Demand themes.
•Extraordinary support for the book by IBM external thought leaders and market influencers.
•Author team members have already published books for IBM Press and delivered external articles successfully before; with this book they cover the full range of IBM‘s capabilities covering Business Scenarios, Conceptual & Logical Component Architecture, Implementation Design using Operational Models – all consistent with IBM‘s Unified Method as well as offerings such as the Dynamic Infrastructure.
Mario Godinez is Executive IT Architect and IBM Senior Certified IT Architect within IBM's Worldwide Information On Demand Architecture team. He co-founded IBM Software Group's Information Management Technical Enablement team, and has spent 15+ years helping IBM financial and industrial customers architect and implement complex enterprise solutions.
Eberhard Hechler is Chief Architect of the European IBM Information On Demand Technical Center of Excellence. As Senior Certified IT Architect (SCITA) and Executive IT Architect, he is a technical leader of the Information Management organization at the IBM Germany Research and Development Lab. He co-authored Enterprise Master Data Management.
Klaus Koenig is an IBM Distinguished Engineer and has been involved in IT for 20 years. He is an internationally recognized expert in the field of IT architecture management and IT infrastructure design. As key innovator and chief technology executive he is currently leading several development and transformation initiatives, the major ones in the area of Cloud Computing, Green IT, Service Lifecycle Management and IT Process Automation.
Steve Lockwood works in IBM Software Group as a Lead Architect and within IBM's Business Intelligence practice (a part of Global Business Services). He has been involved in all aspects of the development of information related projects, covering Data Warehousing, analytics, Information Integration for CRM solutions and development of Master Data Management solutions.
Martin Oberhofer is a Senior Technical Consultant at IBM and a member of the World-Wide IBM Software Group Master Data Management Center of Excellence. His areas of expertise are Master Data Management, database technologies, Java development and IT system integration.
Michael Schroeck is a Partner and the Global Business Intelligence (BI) and Information on Demand (IOD) Leader for IBM, Global Business Services. Mike has a proven track record in having guided project teams in the design and successful implementation of large, complex BI/IOD Solutions (e.g., decision support, integrated analytics, data warehousing, data mining, etc.) for a wide range of clients.
You can preorder the book now. Very soon there will be a Rough Cuts version available where you can get the electronic version of the chapters as they are completed.
Thanks to the author team for putting in so many hours to create this book to share their extensive experience with all readers!
Just published by IBM Press:
Unfortunately Tony will not be at IBM Insights this year, so you won’t get a chance to get him to sign his latest book. His book, however, will be at the conference, and it looks like Tony has another best seller on his hands!
About the book:
Most enterprises recognize the crucial importance of effective information governance. However, few are satisfied with the value of their efforts to date. Information governance is difficult because it is a pervasive function, touching multiple processes, systems, and stakeholders. Fortunately, there are best practices that work. Now, a leading expert in the field offers a complete, step-by-step guide to successfully governing information in your organization.
Using case studies and hands-on activities, Anthony Giordano fully illuminates the “who, what, how, and when” of information governance. He explains how core governance components link with other enterprise information management disciplines, and provides workable “job descriptions” for each project participant.
Tony helps you successfully integrate key data stewardship processes as you develop large-scale applications and Master Data Management (MDM) environments. Then, once you’ve deployed an information asset, he shows how to consistently get reliable regulatory and financial information from it.
Performing Information Governance will be indispensable to CIOs and Chief Data Officers…data quality, metadata, and MDM specialists…anyone responsible for making information governance work.
About the Author
Tony Giordano is an experienced executive with more than 25 years of global professional services experience in the information management field in the areas of business intelligence, data warehousing, customer relationship management and program management. He has significant work experience in the financial services, life sciences, and automotive sectors. Mr. Giordano has functioned in various roles, including positions such as IBM Japan BAO Service Line Leader, Financial Services Practice Partner, and other consulting roles.. Tony has been dedicated to implementing customer-focused business analytics and information management platform that deliver business outcomes.
Congratulations to the authors for completing this book for DB2 Express-C 9.1: Getting Started with DB2 Express-C
Getting started with DB2 couldn't be easier. Read this book to:
* Find out what DB2 Express-C is all about * Understand DB2 architecture, tools, security * Learn how to administer DB2 databases * Write SQL, XQuery, stored procedures * Develop database applications for DB2 * Practice using hands-on exercises * Prepare for the DB2 on Campus exam
This book is ideal for developers, consultants, ISVs, DBAs, students, or anyone who wants to get started with DB2. While this books is focused on DB2 Express-C, the no-charge edition of DB2, the concepts and content are also very applicable to other DB2 editions on Linux, UNIX, and Windows.
Authors of the book include: Raul Chong, Rav Ahuja, and Ian Hakes.
Today was the fourth and final show of the first round of the DB2’s Got Talent Competition. If you didn’t participate live, I strongly encourage you to watch the replay. We had 7 contestants as well as an extra special presentation from judge Klaas Brant. The caliber of the presentations today blew me away. We judges had a very hard time selecting 3 to move on and were hoping we could save a few more. But alas, 3 was our max. Here’s how it played out.
Contestant 1 – Brian
Brian used a physical health analogy for his presentation and it worked out really well. Good thing I was on mute as I was laughing pretty hard at some of the graphics. In reality, indexes can get very out of shape, but there are ways to recognize this, monitor their health, speed them up, and ultimately make them into top physical form. The judges found the presentation to be very professional, interesting and easy to follow. If you’re into twitter, you can follow Brian at fairchild_db2. Also, he blogs at http://bit.ly/yGpae2 . Check it out if you’re interested.
Contestant 2 – Ember
Testing Your Recovery Strategy
As Ember said at the beginning of her presentation, this isn’t a very sexy topic. But as Scott said at the end, the way she presented it made the topic kind of sexy! OK, past the crazy talk, Ember chose to present the very valuable topic of being prepared. If you don’t fully test your recovery strategy, you may find yourself in hot water when you actually need to use it. Her tips were very insightful. Her presentation was interesting, very well laid out, and professional. One of the reasons Ember was so high on our list is because she chose a topic that cannot be found in the manuals. She came up with these tips from personal experience and a lot of hard work. Ember also tweets ember_crooks & blogs http://db2commerce.com/.
Contestant 3 – Mark
DB2 LUW Workload Management – Using Role-based Workload Management to Meet your Company’s Performance Goals
Mark chose a very tough topic and made it understandable. He started with showing how to identify the roles all the way to adding the UserIDs to the workload. One of the judges commented that this was a very adventurous topic and it was so well liked because we don’t often have tips related to this area.
Contestant 4 – Rajib
Debug High CPU Situations with DB2
Rajib works in the support area, so this is a topic that he knows very well, from experience with many customers. Rajib gave several decision trees to help you make the correct choice when you discover your CPU spiking. Rajib mentioned that he had more details in a follow on presentation that maybe we’ll hear one day. The one thing that Rajib could have done better right from the beginning is to put his presentation into Play mode. He had it in Edit mode so we could see less of the presentation than we wanted to see. The decision trees would have been much easier to read had it been in Play mode. Also, Rajib mentioned a perl script that he uses but we didn’t see the details. Rajib will find a home for his perl script so that we can all benefit.
Contestant 5 – Jean
DebReal 24x7 Enhancement: No downtime, no slowdowns, no planned outages, no suspending traffic, simplifies & expedites blackout, any time – day or night
Jean worked with her colleague Chuck to create this presentation, but she presented on her own. I found it to be a rather complex topic but with her examples, it helped make it understandable. Jean did a wonderful job of presenting, even though she said she was nervous. Jean, it didn’t show!
Contestant 6 – Sameer
Sameer’s been here before and I can tell you that his presentations are improving. Not a single typo this time around and the slides were well organized with a problem, questions a person would ask about the problem and ways to resolve the problems. Sameer’s slides said the presentation was based on personal experience, but during a discussion with the judges, he admitted that he made it up. It was a good choice for a topic as this isn’t discussed or documented in many places. Sameer tweets https://twitter.com/#!/sameerkasi200x and blogs: http://db2performance.blogspot.com/ .
Contestant 7 – Jonathan
DB2 LUW Load from Cursor
There are many load options and Jonathan wisely chose one to discuss so that he could finish his presentation on time. Another good presentation that was well laid out and easy to follow. The best slide was the last one where Jonathan gave a summary of the Load / Import options and under which conditions they should be used. One of the judges commented that many of his customers were using this option.
Extra Special Presentation – Klaas
DB2 LUW Prefect IO Configuration
This was a real presentation and a good one, at that. Klaas gave this primarily to show the contestants a well organized presentation, that is interesting and informative. If you are moving on, or if you simply want to improve your presentation skills, take a look at what Klaas did to get some ideas. The first thing I noticed and mentioned on the show is how appealing graphics are. I’m not sure if I would have said that before, but after today’s amazing 8 presentations I can say that the ones that captured my attention to the fullest were the ones that had graphics. And not complex graphics, rather simple ones that are make a connection to the technical material being discussed. Here’s a summary of the tips we gave over the past month:
The judges, Martin Hubel, Klaas Brant, and myself chose Ember, Brian and Jean to move onto the next round based on the relevance / uniqueness of their topic and the quality of their presentations. These three will join Richard, Douglas, Yonghang, Rodolpho, Kingo, Kholi, and Elder.
Congratulations to you all. We’re looking forward to more quality presentations from each of you.
Do you agree with our choices? So far, the survey selections have matched the judge’s selections. If you watch the replay, you’ll be able to fill in a survey to let us know if there is someone else who should also move on. Listen for the great tips and for advice on improving your presentation skills.
That’s it for the contestant presentations. March is reserved for the finals where those who have moved on will present a second time and the listeners can choose the winner rather than the judges. There are only 3 shows in March: 2, 16, and 30. If you get reminders for March 9 and 23, please ignore these reminders.
Thanks to host Scott Hayes for this opportunity for me as a judge and for the contestants for helping them build technical presentation skills that are so valuable.
For details on the prizes for this competition… and a summary of last year’s event… see my blog entry: http://ibm.co/AnZxb4
PS… If you are in the NY area, make sure you look into attending the DB2 Symposium that is taking place March 28-30 in this area. See DB2 Symposium for details. Today a special discount was announced: If you book by March 1, use the promo code DBI12A1 to get a 20% discount.
PSS…. If any other contestants tweet or blog, let me know and I’ll publicize you as well!
Just published: The Data Warehouse Mentor: Practical Data Warehouse and Business Intelligence Insights
Congratulations to Author Bob Laberge for publishing his first book:
by Robert Laberge
I’ve promoted this book since it was available as a pre-order and am very pleased with the interest in this book. I’ve had many views on my blog entry and many people when to amazon to order the book. I’ve been requesting reader feedback, so if you do read the book, we’d love to see your comments in a blog or on amazon. By the way, as of today, amazon’s pre-order price of 38% off the regular price is still active.
What’s in the Book?
In The Data Warehouse Mentor: Practical Data Warehouse and Business Intelligence Insights, business intelligence and data warehousing expert Robert Laberge explains the components and different alternatives in building a data warehouse and describes pros and cons for choosing one path over another. Building a data warehouse is unique for each organization but can be guided by the author’s years of knowledge obtained from working on many differing data warehouse and business intelligence environments in organizations around the world.
The book covers practical and technical aspects of current data warehouse and business intelligence issues with views on realistic solutions within the management and technical arenas. Data warehousing topics are first presented from a high-level overview to ensure the terminology and context is understood, and are then covered in deeper detail to clarify the specifics. These topics all pertain to data warehousing, business intelligence, and performance management.
The Data Warehouse Mentor
About the Author
Robert Laberge is a lead principle consultant for the IBM Industry Models and Assets Lab in Dublin which focuses on data warehousing and business intelligence solutions. He has helped more than 50 large organizations in 20 countries by mentoring, training, and demonstrating data warehouse and business intelligence solutions, including Target, Qwest, ING, Mayo Clinic, Canadian Tire, Shoppers Drug Mart, BMW, Korea Telecom, Scotiabank, Capital One, Reliance Infocomm, and Tata Group. Robert has a Masters of Business Administration from the University of Durham (UK) and has nearly 30 years of experience in IT.
Proven strategies for implementing the right data warehouse and business intelligence solutions for current and future business needs: order the book now!
There are a few new things that I'd like to tell you about the DB2 Certification Guides that you don't already know:
1) Judy Nall's book was the latest to publish and I've been told it is selling VERY well! I hope those who are purchasing the book are taking and passing exam 737 as a result!
2) Susan Lawson and Dan Luksetich are beginning to update their Certification Guide and hope to have the new version of the book to match the new exam by IDUG in May 2011.
3) Roger Sanders is in discussions with the publisher to create a V9.7 update to his very popular V9 Cert Guides.
To prepare yourself to pass the exams read through a previous blog entry that I did called Certification 101.
Buy or borrow a Study Guide related to the exam you are taking. These books are available electronically through Books 24x7 or Safari Books Online. The suggested books are:
DB2 9 Database Administration Certification Study Guide for Exam 732
DB2 9 Advanced Database Administration Certification Study Guide for Exam 734
DB2 9 Fundamentals Certification Study Guide
Note that all of these books were written by members of the exam development team and each chapter contains sample questions along with answers and explanations.
I'm not sure where to start today... yesterday was such a momentous day! Obama's inauguration speech inspired much hope around the world (remember, I'm a Canadian and wasn't able to vote).. I can almost feel the change happening around me!
IBM released their 4th quarter results... and guess what? They were fantastic! I'm sure there are lots of reasons for such results, but maybe a part had to do with the Smarter Planet initiative which... again is inspiring change in organizations world wide.
On a much smaller level... let me try to inspire some hope.. and perhaps change.
Craig Mullins recently blogged about Ten Tips for DBAs to Get a Raise based on the article DBAs: Get a Raise! 10 Tips for Success at Review Time by Bob Zurek. When reading the article, I realized that it isn't very difficult to achieve what Bob suggests, especially since my team works tirelessly at providing you the tools that you need.
1. Expand your knowledge beyond the “Big 3” commercial databases to include popular open source database systems.
OK... for starters.. do you know all the "Big 3" commercial databases? If you don't yet know DB2... the best place to start is the book Understanding DB2(R): Learning Visually with Examples (2nd Edition). If you do know all three and are looking for an open source database to learn... look into DB2 Express. Technically it isn't "open sourced", but it is free and easy to use.
2. Get certified.
Now this is an easy one! I've been encouraging people to get certified for nearly 10 years now! We have an excellent program that allows you to go very deep in a technical way. You'll find everything you need on our Training and Certification page. And don't forget the series of certification guides that we have published to help you deepen your skills and pass the exam. See a discussion of the books in the DB2 in Books group on ChannelDB2.
3. Learn about high availability, clustering, and replication.
I don't know of a recent book on replication... but you can learn more about high available with this book: High Availability Guide for DB2 by Chris Eaton and Enzo Cialini. And clustering with this book: DB2 9 for Linux, UNIX, and Windows Advanced Database Administration Certification by Roger Sanders and Dwaine Snow.
4. Enrich your database administration skills with expertise and experience in data security.
Ah... security... it keeps coming up, doesn't it? Here is the best book on the market to help you as a DBA figure out what you need to know: Understanding DB2 9 Security. Rebecca Bond, the lead author, is a DBA and a security expert. Learn from her and her many experiences, including Katrina.
5. Know about data quality and how to implement a data quality and auditing solution in conjunction with your database projects.
6. Drive the adoption of metadata management capabilities across the organization including establishing a metadata business glossary.
For both of these points, I would suggest the book Enterprise Master Data Management: An SOA Approach to Managing Core Information .
7. As a DBA, you might not be writing any application code, but you will need to become a SQL expert over time.
There are many resources available in this area. See my blog entry about SQL resources. Soon a book on pureXML will publish, so stay tuned.
8. Become a member of the customer advisory board of your company’s database vendor.
This item fits loosely in the category of joining a community. See my blog entry on several communities that you might wish to join. Also remember that those who do get involved could get rewarded via the IBM Data Champion Program.
9. Mentor other DBAs in your organization.
See this brand new book for some tips on mentoring: Intelligent Mentoring: How IBM Creates Value through People, Knowledge, and Relationships.
10. Dig into the topic of database analytics.
There are several choices, but my suggestions are the following:
Competing on Analytics by Tom Davenport Managing Your Business Data: From Chaos to Confidence by Maria Villar and Theresa Kushner
Also, I recently watched Baseline's Career Slideshow: 10 Hot IT Jobs for 2009. Again, I was pleasantly surprised to see that I am able to recommend books that may suit a few of these jobs.
1. Business Intelligent Experts
See these two books:
Competing on Analytics by Tom Davenport Managing Your Business Data: From Chaos to Confidence by Maria Villar and Theresa Kushner
5. Enterprise Architects
See this book:
Enterprise Master Data Management: An SOA Approach to Managing Core Information
6. ITIL Managers
Check out this book:
Implementing ITIL Change and Release Management by Larry Klosterboer
8. Security Architects
See this book:
Understanding DB2 9 Security
9. AJAX Developers
In the description for this job, they also mention XML Developers. There will be a book published this year specific to XML, but in the meantime, check out these resources listed in previous blog entries.
I wish you much success in this year of change!
svisser1 2700018UK9 Tags:  contest free db2 webinar education performance db2night_show 6,805 Views
I’ve promoted many, if not all, of the DB2Night Show episodes that took place in 2010. Scott Hayes, the host of these free webinars has produced a list of the most highly attended shows. All of these shows were recorded, so if you missed one or more, you can catch up.
#1 - Episode 21. DB2 LUW Locking with special guest Mike Winer from IBM
#2 - Episode 17 . DB2 LUW Performance Updates with special guest Berni Schiefer from IBM
#3 - Episode 28. DB2 LUW Range Partition Tables with Mike Winer from IBM. Mike congratulations for having two spots in the TOP 3!!
#4 - Episode 11. DB2 9.7 Optimizer Updates with special guest John Hornibrook from IBM
#5 - Episode 18. The Top 10 DB2 LUW Mistakes People Make with special guest Klaas Brant from KBCE.
#6 – Episode 29. DB2 LUW High Availability and Recovery Planning with special guests Kate Kurtz and Dale McInnis from IBM
#7 – Episode 13. DB2 LUW Compression Updates with special guest Paul Zikopoulos from IBM
#8 – Episode 12. DB2 Information Resources with yours truly….Susan Visser. Can’t believe I made the list!!
#9 – Episode 31. Valuable SQL Lessons Learned with special guest Sheryl Larsen from SMLSQL Inc.
#10 – Episode 10. DEAR IBM... Q&A with Senior Executives with special guests Sal Vella and Tim Vincent from IBM
Thanks Scott for pulling together such a valuable and well attended series of educational webinars!
I work in the Toronto Lab, so I’m very lucky to know all of the listed speakers personally. I’m constantly humbled by the high quality people I get to work with! Sheryl and Klaas I also personally know, but from my association with IDUG instead of IBM.
What’s up for 2011?
I’ll be a judge on the DB2 Night Show in February & March: DB2'S GOT TALENT CONTEST.
Join us on the following dates:
We’re looking for contestants…. are you up for it? Check the site for eligibility. Maybe this will convince you to become a contestant: the prizes!
I’m looking forward to a fun & rewarding new year and wish all the best for you and your families as well!
Two more best practices have recently been released for IBM Smart Analytics Systems. Thanks to Serge Boivin for this information!
This document describes IBM Smart Analytics Systems scenarios where DB2 software manages multiple database partitions in a cluster. The scenarios describe optimization methods that can help improve performance in a short time.
The two main tasks for query optimization are:
The key design goals of ingest application design are to balance the required rate of ingest with the availability of processing resources, to ingest data without affecting data availability, and to maintain flexibility in the volumes of data ingested. Identifying service level objectives for the speed and volume of data ingested into the data warehouse will determine the architecture, design, and development of the data ingest application.
See also my previous posts on Best Practices:
Today’s DB2Night Show featured the top 10 contestants who were chosen by the judges in February. They each had four minutes to impress the audience and replay listeners. That’s correct. This time the judges are giving feedback, but are not choosing the best competitor. I must say that I’m very glad I’m not choosing the best. If you were in the audience today or if you listen to the replay, you’ll see what I mean: All presenters were incredible Lots of learning happening today!
Here’s a summary:
The Fragmentation of DBADM
Noticed in DB2 9.7. DBADM is still a superuser of sorts, but there are granularities. SECADM and DATAACCESS authorities were added. Great presentation on the permissions for each user type. Great information presented in an educational fashion. AND, she finished in time.
Simple Steps for Substantially Reducing report execution time in a Data Warehouse Environment.
Great graphics, very clear description of the problem and how to fix it.
How to Configure an Efficient HA and DR on DB2 10.1
I like that the tradeoffs slide: puts the problem in perspective. Clear description of the solution. Seems like this could be a common problem that needs to be solved: good reasons to upgrade to V10!
Getting Siblings to Talk - Federating DB2 LUW and DB2 for i
Synchronized DB2 LUW on AIX to their legacy iseries system. Very good description on Federation and how it is set up.
My New Moving Vehicle DB2MOVE "With more POWER and Less Gas"
Lots of situations when you'd use DB2MOVE. Good description on what the command does, its options, actions and how to use them.
How do you work with Application Development to Ensure Performance
What do you do when performance problems arises after new features are added? Problem well defined and quantitative results shown.
SQL Performance Tuning using MQT Part 2
Interesting scenario created to define problem and how it was analyzed and solved using MQT. And... he spelled cheque correctly! Way to go!
Temporal Data Management in DB2 for z/OS
Good definitions and contrast between snapshot and temporal. Lots of details in the scenario that shows the problem and how it is solved. The topic was too large to complete in time.
DML = Data Manipulation Scanner. Great presentation style. I like how different approaches were discussed with pros & cons. Good use of examples and sample code.
The 8 Selects that All DBAs Want to Have
Unfortunately Juliano did not show up today. So without Juliano, we had 9 great presentations today.
Who was the best? Listen to the replay and VOTE. Remember if you complete the survey at the end of the replay, you’ll have a chance to win an amazon.com gift certificate.
Thanks to all the presenters for your hard work on creating these great presentations.
Judges present on the DB2Night Show "DB2's Got Talent" Competition
DB2 NightShow: Episode 3 of the DB2's Got Talent Competition
DB2 NightShow's 2013 DB2's Talent Competition
Promote yourself and DB2 with the help of my slides in SlideShare. Here’s where you can get them: Db2 night social_promoting_susan.
svisser1 2700018UK9 6,795 Views
Download and read the whole book, for FREE:
Paul Zikopoulos, Matthew Huras, George Baklarz, Sam Lightstone, Aamer Sachedina
Technical editor: Roman B. Melnyk
DB2 10.5 delivers one of the most game-changing technologies ever produced by IBM, called IBM BLU Acceleration, plus much more! At nearly 200 pages long, this book offers insight and education into some of the most noteworthy features any database management professional would want to know about. It will inspire thought, and a thirst to gain first hand experience with the features that are described. Upon reading this book, you'll learn more about the key advantages delivered in DB2, including:
Keep in the loop for all new content related to BLU as it is published by following us on these social channels:
I’ve often blogged about the best practice papers that are published in relation to IBM IM products. There has been such great feedback to these papers, that there is now a dedicated portal for Best Practices.
From this portal, you’ll be able to find best practices concerning these product groups:
Visit the new IM best practices community portal often to find a wealth of practical expert advice for your business success. More papers are being added regularly, so become a member of the community to ensure that you won't’ miss a single paper.
The portal connects you to best practice communities for a variety of IBM Information Management products.The best practice papers, technical presentations, and videos published in each community cover a wide range of topics to help you plan, design, implement, tune, and monitor your solutions so they perform at their best in your environments, potentially saving you time and resources. The best practices are written and tested by IBM technical experts who work in the development and quality assurance teams that created the product features, and who work with customers like you to determine the best ways to efficiently use Information Management products in real world environments.
Some of the topic areas you’ll find:
Thanks to Serge Boivin for providing me with this information.
Last year at the IOD Conference, one of the more popular events was handing out printed copies of the IBM Redbooks for Cognos 10. There were a limited number of copies that we had to hand out, and we went through them very quickly. Many other people came and left empty-handed, unfortunately. I pointed out that the book was available for free online at the ibm.com/redbooks site. Clearly there are many people who still prefer to have printed copies!
This year at the IBM Information on Demand 2011 Conference, we’re announcing up front which IBM Redbooks we’ll be handing out, and when. Make sure that if you want one of these books that you come to the Conference Bookstore at the planned times to get your copy. If you miss it, you miss it… but can get the content online!
Get one of the limited copies… and meet the author team behind the book. Maybe you can even find out how you can become an author of an IBM Redbooks.
Monday October 24 from 10:45 – 12:30 p
IBM Production Imaging Edition and Datacap Taskmaster
Metadata Management with IBM InfoSphere Information Server
Tuesday October 25 from 3:00 – 4:00 p
IBM Redbooks DB2 10 for z/OS Performance Topics
Wednesday October 26 from 11:30 – 1:30 p
IBM InfoSphere Streams and the Streams Processing Language
IBM solidDB: Delivering Data with Extreme Speed
The Conference bookstore will be a busy place this year. Here are the other signings and giveaways that are taking place at the event:
Keep this in mind as you build your schedule for the conference. Note, soon I’ll have session numbers for all of these events where you can add them to your SmartSite schedule.
If you are a developer or DBA and are interested in DB2, take this opportunity to preview emerging technologies that are still in the lab.
IBM wants to collaborate with you early in technology conception, prototyping, and iterative development cycles. These technologies may or may not be aligned with announced products. The features or technologies in the download do not represent a commitment or obligation on the part of IBM.
Check it out!!
How it works:
NOTE: The recommendation for using the preview technology is with an 8 core, 64 GB machine, which necessitates the use of a VMware workstation.
I hope you enjoy being the first to try this new technology! We’re looking forward to seeing your feedback!
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.
Beginning tomorrow you can participate in IOD virtual sessions... from your desk... for free.... whether you attended the conference in person or not. Personally I love attending these virtual conferences and have a good headset and mic to get the most out of the experience.
Which sessions should you choose? There have been many blog entries describing the sessions that took place, so take advantage of this information and choose the sessions that you most want to see. My recommendation is the Malcolm Gladwell session. He only spoke for half an hour, which is my only complaint! I could listen to his stories for hours, so I hope that in the future he is invited back to speak at the conference, but is given a large time period.
Malcolm's session is playing tomorrow... Tuesday Nov 10 at 11 EST. Don't miss it!
Register for this complimentary event and share with colleagues who did not attend this year’s live conference.
At the Information On Demand Virtual experience, you will learn how you can:
- Transform data into a trusted strategic asset using an information agenda
- Improve business performance with data analytics and optimization techniques
- Accelerate information intensive projects for immediate ROI
Date: November 10, 2009
Time: 8:00 am Pacific Time
Register now for the Information On Demand Virtual experience at
For advice on what to attend, read these blogs:
There are more... but that's a good start!
I'm not sure how many people from the z/OS platform will read this BLOG, but since this is one of the many products I support in terms of skills, I'll add it here. I still find our z/OS certification program to be a well kept secret, so if you know people who support this platform, do them a favour and tell them about it!
To get certified as a Database Administrator for DB2 on z/OS, you must pass two exams:
Exam 700 DB2 V8.1 Family Fundamentals, and
Exam 702 DB2 V8.1 for z/OS Database Administration.
To prepare for Exam 700, you have a choice of several books, but I'd recommend one of the two:
The Official Introduction to DB2 for z/OS: covers DB2 Universal Database Version 8.1 for z/OS
by Susan Sloan
DB2 UDB V8.1 Certification Test 700 Study Guide
by Roger Sanders
If you have already passed the DB2 V7 Family Fundamentals, Exam 512, then you do NOT need to retake Exam 700. These exams are considered equivalent. Of course, you may take the V8 exam if you want to ensure that you understand all the Version 8 features.
Besides the books, the following tutorials are available to prepare for Exam 700:
DB2 UDB V8 Family Fundamentals Preparation
This series of six tutorials is designed to help you prepare for the DB2 Version 8 Family Fundamentals Exam 700 to attain the certification, IBM Certified Database Associate DB2 Universal Database V8.1 Family. You can link to all the free tutorials from http://www.ibm.com/software/data/education/selfstudy.html#2.
In my experience, many z/OS people are not very fond of Exam 700 since it includes some questions that are true for all platforms that look to be specific for the Linux, UNIX or Windows platforms. It is also my observation that people trained on z/OS do VERY well on this exam. The exam covers SQL, Security, and Concurrency, so pretty basic material.
To prepare for Exam 702, the book that is recommended is:
DB2 Universal Database for z/OS V8.1 DBA Certification Guide
by Susan Lawson
There are several other books that are available for the z/OS platform, but I'll discuss those in another post.
IBM Press Program Manager
The postings on this site are my own and don't necessarily represent IBM positions, strategies or opinions.
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:
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?