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 b/w UNLOAD and IMAGE COPY

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

Active User


Joined: 19 Feb 2005
Posts: 112
Location: chennai

PostPosted: Wed May 17, 2006 1:02 pm    Post subject: Diff b/w UNLOAD and IMAGE COPY
Reply with quote

Hi,

as per I know that UNLOAD is used to load the table data to a flat file and IMAGE COPY is used to take the backup of a table.

May I know the difference between IMAGE COPY and UNLOAD as both the things are extracting the data from the table to a flat file......

and also

May I know whether can we both the things at the same time.........

thanx in advance............

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

Rottenbacher

New User


Joined: 17 May 2006
Posts: 1

PostPosted: Wed May 17, 2006 7:59 pm    Post subject: Re: Diff b/w UNLOAD and IMAGE COPY
Reply with quote

Hi,

image copy produces a binary copy of the data, including all the internal db2 data (like object id, position of data within tablespace, etc.).

If the tablespace was not reorganized and all the data was in bad order within the tablespace, recovering to the imagecopy will put the tablespace in the same bad reorganization state.

When you drop a table and recreate it without any changes to the tabledefinition, the table will get a new obid by db2.

The old imagecopy still contains the obid of the table before dropping the table. Without translating old obids to new obids you can not use old imagecopies.

Unload contains the data in a more readable way. The data is structured in a way a load-utility may use it.

In case you want to move the data to different environment unload is probably your choice. Unload is slower though and has other drawbacks.


Yes you can use both unload and imagecopy because they target different situations.

regards Klaus
Back to top
View user's profile Send private message
i413678
Currently Banned

Active User


Joined: 19 Feb 2005
Posts: 112
Location: chennai

PostPosted: Thu May 18, 2006 10:47 am    Post subject: Re: Diff b/w UNLOAD and IMAGE COPY
Reply with quote

many many thank you Rottenbacher

cheers.............

pavan
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 SORTJOIN - Copy Matched and Unmatched... Steve Ironmonger DFSORT/ICETOOL 5 Tue Jan 17, 2017 4:26 pm
No new posts HALDB data refresh/copy from producti... vineetanand2007 IMS DB/DC 1 Mon Jan 02, 2017 11:16 am
No new posts Copy RECFM =VB TO FB file with RECL =... sahil41352 DFSORT/ICETOOL 3 Wed Dec 28, 2016 11:29 pm
No new posts syncsort: copy lines after the keyword shreya19 SYNCSORT 7 Fri Dec 02, 2016 9:47 am
No new posts Single COPY CICS TS datasets and when... Kyle Carroll CICS 2 Tue Oct 11, 2016 9:47 pm


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