IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

DB2 Load Utility


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
vickey_dw

New User


Joined: 10 Jun 2015
Posts: 51
Location: India

PostPosted: Mon Aug 10, 2015 12:17 pm
Reply with quote

Hello Experts

In one of my job i can see LOAD is used as below

Code:
LOAD RESUME NO REPLACE LOG NO NOCOPYPEND ENFORCE NO
     INTO TABLE xxxxxx


and in other

Code:
LOAD REPLACE     LOG NO NOCOPYPEND INDDN SYSREC00 INTO TABLE   xxxxxx


In both the cases data is present in the tables.

After going through the manuals(and other stuff) i came to know in both the cases data present in the existing tables will be deleted first and new data will be loaded with the file specified.

Please confirm my understanding on this .

Because i can see some data present in the tables which is not there in the load files.
Back to top
View user's profile Send private message
hailashwin

New User


Joined: 16 Oct 2008
Posts: 74
Location: Boston

PostPosted: Mon Aug 10, 2015 2:36 pm
Reply with quote

From the manuals..

Quote:

REPLACE Tells whether the table space and all its indexes need to be reset to empty before records are loaded. With this option, the newly loaded rows replace all existing rows of all tables in the table space, not just those of the table you are loading.


Quote:

RESUME Tells whether records are to be loaded into an empty or non-empty table space. For nonsegmented table spaces, space occupied by rows that have been marked as deleted or by rows of dropped tables is not reused.

NO Loads records into an empty table space. If the table space is not empty, and you have not used REPLACE, a message is issued and the utility job step terminates with a job step condition code of 8.
For nonsegmented table spaces containing deleted rows or rows of dropped tables, using the REPLACE keyword provides increased efficiency.


Thanks,
Ashwin.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Which SORT utility can improve the Pe... DFSORT/ICETOOL 16
No new posts COBOL VS SORT Utility for file format... COBOL Programming 6
No new posts Job is loading load modules several t... COBOL Programming 12
No new posts Need help on DB2 load in Mainframe DB2 5
No new posts Issue in KWIKKEY utility while creat... JCL & VSAM 2
Search our Forums:

Back to Top