Keep on Learning
I hope all my IDUG friends who are in Rome this week are enjoying the city, weather, and of course the amazing conference!
If you are an IDUG member, I'd like to bring this information to your attention:
IDUG members save $100 on registration for the Information On Demand 2009 global conference.
Not a member... become one today.
Visit IDUG for promo code.
I hope to see you in Vegas!
The Information on Demand conference is fast approaching. I've been doing some final planning for the conference that includes creating signage for the bookstore and book signing events. I'll share with you what the plans are and hope that you'll be able to join us at the conference and specifically for the book events.
The IOD bookstore is offering books at a 20% discount. Browse the selection of books because I think you'll be able to find several books that interest you and can perhaps help you do your job better. I'll be working at the bookstore and whenever I do, the comment I hear most often is... "I had no idea there were so many books!".
The bookstore will be open Sunday October 25 thru Thursday October 29. There will only be a limited quantity of each book... so browse & buy early to avoid disappointment.
The following authors will be at the conference and will be available to sign your books. You can buy your book at the conference or bring a copy you already own. Remember that a signed copy of a book makes an excellent gift!
What's Up with Your Handshake?
Meet Mark at the IOD bookstore on Monday, October 26 from 11-12 or Tuesday October 27 from 1:30 - 2:30.
Viral Data in SOA: An Enterprise Pandemic
Meet Neil at the IOD bookstore on Monday, October 26 from 1:30 - 2:30
Promoting all three of his best sellers: Outliers; The Tipping Point, Blink
Meet Malcolm at the IOD bookstore on Wednesday, October 28 from 10:15-11:15
DB2 pureXML Cookbook
Meet Matthias at the IOD bookstore on Wednesday, October 28 from 1:30 - 2:30
As in previous years, we also have some free FLASHBOOKS that you can take. These books are very slim and easy to read and typically only available to conference attendees.
Information on Demand for Dummies
Authors: Judith Hurwitz, Fern Halper, Marcia Kaufman, Glenn Hintze, Adam Gartenberg
These books are only available to partners or customers. Exchange your coupon for a book.
Meet the authors on Monday October 26 from 2:30 - 3:30 at the IOD Bookstore
Break free with DB2 9.7: A Tour of Cost-Slashing New Features
Authors: Paul Zikopoulos, Belal Tassi, George Baklarz, Chris Eaton
Get your free book and meet the authors at the Mandalay Bay Registration Desk South on Tuesday, October 27 from 12 - 1
New Intelligence for a Smarter Planet - Driving Business Innovation with IBM Analytic Solutions
Authors: Bill Wong, Rex Wiederanders, Alan Meyer, Pat Bates, Mike Biere
Get your free book and meet the authors at the Mandalay Bay Registration Desk South on Wednesday, October 28 from 3:45 - 4:45
MDM for Customer Data : Optimizing Customer Centric Management of Your Business
Author: Kelvin Looi
Get your free book and meet Kelvin the Mandalay Bay South: Bayside D - Data Management Room
I know you may think it's too geeky to get your book signed... but the authors enjoy meeting people and talking about their books and related topics.
If you want more info about IOD... read Kate's blog. She's been doing an entire series about various aspects of the conference.
I hope to see you / meet you at the conference. If you are going, come and find me at the bookstore and tell me that you read my blog! I like talking to people too!
You've heard of IBM & Cloud Computing & Amazon.... what do the three have in common? For one, IBM & Amazon have joined together to bring you a FREE webinar about Cloud Computing.
IBM DB2 database software running on Amazon EC2 lets you get the most out of your IT budget . IBM and Amazon Web Services provide a lot of flexibility for cloud computing, including free DB2 AMIs, low cost by-the-hour production-ready DB2 AMIs, and the ability to bring your existing DB2 licenses to the cloud.
Attend the event to learn more about DB2 AMIs and the unique capabilities in DB2, including the new features in DB2 9.7 that make it much easier to move applications from Oracle to DB2.
Even better.... attend the event and get $35 in Amazon Web Services credits to practice everything you learned.
Jump start your skills to build Software as a Service (SaaS) offerings.
Learn why selecting a combination of industry-leading IBM software running on Amazon Web Services (AWS) allows you to focus all your resources on innovation instead of infrastructure.
Be sure to register for and attend the DB2 session at noon – 1pm Eastern Daylight Time where Mark Wilding and Leon Katsnelson will talk about a set of capabilities that are unique to DB2 and make it the best database for use on the Cloud.
Can't make it? Replays will be available but register to be sure you get notified when the replay is available!
Good luck Leon, Mark & others. I hope the event is a huge success! I'll be there!
The DB2Night Show Episode #2We're going to talk about Index Design Best Practices for both DB2 LUW and Oracle! So far we have one special guest lined up: Curt Triplett is an Independent Oracle Consultant specializing in Oracle performance optimization (amongst many other things). We're going to look at Oracle Index Best Practices and see how they compare to DB2. We're also working on a special guest from the IBM Toronto Lab to spice up this lively conversation.
Are you "Joe the DBA"? Do you have a performance challenge you'd like to discuss? Contact The DB2Night Show per the instructions found at left.
RESERVE YOUR Studio Audience FREE SEAT: Thursday, October 1, 2009 at 10am CENTRAL.
We will be broadcasting at your favorite screen resolution. For audio,
VoIP and local country telephone numbers will be available for US, Canada,
European countries, Australia, and New Zealand. You are responsible for your
transportation to our "Studio", popping your own popcorn, and your favorite
Save the date for the third episode:
The DB2Night Show Episode #3HIGH Availability or CONTINUOUS Availability? Join us as we discuss and debate HADR, HACMP, and Xkoto Gridscale. Ask questions of the experts. And find out some configuration settings and best practices to sustain high availability!
Show guests will include IBM Toronto and Xkoto experts - TBD.
RESERVE YOUR Studio Audience FREE SEAT:
Thursday, October 15, 2009 at 10am CENTRAL.
Did you miss the first episode? Catch it in re-runs:
Did you miss our Webinar on IBM DB2 LUW Index Design Best Practices and Case Studies? Access a recorded replay at http://www.DBIsoftware.com/media/20090812INDEXES.wmv (112MB)
Watching TV is good!
Educate. Inform. Entertain.
Today I launched a Certification Checklist on My Developerworks that you can use to track your progress on following the steps required to earn a certification: Getting Started Guide to DB2 Certification. You can use most of the steps in this checklist to track your progress for any IBM software certification, but many of the steps are specific to DB2. I would like to expand the list in the future, but started with the basics.
Please note that you'll need to be logged into My Developerworks in order to access and use the template.
What is a checklist template?
A Checklist template allows you to create a copy of the steps that must be take to achieve a specific goal (in this case to earn a certification). By creating a copy of the checklist, you are able to check off the tasks as you complete them (or if they are not applicable to you) so you can keep track of your progress. You can set specific deadlines for completing each step and use My Developerworks to keep you on top of the schedule.
This is the first checklist that I've created, so I'm sure there are areas for improvement. If you have suggestions for how I can improve this checklist, I'll be happy to hear from you.
Frances Pastuszenski was my mentor for creating this template and I encourage you to follow her checklist for "Getting Started with My DeveloperWorks" and to read her blog entry about her checklist.
svisser1 2700018UK9 Tags:  iod tutorials skills fired certification books 3 Comments 10,289 Views
I subscribe to many newsletters and was reading through them this week..... the one that caught my attention the most was this:
5 surefire ways to get fired by Denise Dubie
I don't want to get fired... and I'm sure most of you don't either! So, reading the article I found that one of the best ways to KEEP your job is by continually growing your skills! I can give plenty advice as to how you can grow your skills... and not all of them require a great deal of time or money!
I've blogged about how to get certified many times. The only thing I want to add at this point is that you can use the path to get certified as a roadmap for building skills. You will learn a lot but will also have validation that your skills are up to par by passing one or more certification exams. For further information on how to start, see my blog entry "Certification 101". To make it even more cost effective for you to get certified, we have Certification Days where exams are offered half price, and a Try it Again offer that allows you to retry your exam if you failed to pass. In my opinion, getting a certification is the FASTEST and most COST-EFFECTIVE way to build skills... bar none!
Travel is expensive, so take a look at the new way to take an IBM class where you choose the time, place, and best of all, no travel involved! Self-paced Virtual Classes are one option, ILO classes are another. Right now, you can take a free SPVC to see how it works.
Another very cost-effective way to build skills. You can buy a printed book, read a book online, borrow from a library... whatever works for you. There is a wide selection of books available... that cover just about every topic imaginable. For the entire list of books that we have available for Information Management topics, see either DB2 in Books or IM Bookstore. The online engines where you can read books are Books 24x7 or Safari Books Online. You can read more about these options in my blog entry.
OK... a conference is very expensive... but is it really? If you factor in all that you get when you attend a conference, you may find that it is very cost-effective. The IOD conference has free certification exams, 400 technical sessions, demos... not to mention networking! See Kate's blog for a series of entries about the IOD conference. Another option is to attend a virtual conference. I don't know of any that are scheduled at this moment...but when I learn about one, I'll blog about it. Sure it is quite different than attending a conference in person in a city away from your home / office, but it still provides some training, demos, and networking, but is usually free to attend.
So, please! Don't get fired because you've let your skills stagnate! Keep up to date with the many options that are available to you!
svisser1 2700018UK9 Tags:  redbooks high-availability db2 database_migration sap filenet 6,382 Views
Two new Information Management IBM Redbooks were published in August:
IBM High Availability Solution for IBM FileNet P8 Systems
Many organizations require almost continuous availability of their mission-critical, IBM® FileNet® P8 systems. Loss of system resources and services can translate directly into lost revenue and lost customers. The goal, therefore, is to design and implement IBM FileNet P8 systems that are highly available by compensating for both planned and unplanned system outages and eliminating single points of failure.
IBM FileNet P8 Platform provides availability features that are built-in to the core components. With these features, high availability of an IBM FileNet P8 system can be achieved through redundancy: redundant components, redundant systems, and redundant data. Hardware and software components might fail. With redundancy, the failure can be eliminated or minimized.
This IBM Redbooks® publication describes strategies and options for core IBM FileNet P8 system components. In addition, the book provides detailed, step-by-step procedures that we used to implement high availability for our case study IBM FileNet P8 system. This book serves as a practical reference when you design and implement highly available IBM FileNet P8 systems.
This book is intended for IT architects, IT specialists, project managers, and decision makers identifying the best high availability strategies and integrating them into the IBM FileNet P8 system design process.
SAP® migrations are a standard process nowadays. This IBM® Redbooks® publication describes optimization strategies and best practices for migrating SAP systems toward IBM DB2 for Linux, UNIX, and Windows, as well as for performing Unicode conversions. We discuss DB2-specific recommendations and best practices.
This book is intended for experienced SAP migration consultants involved in operating system and database migrations or Unicode conversions, choosing IBM DB2 as a target database platform. It addresses the advanced SAP migration techniques, considerations for database layout and tuning, and unique DB2 capabilities such as compressing the target database while loading data.
This book provides in-depth information about the best practices and recommendations for the source system database export, the advanced migration techniques, database layout and configuration, database import recommendations, SAP NetWeaver Business Warehouse, as well as background information about Unicode. We summarize our recommendations in one chapter that can be used as a quick reference for experienced migration consultants.Keep up with the latest technology with IBM Redbooks, which you can download for FREE!
We now have more than 2000 members of the ChannelDB2.com site! Are you one? I am... and I have joined many of the groups, created some groups and discussions. If you're not a member yet... take a look and consider joining.
What is ChannelDB2? It is a social networking site that collects people who are interested in IBM's database technologies. Members can build a network of "friends" as you can do on most social networking sites. What is unique is that there is an aggregate feed of a bunch of bloggers... so this is an easy way to keep up with all the latest news. There are videos, papers, presentations, photos, and free books that can be accessed from this site. Really it is the most complete collection of DB2-related content.
There are groups for niche groups. You can even create a group if you have a niche that you'd like to communicate with. I've noticed that the site is heavily used by students around the world who are trying to learn DB2, get certified on DB2, and perhaps looking for work too.
The group that I take part in the most often is DB2 in Books. Given that my job is to get books published, it isn't surprising that this is my group. I've invited every author who I've worked with to also join the group so you can interact directly with me or authors via this group.
Colleagues on my team run the certification, education, tutorials, and Redbooks programs as well, so I try to relay to you the information that I get from my team so that you are aware of the latest news as it happens.
I'm also actively working on the My developerWorks site to add content where needed. Right now there may be duplication between My developerWorks and ChannelDB2... but I'm sure that eventually one of these will become more prominent.
One question for you ... I'm happy to see that there are more than 2000 members to the site, but not many people have joined a group. I wonder why? If you are a member of a group you can take part in discussions and can control the amount of information you get back from the other group members.
So, if you aren't a member, I hope you check it out... and join: ChannelDB2.com.
And join a group! Specifically, join my group: DB2 in Books and add me as your friend!
See you on ChannelDB2!
I've just returned to the office from summer vacation and enjoyed unpacking the books that were sent to me - all three published through IBM Press this summer:
1) Viral Data in SOA: An Enterprise Pandemic
by Neil Fishman
If you are attending the IOD Conference, be sure to meet Neil and have him sign your copy of the book. Neil will be at the IOD Bookstore on Monday, October 26 from 1:30 - 2:30.
Neil is an information forensics expert and his book will help you identify the unique challenges of data quality in an SOA environment and show you how to implement solutions that deliver the best results for the long term at the lowest cost.
2) Understanding IBM SOA Foundation Suite - Learning Visually with Examples
by Tinny Ng, Jane Fung, Laura Chan, and Vivian Mak
Tinny, Jane, Laura and Vivian are technical specialists at the Toronto Lab and have used their inside expertise to pull together 26 video tutorials and sample code to help you master IBM SOA Software including IBM Rational Software Architect, IBM Rational Application Developer, IBM WebSphere Application Server, IBM WebSphere Service Registry and Repository, IBM WebSphere Integration Developer, IBM WebSphere Process Server, IBM WebSphere Message Broker, BIM WebSphere Portlet Factory, IBM WebSphere Portal, and IBM Tivoli Federated Identify Manager! Whew... that was a lot to type, and a lot to learn. This book makes it easy for you to learn this incredible suite of software in the quickest and easiest manner possible.
3) DB2 pureXML Cookbook: Master the Power of the IBM Hybrid Data Server
by Matthias Nicola and Pav Kumar-Chatterjee
If you are attending the IOD Conference, be sure to meet Matthias and have him sign your copy of the book. Matthias will be at the IOD Bookstore on Wednesday, October 28 from 1:30 - 2:30.
Matthias is a leading developer in the SVL Lab and Pav is a support analyst. Together they have combined their expertise to bring you 700 examples that cover the entire application lifecycle. You can easily adapt these examples to use in your environment. Learn and apply... the objectives of this book!
If you are at the IOD conference, you can buy these books at the conference discount. If you are not attending, here are some special offers that you should consider:
IBM Press is pleased to offer several new books as well as some of our most popular Information Management titles at a very attractive 35% discount. In addition, IBM Press is offering FREE ground shipping for all orders in the US. Simply enter coupon code INFOMGMT during checkout to receive your discount.
Remember that ALL IBM Press titles are available in electronic format so that you can purchase an online version to read or search rather than buying a printed copy.
Enjoy these books! If you have a comment about any of them... consider posting your opinions publicly.
Are you feeling left out that you are back to work and NOT back to school like so many others? Take one of the the Self-Paced Virtual Classes (SPVC) trials for free and you'll be "back in school" too!
What is SPVC?
Self-Paced Virtual Classes (SPVC) are recorded lectures, demonstrations and exercises that you can access on-demand. Meaning... you can take the class in the middle of the night if you like, wearing whatever you choose to wear, and wherever you choose to be (as long as you have high speed internet access! The classes are narrated by IBM classroom instructors.
What is the benefit of this type of class?
* Big savings with no travel costs and lower tuition
* Delivers same content, exercises and hands-on labs as classroom courses
* Instructors are included “virtually” through recorded lecture, demonstrations and exercises
* Conduct hands-on labs with real IBM software – not simulations
* Access to course Forums with expert feedback from instructors and fellow students
* Flexibility to train when and where you want
What is offered in the Free Trial?
The trial courses include a portion of a real course that, depending on the course, includes instructor lecture, demonstrations, and exercises.
The trial courses do not include access to the hands-on lab environments. However, a copy of the lab exercise books are included on the materials tab.
How do I get started?
Register at Free SPVC Trial.
After enrolling,you receive your access and login information by email. At your convenience, anytime within the next 30 days, log in and begin your course.
Once you login, your class material is presented as an integrated eLearning environment, with all course components in one easy-to navigate interface.
Begin your study by reading the course content and to reinforce key concepts, you are challenged to multiple interactive online exercises.
Enjoy the free trial and if you like it... let me (and others) know!
svisser1 2700018UK9 Tags:  certify test retake failed repeat again db2 certification 7,751 Views
Earning IBM Professional Certification is a smart career move. But many of us are nervous when taking the certification exam. Our “Take it Again” promo can help build your confidence. If you don’t pass an exam on your first attempt, you can retake it for no additional cost.
Take It Again is a voucher program, offered worldwide, by IBM Professional Certification.
With Take It Again you may purchase specially priced vouchers so that in the event you do not pass an exam on your first attempt, you may quickly and easily retake the same exam for no additional costs.
For all the information you will need to get certified... see my blog entry: Certification: 101
IDUG Solutions Journal July 2009 : Volume 17 Issue 2 provides Chapter 11 (Chapter 11 - Converting XML to Relational Data) for free from the book:
DB2 pureXML Cookbook: Master the Power of IBM's Hybrid Data Server
Authors: Matthias Nicola, Pav Kumar-Chatterjee
In DB2 pureXML Cookbook, two of IBM's leading experts provide the single most comprehensive coverage of DB2's pureXML capabilities. This book explains DB2 pureXML in over 700 practical examples, including 250+ XQuery and SQL/XML queries, taking the reader from simple introductions all the way to advanced scenarios. The authors have distilled their hands-on experience with many pureXML applications so that you can benefit from best practices, tips & tricks, performance guidelines, and other gems that are not documented elsewhere.
This book is invaluable for database administrators and application developers, beginners and DB2 experts. The topics are organized by typical user tasks throughout the life cycle of XML database projects, from planning, designing, and implementing databases all the way to tuning, problem determination, and application development. It includes code samples for Java, .NET, COBOL, PL/1, C, PHP, and Perl programmers.
The DB2 pureXML Cookbook provides proven recipes rather than a mere reference of ingredients.
DB2 pureXML Cookbook: Master the Power of the IBM Hybrid Data Server
Use Coupon Code when checking out:
I'm expecting this book to be a BEST SELLER this year! Make sure you get your copy before they run out! Also, meet Matthias Nicola and get your book signed at theIOD Global Conference.
Have you seen this exciting news:
DBI is sponsoring a new virtual TV Show "The DB2Night Show". Your host will be Scott Hayes and we hope he further develops his sense of humor!
Like many TV and Radio Shows, each segment will include fun stuff, education, tips, and special guests. The DB2Night Show will reach out to various industry experts for their participation. We will also be seeking guests from the DB2 LUW User Community - yes, that's right, you could be on our show! We want to take questions from viewers and possibly even help solve DB2 mysteries. Would you like over 100 DB2 LUW professionals to help you solve your toughest DB2 challenges? If you are interested in being on The DB2Night Show, please send an email to firstname.lastname@example.org.
The DB2Night Show has a Twitter account - please follow twitter.com/db2nightshow for the latest news about new episodes and interactive discussion. Use the hash tag #DB2Night in your Tweets.
Episode #1 will include two very special guests:
Drew Bradstock with the IBM DB2 Toronto Lab will share with us his "Top 10 Coolest Things about DB2 9.7".
Rebecca Bond, published author of Understanding DB2 9 SecurityUnderstanding DB2 9 Security, Independent Consultant, Full Time Shoe Collector, and part time comic will also share with us her "Top 10 DB2 LUW Security Tips"
Scott Hayes promises to share his "Top 10 Ways to Know if your DB2 LUW Database is Toast".
We're going to go to a shopping mall and ask random people what they think and know about DB2, if they've heard of IBM, and how they are contributing to a Smarter Planet.
To register: http://bit.ly/db2ontv
We hope you will join us and participate as a guest or via twitter.com/db2nightshow. The more people we have involved during the recording of the show, the more fun we'll have.
If you can't make the scheduled time, register anyways so that you get information about recorded replays. Lastly, please forward this invitation to at least 5 of your friends! We can keep this FREE with your help!
Good luck Drew, Rebecca and Scott! I hope Episode 1 is a huge hit so we can have many more similar events!!
Over the past month, I've written several entries to help you get certified. This posting lists all of those entries and makes it easy for you to navigate through some of the material. I'll repost or update this entry as I go. I hope you find this useful.
Benefits of Earning a Certification
New in Certifications
How to Prepare to Pass a DB2 Certification
Details about DB2 Certification Program
Once you are Certified... What Next?
Study Materials Electronically
Roger Sanders Books, Videos, and Crammer Course
Kate's blog where you'll find details on the Certify & Save program, as well as the Upgrade exam.
ChannelDB2 for individual groups that you can join to learn and / or discuss topics.