Home > IT Answers > Business Intelligence > DB2 Load Utility
Ian in Uk
5 pts.
 DB2 Load Utility
DB2, DSN1COPY, 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 ?

Software/Hardware used:
ASKED: March 5, 2008  4:59 PM
UPDATED: December 7, 2009  7:16 PM
RELATED QUESTIONS
Answer Wiki:
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.
Last Wiki Answer Submitted:  June 25, 2008  7:03 pm  by  Msenatore@fisa   185 pts.
All Answer Wiki Contributors:  Msenatore@fisa   185 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

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

Pravin1234jd
 10 pts.
 

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.

Neha1987
 15 pts.
 

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

Meandyou
 5,205 pts.