DB2 Load Utility

Ian in Uk

5 pts.

Tags:

IBM DB2

LOAD

If I run the DB2 LOAD utility LOG NO REPLACE is all the data externalised to DASD immediatley ? I.e. if I ran DSN1COPY against the underlying VSAM dataset immediately (without stopping pageset) would all rows be copied ?

Asked: March 5, 2008 4:59 PM Last updated: December 7, 2009 7:16 PM

Answer Wiki

Last updated: June 25, 2008 7:03 PM GMT

Msenatore@fisa185 pts.
History
Contributors
- Ordered by most recent
- Msenatore@fisa185 pts.

Thanks. We'll let you know when a new response is added.

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

Pravin1234jd Nov 25, 2009 2:02 PM GMT

what is the use of COPYPEND in the below SYSIN LOAD DATA RESUME YES LOG NO NOCOPYPEND CAN ANYONE PLEASE LET ME KNOW

10 pointsBadges:

report
Neha1987 Dec 5, 2009 9:42 AM GMT

NOCOPYPEND is used to eliminate the copy pending status which gets set on the tablespace because of use of LOG NO in the SYSIN defination.

15 pointsBadges:

report
Meandyou Dec 7, 2009 7:16 PM GMT

but remember, when you specify NOCOPYPEND you are assuming absolute responsibility for the recoverablity of the data. One of DB2's priorities is to protect the data, that is to ensure the data is recoverable. When you turn off the copy pending flag, YOU are now responsible. Not DB2. Go ahead and use NOCOPYPEND, but please understand the (possible) ramifications. Steve

5,220 pointsBadges:

report