IBM Books

Image, Audio, and Video Extenders Administration and Programming

REORG


Image Audio Video
X X X

Clean up the administrative tables (administrative table and the attribute table) associated with a specific table, tables with a specific qualifier, or all tables in the current database.

Authorization

For a specific table (if you run REORG TABLE), or tables with a specific qualifier (if you run REORG DATABASE): SYSADM, SYSCTRL, SYSMAINT, DBADM, Control

For all tables in the database (if you run REORG DATABASE): SYSADM, SYSCTRL, SYSMAINT, DBADM

Command syntax

>>-REORG----+-DATABASE--+----------------+-+--FOR--------------->
            |           '-USER--user_ID--' |
            '-TABLE--table_name------------'
 
      .-,----------------.
      V                  |
>--------extender_name---+-------------------------------------><
 

Command parameters

user_ID
The qualifier of the tables.

table_name
The name of the table in the current database whose administrative tables you want to clean up.

extender_name
The name of the extender. Valid extender names are db2image, db2audio, and db2video.

Examples

Reorganize and clean up the image administrative tables for the current database:

reorg database for db2image

Reorganize and clean up the image administrative tables in all tables with the qualifier anita:

reorg database user anita for db2image

Reorganize and clean up the image administrative tables for the employee table:

reorg table employee for db2image

Usage notes

Connect to the database before using this command.


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