Dear Ian,
If you run a DB2 Load utiliy with Log No Replace, it is not safe to assume that your data externalized even through you have a new LDS. In addition, your table will be in COPYPEND status. Do the load using the following: STATISTICS TABLE(ALL) INDEX(ALL) UPDATE ALL LOG NO(NOCOPYPEND) SORTKEYS. Remove sortkeys if your target table has no index.
After the load, run a Quiesce to externalize the data.
Discuss This Question: 3  Replies