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 |