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
 

 

DB2 utilities, contention or failure?

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

New User


Joined: 24 May 2008
Posts: 15
Location: Gurgaon

PostPosted: Fri Apr 21, 2017 6:18 pm    Post subject: DB2 utilities, contention or failure?
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: 8117
Location: East Dubuque, Illinois, USA

PostPosted: Fri Apr 21, 2017 6:58 pm    Post subject:
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

Senior Member


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

PostPosted: Fri Apr 21, 2017 10:14 pm    Post subject:
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    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 ALLOCATE REXX PDS to SYSPROC failure mambopras CLIST & REXX 4 Sat Apr 04, 2015 10:14 am
No new posts GRS contention on IMS resource Hooman24 IMS DB/DC 7 Sun Jan 11, 2015 1:28 pm
No new posts OPC/Tivoli OCL failure (line 1560) David Robinson IBM Tools 14 Mon Dec 01, 2014 7:13 am
No new posts FTINCL failure code 20 Invalid contro... Steve Coalbran TSO/ISPF 2 Mon Aug 04, 2014 10:44 am
No new posts How to reduce PDRB latch contention? Hooman24 IMS DB/DC 0 Sun Jun 22, 2014 8:53 pm


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