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
 
Questions about DB2 COPYTOCOPY Utility

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

New User


Joined: 11 Dec 2008
Posts: 33
Location: China

PostPosted: Wed Aug 11, 2010 5:12 pm    Post subject: Questions about DB2 COPYTOCOPY Utility
Reply with quote

Dears,

I got a DB2 problem at Apr 2010 and hope can seek some advice from your side.

Our job PLIMDB14 is a off-site backup db2 talbe job using COPYTOCOPY utility and it failed in production due to tape error when wrote IMIMSTTS in tape.SYSIN as below:

Code:

COPYTOCOPY TABLESPACE LIMPMBDP.IMIMSTTS COPYDDN(,IMIMSTTS) 
COPYTOCOPY TABLESPACE LIMPMBDP.IMIRLSTS COPYDDN(,IMIRLSTS) 
COPYTOCOPY TABLESPACE LIMPMBDP.IMISTHTS COPYDDN(,IMISTHTS) 
COPYTOCOPY TABLESPACE LIMPMBDP.IMIBLHTS COPYDDN(,IMIBLHTS) 
COPYTOCOPY TABLESPACE LIMPMBDP.IMIRLBTS COPYDDN(,IMIRLBTS)


Then we rerun the job as job recovery instruction as below:

Code:

1ST RE-RUN                                               
---------------------------------------------------------
              COPYDDN(,IMIMSTTS)--> RECOVERYDDN(IMIMSTTS,)
              COPYDDN(,IMIRLSTS)--> RECOVERYDDN(IMIRLSTS,)
              COPYDDN(,IMISTHTS)--> RECOVERYDDN(IMISTHTS,)
              COPYDDN(,IMIBLHTS)--> RECOVERYDDN(IMIBLHTS,)
              COPYDDN(,IMIRLBTS)--> RECOVERYDDN(IMIRLBTS,)
2ND RE-RUN                                               
---------------------------------------------------------
              COPYDDN(,IMIMSTTS)--> RECOVERYDDN(,IMIMSTTS)
              COPYDDN(,IMIRLSTS)--> RECOVERYDDN(,IMIRLSTS)
              COPYDDN(,IMISTHTS)--> RECOVERYDDN(,IMISTHTS)
              COPYDDN(,IMIBLHTS)--> RECOVERYDDN(,IMIBLHTS)
              COPYDDN(,IMIRLBTS)--> RECOVERYDDN(,IMIRLBTS)


But it failed again with error message 'INVALID OPERAND FOR KEYWORD 'RECOVERYDDN''.

1 hour later our tape performed initialization & power cycle and we rerun the job with original version(without change copyddn to recoveryddn) it ended ok.

So we suspect the recovery instruction is not exact.We think when copy occurs error for any of the table space we can just rerun if type is ok.

Any guys can advice about it?I know COPYTOCOPY can create local site primary copy and backup copy and recovery site primary and backup copy.But in my situation first run when it was creating backup copy to tape it failed due to tape error.when rerun is it necessary to change COPYDDN(,AAAAAAAA) to RECOVERYDDN(,AAAAAAA)?seems it is not recovery way.
Back to top
View user's profile Send private message

lee_issc

New User


Joined: 11 Dec 2008
Posts: 33
Location: China

PostPosted: Wed Aug 11, 2010 6:33 pm    Post subject:
Reply with quote

Nobody notice it? icon_redface.gif
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10374
Location: italy

PostPosted: Wed Aug 11, 2010 6:49 pm    Post subject: Reply to: Questions about DB2 COPYTOCOPY Utility
Reply with quote

Quote:
got a DB2 problem at Apr 2010

... You waited 5 months, soliciting for an answer after 1 hour and 15 minutes the initial question is ... any derogatory adjective of Your choice

... since Your manager referred to the forum, seems that he is expecting some free consultancy services ( unhetical isn' t it icon_question.gif icon_evil.gif )
on his terms and timings

Well, tell Your manager that people answer on their own time and at no charge
if You have time issues it would be wiser to get a paid consultant
( as a part of the contract You organization might want to include some time specific constraints )
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 NULLFILE on ICEGENER Utility Ashishpanpaliya DFSORT/ICETOOL 5 Wed Nov 08, 2017 10:45 pm
No new posts Table(Unicode(Graphic) table) loading... muralikrishnan_new DB2 0 Thu Oct 05, 2017 5:10 pm
No new posts How to Use DebugTool CodeCoverage Uti... neo4u IBM Tools 0 Thu Jun 22, 2017 6:38 pm
No new posts Search utility(3.14) using JCl and Cobol RKS3 COBOL Programming 12 Sat Jun 10, 2017 10:24 pm
No new posts DB2 - TERMINATE utility vasanthz DB2 5 Mon May 15, 2017 11:49 pm

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