Joined: 15 Dec 2002 Posts: 637 Topics: 43 Location: Bengaluru, INDIA
Posted: Sun Jan 11, 2004 5:04 am Post subject: SYSCOP dataset already exists.
Hi,
I am facing problem while uploading records from a flat file. I get a message saying,
Quote:
DATA SET ALREADY USED FOR PREVIOUS IMAGE COPY DDNAME SYSCOP01
I found from Kolusu in the other forum:
Quote:
DB2 Automatically stores information about about full and incremental image copies in the catalog table SYSIBM.SYSCOPY.The information will be used by the recover utility.So every time you run the Image copy it tries to update the catalog tables with the image copy info dataset which is the prime reason you are getting the error.
The manual do not speak about the use or non-use of any kind of dataset/DISP for SYSCOPxx.
However, I am using a GDG. Despite, this I get the message for re-using an already used dataset! For example,
Yes, I deleted all generations before re-submitting. Yet, I get the above message. So, how do I use GDG for image copies?
For testing purposes, I removed the GDG base name and replaced it with a PS file. While re-running I changed the DISP=OLD. This too throws the same error message. Perhaps, this can be explained by the first quote that I have typed above.
I have another doubt in my mind. Suppose, I am able to fix the problem of upload while using GDG. If the upload step is restarted in case of a ABEND, then the backup cannot be taken into the latest generation with DISP=OLD. Right? The only way would be to get the latest generation and raise its version number. That is, change the dataset name to XXXXXXX.IMGCOPY.PRI.G0001V01. Right?[/list] _________________ ALL opinions are welcome.
Debugging tip:
When you have eliminated all which is impossible, then whatever remains, however improbable, must be the truth.
-- Sherlock Holmes.
Joined: 15 Dec 2002 Posts: 637 Topics: 43 Location: Bengaluru, INDIA
Posted: Sun Jan 11, 2004 5:26 am Post subject:
The answer to,
Quote:
The only way would be to get the latest generation and raise its version number. That is, change the dataset name to XXXXXXX.IMGCOPY.PRI.G0001V01. Right?
is Yes.
I just tested it. _________________ ALL opinions are welcome.
Debugging tip:
When you have eliminated all which is impossible, then whatever remains, however improbable, must be the truth.
-- Sherlock Holmes.
Joined: 15 Dec 2002 Posts: 637 Topics: 43 Location: Bengaluru, INDIA
Posted: Sun Jan 11, 2004 6:12 am Post subject:
I just tested a situation with the GDG generation +11. This ran fine. Then, I deleted this generation and resubmitted. It failed.
This means, SYSIBM.SYSCOPY (?) stores the dataset name which was used for image copy. When I resubmitted-even after deleting-I got an ABEND as this dataset name was used before.
So, for a restart (in a rare case), the GDG must be changed with an incremented version number.
We do not want an altgether new generation, as we have to associate the generations to day of run.
I guess, I must have tried more before posting this thread.
Any inconvenience regretted. _________________ ALL opinions are welcome.
Debugging tip:
When you have eliminated all which is impossible, then whatever remains, however improbable, must be the truth.
-- Sherlock Holmes.
Joined: 26 Nov 2002 Posts: 12376 Topics: 75 Location: San Jose
Posted: Mon Jan 12, 2004 5:20 am Post subject:
Cogito,
Can you post your Image copy control statements? You can use a GDG for an image copy with DISP=(MOD,CATLG,CATLG).The sample control statements should be as follows
Joined: 15 Dec 2002 Posts: 637 Topics: 43 Location: Bengaluru, INDIA
Posted: Tue Jan 13, 2004 1:14 am Post subject:
And, if this step abends, we start with GDG gen as 0 and DISP=(MOD,CATLG)? (Because, OLD did not work for me.) Is this what you are saying? _________________ ALL opinions are welcome.
Debugging tip:
When you have eliminated all which is impossible, then whatever remains, however improbable, must be the truth.
-- Sherlock Holmes.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
