Export/Import:
export to employee.ixf of ixf SELECT * FROM ADMINISTRATOR.EMPLOYEE fetch first 10 rows only;
import from employee.ixf of ixf commitcount 10 create into ADMINISTRATOR.EMPLOYEE;
ixf include the table definition and data, but only can use import/create into load data if no table exist.
Load:
Import need to check reference and constraint and write log for ever row insert. but Load doesn't do these.
rebuild
Make the application use the optimal access path.
db2look -m
extract DDL and stastical which can smilate the product env.
Flow:
runstats->reorgchk(Y)->reorg->runstats->rebind app
runstats->reorgchk(N)->rebind app.
Backup:
incremental:All change after the previous ful backup
delta: All change after the previous backup(full,incremental,delta)
so delta is less than incremental.