(Doyun Kim) This article describes how to perform point-in-time table-level restores that extract tables or portions of tables from archives and logical logs. Table-level restore is a new feature for IBM Informix Dynamic Server Version 10.0. This feature is useful where portions of a database, a tab

(C. M. Saracco) DB2 9 features support for XQuery, an industry-standard language designed expressly for querying XML data. With XQuery and DB2 9 you can retrieve entire XML documents or XML fragments stored in XML columns. You can also specify XML-based filters for queries, transform XML output, and

(Willie Favero) On July 17, I posted a blog entry titled “The incredible shrinking data: DB2’s Compression – Part I” and on Aug 5 I posted “DB2 Data Compression Part II: The saga continues…”. As promised, here is the final chapter.

(Pat Moffatt, Bruce Creighton and Jessica Cao) This tutorial introduces readers to the Aroma database to apply Structured Query Language (SQL) and XML Query (XQuery) knowledge to solve typical business questions. Also included are detailed instructions for installing DB2 and the Aroma database. This

(Dwaine Snow) While databases are becoming more and more self-aware and self-healing, they still require some monitoring to keep them running as efficiently as possible. Just like your car, a database requires some checks to keep it running optimally. This document is broken down into tasks or check

(Roger E. Sanders) This tutorial introduces you to the concept of data consistency and to the various mechanisms that are used by DB2 to maintain consistency in both single and multi-user database environments. This is the sixth in a series of seven tutorials to help you prepare for the DB2 9 for Li

(Farzad Farahbod, Chat Chatterton and Chenhong Xia) This is Part 4 of a tutorial series that teaches you how to create proof-of-concept applications to access relational and XML data in IBM DB2 V9, using Microsoft Visual Studio .NET 2005. Part 1 explained the application specifications, database

(Willie Favero) The people at DB2 Development have been talking about DB2’s private protocol going away for what seems like forever. Can you say “No changes since DB2 Version 5”? That’s a heck of a long time to go with enhancements. And all through V5, V6, V7, and now V8 the subtle suggestions have

(Werner Schuetz) A schema in DB2 is a collection of named objects, such as tables, views, nicknames, triggers, functions, and packages. Schemas provide a logical classification of objects in the database. A schema name can be up to 30 bytes long and is used as the high order part of a two-part objec

(Hana Curtis) Learn about data types, tables, views, and indexes as defined by DB2 9. This tutorial explains the features of these objects, how to create and manipulate them using Structured Query Language (SQL), and how they can be used in an application. This tutorial is the fifth in a series of s