IBM Books

Image, Audio, and Video Extenders Administration and Programming


Preparing a database

The system administrator creates and enables the personnel database for use by the Image Extender.

What the system administrator does: The system administrator creates the personnel database in DB2 for AIX using the following SQL statement:

CREATE DATABASE personnl           /*name of the database*/
       ON /persdb                  /*name of the database directory*/
       WITH "Personnel database"   /*comment*/

The system administrator connects to the database and enables it for use by the Image Extender. The system administrator uses the db2ext command-line processor to issue the following commands:

CONNECT TO personnl
ENABLE DATABASE FOR DB2IMAGE

What happens: In response to the ENABLE DATABASE command, the Image Extender:


UDF name Description
Comment Get or update user comments
Content Get or update the content of an image
DB2Image Store the content of an image
Filename Get the name of the file that contains an image
Format Get the image format (for example, GIF)
Height Get the height of an image in pixels
Importer Get the user ID of the importer the of an image
ImportTime Get the timestamp when an image was imported
NumColors Get the number of colors used in an image
QbScoreFromName Get the similarity score of an image (using a named query)
QbScoreFromStr Get the similarity score of an image (using a query string)
QbScoreTBFromName Get a table of similarity scores for a column of images (using a named query)
QbScoreTBFromStr Get a table of similarity scores for a column of images (using a query string)
Replace Update the content and user comments for an image
Size Get the size of an image in bytes
Thumbnail Get a thumbnail-sized version of an image
Updater Get the user ID of the updater of an image
UpdateTime Get the timestamp when an image was updated
Width Get the width of an image in pixels


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