View previous topic :: View next topic
|
Author |
Message |
sheersh
New User
Joined: 24 May 2008 Posts: 17 Location: Gurgaon
|
|
|
|
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 |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008 Posts: 8696 Location: Dubuque, Iowa, USA
|
|
|
|
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 |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010 Posts: 3051 Location: NYC,USA
|
|
|
|
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 |
|
|
|