LOAD:
Use LOAD to load one or more tables of a table space. LOAD loads records into the tables and builds or extends any indexes defined on them. If the table space already contains data, you can choose whether you want to add the new data to the existing data or replace the existing data. The loaded data is processed by any edit or validation routine associated with the table, and any field procedure associated with any column of the table.
REORG:
The REORG online utility reorganizes a table space or index to improve access performance and reclaim fragmented space. In addition, the utility
can reorganize a single partition of either a partitioned index or a
partitioned table space. You can specify the degree of access to your data
during reorganization. If you specify REORG UNLOAD ONLY, the data is
unloaded in a format that is acceptable to the LOAD utility of the same
DB2 subsystem.
Output: If the table space or partition has the COMPRESS YES attribute,
then the data is compressed when reloaded. If you specify the
KEEPDICTIONARY option of REORG, the current dictionary is used; otherwise
a new dictionary is built.
REORG TABLESPACE can be executed on the table spaces in the DB2 catalog
database (DSNDB06) and some table spaces in the directory database
(DSNDB01). It cannot be executed on any table space in the DSNDB07
database.
Authorization Required: To execute this utility on a user table space or
index, the privilege set of the process must include one of the following:
o REORG privilege for the database
o DBADM or DBCTRL authority for the database
o SYSCTRL authority
o SYSADM authority.
No comments:
Post a Comment