IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search Log in to check your private messages Log in
 

DB2 utilities, contention or failure?


 
IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: :: View next topic  
Author Message
sheersh

New User


Joined: 24 May 2008
Posts: 17
Location: Gurgaon

PostPosted: Fri Apr 21, 2017 6:18 pm
Reply with quote

If any DB2 utility is running on the table (reorg, runstat, load, unload etc), I understand it takes exclusive hold of the table. What will happen if another job comes in queue to read data from the same table during utility run? would read job wait for utility to finish or wait job will fail?
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8566
Location: Dubuque, Iowa, USA

PostPosted: Fri Apr 21, 2017 6:58 pm
Reply with quote

Quote:
What will happen if another job comes in queue to read data from the same table during utility run? would read job wait for utility to finish or wait job will fail?
You are asking an EXTREMELY broad question and hence the only possible answer is "it depends upon the utility and what the job is attempting to do". The DB2 V10 Utility Guide and Reference manual is 1151 pages and each utility described in this manual has a "Concurrency and compatibility" section describing what the restrictions on it as far as other jobs running simultaneously. I HIGHLY recommend you start reading the Utility Guide and Reference manual for your version of DB2 -- it will answer your questions. If it takes you a few weeks to read over a thousand pages, then so be it -- you need to learn this material sooner or later any way.
Back to top
View user's profile Send private message
Rohit Umarjikar

Global Moderator


Joined: 21 Sep 2010
Posts: 2503
Location: NY,USA

PostPosted: Fri Apr 21, 2017 10:14 pm
Reply with quote

It sounds like an interview question, so please post it to the right section of the forum otherwise give a try and see what happens.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic All times are GMT + 6 Hours
Forum Index -> DB2
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Forum Replies
No new posts Auto ticketing of a job failure ABENDS & Debugging 1
No new posts Failure after DIR command All Other Mainframe Topics 2
No new posts ALLOCATE REXX PDS to SYSPROC failure CLIST & REXX 4
No new posts GRS contention on IMS resource IMS DB/DC 7
No new posts OPC/Tivoli OCL failure (line 1560) IBM Tools 14

Back to Top