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
 
Merging of Incremental Image Copy with Full Image copy

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

New User


Joined: 09 Sep 2007
Posts: 60
Location: india

PostPosted: Fri May 28, 2010 6:46 pm    Post subject: Merging of Incremental Image Copy with Full Image copy
Reply with quote

Hi,

I m trying to merge Incremental Imagecopy to Full Image copy.
I have coded as:

Code:
//DSNUPROC EXEC PGM=DSNUTILB,REGION=6144K,                       
//       PARM='D01G,RDBDB1DC.MERGDB1,'                           
//STEPLIB  DD   DSN=DB2D.PSYSB.P.D01G.SDSNLOAD,DISP=SHR           
//SYSPRINT DD   SYSOUT=*                                         
//UTPRINT  DD   SYSOUT=*                                         
//SYSUDUMP DD   SYSOUT=*                                         
//COPY1    DD   DSN=RDBD.PEXTB.N.RDBDB006.RDBS2173.INCR,         
//        DISP=(MOD,CATLG,CATLG)                                 
//COPY2    DD   DSN=RDBD.PEXTB.N.RDBDB006.RDBS2173.FULL,         
//        DISP=(MOD,CATLG,CATLG)                                 
//SYSUT1   DD   DSN=RDBD.PEXTB.N.MERGED.FULL.RDBS2173,           
//      DISP=(NEW,CATLG,CATLG)                                   
//SYSIN    DD *                                                   
MERGECOPY TABLESPACE RDBDB006.RDBS2173                           
  COPYDDN      (COPY1,COPY2)                                     
 NEWCOPY  NO                                     




I m getting error

Code:
DSNU458I  -D2DC DSNUYAS2 - NO IMAGE COPIES TO MERGE                             
DSNU407I    DSNUBCKB - DATA SET ALREADY USED FOR PREVIOUS IMAGE COPY           
                      DDNAME COPY1                                             
DSNU408I    DSNUBCKB - 'RDBD.PEXTB.N.RDBDB006.RDBS2173.INCR' EXISTS WITH -     
                      VOLUME=(CATG)                                             
                      FILE SEQUENCE NUMBER=0                                   
                      RBA=X'C60B6C59F241'                                       
                      DATE=10/05/28                                             
                      TIME=08:17:16                                             


Can anyone help to resolve this error? I have tried to take help from Manuals but i did not get much.

Even i m not sure we need to give Full copy name also.

Regards,
Sajjan
Back to top
View user's profile Send private message

enrico-sorichetti

Senior Member


Joined: 14 Mar 2007
Posts: 10478
Location: italy

PostPosted: Fri May 28, 2010 6:52 pm    Post subject: Reply to: Merging of Incremental Image Copy with Full Image
Reply with quote

learn to use the code tags it makes things easier to read for people willing to answer

Your post has been edited to show how it looks much better
Back to top
View user's profile Send private message
ashimer

Active Member


Joined: 13 Feb 2004
Posts: 551
Location: Bangalore

PostPosted: Fri May 28, 2010 8:05 pm    Post subject:
Reply with quote

COPY1 DSN is already existing in your case.
NEWCOPY NO is going to create another incremental copy for the named tablespace and not merge the incremental copy with the full copy.

For merging use NEWCOPY YES to create a new full copy image - here you need to mention only the new full copy DSN to be created.

Code:

//DSNUPROC EXEC PGM=DSNUTILB,REGION=6144K,                       
//       PARM='D01G,RDBDB1DC.MERGDB1,'                           
//STEPLIB  DD   DSN=DB2D.PSYSB.P.D01G.SDSNLOAD,DISP=SHR           
//SYSPRINT DD   SYSOUT=*                                         
//UTPRINT  DD   SYSOUT=*                                         
//SYSUDUMP DD   SYSOUT=*                                         
//SYSCOPY1    DD     
           DSN=RDBD.PEXTB.N.RDBDB006.RDBS2173.INCR,         
//        DISP=(MOD,CATLG,CATLG)                                 
//SYSUT1   DD   DSN=&TEMP,           
//      DISP=(NEW,CATLG,CATLG)                                   
//SYSIN    DD *                                                   
MERGECOPY TABLESPACE RDBDB006.RDBS2173                           
  COPYDDN      SYSCOPY1
 NEWCOPY  YES         
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 Copy set of records based on condition krish.deepu SYNCSORT 2 Thu Mar 08, 2018 11:39 am
No new posts Merging records, but not all the time prino DFSORT/ICETOOL 17 Sat Feb 17, 2018 4:20 pm
No new posts Image copy after Online reorganization. lind sh IMS DB/DC 0 Tue Jan 30, 2018 9:58 pm
No new posts Copy Specific Groups V S Amarendra Reddy SYNCSORT 10 Thu Jan 11, 2018 1:16 am
No new posts Merging 2 records at multiple rows wi... Bijesh DFSORT/ICETOOL 2 Wed Dec 06, 2017 1:50 am

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