View previous topic :: View next topic
|
Author |
Message |
naive
New User
Joined: 26 Apr 2005 Posts: 46 Location: LA
|
|
|
|
Guys
emergency!!
we got one job that takes a table unload with a normal DSNTIAUL (full extract).
we got another job that takes an image copy of the same table with a DSNUTILB utility (COPY TABLESPACE).
Can these jobs run parallely?????? I mean is there any chance of a contention problem?? |
|
Back to top |
|
|
khamarutheen
Active Member
Joined: 23 Aug 2005 Posts: 677 Location: NJ
|
|
|
|
Hi frnd,
I think u may occur some problem once it runs parallely.. bcz as u said one is unloading a table and one takes image copy.. so it's better i think to run it in seperate schedule... |
|
Back to top |
|
|
naive
New User
Joined: 26 Apr 2005 Posts: 46 Location: LA
|
|
|
|
thats toooo bad..... this would impact our batch window.. if i have got to make one of these jobs dependent on the other....
Any suggestions anyone??? Any magic word to use the table in "share" mode for both jobs??? |
|
Back to top |
|
|
anilbatta
New User
Joined: 13 Nov 2005 Posts: 22
|
|
|
|
Hi
We can run the jobs parallely bcoz the jobid's will be different. The first job will execute in SYSA and the other job will run in SYSB servers.
Here awe are using two utilities called DSNTIAUL and DSNUTILB in which the first one is for Extracting the job log information thru JES2 or JES3 and the second is for copying the tables to the specified location.
According to my understanding, we can run the jobs parallely without any job contention. |
|
Back to top |
|
|
khamarutheen
Active Member
Joined: 23 Aug 2005 Posts: 677 Location: NJ
|
|
|
|
Hi anibatta,
Yes the Jobs can b ran parallely.. but his problem is one job is doing unloading a table and one takes image copy. so it's his problem.. can u get any solution now..??? |
|
Back to top |
|
|
naive
New User
Joined: 26 Apr 2005 Posts: 46 Location: LA
|
|
|
|
guys, just to clarify things: we are talking unload n imagecopy of the same table(or tablespace for copy)..
now someone please tell me if there can b a contention prob?? |
|
Back to top |
|
|
khamarutheen
Active Member
Joined: 23 Aug 2005 Posts: 677 Location: NJ
|
|
|
|
Hi VG,
since imagecopy is used for taking backup like that.. v will surely get abend once u run both parallely... so v should try some other utility i think so.. |
|
Back to top |
|
|
naive
New User
Joined: 26 Apr 2005 Posts: 46 Location: LA
|
|
|
|
but the thing is .. imagecopy is supposed to work on the tablespace level (physical) and the unload on the logical table right??i mean i am not sure if they should have a contention problem...
i have a suspicion.. and i would like someone to confirm it....(whether it happens or not) |
|
Back to top |
|
|
ragshere
New User
Joined: 20 Dec 2004 Posts: 70
|
|
|
|
Hi Guys,
you can run UNLOAD and IMAGE COPY in parellel. Because both will take share lock on the table/tablespace lock. there won't be any contention as I know.
Thanks
Rags |
|
Back to top |
|
|
|