I arrived in California at noon on Sunday for the conference and was pleasantly pleased with how warm the weather is here compared to Toronto! I arrived just in time to organize the signing of Devon Harris's book "Yes, I can". It was amazing to meet Devon and he clearly is inspirational. His talk was at 8 am on Sunday morning, so unfortunately many people weren't able to attend his talk. I hope that if you have a future opportunity to meet or hear Devon that you take it!
Sunday night the opening reception was held in the Expo area and the band "Toxic Audio" played. They are five lovely accapella singers who have an amazing amount of energy! The music was beautiful and the band was fun to listen to. We had a signing for their CD after their show, but unfortunately it was in a very bad location so we had very few people. The band was a good sport about it anyway.
Now work stuff.... I met up with Berni Scheifer on the plane and he gave me a few performance related topics to blog about that I'll get to later. Ellice Uffer, my colleague on IBM Press, tells me that she has self-published a book about her puppy... when I get her website I'll post it.
I spent some time with conference organizers Carolyn Woods and Bonnie-Lynn Murphy to go over some logistics for the next couple of days. Apparently Carolyn wore a pedometer to the conference and clocked 13 miles in a single day!
It makes for a very long day traveling from Toronto to Anaheim and working at a conference until 10 pm!
more to come.....
Keep on Learning
svisser1 2700018UK9 2,634 Views
svisser1 2700018UK9 2,612 Views
Wayne Brady from the TV show "Whose Line is this Anyway?" was the host of the keynote session this morning. He was hilarious! He had us laughing so hard that it hurt. The funniest scene was with an audience member named Mark who "was wearing Friday casual on a Monday". Ambuj Goyal delivered the keynote interspirsed with interesting video customer references. Likely the most memorable was one from Harly Davidson.
No one introduced the female rap singer who performed during the opening. She did wonderful job of working in tons of IBM related terms into a rap song. If anyone knows who she was, let me know.
I had another Devon Harris book signing starting at lunch time. Many books were sold and it was interesting to hear how moved everyone was with his story. By the way... the movie Cool Runnings that was based on the Olympic Jamaican bobsled team that Devon was part of.... was fiction..... and there are four "original" bobsleds spread across many locations in the world! Devon emailed me with his newsletter and to tell me that his flight was delayed and he spent 5 hours in LAX waiting for his flight to NY.
My big event of the week took place after Arvind Krishna's keynote about data servers. I had arranged to have every attendee of Arvind's session receive a copy of the "Introduction to DB2 9 New Features" book that is an abridged version of the McGraw-Hill book that will be published in December written by Paul Zikopoulos, Chris Eaton, George Baklarz, and Leon Katsnelson. George isn't at the conference this week, but the other three were really good sports at signing hundreds of books! The biggest complaint I heard is that Leon's signature is illegible! I hope you enjoy reading the book!
After the session, I delivered left over copies to the Hilton hotel where the executive sessions are taking place. Bruno Bagala helped me find suitable locations for the books. I managed to make it back to the Expo before the Hampton String (Rock) Quartet were finished playing and got a bite to eat before the Gladys Knight concert. Hampton String Quartet were amazing! They play extremely well known rock songs with string instruments. Definately worth checking out!
Gladys Knight was also amazing. I knew fewer songs than I thought I would but she has a very sweet personality. It was funny when she made a comment about the audience being at show with people who they loved. We all laughed.... since we were actually there with our co-workers....
After the concert I went to the party in James Sobieski's party at the Hilton. I walked to the party with Sandra Beattie, Terry Mason, and Susan Gausden. There was no shortage of food at this party! I ate as much as I could before I was too tired. I spent a bit of time talking to my good friend Catalin Comsia. I loved hearing his story about his races and soccer. If you know Cat, ask him about being offered a new job as a soccer goalie!
I was also invited to Frank Filmore's party, but unfortunately I ran out of steam before I was able to make it there..... I hope I'm able to spend time talking to Frank and Ray before the week is over.
svisser1 2700018UK9 2,685 Views
Have you had a chance to check out the IBM Information Server Guided Tour and Demo? It provides a graphic "guided tour" and demonstration of IBM Information Server that was announced at the IOD conference.
To get to the demo: http://www.ibm.com/software/sw-library/en_US/detail/N182391G31164I31.html
I'm way behind on my blogging, but plan to get back on track today!
At the IOD conference, we lauched two brand new DB2 certifications. Exam 730 DB2 9 Fundamentals and Exam 731 DB2 9 Database Administration.
• New DB2 9 Fundamentals Professional Certification Now you can validate your skills and demonstrate your proficiency on IBM DB2 9 technology by becoming an IBM Certified Database Associate - DB2 9 Fundamentals. To achieve this new level of certification, candidates must take and pass the brand new exam DB2 9 Fundamentals- Exam 730. See http://www.ibm.com/certify/certs/dbda9fun.shtml for details on the exam objectives, cutscore, number of questions, and more.
• New DB2 9 DBA for Linux UNIX and Windows Professional Certification Demonstrate your DBA proficiency on IBM DB2 9 technology by becoming an IBM Certified Database Administrator – DB2 9 DBA for Linux, UNIX and Windows. To achieve this new level of certification, candidates must take and pass the brand new exam DB2 9 DBA for Linux, UNIX and Windows- Exam 731. See http://www-03.ibm.com/certify/certs/dbdadba.shtml for details on the exam objectives, cutscore, number of questions, and more.
The books to help you prepare these exams are currently being written. In the meantime, I suggest that you study via the tutorials that have been created: http://www.ibm.com/software/data/education/selfstudy.html#5
These tutorials provide a solid base for each section of the two new DB2 9 Professional Certification exams which have just been released. There is a series of 7 tutorials developed to help you prepare for the new DB2 9 Fundamentals Exam, 730 and a series of 7 tutorials developed to help you prepare for the new DB2 9 DBA for Linux Unix and Windows Exam 731. After a quick registration, you can begin a tutorial. Each tutorial should take about an hour to complete. You can take the tutorials on-line, or download a PDF or zip file.
Tomorrow I'll tell you about some of the other new exams that were recently launched and will tell you about the exams that are under development.
Have you heard of the DB2 Detective Game? I was part of a small team that created this game a few years ago with the objective of teaching people how to query a DB2 database. Our original audience was a SHAD Valley group of high achieving high school students (http://www.shad.ca/). One of the people on our team was a former SHAD grad who was on a coop term at IBM. Teaching the students was an amazing experience. They like the competitiveness of playing a game, but it was astonishing how quickly they picked up the skill of writing queries to get important information from the database.
The game has gone through many iterations of improvements and is now called the DB2 business game and is available on developerWorks for all to "play". Give it a try....
Here are the details:
The DB2 business gamehttp://www.ibm.com/developerworks/edu/dm-dw-dm-0609cao-i.htmlTest your DB2 querying skillsLevel: Introductory
If you're a beginner with IBM® DB2® and SQL, you may wonder how the technical skills you're learning are used in the "real world." Here is a chance for you to put your DB2 SQL skills into play in this interactive game! Jump into a "run your own business" scenario, where your company's future depends on a key report needed to secure funds for a critical upgrade. Use your relational database skills to build this report.
Put your DB2 SQL skills into play using a "real world" business scenario.
svisser1 2700018UK9 2,887 Views
Coming soon to an online bookstore near you: http://www.amazon.com/Understanding-DB2-Security-Rebecca-Bond/dp/0131345907
Understanding DB2 9 Security (Hardcover) by Rebecca Bond, Kevin Yeung-Kuen See, Carmen Ka Man Wong, Yuk-Kuen Henry Chan
Rebecca is a long time consultant who works on DB2 projects. Kevin, Carmen and Henry are employees of the Toronto Lab who have built expertise in Security. You may be read articles on dWorks from Kevin, Carmen or Henry:
By Kevin: DB2 UDB security, Part 2: Understand the DB2 Universal Database security plug-ins Learn about the DB2 UDB security plug-ins, a new feature introduced in version 8.2. This article explains what the security plug-ins accomplish and teaches you how to enable and write your own security plug-ins. http://www.ibm.com/developerworks/db2/library/techarticle/dm-0512chong/
DB2 UDB security, Part 6: Configure Kerberos for authentication on DB2 UDB for Linux, UNIX, and Windows Using Kerberos for authentication provides a central repository for user IDs (or principals), thus centralizing and simplifying principal or identity management.http://www.ibm.com/developerworks/db2/library/techarticle/dm-0603see/
DB2 security, Part 7: Object ownership management for DB2 9 Transfer ownership is a new DB2 9 feature where the ownership of a database object can transfer to another authorization ID (authid). There are two general usages for this feature. http://www.ibm.com/developerworks/db2/library/techarticle/dm-0608see/
DB2 security, Part 10: Deploy customized security plug-ins in DB2 9 Determine what should be tested before deploying your own customized security plug-ins. Accompanying this article, there is a security plug-in loader program. This article also discusses how to take advantage of the new enhancements to the security ... http://www.ibm.com/developerworks/db2/library/techarticle/dm-0610see/
DB2 Label-Based Access Control, a practical guide, Part 1: Understand the basics of LBAC in DB2http://www.ibm.com/developerworks/edu/dm-dw-dm-0605wong-i.html
DB2 label-based access control: A practical guide, Part 2: A step-by-step guide to protect sensitive data using LBAChttp://www.ibm.com/developerworks/edu/dm-dw-dm-0605wong2-i.html
Co-author on one of the articles from Kevin: DB2 UDB security, Part 6: Configure Kerberos for authentication on DB2 UDB for Linux, UNIX, and Windows Using Kerberos for authentication provides a central repository for user IDs (or principals), thus centralizing and simplifying principal or identity management.http://www.ibm.com/developerworks/db2/library/techarticle/dm-0603see/
Order the book at a discount from http://www.ibmpressbooks.com/bookstore/product.asp?isbn=0131345907&rl=1
svisser1 2700018UK9 2,682 Views
Attendees at the IOD conference had an opportunity to pick up a complementary copy of the book: "Information on Demand; Introduction to DB2 9 New Features". Our nickname for the book is "flash book". Here is a link to the flash book: http://books.mcgraw-hill.com/getbook.php?isbn=0071487832&template=
There was plenty of excitement the day we gave out the flash book and had three of the four authors available to sign copies. People were carrying the flash book with them as it is very small and portable. And I heard many positive comments about the content as well. Our intention for creating this flash book was to provide a very quick introduction to the latest features, from a business perspective. And... our goal was achieved.
This flash book is actually an abridged version of the soon-to-be published McGraw-Hill book: "IBM DB2 9 New Features". You are able to pre-order this book at a 40% discount: http://www.superbookdeals.com/IBMDB2-9. You've probably heard of all four authors as each of them is very active with customers, at conferences, and as authors: Paul Zikopoulos, Chris Eaton, George Baklarz, and Leon Katsnelson.
This book will provide you with comprehensive technical details and real-world business uses for all of the new features in DB2 9. You'll learn about the capabilities found in pureXML as well as administrative enhancements in areas such as self-management, high availability, and security. Also covered are features for the developer from a Ruby on Rails toolkit for the Developer Workbench and enhanced .NET developer support.
If you were lucky enough to receive a flash book, let me know what you think of it.... and if not, please consider buying the full version of the book at a 40% discount.
svisser1 2700018UK9 2,628 Views
Another custom book that we created for the IOD conference was called "DB2 9: pureXML Overview and Fast Start". This book was also in a very small printed format that is a collection of key papers about XML. We ran out of these books at the conference as well and continue to get requests for additional copies.
Fortunately for this book, we used the ITSO to create an electronic format of the book, so you are still able to read the content: http://www.redbooks.ibm.com/abstracts/sg247298.html?Open
Thanks to Rav Ahuja for initiating this custom book. I'm working on another one right now that I'll tell you about when it gets closer to becoming reality :)
svisser1 2700018UK9 2,621 Views
Many questions are coming up asking about training resources and certifications for XML. This is a great sign that people are embracing pureXML in DB2 9 and are looking at ways to becoming super users!
Thanks to our Training Segment manager Pat Moffatt for providing this list of XML courses:
1) DB2 9 for Linux, UNIX, and Windows Transition (CG09) This is an intermediate course for database administrators, application designers, technical support, and technical specialists who require information about the features and function of DB2 9 for Linux, UNIX, and Windows.http://www.ibm.com/jct03001c/services/learning/ites.wss/us/en?pageType=course_description&includeNotScheduled=y&courseCode=CG090
2) Query XML Data with DB2 9 (CG10)This is a basic course for end users and anyone interested in learning how to retrieve native XML data and perform text searching of native XML.http://www.ibm.com/jct03001c/services/learning/ites.wss/us/en?pageType=course_description&includeNotScheduled=y&courseCode=CG100
3) Querying and Administering XML Data with DB2 9 (CG13)This is an intermediate course for database administrators and anyone interested in learning how to handle native XML data in DB2.http://www.ibm.com/jct03001c/services/learning/ites.wss/us/en?pageType=course_description&includeNotScheduled=y&courseCode=CG130
Coming in 2007 is a self-study course to cover XPath/XQuery.
As for certifications, there are questions about XML built into the DBA and AD exams as part of the DB2 program, but no specific XML exam. IBM does have a certification stream for XML, but it wasn't designed with DB2 in mind, but it should still help verify the XML skills a person has. Here are the details regarding the exam: http://www.ibm.com/certify/certs/xmsdreltop.shtml
Redbooks and retail books:
"DB2 9 pureXML Guide" http://www.redbooks.ibm.com/abstracts/sg247315.html?Open"DB2 9: pureXML Overview and Fast Start" http://www.redbooks.ibm.com/abstracts/sg247298.html?Open"DB2 9 New Features" http://www.superbookdeals.com/IBMDB2-9
Take the time now to become an expert in XML... these skills are in very high demand!
svisser1 2700018UK9 2,684 Views
This is a cool new way to learn about the latest IBM products and technology: IBM TV: http://www.ibm.com/software/info/ibmtv
IBM TV is a one-stop IBM location for all media related to IBM Software solutions: Audio, Video, Demos, Events, and a lot more.
IBM TV provides an easy, fast and interactive way to access media about a variety of software topics. Browse the content by business need, media type or hot topic (such as Service-Oriented Architecture or Information Management) to find exactly what you need, when you need it.
On-line host, Joe Washington, gives a top-level view of what's happening on IBM TV, so you can decide what you want to watch, listen to or do. Then dive in and experience rich media designed with your business needs in mind.
svisser1 2700018UK9 2,799 Views
Have you signed up for the IBM Press newsletter? The copy that came out today has part of the interview with Rebecca Bond, lead author of the soon to be published book... the FIRST retail book to cover VIPER / DB2 9 content:
Understanding DB2 9 Securityby Rebecca Bond, Kevin Yeung-Kuen See, Carmen Ka Man Wong,and Yuk-Kuen Henry Chan
Understanding DB2 9 Security is the only comprehensive guideto securing DB2 and leveraging the powerful new securityfeatures of DB2 9. Direct from a DB2 Security deploymentexpert and the IBM DB2 development team, this book givesDBAs and their managers a wealth of security informationthat is available nowhere else. It presents real-worldimplementation scenarios, step-by-step examples, and expertguidance on both the technical and human sides of DB2security.
To read the interview, visit: http://www.ibmpressbooks.com/promotion/3977
To subscribe to the IBM Press newsletter, visit: http://www.ibmpressbooks.com/newsletters
svisser1 2700018UK9 2,550 Views
Download the latest DB2 9 Express-C software for free.... this new version of DB2 is tailored for the new Windows Vista operating system and openly available for download, at no cost, to customers, developers and partners. Current editions of DB2 Express-C supports the Windows and Linux operating systems on various 32-bit and 64-bit processor architectures.
DB2 Express-C enables and supports the growing community of DB2 developers and customers, making it easier for them to create and deploy applications and solutions that meet their changing information management requirements regardless of platform or OS changes.
DB2 9 Express-C offers the same core DB2 9 data server found in other editions, in a smaller package specifically designed for use in software development, deployment, redistribution and embedding within applications. No charge community support for DB2 Express-C is available via www.ibm.com/db2/express. For-fee IBM support is available with the purchase of DB2 Express Edition.
DB2 Express-C for Vista provides developers with the industry's first no-cost, fully functional relational and pureXML data server to use for developing and deploying applications on the new Windows platform.
See http://www.ibm.com/press/us/en/pressrelease/20735.wss for the official announcement.
svisser1 2700018UK9 2,582 Views
Are you trying to prepare to pass certification exam 443 (http://www.ibm.com/certify/tests/obj443.shtml)? You'll be happy to know that a series of articles are now available to prepare you to pass the IBM® DB2® Content Manager V8.3 certification exam 443.
These articles provide a strong foundation for educating yourself on DB2 Content Manager, from understanding how to gather requirements for your content management system, to learning about the core products, to tuning and administering, to troubleshooting.
To get to the articles, go to this url: http://www.ibm.com/developerworks/db2/library/long/cmcertification/The articles were written by Karensa Jablonka, Mary Desisto, and Michael Lowe.... all long term content manager experts.
Good luck on the test!
svisser1 2700018UK9 2,663 Views
Although we haven't had a tremendous number of retail books published this year, there are several key ones that I'd like to tell you about. The titles are not listed in any particular order:
Information on Demand Introduction to DB2 9 New Featuresby Paul Zikopoulos, Chris Eaton, George Baklarz, Leon Katsnelson (flashbook)
This one was a custom book that we did for the IOD conference. You cannot buy individual copies like most books, but if you want a stack of the books, that can be accomodated... send me a note if you do want to pursue a bulk order.
DB2 9:pureXML Overview and Fast Startby Cynthia Saracco, Don Chamberlin, Rav Ahuja
This was also a custom book, where hardcopies were handed out at the IOD conference. We're out of hardcopies, but can print more if we had the demand. We also have the content loaded on the redbook site for all to read electronically.
Introduction to SQL: Mastering the Relational Database Language (4th Edition)by Rick Vanderlans
This is the 4th edition of a popular university text book that was written by an IBM Gold Consultant. The book doesn't cover XML, but is an excellent book to help new comers learn SQL.
Refactoring Databases: Evolutionary Database Design (The Addison-Wesley Signature Series)by Scott Amber and Pramod J. Sadalage
This book is written from a design perspective. It's not specifically about DB2, but will help you design your databases for improved performance.
SQL Pocket Guideby Jonathan Gennick
This is an excellent small reference book that covers SQL across all relational database products.
Understanding DB2 9 Securityby Rebecca Bond, Kevin Yeung-Kuen See, Carmen Ka Man Wong, Yuk-Kuen Henry Chan
This is our first official published book on DB2 9! Everything that you should know about the security features in DB2 9, plus much more. This book will help you consider all of the actions that must be taken to ensure that your data is well protected from various threats.
IBM DB2 9 New Featuresby Paul Zikopoulos, George Baklarz, Leon Katsnelson, Chris Eaton
Coming in January... not only a listing of the latest DB2 features but a good way for you to learn how to use the new features so that you can begin realizing significant business benefits.
svisser1 2700018UK9 2,744 Views
With the end of the year come lists… lists of all the accomplishments made throughout the year. A few posts ago I listed all of the retail books that were published in 2006. This post lists the redbooks that published this year… and what a list! Thirty books that span the wide range of topics in the Information Management area. I’m sure there is a book that would be valuable to you and others you know.
Congratulations to everyone who was involved in producing these 30 books. No small feat!
DB2 9: pureXML Overview and Fast Start
DB2 Express-C: The Developer Handbook for XML, PHP, C/C++, Java, and .NET
Developing PHP Applications for IBM Data Servers
DB2 Performance Expert for Multiplatforms V2.2
Coupling Facility Performance: A Real World Perspective
IBM DB2 Recovery Expert for Multiplatforms V2 Usage Guide
Powering SOA with IBM Data Servers
LOBs with DB2 for z/OS: Stronger and Faster
DB2 Recovery Expert for z/OS User Scenarios
Data Integrity with DB2 for z/OS
WebSphere Replication Server for z/OS Using Q Replication: High Availability Scenarios for the z/OS Platform
Disk storage access with DB2 for z/OS
DB2 UDB for z/OS: Design Guidelines for High Performance and Availability
A Deep Blue View of DB2 Performance: IBM Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS
Leveraging DB2 Data Warehouse Edition for Business Intelligence
Improving Business Performance Insight . . . with Business Intelligence and Business Process Management
Dimensional Modeling: In a Business Intelligence Environment
Stored Procedures, Triggers, and User-Defined Functions on DB2 Universal Database for iSeries
The Ins and Outs of XML and DB2 for i5/OS
Preparing for and Tuning the SQL Query Engine on DB2 for i5/OS
SQL Performance Diagnosis on IBM DB2 Universal Database for iSeries
Moving Forward with the On Demand Real-time Enterprise
How does the MIDAW facility improve the performance of FICON channels using DB2 and other workloads?
Performance Tuning for Content Manager
Content Manager OnDemand Guide
Content Manager Implementation and Migration Cookbook
WebSphere Replication Server Using Q Replication High Availability Scenarios for the AIX Platform
IBM DB2 Document Manager with IBM Records Manager Solution Guide
E-mail Archiving and Records Management Integrated Solution Guide Using IBM DB2 CommonStore and DB2 Records Manager
IMS Connectivity in an On Demand Environment: A Practical Guide to IMS Connectivity
Publishing IMS and DB2 Data using WebSphere Information Integrator: Configuration and Monitoring Guide[Read More]