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
 

 

Creating Imagecopies

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

Active User


Joined: 17 May 2006
Posts: 310

PostPosted: Tue Apr 22, 2008 7:03 pm    Post subject: Creating Imagecopies
Reply with quote

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.
Back to top
View user's profile Send private message

mkk157

Active User


Joined: 17 May 2006
Posts: 310

PostPosted: Wed Apr 23, 2008 12:13 pm    Post subject: Creating Imagecopies
Reply with quote

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.
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 Creating an 'Enter' event with IMS MF... dileep chirasani Java & MQSeries 1 Sat Aug 06, 2016 2:23 am
No new posts Creating a dynamic sort card in JCL u... ChitraChhabra DFSORT/ICETOOL 4 Wed Aug 03, 2016 6:15 pm
No new posts creating a physical sequential file i... Shaheen Shaik JCL & VSAM 8 Wed Jun 29, 2016 3:46 pm
No new posts Faccing issues while creating a GDG V... sravindra_s JCL & VSAM 5 Thu Jun 23, 2016 11:26 am
No new posts Creating a pipe delimited file from C... dmanwi COBOL Programming 1 Sat Mar 19, 2016 10:40 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us