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
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.