Keep on Learning
A total of 19 Technical Education sessions are being offered at the IOD conference on Sunday October 14 in Las Vegas. The sessions are spread across the following segments:
Information Platform & Solutions (3)Enterprise Content Management (3)Data Servers (12)Support (1)
The fee for these classes is set at $399.00 which is the same price as offered at last year's conference.
I've listed most of the available sessions in this entry. Click on the link to see the list and to register for the class.
Successfully Transitioning with DB2 9 for z/OSConsidering an implementation of DB2 9 for z/OS? Then you won't want to miss this 1-day course. Designed to provide you with technical information on the new features, you'll learn what's required for a successful implementation. 9:00 AM / 4:30 PM Mark Wilson
Spotlight on IDS 11 - Transition TopicsThe newest addition to the Informix Dynamic Server family, IDS 11 boasts a wealth of new functions and features. This 1-day course will take a deep dive into the technical information behind these features, providing a better understanding of and ensuring a smooth transition to this new product. 9:00 AM / 4:30 PM Jeff Bohm**
DB2 9 for Linux, UNIX, and Windows DBA Certification Crammer (Exam 731)This high level certification preparation review is intended to help you take IBM Certification Test 731. Gain an intense overall review of those areas that are on the certification exams. 9:00 AM / 4:30 PM Bob Schwan **
DB2 9 for z/OS DBA Certification Crammer (Exam 732) This high level certification preparation review is intended to help you take IBM Certification Test 732. Gain an intense overall review of those areas that are on the certification exams. 9:00 AM / 4:30 PM Susan Lawson
DB2 9 Fundamentals Certification Crammer (Exam 730) This high level certification preparation review is intended to help you take IBM Certification Test 730. Gain an intense overall review of those areas that are on the certification exams. 9:00 AM / 4:30 PM Roger Archambault **
Getting to Know DB2 WarehouseThis 1-day course is a must for those wanting to understand the components of DB2 Warehouse. Topics for the class include an overview on the SQL Warehouse Tool, DB2 Intelligent Miner, Cube Views, and their common interface, the Design Studio. 9:00 AM / 4:30 PM Warren Pettit
Preparation is Key: DB2 9 for Linux, UNIX, and Windows Advanced Recovery TopicsRecovery is top of mind for many businesses today. In this 1-day lecture you'll gain a deeper understanding of how DB2 9 for Linux, UNIX, and Windows addresses the issue with its many advanced recovery features. Topics may include recovery log management, dropped table recovery, table space recovery, crash recovery, disaster recovery, incremental backup & recovery, redirected restore, and additional recovery facilities. 9:00 AM / 4:30 PM Melanie Stopfer**
Unleash the Knowledge: An Introduction to Data Sharing Learn the basic purpose, justification, and planning considerations for employing DB2 data sharing in your enterprise IT system. This 1-day class will also cover the basic knowledge of the architecture and major components of DB2 data sharing and provide an overview of the steps to implement a DB2 data sharing environment. 9:00 AM / 4:30 PM Wayne Cope
Informix Dynamic Server System Administration - A Beginner's LookThis 1-day class will enable you to develop the skills necessary to successfully administer one or more database servers. You will learn how to configure and initialize a database server instance, configure and test client connectivity, configure and manage memory and disk usage, plan and implement system maintenance tasks, and configure the server for optimal Online Transaction Processing (OLTP) or decision support. 9:00 AM / 4:30 PM John Zucchero
Maximize Your Optimizer: A Guide to DB2 9 for Linux, UNIX, and Windows OptimizerThis 1-day class will enable users to understand optimizer's decision making process, influence optimizer decisions, identify problems from optimizer access plans and most importantly, fix them. By the end of this 1-day course, participants should be able to leverage fully DB2 optimizer for best query performance. 9:00 AM / 4:30 PM Yasir Warraich
Architecting the Dynamic Warehouse - a How to Guide Are you interested in dynamic warehouses but don't know the first thing about how to build one? This 1-day class is your answer. The course offers practical methods and techniques for designing and constructing a dynamic warehouse. Whether you intend to create one or just want to learn more, this class will broaden your understanding of the data warehouse 9:00 AM / 4:30 PM Joe Cullen
Behind the XML Buzz: Querying & Using XML with DB2 9Much noise has been made about the XML features in DB2 9 and this 1-day class will show you why. The course introduces participants to XML found in DB2 9 for LUW and provides a lightening tour of the fundamentals. From XPath/XQuery to defining/building indexes on XML data to sophisticated queries using combinations of SQL and XML data, you won't want to miss this engaging look at one of DB2 9's most popular components. 9:00 AM / 4:30 PM Glen Mules
None of the sessions are full at this point, but demand is increasing. If you are interested in attending one of these sessions, be sure to register soon.
Roger Sanders' latest book DB2 9 Fundamentals Certification Study Guide continues to sell extremely well... and has received 6 customer reviews on amazon.com.... all rated 5 stars! What are people saying? Click the link above to see all the customer reviews (or to add your own if you own the book :)
The ITSO sends out lists of the most popular IBM Redbooks each month, in terms of the number of downloads. The list covers all IBM Redbooks, across all product areas. This past month, there were 2 DB2 book in the top 10 list:
* DB2 9 for z/OS Technical Overview* Up and Running with DB2 for Linux
Congratulations to all authors!
I hope you'll be able to find this book: DB2 9 Fundamentals Certification Study Guide in actual bookstores... but if not, check out amazon.com. Today they put the book on sale with a 37% discount!
Today I received my copies of the book. They look amazing. The most unique thing about the book is the large number of sample questions. Each chapter has several study questions along with reasons why the correct answer is the right one. Each of these study questions are repeated in Appendix B... and take up 105 pages of the book. By far the most complete study guide for a DB2 exam that has ever been produced.
This book prepares you to pass the DB2 9 Fundamentals Exam (730). Roger is working on the second book in the series and has plans for a third book as well.
Last Tuesday, IBM announced the availability of DB2 9 for z/OS and the reception has been red hot!
From the press release: DB2 9 promises to provide users of System z with advanced security, superior data compression, enhanced disaster recovery and reduced system administration costs. DB2 9 for z/OS brings advancements to the mainframe that include patented pureXML™ technology as well as the ability to manage both relational and XML information within the same database.
Related to this, the newest V9 certifications are arriving:
DB2 9 Fundamentals Exam 730 is currently available and by passing, you'll validate that you have acquired V9 skills at a database associate level. To study for this exam, I recommend the DB2 9 Fundamentals certification 730 prep series. Ensure that you are fully prepared by taking a professional certification on-line assessment exam. Roger Sanders is updating his extremely popular study guide and it will be available for purchase in May. I'll post information about the book as soon as it is available for you to pre-order.
Also coming soon is Exam 732: Database Administration for DB2 9 z/OS. Susan Lawson is working on an update to her study guide as well and hopes to have it published in July. Keep visiting my blog and I'll let you know as everything becomes available.
Many of us are unable to take the time to go to a conference for a week to build our skills. If you would like to go to a face-to-face event to learn about a new product or technology with taking the time or expense of a full conference, see if there is a technical briefing planned for your city.
As an example, you may wish to consider attending the following technical briefing: Experience the power of Information Management solutions
This is a half-day briefing that covers the following:
* Learn how DB2 9 can help you reduce costs and improve service levels.
* Learn about DB2 9 enhancements for working with SAP.
* See how Information Management software integrates data better than other vendors.
* Gain an understanding of how the new IBM data server can unlock the latent potential of XML with performance and development savings.
* See how "Information as a Service" delivers business information accurately, consistently, timely, and coherently across disparate operating systems, applications and legacy systems.
* Learn how IBM solutions can break down information silos by connecting product, location, trading partner, organization, and terms of trade seamlessly across the Web, intranets, collaboration workspaces, file shares, and content management systems.
* Minimize the total cost of ownership by implementing a solution that provides pre-built, secure integrations to Lotus Domino, WebSphere Portal, FileNet, Documentum, and Open text. Mitigate the risk of exposing content by delivering a highly secure search experience. During this briefing, you'll see demos for:
* DB2® 9 * DB2 9 Development Center and pureXML™ * IBM Information Server (including WebSphere QualityStage, WebSphere DataStage, and WebSphere Federation Server) * Dynamic Warehousing Solutions -- DB2 Data Warehouse Edition & Alphablox * IBM OmniFind
Note: Click on Select location and register to find where and when this technical briefing is taking place.
The SOA Compass book continues to be a fast moving book. Have you had a chance to look at it yet? To download one of the chapters, see http://www.ibmpressbooks.com/bookstore/product.asp?isbn=0131870025&rl=1 This site also contains many customer reactions to the book such as this one:
"Service-Oriented Architecture offers a pathway tonetworking of intra- and inter-corporate business systems.The standards have the potential to create far more flexibleand resilient business information systems than have beenpossible in the past. This book is a must-read for those whocare about the future of business IT." –Elizabeth Hackenson,CIO, MCI
If you have access to Books 24x7 or Safari, you should be able to read this book entirely or in part electronically.
The second edition of the Information Management Professional Certification Newsletter is now available:http://www.ibm.com/software/data/education/cert-newsletter.html.
In this edition, find out about the certifications that are currently under development and when they are expected to be live. You'll see a list of the events where certifications are being offered for free or at a reduced price. Also, you'll have links to the latest white papers and offers.
Have you ever used an online book engine such as Safari or Books 24x7? Both Safari and Books 24x7 are online book engines that give you access to thousands of retail books. These engines are quite powerful and very suitable in today's electronic world. IBM Press books are now available in both engines.
Safari is an online book engine that is jointly owned by Pearson and O'Reilly. All books that are published by these publishers are automatically formatted for Safari and made available to anyone who has a subscription to Safari. If you have a subscription, you can read the entire book electronically, search for a keyword across the entire library or a subset of the library, bookmark well-used pages in the books you've read, make notes for your co-workers who also have subscriptions, download chapters to print or read offline, or copy code directly from the book into your programs. You can sign up for a 2-week trial from http://safari.informit.com/. Monthly subscription rates can be as low as $19.99 depending on the number of books you choose for your bookshelf.
Books 24x7 has all the same features as Safari, but a slightly different set of books. Books 24x7 is a direct competitor to Safari and as such, typically carry only the books published outside of Pearson or O'Reilly. Exceptions are made when Books 24x7 buys the electronic rights to use a Pearson or O'Reilly book. This was an arrangement that was made for the IBM Press books that are published through Pearson. You can get further information about the subscription details and prices from http://www.books24x7.com.
IBM employees have a paid subscription to Books 24x7 and you can sign up to use it through this internal site: http://w3.ibm.com/education.
I've used Books 24x7 to review books and table of contents, searched for specific topics in a set of books, but one of the key benefits is their newsletter. At least every week I'm sent a note telling me about the new books that are available on the engine. I end up seeing titles that are very interesting and useful that I wouldn't have known about without this newsletter! Another thing that I've recently discovered is that some of the books have a mp3 teaser available that allows you to listen to someone reading part of the book to you. This is great for commuters or for anyone who wants a break from reading!
Let me know if you've tried these engines and if you see benefits to using them.
IBM Press Program Manager
The postings on this site are my own and don't necessarily represent IBM positions, strategies or opinions.[Read More]
Can you think of an industry that is changing more drastically than publishing is at this time? More books are now being sold for devices such as Kindle than printed books. There are so many Kindle-like book readers available that it is pretty difficult to name them all. I’m not sure if “books on tape” or audible forms of books were popular in the past, but I’ve personally become a huge fan and am listening to about half the books I consume in a year.
Another big change is the movement away from large books. Remember when the technical books you used to purchase were at least 2 inches thick? These types of books are not selling well now… nor are publishers eager to get into such a venture.
But, what is one to do when the topic is huge and deserves a large number of pages to cover it effectively? Take a look at what publisher MC Press has decided to do with the certification study guide by Susan Lawson and Dan Luksetich: “DB2 10 for z/OS Database Administration (Exam 612)”:
Purchase individual chapters in electronic format as needed. The chapters are priced from $2.99 to $9.99 (depending on length).
This link takes you to the “Database & Data Management” category on the MC Press ebook site. When you scroll down, you’ll see the individual chapters for sale, followed by the entire book item.
Let me know what you think of this offering. I am working on having other books made available in the same way.
Here is the master list of current and upcoming books for DB2 on Linux, Unix and Windows. Updates will be made to this page as books are published, so bookmark this page and come back often.
As usual, IBM Champions are well represented at IDUG this year. Gain knowledge from this group of talented and hardworking people, who I consider IBM’s best friends!
I’ve done my best to pull out all the sessions that IBM Champions are taking part in at the
April 29th - May 3rd, 2013
If I missed any, please let me know and I’ll update this entry.
Monday April 29 - Full Day Educational Seminars
Tuesday April 30: Technical Sessions
Wednesday May 1: Technical Sessions
Thursday May 2: Technical Sessions
Friday May 3: Technical Sessions
A very popular item on the developerWorks site is the series of Certification Tutorials. The V10 Tutorials are starting to be published now. We were hoping to have them all done by the end of September, but it didn’t happen.
I’m very happy with the quality of the tutorials that we are getting and I hope you find them very helpful while preparing to pass for your exam. Many thanks to the authors who found the time in their regular life to put these together. It wasn’t easy for any of them, but an achievement to be very proud of!
I’ll post here as others are published.
Updated Nov 1 with Part 5.
DB2 10.1 fundamentals certification exam 610 prep, Part 1: Planning
Norberto Gasparotto Filho, Database specialist, IBM
Summary: This tutorial introduces you to the basics of the IBM® DB2® 10.1 product editions, functionalities and tools, along with underlying concepts that describe different types of data applications such as OLTP, data warehousing / OLAP, non-relational concepts and more. It will briefly introduce you to many of the concepts you'll see in the other tutorials in this series, helping you to prepare for the DB2 10.1 Fundamentals certification test 610.
DB2 10.1 fundamentals certification exam 610 prep, Part 3: Working with databases and database objects
Gerald Kupris, Solution Migration Specialist, IBM
Summary: This tutorial shows you the basic steps and requirements to create and connect to a database in DB2® 10.1. This tutorial also introduces you to the objects that make up a DB2 database, as well as how to create and manipulate them. This tutorial is third of a series of six "DB2 10.1 fundamentals certification exam 610 prep" tutorials that will help prepare you for the DB2 10.1 fundamentals certification exam 610.
DB2 10.1 Fundamentals certification exam 610 prep: Part 5: Working with tables, views, and indexes
Summary: This tutorial discusses IBM DB2 10.1 support for data types, tables, views, triggers, constraints and indexes. It explains the features of these objects, how to create and manipulate them using Structured Query Language (SQL), and how they can be used in an application. This tutorial is the fifth in a series that you can use to help prepare for the DB2 10.1 Fundamentals certification exam 610.
Roger E. Sanders, Senior Consultant Corporate Systems Engineer, EMC Corporation
This tutorial is designed to introduce you to the concept of data consistency and to the mechanisms DB2 uses to maintain data consistency in both single- and multi-user database environments. This tutorial will also help you prepare for Section 6 of the DB2 10.1 Fundamentals certification exam (Exam 610).
I have a few other blog entries about Certification that I recommend:
Certification Offer: Assess & Save, until Dec 14, 2012
Three DB210 for LUW Certification Exams are now available
A new way to study for DB2 Certifications
Get Certified at the IBM Information on Demand Conference
How to Prepare to Pass a DB2 Certification Exam?
DB2 10 for z/OS Certification Roles, Exams and Study Materials
Certification Study Guides for DB2 LUW Exams
DB2 9.7 for Linux, UNIX and Windows: Certification Roles and Exams
Certifications: Beyond DB2
Certification Tips on the DB2Night Show
Web-based Training Courses to Consider
The largest data warehouse resides at the IBM Technology Campus in Dublin, Ireland and contains 3 petabyte (3,000 terabytes) of raw data. The software is IBM - DB2 Information Management and the official date of the record is January 18, 2012.
According to wikipedia:
A petabyte (derived from the SI prefix peta- ) is a unit of information equal to one quadrillion (short scale) bytes, or 1 billiard (long scale) bytes. The unit symbol for the petabyte is PB. The prefix peta (P) indicates the fifth power to 1000:
According to Gizmodo:
How Large Is a Petabyte?
13.3 years of HDTV content. That's approximately 58,292 movies, which means an equal number of large pizzas. So one petabyte equals 52 tonnes of pepperoni pizza. Yes, my head has assploded. For other equivalents, click and zoom in.
How big are 20 million four-drawer cabinets? As big as the Sears Tower? I have a hard time visualizing that. Strangely enough, I don't have any problem visualizing 52 tonnes of pepperoni pizza.
With the amount of data that is being collected and analyzed these days, I expect this record to be broken sooner than imaginable!
After a long delay, I can finally announce that this long awaited book has published.
DB2 10 for z/OS Database Administration: Certification Study
by IBM Champions Susan Lawson and Daniel Luksetich
I can also tell you that the covers for the certification series of books by MC Press have been redesigned and will be launched on this title. I hope you like the new design.
What’s in the book?
DB2 10 for z/OS Database Administration: Certification Study Guide is
the definitive guide to preparing for IBM’s Certification Exam 612: DB2 10 for
z/OS Database Administration. This book provides a comprehensive review of all
the topics covered on the exam and introduces you to important new features
found in DB2 10 for z/OS.
Written by two industry experts who were members of the team that created the
612 exam, this book guides you through all the areas you need to know about to
pass the exam: Database Design and Implementation, Operation and Recovery,
Security and Auditing, Performance, and Installation and Migration/Upgrade.
With DB2 10 for z/OS Database Administration: Certification Study Guide, you will:
While the book does cover all topics on the test, it also covers much more than that. It covers the new features of DB2 10 for both database and application development.
What do you need to know to pass the exam?
This is an outline of the Exam Objectives that this book covers:
Section 1 - Database Design and Implementation (30.5%)
Section 2 - Operation and Recovery (29%)
Section 3 - Security and Auditing (7%)
Section 4 - Performance (29%)
Section 5 - Installation and Migration/Upgrade(4.5%)
About the Authors:
Susan Lawson is an internationally recognized consultant and
lecturer with a background in system and database administration. She currently
works with several large clients to help develop, implement, and tune some of
the world’s largest and most complex DB2 databases and applications. Susan also
conducts performance and availability audits to help clients reduce costs
through proper performance tuning and ensure availability. She also writes
articles and white papers, presents at user group meetings, and teaches a
variety of DB2 courses. Susan is an IBM GOLD Consultant for DB2 and System z and
an IBM Champion.
Daniel Luksetich is a DB2 database professional with more than 26 years of experience in high-performance design and tuning of very large databases and highly available, high-volume database applications. He also teaches DB2 courses and has authored books, guides, whitepapers, and magazine articles. Working as a DB2 application architect, Dan has been involved in several very large DB2 application designs. An IBM Champion, Dan specializes in DB2 for z/OS but has worked with DB2 on a variety of platforms. His specialties include performance audits, SQL education, backup and recovery, stored procedures, UDFs, triggers, application design, high-availability design, and DB2 high performance.
PS, for all my z/OS friends, check out this new BLOG that focuses on technical information that will interest you: DB2 for z/OS Exchange Forum
The next Chat with the Lab takes place next Thursday, Jan 26 from 12:30 – 2:00 pm. Join Rav Ahuja and Bill Minor (DB2 Tooling Development Team) for a discussion about Advanced Recovery Solutions.
Date: Thurs, Jan 26, 2012
Time: 12:30-2:00 PM Eastern / 11:30 AM Central / 9:30 AM Pacific / 17:30hrs London / 18:30hrs Frankfurt, Paris / India 11 PM
The availability and integrity of data is critical to the business enterprise. When a problem occurs and your data is compromised or unavailable, it is paramount to be able to recover from such an 'outage' as quickly as possible. Equally important, is the ability to recover efficiently by quickly identifying recovery assets and minimizing the recovery scope, required resources and effort. This session will explore in detail the Advanced Recovery Solutions for DB2 LUW. The solutions are comprised of the Recovery Expert, Merge Backup and High Performance Unload tools. The Advanced Recovery Solutions for DB2 LUW provide unique capabilities for changed data analysis, elimination of physical or logical data errors and maximizing data availability. We will examine in detail the features these solutions present and demonstrate, through realistic user scenarios, the business value that can be gained by complementing and extending your data management and recovery strategies with these tools.
DB2 Chat with the Lab is a free webinar series from the IBM labs.
The chat is recorded and available for replay. Here are some previous chats you may be interested in:
For more information, see the DB2Channel.com page for DB2Chats.
SusanChat with the Lab: Advanced Recovery Solutions for DB2 LUW