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