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:
Optional tasks:
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.