After you have loaded the data to
DB2®, you must perform a number of routine
DB2 database administration tasks.
Some or all of these will be dictated by your current
DB2
DBA standards.
- Run the
DB2 COPY
utility to create an image copy and remove the copy pending flag. This is
not required if your DB2 load utility includes NOCOPYPEND.
- Check to see if the
DB2
LOAD has caused multiple extents in either the tablespace
or indexspace page sets. If necessary, use the ALTER SQL statement to modify
the page set SPACE allocation.
- To resolve multiple data set extents, run the
DB2 REORG
utility and gather RUNSTATS data. Otherwise, run RUNSTATS.
- Optionally, rebind the DDM package with
EXPLAIN(YES).
- Verify that the correct access paths have been selected by
DB2.