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
 
Difference between ImageCopy and Unload

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC
View previous topic :: :: View next topic  
Author Message
shiny

New User


Joined: 27 Apr 2010
Posts: 4
Location: India

PostPosted: Mon Aug 30, 2010 11:36 am    Post subject: Difference between ImageCopy and Unload
Reply with quote

Hi ..
Can anybody please tell me the difference between ImageCopy of a database and an Unload of a database
Back to top
View user's profile Send private message

Bala Siva

New User


Joined: 30 May 2012
Posts: 5
Location: Chennai

PostPosted: Fri Jun 01, 2012 3:29 pm    Post subject: Reply to: Difference between ImageCopy and Unload
Reply with quote

ImageCopy - Its a kind of Photocopy of your DB

Unload - You get whatever present into a specific file/somewhere you need. After Unloading you cannot see the contents in the DB.
Back to top
View user's profile Send private message
Naish

New User


Joined: 07 Dec 2006
Posts: 82
Location: UK

PostPosted: Fri Jun 01, 2012 3:59 pm    Post subject:
Reply with quote

Quote:
After Unloading you cannot see the contents in the DB

What?

Shiny,

This might be helpful.

http://ibmmainframes.com/viewtopic.php?t=11108&highlight=imagecopy
Back to top
View user's profile Send private message
Ed Goodman

Active Member


Joined: 08 Jun 2011
Posts: 556
Location: USA

PostPosted: Fri Jun 01, 2012 5:06 pm    Post subject:
Reply with quote

An image copy is an exact copy of what is in the area of the disk drive which contains the database.

An unload is a like writing a program to read every segment sequentially using an unqualified GN and write it out to a flat file.

There are lots of options for each one. To me, the most important one is for the unload, and it tells it to either uncompress the segments or leave them compressed.

Image copies are used to make a clean backup of a database, and can be restored exactly as-is. That requires that the database definition NOT change between the ic and the restore.

An unload is used to do things like re-organize a database. Since the restore of an unload is really a reload of the entire DB, it puts everything where it belongs. This helps eliminate split records and split CI/CA's.

The unload/reload is also needed if you change the database definition. You unload with the old definition and reload with the new. They can also be used to move data from one system to another with different, yet compatible, definitions.
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 -> IMS DB/DC All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Difference in SORT & ICETOOL Mohan Kothakota DFSORT/ICETOOL 5 Fri Sep 22, 2017 4:56 pm
No new posts unload data from table with lob columns farhad_evan DB2 1 Sat Apr 22, 2017 1:32 pm
This topic is locked: you cannot edit posts or make replies. Need help in estimating space of unlo... ashek15 IMS DB/DC 12 Fri Apr 07, 2017 5:11 am
No new posts Difference between TWALENG and TWASIZE Arunkumar Chandrasekaran CICS 3 Tue Jan 03, 2017 12:57 pm
No new posts Sticky: difference between ... DUMMY ... and ... enrico-sorichetti JCL & VSAM 0 Mon Oct 17, 2016 4:31 pm

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