What's New

DB2 Extenders

DB2 Extenders give you the ability to store, access, and manipulate text, images, audio, and video in a DB2 database.

Version 5.2

Partitioned Databases

DB2 Extenders Version 5.2 adds support for DB2 Universal Database Extended Enterprise Edition on Windows NT, Solaris, and AIX operating systems. When DB2 runs a query in parallel, any DB2 Extender user-defined function (UDF) in the query is run in parallel on the individual partitions. The Query by Image Content (QBIC) feature of the DB2 Image Extender will manage the parallel operation of the QBIC UDFs. See the DB2 Universal Database Extender Administration and Programming guides for details.

Commands

DB2 Extender's support for DB2 Extended Enterprise Edition adds the following commands:

• REDISTRIBUTE NODEGROUP completes the redistribution process so that redistributed data can be used with DB2 Extenders.

• RECREATE QBIC CATALOG recovers a QBIC catalog on a specified node.

• DMBNCRT adds a node to a DB2 Extender instance.

• DMBNDROP drops a node from a DB2 Extender instance.

• DMBNLIST lists all the partitions for a DB2 Extender instance.

The following DB2 Extender commands have changed:

• START SERVER, STOP SERVER, and GET SERVER STATUS process all nodes for the connected database.

• DMBSTART and DMBSTOP start or stop all nodes or a specified node for the extender instance.

• DMBICRT creates a partitioned DB2 Extender instance.

See the DB2 Universal Database Extender Administration and Programming guides for details.

Migration

Users using DB2 Extenders Version 5 can migrate their data for use with DB2 Extenders Version 5.2, but the data will not be partitioned.

[ DB2 List of Books | Search the DB2 Books ]