As a follow-on to yesterday's blog entry The Year of Change, I'd like to point out some additional resources in the areas of high availability and pureXML:
High availability High Availability Feature in DB2 9 for Linux UNIX and WindowsThis Web site lists the main features of DB2 which include high availability High Availability Guide for DB2 (Book)This book provides an easy-to-read, illustrated way to learn about high availability concepts and configuration. However, it does not provide much information about high availability of clusters. High Availability and Scalability Guide for DB2 on Linux, UNIX, and Windows (IBM Redbooks, html and pdf)This guide provides an in-depth and detailed analysis of DB2 high availability features, including high availability for clusters. This book describes DB2 UDB Version 8.2 and therefore does not showcase the many improvements made in DB2 9 to simplify configuration. DB2 9 DBA exam 731 prep, Part 6: High availability: Backup and recovery (Tutorial)This tutorial is part of the educational materials related to high availability that are part of DB2 certification education materials. It provides a concise summary of the key benefits and uses of the backup and restore utilities. DB2 9 DBA exam 731 prep, Part 7: High availability: Split mirroring and HADR (Tutorial)This tutorial is part of the educational materials related to high availability that are part of DB2 certification education materials. It provides a concise summary of how to implement a split mirroring implementation.
pureXML DB2 pureXML technology (Product Web site)This is the main DB2 product Web site for pureXML. Information Management and XML technology developerWorks domain (IBM community Web site)This is the main developerWorks Web site from which you can access articles, online tutorials, and other technical resources about DB2 and XML standards and technologies. IBM DB2 9 pureXML Guide (IBM Redbooks, html and pdf)This IBM Redbooks publication describes the pureXML data store, hybrid database design, and administration. It explains what XML schemas are, how to use industry standards to implement them, and how to manage XML schemas. It covers how to use SQL/XML, XQuery, and XPath for querying XML data by providing easy-to-understand examples and how to use XML technology efficiently in business applications. Get started with XPath (Tutorial)This tutorial introduces the W3C standard XPath Version 1.0. This tutorial is intended for people who do not know XPath or who want a refresher. If you plan to use XSLT, you should take this tutorial first. You will learn what XPath is, what the syntax and semantics of the XPath language are, how to use XPath location paths, how to use XPath expressions, how to use XPath functions, and how XPath relates to XSLT. DB2 9: pureXML Overview and Fast Start by Cynthia Saracco, Don Chamberlin, Rav Ahuja (IBM Redbooks, html and pdf)This IBM Redbooks publication provides a concise introduction to pureXML, with short, precise examples and explanations that provide a distilled version of the knowledge essential to start working with pureXML. This book is a compilation of many of the IBM published articles on pureXML. Native XML support in DB2 (White paper, pdf)This white paper provides a technical overview of XML support in DB2 products. It explains how XML data has been stored in relational database systems in the past using data type mappings and explains the limitations of these approaches. It then introduces the concept of pureXML and what it means for XML data to be stored natively within a database. It explains the benefits of this approach and how this implementation can be complemented with features such as XML indexes, a full XQuery language, SQL/XML, XML schema support, and utilities that support the bulk loading of XML data. pureXML in DB2 9: Which way to query your XML data? (Article)This intermediate-level article discusses DB2 pureXML support and compares the two methods by which you can query XML data in a DB2 database: SQL/XML and XQuery. By providing examples, this article explains the relationship between these two query access language syntaxes, the circumstances in which each method is preferred, the benefits of using each independently, and the use of them together to perform more complex queries. pureXML wiki (Wiki)This Web site contains links to numerous articles, demos, webcasts, and other information about DB2 pureXML published by IBM and other parties Alphaworks DB2 pureXML download and demo site (Download)This Web site contains industry-specific DB2 pureXML software offerings and resources. DeveloperWorks DB2 pureXML forum (Forum)This DeveloperWorks forum is one of the fastest ways to get any pureXML questions answered.
Thanks to Farzana Anwar for pulling this list together!
The developerWorks Connections platform will be sunset on December 31, 2019. On January 1, 2020, this blog will no longer be available. More details available on our FAQ.
Keep on Learning
Matching: links X
Thanks to Farzana Anwar from DB2 Information Development for this incredible list of sites that you might want to visit or bookmark.
DB2 for Linux, Unix, and Windows (Product Web site)This IBM DB2 product Web site contains information about the latest release and new features, links to important related Web sites, announcements about the release and more. This is a good starting point for information about DB2 for LUW.
DB2 for Linux, Unix, and Windows Editions (Product Web site)This product Web site provides information about IBM DB2 product editions. It contains information about the various editions of DB2 that are available. This Web site highlights the key features available with each edition and compares them in a tabular format. If you are not sure what edition of DB2 is appropriate for your needs this is a good starting point and reference.
DB2 for Linux, UNIX, and Windows Features and Benefits (Product Web site, Video with Sal Vella)This product Web site provides information about value-added features. It describes the value added features that are available to extend the core features available with a DB2 edition. Value added features are generally used to address specific business problems that might not be of general use to all customers. The value added features can be purchased separately and enabled with a separate license key.
Overview of DB2 9.5 by Chief Architect Tim Vincent (Podcast, mp3 file)This podcast which can be listened to or downloaded from the Voice of the DB2 Community Web site provides an overview of new DB2 9.5 features.
Introducing DB2 9: DB2 Unveiled (Article by Rav Ahuja)This article contains a comprehensive overview of new features available in DB2 9.1 with a focus on how you can use the features to help lower business costs and improve business data management. It links to several related articles that describe specific features in more detail. The content also applies to DB2 9.5 and DB2 9.7 data servers.
Compare the Distributed DB2 9 Data Servers (Article by Paul Zikopoulos)This article compares the various DB2 9.1 data server products. The content also applies to DB2 9.5 and DB2 9.7 data servers.
Which edition of DB2 9 is right for you? (Article by Paul Zikopoulos)This article describes and compares the product specifications, licensing considerations, and specific features and capabilities of each edition of DB2 9.1. The content is generally also appropriate for DB2 9.5 and DB2 9.7.
DB2 Version 9 Product and Packaging Information (Technote)This technote explains the DB2 product packaging options that are available. It contains links to packaging information for DB2 data servers, clients, and add-on features.
IBM DB2 9 New Features (Book)IBM DB2 9 New Features is an easy-to-read book that includes illustrations and examples. The content applies to both DB2 9.1 and DB2 9.5 data servers, however new features in DB2 9.5 are not described in this book.
There were many more links in the document that Farzana sent to me... and I'll share the links with you over the next few days.
I use google to find links to just about anything I'm interested in. I'm not always successful in finding what I am looking for, but I'm sure it is just because of my bad search arguments.
Mark Wilding, a member of the Toronto Lab Development team, was looking for DB2 sites and was frustrated at not being able to find what he wanted to. So, always a problem solver... Mark created the following site:
Forever growing, this site should be one of the first places to go if you are looking for specific DB2 information.
Just a quick comment about Mark. Mark is one of the many prolific authors that we seem to attract in the Toronto Lab. He's been involved with a few books with many ideas still unpublished. He was the driving force behind the latest DB2 Best Practices initiative. If you don't know about this yet, check out the bookmark list to find it.
Also, Mark, along with Dan Behman, wrote a book about Linux that should be popular with many people: Self-Service Linux(R): Mastering the Art of Problem Determination .
Thanks Mark for the bookmark list as well as your passion for writing!