DB2 Load Utility

5 pts.
Tags:
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 ?

Answer Wiki

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

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Pravin1234jd
    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
    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
    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

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following