Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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 Copy 4 byte of data from the last rec... arunsoods DFSORT/ICETOOL 9 Fri Oct 06, 2017 12:15 pm
No new posts XMITIP sends it out. Can it copy on l... Rommel Dayon Rustia IBM Tools 0 Tue Sep 05, 2017 10:16 am
No new posts Unable to copy data from spool in a d... srikant314 JCL & VSAM 8 Fri Jul 28, 2017 9:10 pm
No new posts copy SEQ to PDS and create stats steve-myers JCL & VSAM 7 Thu Apr 27, 2017 1:15 am
No new posts unload data from table with lob columns farhad_evan DB2 1 Sat Apr 22, 2017 1:32 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us