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
 

 

What is the Meaning of Image Copy

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

Active User


Joined: 15 Dec 2005
Posts: 236

PostPosted: Tue Nov 28, 2006 12:28 pm    Post subject: What is the Meaning of Image Copy
Reply with quote

Dear all,

Please let me know what is the meaning for image copy & what for this jcl is used for,

//#0010 EXEC PGM=DSNUTILB,
// PARM=(D01T,'SSPFIC'),
// REGION=0M,COND=(0,NE)
//ABNLIGNR DD DUMMY
//DSSPRINT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//UTPRINT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//SYSIN DD *
TEMPLATE LOCALDDN
DSN 'JSSSAST.S00.&TS..M002'
UNIT CASS
LISTDEF DBA
INCLUDE TABLESPACES DATABASE JSSSSSD1

COPY LIST DBA FULL YES
SHRLEVEL REFERENCE
COPYDDN(LOCALDDN)
/*


Note: Need immediate response
Back to top
View user's profile Send private message

guptae

Moderator


Joined: 14 Oct 2005
Posts: 1187
Location: Bangalore,India

PostPosted: Tue Nov 28, 2006 12:34 pm    Post subject:
Reply with quote

Hey,

Just check in mannual
http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db2tools.haa.doc.ug/haad0051006025.htm
Back to top
View user's profile Send private message
Gautam512

Active User


Joined: 05 Oct 2005
Posts: 309
Location: Vizag / US

PostPosted: Wed Nov 29, 2006 1:05 am    Post subject: Re: What is the Meaning of Image Copy
Reply with quote

the jcl depends from shop to shop...

image copy means : take a back up of the database, by givin the tablespace info and schema name into a dataset.
This dataset has the complete info and data of the database for which u have taken a backup.

similarily there will be a restore jcl for having the dataset as input to load all the data into the database.
Back to top
View user's profile Send private message
syed-1919

New User


Joined: 26 Oct 2006
Posts: 12
Location: Chennai

PostPosted: Thu Nov 30, 2006 12:37 pm    Post subject: Re: What is the Meaning of Image Copy
Reply with quote

There are 2 ways in which one can copy a table.

One is to copy the content of a table/tables directly using the DB2 UNLOAD utility onto a dataset and the other is by taking an IMAGE COPY using the DB2 COPY utility.

The difference?

COPY utility copies the image of the table (meaning it uses an compression algorithm to store the data of a table) and if one opens the output dataset of COPY, the details would not be in a human readable format. Input for this is the table itself. It is basically executed for taking a back-up. When COPY is executed, an entry is made available in the SYSIBM.SYSCOPY table which could be useful for recovery purposes.

UNLOAD on the other hand, copies the content of a table directly onto a dataset (you can actually c the values of non-numeric columns) so that it could be used by the LOAD utility to load into a table. This could be one of the areas where UNLOAD could be used.

Also the input for UNLOAD could be a table or the Output of COPY utility.

Regards,
Syed
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 0 Tue Jan 17, 2017 4:26 pm
No new posts HALDB data refresh/copy from producti... vineetanand2007 IMS DB/DC 0 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