Pearson Education, the publisher for the latest IBM Press book, Understanding DB2 9 Security has just issued an online coupon for this book, and I wanted to let you know first:
Coupon Expires: June 30, 2007Use code BOND5907 during the checkout step.Discount: 35% offISBNs: 0131345907 Understanding DB2 9 Security
If you've read the book and liked it, post here or in amazon to let others know!
Keep on Learning
svisser1 2700018UK9 2,658 Views
svisser1 2700018UK9 3,724 Views
Here's another very long list for you.... this one lists all of the tutorials that were created on dWorks in the past year. Tutorials are very popular learning resources and they now cover most of our product areas. Check them out, or pass this information onto someone who you think would benefit from finding these learning materials.
Data Servers Cross Product The ultimate mashup, Part 6: Give the user control DB2 9 Fundamentals exam 730 prep, Part 1 DB2 9 Fundamentals exam 730 prep, Part 2 DB2 9 Fundamentals exam 730 prep, Part 3 DB2 9 Fundamentals exam 730 prep, Part 4 DB2 9 Fundamentals exam 730 prep, Part 5 DB2 9 Fundamentals exam 730 prep, Part 6 DB2 9 Fundamentals exam 730 prep, Part 7DB2 XML evaluation guide DB2 EveryplaceBuild end-to-end DB2 Everyplace mobile applications
DB2 for LUWDB2 9 table partitioningHello World, Part 7: DB2 for Linux, UNIX, and WindowsDevelop proof-of-concept .NET applications, Part 5: Create and consume Web services Kick-start takes you to the movies, Part 2 DB2 9 self-tuning memory management Shrink your database using DB2 9 row compressionDB2 Developer Workbench, Part 3: Developer Workbench and XMLThe ultimate mashup, Part 5: Change out Web servicesInformation on Demand Global Conference Web 2.0 Personal PlannerKick-start your J2EE apps using DB2 9 with pureXML and WebSphereSet up an SQL realm with DB2 Express-C, and WebSphere DB2 Developer Workbench and stored proceduresCreate XML-based stored procedures using the DB2 Developer WorkbenchSQL and XQuery tutorial for IBM DB2, Part 7: XML and XQuerySQL and XQuery tutorial for IBM DB2, Part 5: Data comparison SQL and XQuery tutorial for IBM DB2, Part 6: Data definition language and data control language The ultimate mashup, Part 1: Use and combine Web servicesDevelop a personal movie database app based on PHP and DB2 Create an XML-based Java application using DB2 9SQL & XQuery tutorial for IBM DB2, Part 4: Data analysisDB2 Developer Workbench concepts and basic tasksSQL & XQuery tutorial for IBM DB2, Part 3: Joins and unionsWire your application to DB2 pureXML data (Part 4)SQL & XQuery tutorial for IBM DB2, Part 1: Introduction to Aroma and SQLSQL & XQuery tutorial for IBM DB2, Part 2: Basic queriesDocument-level security using DB2 9 pureXML and LBAC DB2 9 DBA certification exam 731 prep, Part 1 DB2 9 DBA certification exam 731 prep, Part 2 DB2 9 DBA exam 731 prep, Part 3 DB2 9 DBA exam 731 prep, Part 4 DB2 9 DBA exam 731 prep, Part 5 DB2 9 DBA exam 731 prep, Part 6 DB2 9 DBA exam 731 prep, Part 7 Develop proof-of-concept .NET applications, Part 2 Develop proof-of-concept .NET applications, Part 3 Tutorial: DB2 label-based access control, a practical guide, Part 2: A step-by-step guide to protect sensitive data using LBAC Create database objects in DB2 Viper using .NET Integrate DB2 Express-C in apps with ActiveGrid LAMP StudioTutorial: Build Web services using IBM Database Add-ins for Visual Studio 2005: Highlights of the refreshDevelop DB2 applications using persistence-based frameworksDB2 and Rational: Working together, Part 2 Tutorial: Develop and test SQLJ programs for DB2 using Rational Application Developer Developing DB2 UDB User Defined Functions with .NET
DB2 for z/OSCreate z/OS procedures with Database Add-Ins for Visual Studio 2005
IMSIntegrate an IMS transaction into a Business Process Execution Language process
Classics/4GL/EGLCut out the Middle-Man: Use Informix Dynamic Server with J/Foundation to host a Java application service
CloudscapeApache Derby resources from the Web services perspective, Part 2: Producing and consuming WS-Notifications with DerbyApache Derby resources from the Web services perspectiveGet a head start with JDBC 4.0 using Apache Derby
U2A Hitchhiker's Guide to the UniVerse, Part 4: File and performance implicationsA Hitchhiker's guide to the UniVerse, Part 3Travels with Mark: A Hitchhiker's Guide to the UniVerse, Part 2: Sizing hashed files in UniVerse
Content ManagerContent Manager V8.3 Certification Exam TutorialsSearch legacy data sources
Document ManagerGet started with DB2 Document Manager, Part 2DB2 Document Manager: Build a simple client application (Tutorial)
OmniFind Discovery ServerStore selected OmniFind analysis results to a relational database
OmniFind Enterprise EditionSemantic search in IBM OmniFind Enterprise Edition, Part 2
DataStageIntegrated access to application data
Information IntegratorFederation Configuration Wizard
MDM-WebSphere Product CenterWebSphere Product Center - First steps
svisser1 2700018UK9 2,852 Views
I was just reminded yesterday about a blog entry that I read early last year about the book Understanding DB2(R): Learning Visually with Examples. The entry was from James F. Koopmann. The statement that I found most interesting was this:
Now it has been close to 15 years since I worked with DB2 on MVS and have over the years wanted to pick up DB2 again. But having enough time to pull away from Oracle and all the projects I seem to be doing never really gave me the opportunity. Honestly I can say that I am glad I waited. If I would have started with any other book instead of Understanding DB2 I may have gotten discouraged.
One of the best parts of reading this book was that it went into just enough detail for experienced database practitioners to obtain a clear understanding of the components of DB2. Often I was able to easily relate my Oracle, and old DB2 experience, to the concepts in this book. This made learning even easier. This is no easy. I am not even sure that the authors of this book sought out to do. But I can tell you from experience that I have in the past tried to relate database systems, such as Oracle, DB2, SQL Server, and Sybase, together and it is not an easy task to find the information needed. This book cuts through the chase and quickly and easily points out the physical and logical components of DB2 that now allows me to do this.
One of our training courses that was created specifically for those trained on other relational databases has been recently update and is another good way to expand existing skills to include DB2: CF282 Fast Path to DB2 9 for Experienced Relational DBA * Classroom * 3 Days *
svisser1 2700018UK9 2,907 Views
I started my career in database as a technical writer working on the Toronto Information Development team. This is the team of people who create the documentation that is available to support the product in manuals and online help. The team of people has changed much since I left 9 years ago... and the sheer volume of information that the team creates is incredible! I hope the job is as much fun now as it was during my 6 years.
(Interesting side note: One of the technical writers who is back on the team on an assignment is sci-fi author Karl Schroeder. Welcome back Karl!)
To see of list of the manuals that are available to support DB2 9, click List of DB2 Manuals. Here is the large number you can select from :
Release Notes * Release Notes for Fix Pack 1 * Net Search Extender Release Notes
Getting started * What's New * Quick Beginnings for DB2 Clients * Quick Beginnings for DB2 Servers * Getting started with DB2 installation and administration on Linux and Windows * Migration Guide
Administration * Administration Guide: Planning * Administration Guide: Implementation * Data Movement Utilities Guide and Reference * Data Recovery and High Availability Guide and Reference * National Language Support Guide and Reference * Performance Guide * Query Patroller Administration and User's Guide * Spatial Extender and Geodetic Data Management Feature User's Guide and Reference * System Monitor Guide and Reference * Troubleshooting Guide * XML Guide
Application development * Getting Started with Database Application Development * Developing ADO.NET and OLE DB Applications * Developing Embedded SQL Applications * Developing Java Applications * Developing Perl and PHP Applications * Developing SQL and External Routines * XML Extender Administration and Programming
Reference * Administrative API Reference * Administrative SQL Routines and Views * Call Level Interface Guide and Reference Vol.1 * Call Level Interface Guide and Reference Vol.2 * Command Reference * Precompiler Services APIs * Message Reference Vol.1 * Message Reference Vol.2 * SQL Reference Vol.1 * SQL Reference Vol.2 * XQuery Reference
Tutorial * DB2 Visual Explain Tutorial
Additional component information * DB2 Connect * Quick Beginnings for DB2 Connect Servers * Quick Beginnings for DB2 Connect Personal Edition * DB2 Connect User's Guide * IBM WebSphere Information Integration * Administration Guide for Federated Systems * ASNCLP Program Reference for Replication and Event Publishing * Configuration Guide for Federated Data Sources * SQL Replication Guide and Reference
Of course the standard these days is to deliver PDF versions of the manuals, but for those of you who like to have a printed copy sitting on your desk for easy access, you can buy printed / bound copies (in many but not all countries or regions) from the IBM Publications Center.
To order printed DB2 manuals: Order Printed DB2 Manuals.[Read More]
svisser1 2700018UK9 3,062 Views
Happy New Year to Everyone!
A series of new certification roadmaps have been created to help you find your way around the latest exams that are available to support the newest product releases for Information Management Software.
This series of certification roadmaps will help you define and map out your certification path for a variety of job-related certifications for our Information Management software products.
These roadmaps are designed to provide a comprehensive, concise view of all the exams and roles available as well as provide you with the most efficient path to achieve the various levels of certification. Once you earn one or more of these certifications, you earn the right to display the Information Management professional certification mark.
The roadmaps fall into the following categories:
Content Management and Discovery Content Manager V8.3 => Exam 443 Content Management On Demand => Exam 444 Content Management Document Manager => Exam 445 (currently under development) DB2 9 Family Fundamentals => Exam 730 Database Administration for DB2 on Linux, Windows and UNIX => Exam 731 Database Administration for DB2 on z/OS => Exam 732 (currently under development) Application Development => Exam 733 (currently under development) Advanced Database Administration => Exam 734 (currently under development)
Dynamic Data Warehousing and Business Intelligence IBM Alphablox => Exam 715 Business Intelligence Solutions => Exam 705 DB2 Data Warehouse Edition => Exam 716 Information Integration Websphere IIS QualityStage V7.5 => Exam 416 WebSphere IIS DataStage Enterprise Edition V7.5 => Exam 415 Informix Informix Dynamic Server V9 => Exam 915 Informix 4GL V10 => Exam 917 Red Brick™ Warehouse => Exam 914 U2 U2 Family => Exam 713 UniVerse V10 => Exam 714 UniData V6.1 => Exam 711 To access the roadmaps, click Certification Roadmaps
I hope that the new year brings you and your family much joy, laughter and love.
Now this list was a difficult one to put together. In fact, I went to Louise McNicoll from the Toronto Lab for this list... and you may discover that it isn't all inclusive. You may notice that the authors are all employees of the Toronto Lab. Yes, the employees from the US and India have published articles as well, but I have not yet been able to pull together a complete list. One of my goals for the New Year!
Nevertheless, you'll notice that this is a very lengthy list, so clearly the list will be much longer when I get all the details.
I hope you find this list useful. Happy Reading :)
Comparing real time cardinality to the optimizer cardinality estimatesby Samir Kapoor, Sid Selvarajah, Kaarel Truuvert
A quick start: Developing and testing SQLJ programs using Rational Application Developerby Yongli An, Joyce Coleman
Set up a Multi-tier SPECjAppServer2004 cluster with DB2by Tony Lau, Meng Fu
Set up a WebSphere v6 SPECjAppServer2004 cluster with DB2 for Linux, UNIX, and Windowsby Tony Lau
Backup/Restore Schemas for DB2 Universal Databaseby Serge Rielau
Configure DB2 UDB ESE V8.2 with the Database Partitioning Feature on SUSE Linux Enterprise Serverby Sam Poon, Fraser McArthur
DB2 9 XML Performance Characteristicsby Irina Kogan, Matthias Nicola, Berni Schiefer
DB2 Partitioning Features: an overview for data warehousesby Paul McInerney
DB2 Developer's releaseby Paul Zikopoulos
DB2 Universal Database: The Database Explorer, Part 1by Paul Zikopoulos
DB2 Universal Database: The Database Definition Windows, Part 2by Paul Zikopoulos DB2 Universal Database: Building Stored Procedures using the Database Expolorer View, Part 3by Paul Zikopoulos DB2 Universal Database: Building User Defined Functions using the Data Definition View, Part 4by Paul Zikopoulos DB2 Universal Database: Generating SQL Statements Using the SQL Editor, part 5by Paul Zikopoulos DB2 Universal Database: Productivity Features of the SQL Builder, Part 6 by Paul Zikopoulos Building Tables with the DB2 Designer and Visual Studio 2005 by Paul Zikopoulos Build a DB2 Bound Data Application using Visual Studio 2005by Paul Zikopoulos How to Build an ASP.NET Web Site Using DB2 Data with Visual Studio 2005by Paul Zikopoulos Binding DB2 Data to Visual Studio 2005 Windows Applicationsby Paul Zikopoulos Creating an XML Schema Document (XSD) with the DB2 Tools for Visual Studio 2005 Database Journal (www.databasejournal.com)by Paul Zikopoulos
DB2 9 Fundamentals exam 730 prep, Part 1: DB2 planningby Paul Zikopoulos DB2 9 Fundamentals exam 730 prep, Part 3: Accessing DB2 data by George Baklarz
Information on Demand Global Conference Web 2.0 Personal Plannerby Leons Petrazickis, Grant Hutchison
DB2 9 Fundamentals exam 730 prep, Part 4: Working with DB2 databy Roman Melnyk
Introducing DB2 9: DB2 9 unveiledby Rav Ahuja
Introducing DB2 9: Application development enhancements by Rav Ahuja
Introducing DB2 9, Part 1: Data compression in DB2 9 by Rav Ahuja
Introducing DB2 9, Part 2: Table partitioning in DB2 9 by Rav Ahuja
Introducing DB2 9, Part 3: Self-tuning memory in DB2 9 by Rav Ahuja
Introducing DB2 9, Part 4: Autonomic and other enhancements in DB2 9by Rav Ahuja
Setting up DB2 for UNIX and Linux on NFS mounted file systemsby Felix Lee
DB2 Developer Workbench, Part 1: Developer Workbench concepts and basic tasksby Chris Eaton
DB2 Developer Workbench, Part 2: Developer Workbench and stored proceduresby Debra Eaton
DB2 XML evaluation guideby Gerald Leung, Grant Hutchison
Kick-start your J2EE applications using DB2 9 with pureXML and WebSphere Community Editionby Gerald Leung, Lin Sun
DB2 Express-C, the developer-friendly alternative by Grant Hutchison
Work with XML Data in the Zend Framework: Getting started with the Zend_Db_Xml Incubator Project by Salvador Ledezma
Take the Fast Trainby Rahul Kitchlu, Boris Bialek
Cost-based Optimization in DB2/XMLby John Hornibrook, Andrey Balmin, Tom Eliaz, Lipyeow Lim, David Simmen, Guy Lohman, Min Wang, Chun Zhang
Automating DB2 HADR Failover using IBM Tivoli System Automation for Linuxby Melody Ng, Steve Raspudic, Chris Felix
Installing the DB2 Plug-in for Nagios System Monitor (PDF download)by Chris Thomason
What's Hot for Javaby Christine Law
HASE: A Hybrid Approach to Selectivity Estimation for Conjunctive Predicatesby Calisto Zuzarte, Xiaohui Yu, Nick Koudas High Availability with IBM® DB2® 9 and xkoto GRIDSCALE (PDF download)by David Tam, Belal Tassi Workload Adaptation in Autonomic DBMSsby Randy Horman, Baoning Niu, Patrick Martin, Wendy Powley, Paul Bird CASCON 2006
Using Zend Core for IBM and IBM® DB2 Technologies to Implement an OLTP System Supporting Tens of Thousands of Simultaneous Database Connectionsby Nailah Bissoon, John Tran, Sunil Kamath Zend Developer Zone
A Recipe for Services Oriented Architectureby Paul Zikopoulos
Taking Control: DB2 Query Patrollerby Paul Zikopoulos, Dwaine Snow
Introducing the db2pd Tool – A Not-So-Well Known Friend for a DBAA Simple Fix to a DB2 Query Patroller Locking Problemby Paul Zikopoulos
Accessible Standy Database in IBM DB2 UDB HADR Environement Using VERITAS Volume Instant Snapshots (PDF download)by Nuzio Ruffolo www.ibm.com[Read More]
svisser1 2700018UK9 2,918 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]
svisser1 2700018UK9 2,825 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,735 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,717 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,959 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,849 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,789 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,802 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,843 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.