IBM Books

Image, Audio, and Video Extenders Administration and Programming

ENABLE TABLE


Image Audio Video
X X X

Enables the specified table to store media data using the specified table space.

Authorization

SYSADM, DBADM, Control, Alter

Command syntax

>>-ENABLE TABLE--table_name--FOR---extender_name---------------->
 
      .-,-----------------------------.
      V                               |
>--------+-------------------------+--+------------------------><
         '-USING--tablespace_name--'
 

Command parameters

table_name
The name of the table in the current database you want to enable.

extender_name
The name of the extender for which you want to enable the table. Valid extender names are db2image, db2audio, and db2video.

tablespace_name
The name of the table space, which is a collection of containers into which administrative tables are stored. The table space specification has three parts as follows: datats, indexts, longts, where datats is the table space in which metadata tables are created; indexts is the table space in which indexes on the metadata tables are created; and longts is the table space in which values of long columns in the metadata tables (such as those that contain LONG VARCHAR and LOB data types) are stored. If you provide a null value for any part of the table space specification, the default table space for that part is used.

If you provide a null value for any part of the table space specification, the default table space for that part is used.

EEE Only: The tablespace specified should be in the same nodegroup as the user table.

Examples

Enable the table employee to hold image data:

enable table employee for db2image
   using mydataspace, myindxspace, mylongspace

Enable the table employee to hold image data. Use default table spaces:

enable table employee for db2image

Usage notes

Connect to the database before using this command.

If the table space is not specified, the system uses the table space defined when the current database was enabled.


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