lee_issc
New User
Joined: 11 Dec 2008 Posts: 33 Location: China
|
|
|
|
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. |
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
|
|
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 )
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 ) |
|