IBM Books

Image, Audio, and Video Extenders Administration and Programming


Administration tasks you can perform with the DB2 extenders

There are five categories of administrative tasks:

The following table lists all the tasks involved in administering extender data. The table specifies which tools are provided to perform each task, and where to find more information.

In the Extender API column, x represents the third character of each API statement. This character varies according to the extender you are using:
Character Extender
a Audio
i Image
v Video

For example, the API for enabling a table for image data is DBiEnableTable, the API for enabling a table for audio is DBaEnableTable, and the API for enabling a table for video is DBvEnableTable. A value of No in the Extender API column means that there is no extender API for the task. A value of No in the Extender Command column means that there is no extender command for the task.

QBIC requires additional administration: If you plan to use the Image Extender's Query by Image Content (QBIC) capability, you need to perform additional administrative tasks, such as creating a QBIC catalog. For information about these tasks, see Chapter 13, Querying images by content.

Table 1. Administration tasks and facilities for the DB2 extenders
Task Extender API Extender Command See
Managing extender services
Start the extender services No DMBSTART Establishing the extender environments
Get status of the extender services No DMBSTAT Displaying server status
Stop the extender services No DMBSTOP Stopping and starting extender servers
Connect to a database No CONNECT Establishing the extender environments
Start an extender service for your database No START SERVER Stopping and starting extender servers
Get status of an extender for your database No GET SERVER STATUS Displaying server status
Stop an extender service for your database No STOP SERVER Stopping and starting extender servers
Preparing data objects for multimedia data
Enable a database DBxEnableDatabase ENBLE DATABASE Enabling databases
Disable a database DBxDisableDatabase DISABLE DATABASE Disabling data objects
Enable a table DBxEnableTable ENABLE TABLE Enabling tables
Disable a table DBxDisableTable DISABLE TABLE Disabling data objects
Enable a column DBxEnableColumn ENABLE COLUMN Enabling columns
Disable a column DBxDisableColumn DISABLE COLUMN Disabling data objects
Redistributing extender data in a partitioned environment (EEE only)
Redistribute extender data based on a new nodegroup configuration. DMBRedistribute REDISTRIBUTE NODEGROUP Redistributing extender data
Tracking data objects and media files
Find out if databases are enabled DBxIsDatabaseEnabled GET EXTENDER STATUS Checking the status of data objects
Find out if tables are enabled DBxIsTableEnabled GET EXTENDER STATUS Checking the status of data objects
Find out if columns are enabled DBxIsColumnEnabled GET EXTENDER STATUS Checking the status of data objects
Find table entries that reference files in tables whose qualifier is the current user ID DBxIsFileReferenced No Finding table entries that reference files
Find table entries that reference files in all tables of a specific qualifier or all tables in a database DBxAdminIsFileReferenced No Finding table entries that reference files
Find files referenced by table entries in tables whose qualifier is the current user ID DBxGetReferencedFiles GET REFERENCED FILES Finding files referenced by table entries
Find files referenced by table entries in all tables of a specific qualifier or all tables in a database DBxAdminGetReferencedFiles GET REFERENCED FILES Finding files referenced by table entries
Find inaccessible files referenced by table entries in all tables whose qualifier is the current user ID DBxGetInaccessibleFiles GET INACCESSIBLE FILES Checking if media files exist
Find inaccessible files referenced by table entries in all tables of a specific qualifier or all tables in a database DBxAdminGetInaccessibleFiles GET INACCESSIBLE FILES Checking if media files exist
Clean up administrative support (metadata) tables
Clean up metadata tables for a specific user table or all user tables whose qualifier is the curent user ID DBxReorgMetadata REORG Chapter 9, Cleaning up administrative support tables
Clean up metadata tables for all user tables with a specific qualifier or all user tables in a database DBxAdminReorgMetadata REORG Chapter 9, Cleaning up administrative support tables

Sequence of administration tasks: The following list is an ordered summary of the administration tasks you perform when you use the extenders the first time. You use DB2 commands or statements to perform some tasks. You perform other tasks with the DB2 extenders. This sequence assumes that your DB2 system is running.

    Required tasks:

  1. Start the extender services.
  2. Create a database (by using DB2).
  3. Connect to the database database server.
  4. Enable the database.
  5. Create a table and column (by using DB2).
  6. Enable a table in the database.
  7. Enable a column in the table.

    Optional tasks:

  1. Track data objects and media files.
  2. Set the function path (using DB2).
  3. Clean up administrative support tables.

Examples: Most of the examples in the next five chapters assume that a system administrator (SYSADM) or a database administrator (DBA) is performing the tasks. A few tasks do not require DBA or SYSADM authority.

The examples assume that the DBA has added the MMDBSYS schema in the current function path. This allows the DBA to specify UDT names without prefixing them with the MMDBSYS schema name. For more information about UDT names, see UDF and UDT names.

Many of the API examples in this section are based on the sample application code that is supplied with extenders. The sample code is in the SAMPLES subdirectory on the client.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]