Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Can two jobs run parallelly if one imagecopy and one upload

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

New User


Joined: 26 Apr 2005
Posts: 46
Location: LA

PostPosted: Fri Dec 16, 2005 7:12 am    Post subject: Can two jobs run parallelly if one imagecopy and one upload
Reply with quote

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
View user's profile Send private message

khamarutheen

Active Member


Joined: 23 Aug 2005
Posts: 680
Location: NJ

PostPosted: Fri Dec 16, 2005 12:04 pm    Post subject: Contention problem
Reply with quote

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
View user's profile Send private message
naive

New User


Joined: 26 Apr 2005
Posts: 46
Location: LA

PostPosted: Fri Dec 16, 2005 12:08 pm    Post subject:
Reply with quote

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
View user's profile Send private message
anilbatta

New User


Joined: 13 Nov 2005
Posts: 22

PostPosted: Fri Dec 16, 2005 2:24 pm    Post subject:
Reply with quote

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
View user's profile Send private message
khamarutheen

Active Member


Joined: 23 Aug 2005
Posts: 680
Location: NJ

PostPosted: Fri Dec 16, 2005 2:40 pm    Post subject: solution request
Reply with quote

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
View user's profile Send private message
naive

New User


Joined: 26 Apr 2005
Posts: 46
Location: LA

PostPosted: Fri Dec 16, 2005 2:45 pm    Post subject:
Reply with quote

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
View user's profile Send private message
khamarutheen

Active Member


Joined: 23 Aug 2005
Posts: 680
Location: NJ

PostPosted: Fri Dec 16, 2005 2:59 pm    Post subject: image copy
Reply with quote

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
View user's profile Send private message
naive

New User


Joined: 26 Apr 2005
Posts: 46
Location: LA

PostPosted: Fri Dec 16, 2005 3:03 pm    Post subject:
Reply with quote

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
View user's profile Send private message
ragshere

New User


Joined: 20 Dec 2004
Posts: 70

PostPosted: Tue Dec 20, 2005 12:48 pm    Post subject:
Reply with quote

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
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 Determine Region with max bandwidth f... seahawk789 COBOL Programming 3 Mon Feb 27, 2017 8:26 pm
No new posts How to show message using batch jobs madprasy TSO/ISPF 7 Fri Sep 09, 2016 6:55 pm
No new posts Don't allow CICS to submit batch jobs prino JCL & VSAM 5 Mon Jul 25, 2016 3:26 pm
No new posts Predicting jobs which are about to re... kpanchabhai85 DFSORT/ICETOOL 4 Thu Jun 30, 2016 7:51 pm
No new posts How to find jobs that are in schedule... anilkumar922 All Other Mainframe Topics 5 Tue Jun 28, 2016 10:01 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us