mkk157
Active User
Joined: 17 May 2006 Posts: 310
|
|
|
|
Dear Expert,
I need some help on taking the Imagecopies for the tables. I have searched on the forum, But I couldn't get much details, so is the following post.
Here are my concerns.
Presently I have 10 tables in 5 different Tablespaces. I need to create the Imagecopies into 5 different GDG's with 5 generations each.
All the tables are Partitioned tablespaces. And the tables have a maximum of 40 records totally in all the partitions.
I have the followng script to take the Imagecopies.
//JSTEP010 EXEC @BMCPCPY,SYSTEM=DQA0,UID=TTTTTTTT,TYPE=D,
// GDGLIMIT=5
//SYSIN DD *
OUTPUT SYSCOPY
UNIT DASD
SPACE CYL
MAXPRIM 500
DSNAME TTYA.ABC.DBNAME.TBNAME(+1)
// DD *
COPY TABLESPACE TSNAME
DSNUM PART
COPYDDN SYSCOPY
GROUP YES
FULL YES
SHRLEVEL REFERENCE
RESETMOD NO
QUIESCE AFTER
PARALLEL 8
I am basically interested in creating the imagecopy for all the tables in daily basis and then unloading the data from them into a sequential file and then sending it to another program.
while taking the imagecopies, Probelm is One GDG version has been created for the first 4 tables and for the fifth table there were 3 generations created.
what is the meaning of creating the 3 versions of the GDG. I thought that it contains 10 partitions. It would have created 10 versions perhaps, instead created only 3.
Do we need to create the GDG with number of versions which is equal to the number of partitions of the table? Is it the general case?
and I have few other queries regarding the same
1) Can we take the image copies across a single table into 2 different GDG's? If so when we are trying to unload the data from the table, then which GDG will be referred. provided that the table has not updated in between
2) Could you please provide me the related link to get more information on the same. |
|
mkk157
Active User
Joined: 17 May 2006 Posts: 310
|
|
|
|
Yes,
I cracked it a little.
I have changed the paramter from PARALLEL 8 to PARALLEL 1 and then increased the GDG limit to 100 then it creates x number of versions where x is equal to the number of partitions of a table.
and another is I have just removed the paramter DSNUM PART
this time, only one generation was created and it contains all the records of all the partitons of the table. |
|