Additional data migration tasks

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.
  1. 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.
  2. 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.
  3. To resolve multiple data set extents, run the DB2 REORG utility and gather RUNSTATS data. Otherwise, run RUNSTATS.
  4. Optionally, rebind the DDM package with EXPLAIN(YES).
  5. Verify that the correct access paths have been selected by DB2.

Information Information

Feedback


Timestamp icon Last updated: Monday, 10 February 2014


http://pic.dhe.ibm.com/infocenter/cicsts/v5r1/topic/com.ibm.cics.vt.doc//topics/cvtug_datamig_addtasks.html