View previous topic :: View next topic
|
Author |
Message |
pkmurali Warnings : 1 Active User
Joined: 15 Dec 2005 Posts: 271
|
|
|
|
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 |
|
|
guptae
Moderator
Joined: 14 Oct 2005 Posts: 1208 Location: Bangalore,India
|
|
Back to top |
|
|
Gautam512
Active User
Joined: 05 Oct 2005 Posts: 308 Location: Vizag / US
|
|
|
|
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 |
|
|
syed-1919
New User
Joined: 26 Oct 2006 Posts: 12 Location: Chennai
|
|
|
|
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 |
|
|
|