Keep on Learning
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 email@example.com. 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 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.
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.
svisser1 2700018UK9 4,229 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!
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!
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.
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!