Keep on Learning
The DB2 Chat with the Lab series continues. Listen to the DB2 experts, including Sal Vella, Drew Bradstock, Chris Eaton, Pat Bates, Paul Bird, Bill Minor, John Hornibrook, and Les King who develop breakthrough technology and get your questions answered.
Here are some of the topics that you can find:
* DB2 Warehouse 9.5 - What's New in the Platform for High Performance DB2 Analytics* Workload Management in Viper 2* Deep Dive into Deep Compression - a look into Compression in Viper and Viper 2* DB2 for LUW Security Enhancements: Making Database Security Management and Compliance Easier* Viper 2 Features and Open Beta Program* Webcast: Premiering DB2 Express-C: The Truly Free Database* Improved Query Optimization with Statistical Views* Beyond DB2 Viper - Technology Trends and Directions
New chats are added all the time, so keep watching for chats that you can take part in live.
Happy New Year! I hope you enjoyed a well-deserved break and have lots of momentum for the coming year! I have many things that I could blog about today, but I think this is likely the best thing for the start of the year.
On Wednesday, January 9, IDUG and CA are delivering a FREE webcast. This sounds like a perfect way to begin the year!
Free Technical Webcast: DB2 Prerequisites, Migrations and DeprecationsWednesday, January 9, 11 a.m. ET
IDUG is pleased to partner with CA to deliver a free Webcast by renowned presenter Phil Grainger, CA Product Management Director. This live event will run approximately 60 minutes and participants will have the opportunity to pose questions to the presenter. Capacity is limited, so register early.
About the Webcast:Moving from one DB2 version to another is a monumental task that takes careful planning and execution to achieve a successful result. This initial offering in the IDUG/CA co-sponsored DB2 9 for z/OS Webcast Series, looks at the announcements from IBM, the pre-requisites for installing and/or migrating to DB2 9, and provides some insight on the migration process itself. This session will conclude with an updated review of V9 features different from previous releases.
About the Presenter:Phil Grainger, Product Management Director, CA, has more than 17 years experience with DB2, starting in 1987 with DB2 Version 1.2. Since then he has worked with all versions, including Version 8. Beginning as a DBA for one of the largest users of DB2 in the UK, Phil moved to PLATINUM technology and then to his present role as Product Management Director for CA. Phil has always been a keen supporter of user groups and is a regular speaker at CA events, as well as independent industry events. He currently serves as the CA representative on the European IDUG Planning Committee, and is a regular contributor to the IDUG sponsored DB2-L discussion list.
Webcast Schedule (USA time zones):Wednesday, January 9, at 11:00 a.m. ET (10 a.m. CT, 8:00 a.m. PT). To register: Click here!
A replay of this Webcast will be available for a short period of time after January 9th. Look for future announcements for direction on how to access the pre-recorded Webcast.
IDUG is pleased to sponsor this free distance learning opportunity. Questions about the Webcast can be directed to firstname.lastname@example.org. Please make plans to attend other IDUG 2008 educational events, including: North American Conference, May 18-22 in Dallas, Texas. For more information and to register, go to http://www.idug.org/, and click on 'Conferences.'
The IBM Education Pack can be used to attend IBM Technical conferences, such as
Lotusphere 2008 - Orlando, Florida, USAImpact 2008 - Las Vegas, NVAutomated Operations Technical Council - New Orleans, Louisiana, USAIBM Pulse 2008 (a new Tivoli Technical User Conference) - Orlando, Florida, USAIBM Rational Software Development Conference 2008 - Orlando, Florida, USAIBM System System Storage and Storage Networking Symposium - San Diego, California, USAIBM System x & BladeCenter Technical Conference - San Diego, California, USAIBM System z Expo - Las Vegas, Nevada, USAIBM Information On Demand 2008 - Las Vegas, Nevada, USA
IBM Education Pack - online account overview
The IBM Education Pack - online account is an electronic debit system which you fund and use to pay for designated IBM Training offerings. It is ideal for companies that need to train multiple employees on limited budgets.
Q: What is the Education Pack – online account? A: The IBM Education Pack – online account is a convenient way for customers to purchase IBM Training offerings. The Education Pack – online account an electronic account that you can use to purchase IBM Training’s public or onsite class offerings and IBM Technical Conferences in the U.S. You may also purchase IBM Self-Paced Virtual Classes with this account. Q: How does it work? A: The IBM Education Pack – online account functions as an electronic debit account, funded with training dollars you designate for IBM Training offerings. The account can be funded in values of $2,500, $5,000, $10,000,$15,000 and $25,000. The account can also be funded in precise $100 increments with a minimum $1,000 account value. Q: What discounts do I get when I purchase my account in $100 increments? A: When you purchase training with the IBM Education Pack – online account in $100 increment , you receive a discount of up to 10% off the retail cost of IBM training. You receive:
· Values of $1,000-$4,900 at $95 per increment (5% discount)· Values of $5,000-$9,900 at $92 per increment (8% discount)· Values of $10,000 or more at $90 per increment (10% discount) Q: What is the minimum IBM Education Pack -online account I can purchase? A: A minimum $1,000 value IBM Education Pack - online account is required to receive a discount. Q: How do the IBM Education Pack - online account pre-set values save me money? A: When you purchase training with the IBM Education Pack – online account, you receive a discount of up to 10% off the retail cost of IBM training. You receive:
· $2,500 value for retail price of $2,375· $5,000 value for retail price of $4,595· $10,000 value for retail price of $8,995· $15,000 value for retail price of $13,500· $25,000 value for retail price of $22,500 Q: Can the IBM Education Pack – online account be used by more than one person in my company? A: Yes. The funds in the account can be used to purchase training from IBM for any employee in the company. Q: How do I purchase an IBM Education Pack – online account? A: There are two ways to purchase an IBM Education Pack – online account:
· On the IBM Training Web site, or· Through your authorized IBM Business Partner Q: When does the IBM Education Pack – online account start and expire? A: Your account is activated the day IBM Training receives the application and billing information, unless an alternate start date is provided at the time the application is submitted. A start date of up to 60 days from the date of the application may be selected if indicated on the order form. The IBM Education Pack – online account will expire 12 months from the activation date. Q: What denominations can I use from my IBM Education Pack – online account? A: That’s one of the great features of the IBM Education Pack - online account! It’s not limited by specific denominations. The IBM Education Pack – online account lets you debit your account with a voucher for the exact amount of training dollars that you want to spend. Q: What is an IBM Education Pack – online account voucher? A: The IBM Education Pack – online account voucher is your online transaction record that is applied against your purchase. Q: Do I have to take the IBM Education Pack – online account voucher with me to class? A: No. You create and submit an online voucher to IBM through your IBM Education Pack – online account.
Special OfferFrom October 9, 2007 – February 15, 2008, save up to $10,000!
Now, during our score more savings event, when you purchase $25,000 worth of training in an IBM Education Pack – online account, you pay only $22,500 and receive an additional $2,000 worth of training posted to your account. That’s $27,000 worth of training for just $22,500!
When you purchase $50,000 worth of training for just $45,000, you’ll also score an extra $5,000 in training dollars! That’s $55,000 worth of training for just $45,000!
Susan PS. Be sure to check out PlanetDB2.com if you haven't already done so.[Read More]
With the summer holidays coming to an end (sad).... and school about to start for a good portion of the population... it seems like the right time to give you a summary of all the IM books we've published this year so far... and those that are coming very soon.
I'm very proud of the number of books and the breadth of content that we covered this year... with quite a few more still on their way! I hope you are able to find one or two books that match your needs perfectly!
Understanding DB2 9 Security (IBM Press) by Rebecca Bond, Kevin Yeung-Kuen See (IBM), Carmen Ka Man Wong (IBM), Yuk-Kuen Henry Chan (IBM). Promotion: Q&A with Rebecca Bond.
IBM DB2 9 New Features (McGraw-Hill) by Paul Zikopoulos, George Baklarz, Leon Katsnelson, Chris Eaton (all IBM)
DB2 9 Fundamentals Certification Study Guide (MC Press) by Roger Sanders
IBM Informix Dynamic Server 11, the Next Generation in OLTP Data Server Technology (MC Press) by Carlton Doe (IBM)Distributed by IBM at selected events.
Physical Database Design: the database professional's guide to exploiting indexes, views, storage, and more (Morgan Kaufmann) by Sam Lightstone (IBM), Toby J. Teorey, Tom Nadeau Published March 21, 2007 and covers DB2, Oracle, SQL Server, and other databases
Mining the Talk: Unlocking the Business Value in Unstructured Information by Scott Spangler, Jeffrey Kreulen (both IBM)Written by IBM researchers, so product teams were not involved in creating or reviewing content. Doesn’t describe a product that is for sale, but techniques used in research at IBM and by IBM consultants on customer service engagements. IBM Alphaworks provides a free demonstration copy of one of the early text-mining tools called IBM Unstructured Information Modeler, as an adjunct to this book: alphaworks.ibm.com/tech/uimodeler.
ABOUT TO PUBLISH
DB2 9 for Linux, Unix, and Windows: DBA Guide, Reference and Exam Prep (IBM Press) by George Baklarz (Author), Bill Wong (Author), Paul C. Zikopoulos (Author)- Sixth Edition of our most popular book EVER!
DB2 for Developers (MC Press) by Phil Gunning - expected in December.... SPECIAL 37% PRE-ORDER DISCOUNT!
DB2 9 for z/OS Database Administration Certification Study Guide for Exam 732 (MC Press) by Susan Lawson and Dan Luksetich - October - SPECIAL 30% DISCOUNT ON PRE-ORDERS!
Building an Intelligent Web: Theory and Practice (Jones & Bartlett Publishers) – to include DB2 Express; book is a university text book. - expected in Oct.
DB2 9 Database Administration Certification Study Guide for Exam 731 (MC Press) by Roger Sanders - October
DB2 9 Database Administration Upgrade Certification Study Guide for Exam 736 (MC Press) by Roger Sanders
WHERE TO BUY?You can buy these books in most countries in the world. We have set up a bookstore website to give you URLs for the sites that give the best prices: ibm.com/software/data/education/bookstore. Choose the international tab on this page for locations outside of the US, including Canada.
I have a few other really interesting projects in the works, but I'll wait to tell you about those once I have a few more details firmed up.
As always, stay tuned :)
The Version 9 books are slowly arriving, so now is your chance to pick up any Version 8 books that you may want for 50% off the usual price. Here are the details:
************************************************************SPECIAL OFFER - Save 50% on DB2 8 Books************************************************************
BUY any two DB2 8 books from IBM Press and save 50%, plus free ground shipping in the U.S. Make room on your library shelf for these invaluable resources, quantities are limited.
DB2 Universal Database V8 for Linux, UNIX, and Windows Database Administration Certification Guide, 5th Edition The V9 book will publish this summer. It is still worth buying this book if you have not yet earned your V8 certification.
Understanding DB2: Learning Visually with Examples, 1/e The V9 book is expected in the first half of 2008.
High Availability Guide for DB2 There are no plans to update this book for V9. The book is amazing, but is missing information on some of the latest features related to High Availability. It is still worth reading this book as you can find articles related to the missing features on dworks.
DB2 SQL PL: Essential Guide for DB2 UDB on Linux, UNIX, Windows, i5/OS, and z/OS There are no plans to update this book for V9. This is, however, an IBM Redbook about to publish. It is worth reading this book and getting the updates from the IBM Redbook.
DB2 for z/OS Version 8 DBA Certification Guide The V9 book is coming out this summer. It is still worth buying this book if you have not yet earned your V8 certification.
DB2 Universal Database V8.1 Certification Exam 700 Study GuideDB2 Universal Database V8.1 Certification Exams 701 and 706 Study GuideDB2 Universal Database V8.1 Certification Exams 703 Study GuideThis is an extremely popular series of books and excellent for helping you prepare for 4 of the 5 DB2 V8 Certification Exams. It is worth buying these books, if only for the library of sample questios! Also, there are currently no plans to create a study guide for the V9 Application Development Exam.
Official Introduction to DB2 for z/OS, The: Covers DB2 Universal Database for z/OS V8, 2nd EditionWhat an excellent way to come up to speed on DB2 for z/OS. The book is at the Version 8 level, but there are currently no plans to update this book for V9. There will be online help with the product... but get this book instead.
DB2 Express: Easy Development and AdministrationThere are currently no plans to update it for Version 9, but the DB2 Express team is looking into creating an electronic version that is similar to this book. This book is worth buying since it gets you up to speed very quickly in both the DBA and AD areas.
Quantities are limited. Promotion ends June 30, 2007. Click here for more details and for a complete list of the DB2 8 books on promotion.
For this offer and more, see our Offer Page
One of the most popular questions I hear is regarding book shelf space. It doesn't matter where you are in the world, but if you go into a bookstore, most likely you will see an entire bookcase dedicated to Oracle books and another to Microsoft books and in most cases only a single book about DB2. Why is this?
First of all, if you look very carefully, you may find a few other DB2 titles hidden away in other bookshelves. Try looking under "Certification", "Networks" or "Operating Systems". I know, it doesn't make any sense to look in those sections, but I've personally found DB2 titles in each of those categories! The biggest problem for a bookshelf stocker is that they have no idea where they should put our books. Some will even put our books in the Oracle bookshelf. In my opinion, there should be a Database Section, not an Oracle section. Or better yet, let's get a shelf for all IBM SW products or technology. It seems that this would make it easier for those stocking the shelves as well as those buying the books.
I'm hoping that now that we have an IBM Press (http://www.ibm.com/ibmpress) series of books published by Pearson Education, that we'll publish enough books about various IBM technologies to have a book case dedicated to IBM Press. Then you be able to find titles for DB2 next to the Cloudscape books, next to the Lotus, Rational, Tivoli, and WebSphere titles. This makes sense to me and it cannot happen soon enough for my liking.
So when will it happen? That depends on a number of factors. The first thing that we need is enough titles in our collection so we can fill a whole bookshelf. On the last count, there were 47 IBM Press titles published! Put 5 of each title in a bookshelf and it won't be very difficult to fill a book case.
But, the bookstore buyers aren't yet willing to take a risk on our books. Last year I convinced 60 key Borders stores to stock DB2 titles, but they didn't sell! No surprise, really. If you've never found a DB2 title in a bookstore, why would you ever look in a bookstore to find one? So the titles were sent back to the publisher and again, very few bookstores are carrying our titles.
Is it really a big deal though since the books can be purchased online, usually at a lower price than in the bookstore? Well, yes and no. I would assume that most people buying IT books are buying them from a favourite online bookstore. Amazon.com is probably the most common place. But what we're missing is MIND SHARE.
Assume that you are a university student and in your spare time you wandered into the database section in a bookstore. You see Oracle, MS SQL Server, MYSQL, and a few others, but nothing on DB2. Are you going to care about getting skilled on DB2 after witnessing this? I doubt it. But the problem can get worse if an executive is making a database buying decision by browsing in a bookstore. Does that happen? Sure, why not? Does the number of books available indicate the size of the skilled population using that technology? Maybe.
So what can we do to get shelf space for our books and therefore mindshare for our products? One simple thing that we can all do is to support the authors and the books that are available. If you've read a book and liked it, consider putting a review of the book in a public place such as amazon.com. If you are giving a presentation and there is a related book, consider recommending it to your audience. If you have customers, partners, or co-workers using DB2, mention to them that there are great books available. It may sound simple, but the more books that we sell, the better chance we have that the bookstores will take the chance to carry our books.
I look forward to reading your comments.
IBM Press Program Manager
The postings on this site are my own and don't necessarily represent IBM positions, strategies or opinions.
Last week at the Data In Action Virtual Conference Event that I attended, speaker R. Ray Wang, Vice President, Forrester and Lise Neely, Product Manager, IBM co-presented "Data Management for a Lean Economy: Strategies to Cut Costs, Improve Performance, Reduce Risks". During their talk they mentioned several ways for you to begin making improvements in your data to help save money by right-sizing your database.
Although the event is now over, you can still register and access the recorded presentations. The presentation by Ray and Lise can be found in the Auditorium. To answer the question... where do I start... Ray suggests regulatory compliance, Lise agrees but also suggests archiving. Listen for yourself.
On the same topic, you should read the latest article Integrate IBM InfoSphere Master Data Management Server using WebSphere Process Server, Part 1: Deploy and execute MDM Server Web services in a distributed environment by Stephanie J. Hazlewood, Allan Luo, and Martin Oberhofer. This is Part 1, so stay tuned for the coming parts.
Also on the same topic, the book Enterprise Master Data Management: An SOA Approach to Managing Core Information is continuing to sell well and is educating people on the many ways that they can start down the road of Master Data Management. There are now 5 customer comments on this book... all 5-star ratings! You won't regret reading this book!
Enjoy this amazing knowledge!
Don't miss your chance to be a part of IDUG 2008 - Europe, 13-17 October, in Warsaw, Poland which will provide you the most up-to-date information on major issues taking place in the DB2 industry.
Highlights:This year's conference will feature subject matter experts and users who will provide in-depth information regarding the latest in DB2 technology.
General Session Keynote Presentations:
* Monday, 13 October - Path to Gold, a speech by World Champion Paralympic Athlete, Marc Woods, takes you on an inspirational journey as he shares his personal story of triumph over adversity. Using BBC archive footage from Atlanta 1996 and Sydney 2000, Marc's inspiring story delivers insights into personal responsibility, leadership, teamwork and motivation. Find Marc's book at the conference bookstore.
* Thursday, 16 October - Get the most recent news on IBM's Information on Demand initiative from Curt Cotner, IBM Fellow, Vice President and Chief Technology Officer Data Services. Curt will review the very latest news on DB2, IDS, IMS, Cognos, InfoSphere, and many other key IBM product offerings.
One-Day Education Seminars:
If you are looking for in-depth training, IDUG One-Day Educational Seminars are the answer. Taking place Friday, 17 October, 8:30 - 16:30 these full-day seminars will enhance your IDUG Experience and include intensive training from some of the best in the DB2 industry.
DB2 for LUW Performance Diagnosis Learning LabScott Hayes, DBI
DB2 9 for z/OS - In DepthPhil Grainger, CA
Dynamic SQL Performance Diagnosis Class for DB2 for z/OSThomas Baumann, Swiss Mobiliar
Query Performance and Tuning for DB2 for LUWJohn Hornibrook, IBM Toronto Lab
DB2 v8/v9 Application/Database Challenges and SolutionsSusan Lawson, YL&A Find Susan's latest book at the conference bookstore.
For a complete listing of all the education being offered at IDUG 2008 - Europe, browse the Conference Scheduler.
Education That Fits Your NeedsIDUG 2008 - Europe will offer these unique conference activities to help make your IDUG Experience different from the last.
Free IBM Certification Testing: IDUG has FREE certification testing to help you advance in your area of expertise. Sponsored by IBM, IDUG 2008 - Europe will offer attendees a variety of tests so that attendees of all types of DB2 roles may become certified.
IBM Panel Discussion: Hear directly from IBM engineers in this unique, conversational setting. Nine IBM experts for DB2 for LUW and DB2 for z/OS technologies will be on-hand to answer all of your questions, offer solutions and discuss the future of these technologies.
Online registration for IDUG 2008 - Europe closes Friday, 3 October, so go online and register today! We hope to see you this October in Warsaw!
New for Management Level Professionals
Taking place 13 October, the IDUG 2008 - Management Forum is meant exclusively for IT managers and executives and will provide you a unique environment to speak one-on-one with DB2 experts, leading vendors and fellow managers in a small setting. To learn more about this jam-packed, one-day experience, visit the Management Forum Web site.
Full-conference attendees can add this exclusive full-day offering to your conference registration at no additional cost. Simply register for the full conference using our convenient online registration form. Once complete, please send an e-mail to IDUG Europe Headquarters at Laura@associationhq.com and they will ensure the Management Forum is added to your registration at no additional fee.
Conference BookstoreAgain this year, the conference will feature a bookstore with discounts to conference attendees. New at the bookstore this year:
DB2 9 Database Administration Certification Study Guide for Exam 731 by Roger Sanders
DB2 9 Database Administration Upgrade Certification Study Guide for Exam 736 by Roger Sanders
DB2 9 FundamentalsDB2 9 for z/OS Database Administration Certification Study Guide for Exam 732 by Susan Lawson and Dan Luksetich
DB2 9 for Developers by Philip Gunning
DB2 for Linux, UNIX, and Windows: DBA Guide, Reference, and Exam Prep, 6th edition by George Baklarz, Paul C. Zikopoulos
Understanding DB2(R): Learning Visually with Examples (2nd Edition) by Raul F. Chong, Xiaomei Wang, Michael Dang, and Dwaine R. Snow
Enterprise Master Data Management: An SOA Approach to Managing Core Information by Allen Dreibelbis, Eberhard Hechler, Ivan Milman, Martin Oberhofer, Paul van Run, and Dan Wolfson
IBM Cognos 8 Business Intelligence: The Official Guide by Dan Volitich
Personal Best: 10 lessons to help you achieve your true potential by Marc Woods
Amazon's pre-order price for this book is an amazing 34% off the regular price. Act now as this offer could be removed at any time!
An Enterprise Pandemic
by Neal A. FishmanEnsure the Reliability of the Data
Service-oriented environments utilize web services to share data more widely and rapidly than ever before. It’s easier than ever for incorrect data to trigger inappropriate actions, prevent urgent actions from being taken, disrupt customer transactions and relationships, generate compliance problems, and damage business performance. Companies need a comprehensive blueprint for ensuring data reliability in their SOA environments. Viral Data in SOA provides that blueprint.
Leading IBM data forensics expert Neal A. Fishman helps you identify the unique challenges of data quality in your SOA environment-and implement solutions that deliver the best results at the lowest cost.
Writing for both business and technical professionals, Fishman shows how to think about data quality on a risk/reward basis...why effective data governance is so important, and how to achieve it...how to evaluate data quality, and overcome its inevitable decay...and, last but not least, how to actually drive a data quality initiative that works.
· Why poor-quality data has become even more dangerous
· Practical solutions for assessing, improving, and sustaining data quality
· Why data governance is so critical-and realistic models for implementing it
· How to instill proactive accountability throughout your data processes
· Proven techniques for evaluating data before, during, and after its use
· Handling persistence and memory-resident databases in SOA environments
· Improving business, system, reference, and “meta” data
· Creating data models that support today’s broader spectrum of applications
· Sustaining data quality through conditioning
· Using systems thinking to limit future data problems and understand the potential ripple effects of data sharing
Neal A. Fishman, leader of IBM Software Group’s integration forensics program, has spoken at conferences around the world, and is a Practicing Member of the World Wide Institute of Software Architects. He has served as Technology Editor for the Data to Knowledge Newsletter, and as a member of the IEEE IDEFobject and Business Rules Group standards committees. Fishman holds IBM certifications in DB2, DataStage, QualityStage, and Information Analyzer. He is co-author of Enterprise Architecture Using the Zachman Framework.
I hope you enjoy the book as much as I did.
Don't you love it when there is a conference that is local to your home or office? Well, at least this one is local to me... maybe not for you, but I hope you can come and enjoy our lovely city!
The Central Canada DB2 User Group presents two exciting days of DB2 for LUW and z/OS education! Come see and listen to renown speakers such as John Campbell, Susan Lawson, Bonnie Baker, Sheryl Larsen, Willie Favero, and many other IDUG Hall of Fame speakers present on many diverse areas of DB2.
The event will be held at the Institute for Learning in Markham, Ontario.
Full details and registration available at the CC DB2 User Group web site.
This is the 25th Anniversary of this event and takes place at the end of the month: May 31 - June 1.
I'll be there and hope to see you!
CIO Insight just released another of their addictive top 10 slide shows. This one is called The 10 IT Skills in Most Demand.
In the Information Management space, you'll be glad to see that the following areas are considered "in demand":
# 4 - Data management# 8 - Business Intelligence#10 - CRM Implementation
How can you get skills in these areas? I can recommend a few books that would certainly help:
Data Management1) For Beginners:* Understanding DB2(R): Learning Visually with Examples (2nd Edition)* Beginning DB2: From Novice to Professional (Expert's Voice)* Administering Informix Dynamic Server - Building the Foundation
2) For Advanced Topics:* DB2 9 for Linux, UNIX, and Windows: DBA Guide, Reference, and Exam Prep, 6th Edition* DB2 9 for Linux, UNIX, and Windows Advanced Database Administration Certification Study Guide
3) For Certification:* Series of DB2 Certification Guides by Roger Sanders* Expert Preparation for Exam 732 - DB2 9 for z/OS Database Administration Certification Study Guide
Business Intelligence* IBM Cognos 8 Business Intelligence: The Official Guide* Business Intelligence For Dummies* Business Intelligence Roadmap: The Complete Project Lifecycle for Decision-Support Applications
CRM Implementation - Go for the big picture!* Enterprise Master Data Management: An SOA Approach to Managing Core Information
Be sure to join my new group on ChannelDB2 for these books and more!
Would you rather take a course to build these skills? Try an ILO course!
svisser1 2700018UK9 4,191 Views
Join us for the #Transactions Twitterchat on “How important are transactions in a big data world?” Aug 20, from 11:00 am to 12:00 pm ET.
Our special guests for this Twitterchat are:
You can follow along—and join the discussion using the hashtag #Transactions. We look forward to your thoughts and comments on #Transactons twitterchat hosted by @IBM_DB2 (Susan Visser).
How do you join in?
If you use a Twitter client like Tweetdeck or HootSuite, create a search column for the term #Transactions. Then as participants tweet with the #Transactions hashtag, those tweets will appear in your column.
How do you participate?
Review the discussion questions so you can prepare your thoughts and answers. When the question is posed, begin your response with A1: for question 1 and A2: for question 2, and so on. This makes it easier to follow the conversation throughout the chat. No answer is wrong!
More about our panelists
Craig is president & principal consultant of Mullins Consulting, Inc., a principal with SoftwareOnZ and the publisher/editor of The Database Site, His working experience spans multiple industries. He’s written multiple books and blogs at: http://datatechnologytoday.wordpress.com/
Scott Hayes is President & CEO of Database-Brothers Inc (DBI), a company intensely focused on IBM DB2 UDB LUW and Oracle database solutions. Scott is an IBM DB2 GOLD Consultant and has received a number of DB2 Certifications. Scott hosts The DB2Night Show series of webinars. Check the website http://www.dbisoftware.com/db2nightshow/ where you can found hundreds of hours of free DB2 education.
Kelly works in the IBM Software Group, Information Management as an Executive IT Specialist in WW IM Technical Sales. His specialties are DB2 pureScale & PureData System for Transactions. Kelly has written several blog entries on the IBM DB2 Blog site.
Thanks to Larry Heathcote, Ember Crooks, Sally Hartnell, Kelly Schlamb, and Scott Hayes for helping me put this together!
svisser1 2700018UK9 4,178 Views
svisser1 2700018UK9 4,177 Views
I hope you are aware that we have a Bookstore website where we showcase the books that are related to IBM's Information Management products. Nicole from my team is in the process of redesigning the site and has asked me to update the content. I'm glad we're doing this as I noticed that there are quite a few changes that are needed!
I'd like to ask for your help to make sure that I have the right set of books listed in each of the categories. Today's post is for the Data Management area. Let me know if you think there are books that should be deleted from this list or if there are some that you think should be added.
I'll be posting more lists in my blog each day until I'm finished.
Thanks for your help!
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.
Today I'm thinking about IDS... I just had a phone meeting with Ron Flannery and Paul Watson about a possible book. I'm also working with Carlton Doe on two new projects I'm pursuing a study guide for the new Test 918 - System Administration for IBM Informix Dynamic Server V11. Oh yea, I also had another proposal for an IDS book...
So the questions is.... is there really a market for all these books? I hope so. All of the published books that you can currently find on amazon.com are nearly 10 years old. I'm sure many of you saw the IDS 11 Flashbook IBM Informix Dynamic Server 11: The Next Generation in OLTP Data Server Technology, written by Carlton: IBM has been handing this book out at events since June and the feedback has been amazing! The success of this book showed everyone that there is extreme hunger in the market for new and relevant information.
So, in addition to the IBM Redbooks, articles, tutorials, and courses, I'm hoping to see three full retail books published. Interested?
Here is a current list of the training options that you have for IDS 11:
IBM Informix Dynamic Server 11 System Administration Certification Preparation Tutorial SeriesThis series of eight tutorials has been developed to help you prepare for the IBM Informix Dynamic Server 11 System Administration Certification Exam (918). These tutorials provide a solid base for each section of the exam. However, you should not rely on these tutorials as your only preparation for the exam. After a quick registration, you can begin a tutorial. Currently parts 1 and 2 are available in this series of eight. Each tutorial should take less than two hours to complete. You can take the tutorials online, or download a PDF.
Informix Dynamic Server 11 Systems Administration - Instructor Led OnlineThis online course is designed for Informix Dynamic Server system administrators and is 4 days in length. Travel arrangements are not necessary for this course. After you receive confirmation that you are enrolled, you will be sent further instructions to access audio, video and remote labs.
After completing this course, students will be able to:* Describe the components of a database server.* Install IBM Informix Dynamic Server.* Configure and initialize a database server.* Configure the server to allow both local and remote connections.* Use Dynamic Server utilities to monitor server activity.* Describe the components of shared memory and configure the component sizes.* List, describe, and configure the different classes of virtual processors.* Identify the components of the database server disk architecture.* Create dbspaces, blobspaces, and sbspaces and add chunks to these spaces.* Explain the purpose of physical and logical logs and monitor log activity.* View the individual transactions that are written to the logical log files.* Describe the importance of checkpoints on the server.* Describe the importance of fast recovery.* Perform backups of the database server and logical logs.* Use different methods to restore a database server from backup.* Explain the purpose of temporary spaces used by the server.* Configure the database server to operate more efficiently using parallel operations.* Monitor the resources used by individual user sessions.* Configure the server to respond to specific events by executing an alarm program.* Use various troubleshooting techniques to identify and resolve common problems.
Informix Dynamic Server 11 Extending Availability and ReplicationIn this IBM Redbooks publication, we provide an overview of the high availability and Enterprise Replication features of Informix Dynamic Server (IDS) Version 11, which can simplify and automate enterprise database deployment. Version 11 offers patent-pending technology that virtually eliminates downtime and automates many of the tasks associated with deploying mission-critical enterprise systems. The high availability capability can reduce or eliminate costly downtime through, for example, the introduction of online index rebuild, the capability to create and drop indexes online without locking tables, and point-in-time table level restore. Enhanced Enterprise Replication provides solutions for those customers requiring reliable and quick distribution of data across a global organization. The replicated data can also participate in the high availability environment with capabilities such as seamless online resynchronization of Enterprise Replication (ER) nodes at startup, for example. There is also enhanced capability for high-availability disaster recovery customers in the form of the ability to resend primary server indexes to HDR secondary servers without requiring a rebuild of the index on the primary server. These capabilities enable faster, easier, and reliable distribution and high availability of data, enabling improved access and use throughout the enterprise. For improved availability and data replication, you need IDS 11.
Informix Dynamic Server 11: Advanced Functionality for Modern BusinessIn this IBM Redbooks publication, we provide an overview of Informix Dynamic Server (IDS) 11. IDS is designed to help businesses leverage their existing information assets as they move into an on demand business environment. Requirements here call for a flexible data server that can accommodate growth, in applications, data volume, and numbers of users. And it offers the capability to minimize downtime and to provide the high availability required today. A new suite of business availability functionality provides greater flexibility and performance, automated statistical and performance metric gathering, improvements in administration, and reductions in operating costs. The IDS technology enables efficient use of existing hardware and software, including single and multiprocessor architectures. And it helps you keep up with technological growth, including such things as the use of nontraditional data types. Built on the IBM Informix Dynamic Scalable Architecture™ (DSA), IDS provides a next-generation parallel data server architecture that delivers mainframe-caliber scalability; manageability and performance; minimal operating system overhead; and automatic workload distribution. IDS delivers a lower total cost of ownership (TCO) by leveraging its well-regarded general ease of use and systems administration. It enables customers to use information in new and more efficient ways to create business advantage.
Informix Dynamic Server V10: Superior Data Replication for Availability and DistributionThis book provides an overview of the high availability and enterprise replication features of Informix Dynamic Server (IDS) Version 10, which can simplify and automate enterprise database deployment. Version 10 offers patent-pending technology that virtually eliminates downtime and automates many of the tasks associated with deploying mission-critical enterprise systems. The high availability capability can reduce or eliminate costly downtime through, as examples, the introduction of online index rebuild, the capability to create and drop indexes online without locking tables, and point-in-time table-level restore. Enhanced enterprise replication provides solutions for those customers requiring reliable and quick dissemination of data across a global organization. The replicated data can also participate in the high availability environment with capabilities such as seamless online resynchronization of enterprise replication nodes at startup, for example. There is also enhanced capability for high-availability disaster recovery customers in the form of the ability to resend primary server indexes to HDR secondary servers without requiring a rebuild of the index on the primary server. These significant and powerful capabilities can enable you to intelligently replicate (distribute) your enterprise data to improve the availability of that data to better service the requirements of your enterprise.
Use the Informix Dynamic Server scheduler and SQL APIWith the release of IBM IDS 11, a new set of highly anticipated features form the foundation for a self-managing RDBMS. These tools allow the DBA to collect server information and adjust the database server using SQL as a remote administration tool. Additionally, a scheduler allows those same SQL API commands to be scheduled for execution, much like a UNIX® cron job. IBM IDS further extends its value by adding reduced costs for administration and problem determination to its already lauded reputation as the administration-free database.
IDS CheetahLink to articles, tutorials, blogs, forums, and other resources to learn about IDS Cheetah, the next version of IBM Informix Dynamic Server.
Grant Hutchison hosted a webinar with Guy Bowerman earlier this week, but I'm not sure if it was recorded.... If someone knows, please post a comment.
Today's electronic edition of DB2 Magazine has an article by Howard Fosdick about the IBM Business Intelligence certification exam. His article discusses the credentials required as well as directs the reader to the appropriate study materials.
Here's an intro and link to the article:
With companies clamoring for business intelligence, a certification credential can give DBAs and programmers an significantedge with employers. Certification columnist Howard Fosdick hands out the inside intel on passing IBM's DB2-based business intelligence exam.
--Read Fosdick's columnhttp://news.db2mag.com/cgi-bin4/DM/y/eycu0FlZ1Y0FLd0EhzV0AH
Here is what our instructors are saying about ILO:
Instructor-Led Online courses truly offer a global learning opportunity. Having the option to take a course on your own terms, in the location of your choice, while still being able to experience live interaction with an instructor is highly beneficial for our global customers."- Joan Dunn, IBM certified instructor, U2
"When you look at Instructor-Led Online, it comes down to one thing: convenience. For the student on the go, online access to a real-time instructor means savings in time and money."- John Zucchero, IBM certified instructor, Informix
"Live instructor interaction, high-quality course content, hands-on labs, with flexibility, no travel expenses and real-time skills building with peers… it’s almost a question of why wouldn’t you take an Instructor-Led Online course."- Melanie Stopfer, IBM certified instructor, DB2
The promotions we were running with the user groups were very popular. At last check, there was still room for the IIUG promotion, but one for IDUG members was full. Click the links to be sure.
IDUG: Two special online lecture topics will be offered: SQL procedural language February 26, 2008 & DB2 for LUW Advanced Monitoring March 18, 2008. These offerings have been created for IDUG members only!
IIUG:This special session will be offered on February 19, 2008 from 11:00am - 12:30pm Eastern and will be taught by Mike Lowe.
Also new... a podcast that provides details on this type of education.
For me personally, the last two courses that I signed up to take, there ended up being a major snowstorm on the same day. I managed to make it into the classes, but now I wish they had been ILO classes so I didn't have to risk my life by driving in.
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.
You're invited to a free session about Driving Business Innovation with Smart Analytics at the Sheraton Centre in Toronto the morning of February 10th.
The topic is Driving Business Innovation with Smart Analytics and it is being offered by ComputerWorld Canada’s Technology Insights.
Join Network World Canada editor Greg Meckbach and his guests Glen Sheffield, IBM Information Management Technical Specialist and Jason Gartner, IBM Business Analytics Development Executive.
WHAT WILL BE COVERED:
• The software, hardware, storage and infrastructure requirements for data warehousing and business analytics initiatives
• How to reduce the cost and time of deployment;
• How the business can leverage these analytical tools to turn information into insight and make sound business decisions
Glen Sheffield, IBM Information Management Technical Specialist
Jason Gartner, IBM Business Analytics Development Executive
“Work smarter, not harder” How many times have we heard this phrase? Working smarter means analysts and key decision makers have the right information and insight. It means analysts can quickly access the right data points to evaluate key performance indicators. And yet, working smarter may be more important today than it has ever been. Learn how by attending ComputerWorld Canada’s Technology Insights session in Toronto on February 10th. Seating is limited so don’t delay in reserving your place.
Working smarter means your front line business leaders know where to find the new revenue opportunities and which product or service offerings are most likely to address the market requirement. It means corporate risk and compliance units can recognize regulatory, reputational, and operational risks before they become realities.
Within your organization you have billions of bytes of information stored on your computers. We will examine how to give your organization the insight it needs to work smarter in this challenging environment by putting the right answers in the hands of your decision makers today while putting your business in the best position to quickly adapt and grow to answer the questions of tomorrow.
8:30 AM - 9:00 AM Registration & continental networking breakfast
9:00 AM - 9:15 AM Welcome address & content introduction.
9:15 AM - 10:00 AM Building the Foundation
Bringing a multi-terabyte data warehouse into production can be an insurmountable task. Find out how to overcome the challenges of bringing an enterprise database into production by employing the right software, hardware, storage and infrastructure. Learn how to reduce the time and cost of deployment.
10:00 AM - 10:15 AM Networking & coffee break
10:15 AM - 11:15 AM Turning Data into Decisions
Businesses need a range of analytics capabilities to address the variety of decisions that need to be made every day—and the confidence that those capabilities can be easily expanded as new demands arise. IT managers need to ensure they can quickly get the solution up and running and that it remains as relevant and powerful in the future as it is today. Learn how you can help the business quickly and efficiently turn your information into insight for smart business decisions.
11:15 AM - 11:45 AM Panel of experts - Q&A
11:45 AM - 12:00 PM Wrap-up
12:00 PM Program concludes
If you are in Toronto... come out and join these fabulous speakers and get inspired!
Thanks to Adam Gartenberg for posting an entry about the Forbes interview with Steve Mills: Drowning In Data.
You'll find that the article encourages companies to clear their clutter to all for more effective management. In other words... use the Information Agenda.
I'd like to make a suggestion as well ... invest in the book Enterprise Master Data Management: An SOA Approach to Managing Core Information. The book provides a structure that can be followed to clean up all kinds of clutter in an organization.
Quite a few people in the Toronto Lab are upgrading their certifications to the V9 level this summer, and I thought I'd pass on study tips for Exam 733 that I learned from the candidates this week.
1) There isn't a book available for Exam 733, nor is there one in plan. People recommend reading the V8 book by Roger Sanders to help prepare for Exam 733. If you work for IBM, remember that you can access this and other books through Books 24x7.
2) The two biggest additions to the 733 exam versus the 703 exam is .net and XML content. Of course, neither of these topics are covered to a great extent in the V8 book.
3) There are free tutorials for Exam 733, and it is recommended that you use these to prepare for at least the .net and XML areas, but perhaps reading all the 733 tutorials would be beneficial.
4) Not many of the people here take the assessment exams, but they are still valuable at helping you gauge your readiness to pass the exam.
Do you think that you are ready to pass the certification exam that you've been studying for? Try a practice exam to gauge your readiness. Usually offered through Prometric for $10, you can enjoy them for free from October 12 through October 26.
Be well prepared for the complimentary certification exams at Information On Demand 2008 with free Information Management Certification practice tests.
How should you study: see the exam preparation documents.
Trying to figure out which book to use to study: see the DB2inBooks group on channeldb2.com.
Do you prefer to take a class? Check out the pre-conference crammer courses:
DB2 for z/OS DBA Certification Crammer (Exam 732)
Speaker: Susan Lawson
This high level certification preparation review is intended to help you take IBM Certification Test 732, DB2 9 DBA for z/OS. Gain an intense overall review of those areas that are on the certification exam.
DB2 9 for Linux & Windows DBA Certification Crammer (Exam 731)
Speaker: Roger Sanders
This training is designed to introduce the student to the concepts a test candidate must know in order to take and pass the DB2 9 DBA for Linux, UNIX, and Window certification exam (Exam 731). The material for this course is aligned with the 731 exam objectives.
Remember: Those who are certified are eligible to attend the certification lounge at the IOD conferences... for FREE MASSAGES!
Over the past year I have been working with a geographically dispersed author team who have been writing a book to explain the meaning of Master Data Management to the world! I'm happy to say that the book is now ready for you to preorder... delivery in June.
Enterprise Master Data Management: An SOA Approach to Managing Core Information by Allen Dreibelbis, Eberhard Hechler, Ivan Milman, Martin Oberhofer, Paul van Run, and Dan Wolfson.
As a favour to the authors, I read the majority of the book in order to give feedback on what was written. I found the book very informative and for a complete newbie like me... I found it understandable and can see the potential for every company in the world to want to have MDM!
Dr. Ambuj Goyal wrote the foreword for the book, and I am copying a piece of it here so that you can get a glimpse into the importance of the topic and the book... from an expert who knows what he's talking about:
Unlocking information and letting it flow rapidly and easily to the people and processes that need it, is easier said than done. Over the past 20 years or more, the IT industry has focused on automating business tasks. This has created a very complex information landscape; individual automation projects have led to disconnected silos of information. Little trusted information exists – there are multiple versions of the truth. Redundancy reigns – both logically and physically. Few common definitions of key data elements exist or are shared across the enterprise. No common processes to manage and ensure the integrity of critical data domains exist. These facts define today’s environment. They blind the business from the information it needs, add cost to the IT infrastructure, and slow the ability of the business to move forward with confidence. Solving these problems is what Master Data Management and this book are all about.
The book is written in a generic way so that any one who is considering implementing an MDM system will benefit from reading it. Now the author team is committed to writing about how to implement the solution using IBM technology, and they've just published their first article with many more to come: Implementing a transaction hub MDM pattern using IBM InfoSphere Master Data Management Server
Synopsis of the article: Learn to use the transaction hub Master Data Management (MDM) pattern to implement your MDM systems. This typical architectural pattern is described in terms of capabilities of the MDM Reference Architecture. Get an introduction to the IBM® InfoSphere™ MDM Server and see why this software solution is a good choice for implementing this architecture pattern. Finally, learn about an upcoming book, Enterprise Master Data Management: An SOA Approach Managing Core Information, that deals with these topics in greater detail.
Join us at the IBM Information On Demand EMEA Conference 2008 taking place June 3 - 6, 2008 The Hague, Netherlands. Enterprise Master Data Management: An SOA Approach to Managing Core Information is being launched at this conference and we've arranged for an author signing. I've been told that there are quite a few sessions related to MDM taking place at this conference, so for multiple reasons, this is the place to be!
Thanks to the authors for the tremendous dedication that they have to this topic and for the incredible work they put into creating this book.
New IBM Redpaper for you to download and read: DB2 9 for z/OS Data Sharing: Distributed Load Balancing and Fault Tolerant Configuration
This IBM® Redpaper provides information about exploiting client load balancing and fail over capabilities across a DB2® data sharing group or a subset of the group members. The information provided will help network specialists and data base administrators in appropriately configuring data sharing groups as TCP/IP servers.
We show how to use the functions of DB2 sysplex workload balancing functions, supported by DB2 Connect™ Server and the IBM DB2 Driver for JDBC and SQLJ, in conjunction with the functions of TCP/IP Sysplex Distributor, configured with Dynamic Virtual IP address (Dynamic VIPA or DVIPA) and automatic VIPA takeover, to provide superior load distribution and fail-over capability for transactions and connections across the members of a data sharing group. The two functions work together to ensure the highest availability possible for remote applications accessing a DB2 location in a sysplex.
Thanks to Sabine Kaschta for providing this information to share with you!
IBM Data Studio software is a revolutionary approach to managing data and data-centric applications throughout the lifecycle, from requirements to retirement.
Read the overview article by Holly Hayes that explains both the vision and reality of Data Studio and how you -- whether a data architect, developer or tester, DBA, or data steward -- can use Data Studio today to improve productivity, increase quality of service, and encourage greater alignment across IT roles.
I'm quite pleased to see the number of social community groups that have become quite active lately... largely thanks to Adam Gartenberg... but many others as well.
Here is the list that I have... there might be more. Check them out, and join one or more!
I've just added a discussion group in channelDB2 that I'd like you to specifically check out, join, and comment on! It is called DB2 in Books. I hope you like it :)
planetDB2Viral VideosDM YouTube ChannelIDS Facebook Fan PageDB2 Facebook Fan PageInfoSphere Facebook Fan PageData Studio Community
See you in the community :)
Did you know..... Information Management will have a major presence at this year's Lotusphere conference with four pedestals and 11 sessions featuring Information On Demand solutions.
It is easy to see that the world is changing very quickly in front of our very eyes.... so does that mean we should begin ACTING differently? I think so. Where to start?
Faster decision making: IBM's next generation Lotus collaboration and WebSphere Portal technologies facilitate closer relationships among employees, customers, and partners - resulting in faster decision making.
Trusted information: Making great decisions requires the use of trusted information. Recent surveys indicate that almost 50% of business users lack confidence in their company's information. Information On Demand is designed to help enterprises unlock the business value of information by delivering timely and trusted information to employees, customers and partners.
So....By linking people with people - and people with trusted information - Information On Demand solutions tightly integrated with Lotus collaboration and WebSphere Portal technologies empower people to act on trusted information faster and with greater confidence.
Here are some of the ways for you to learn more about our integrated solutions:
IBM Enterprise Content Management and Lotus Quickr: the most complete single-vendor end-to-end content management solution in the industry.
IBM Content Collector and Lotus Domino: the comprehensive e-mail archiving and retrieval solution for any Notes database or server platform.
Cognos 8 BI and WebSphere Portal: out-of-the-box Cognos portlets for WebSphere Portal.
InfoSphere MashupHub and Lotus Mashups: the first complete mashup portfolio for business, empowering individuals to create situational applications. (Bundled & sold as IBM Mashup Center)
DB2 pureXML and Lotus Forms: efficient, integrated, and cost effective electronic forms solutions.
For a full agenda, see Lotusphere Agenda.
I won't be at the conference, so if you are there, send those of us back in the office some details about what you liked the most.
I use google to find links to just about anything I'm interested in. I'm not always successful in finding what I am looking for, but I'm sure it is just because of my bad search arguments.
Mark Wilding, a member of the Toronto Lab Development team, was looking for DB2 sites and was frustrated at not being able to find what he wanted to. So, always a problem solver... Mark created the following site:
Forever growing, this site should be one of the first places to go if you are looking for specific DB2 information.
Just a quick comment about Mark. Mark is one of the many prolific authors that we seem to attract in the Toronto Lab. He's been involved with a few books with many ideas still unpublished. He was the driving force behind the latest DB2 Best Practices initiative. If you don't know about this yet, check out the bookmark list to find it.
Also, Mark, along with Dan Behman, wrote a book about Linux that should be popular with many people: Self-Service Linux(R): Mastering the Art of Problem Determination .
Thanks Mark for the bookmark list as well as your passion for writing!