IBM Books

Image, Audio, and Video Extenders Administration and Programming

ENABLE DATABASE


Image Audio Video
X X X

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

Authorization

SYSADM, SYSCTRL, DBADM

Command syntax

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

Command parameters

extender_name
The name of the extender for which you want to enable the current database. 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 name has three parts as follows: datats, indexts, longts, where datats is the name of the table space in which metadata tables are created; indexts is the name of the table space in which indexes on the metadata tables are created; and longts is the name of 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 name, the name of the default table space for that part is used. The table space specified should be defined on a nodegroup that includes all the nodes in the partitioned database system.

Examples

Enable the current database to hold image data:

enable database for db2image using mydataspace, myindxspace, mylongspace

Usage notes

Connect to the database before using this command.

If the table space is not specified, the system uses the USERSPACE1 table space for the administrative tables.


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