Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Diff btw LOAD RESUME and LOAD REPLACE

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
zatish

New User


Joined: 06 May 2005
Posts: 14

PostPosted: Tue Feb 28, 2006 2:47 am    Post subject: Diff btw LOAD RESUME and LOAD REPLACE
Reply with quote

Pls let me know the diff btw
LOAD RESUME and LOAD REPLACE

Thks
Back to top
View user's profile Send private message

amitava
Warnings : 1

Active User


Joined: 30 Oct 2005
Posts: 186
Location: India

PostPosted: Tue Feb 28, 2006 9:31 am    Post subject:
Reply with quote

Hi zatish,
I think by LOAD RESUME it means that the loading into DB2 table it will just start loading where after it was stopped. All the old datas will be available after loading here.
But by LOAD REPLACE it means that the table will be truncated and then the loading will take place. So by this way, all the old datas will not be available.
Back to top
View user's profile Send private message
ragshere

New User


Joined: 20 Dec 2004
Posts: 70

PostPosted: Tue Feb 28, 2006 10:59 am    Post subject: Re: Diff btw LOAD RESUME and LOAD REPLACE
Reply with quote

Hi,
LOAD RESUME will append the data to the table. That means you won't lost existing data.

LOAD REPLACE will delete the existing data in tablespace(i.e all the tables in tablespace will lost the data) and load the given data in mentioned table.



Hope you got me.


Thanks
Raghavendra
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Db2 load job abending in SORT mistah kurtz DB2 4 Mon Jun 05, 2017 3:58 pm
No new posts Fileaid Update Replace with null string descann Compuware & Other Tools 4 Mon May 15, 2017 3:00 pm
No new posts Replace values in the input data Vikas Maharnawar DFSORT/ICETOOL 10 Thu May 11, 2017 2:18 pm
No new posts Cobol upgrade - source code missing f... gthmrj IBM Tools 1 Wed Apr 26, 2017 6:04 pm
No new posts Copy load modules and alias vasanthz IBM Tools 5 Thu Apr 20, 2017 6:31 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us