Skip to Content
0
Former Member
Nov 08, 2012 at 08:53 AM

DB13 Online reorg of recommended indexes - causing contention

49 Views

Hi,

On weekend, we have DB13 entry to do 'online reorg of recommended indexes'. However, it has been causing some issue lately - job get either 00C900BA or

00C90083.

Is there a way of avoiding this happening?

Is it possible to say, online reorg window to be within 10:00 to 13:00 - and the job to cancel after? That way we can 'avoid' scheduling the load job during that

'reorg window'? -

- is this possible to implement, and how? Any logic, tool available for this - i.e. job cancelled at 13:00. And if so, what is the impact/side-effect?

Thanks,

Terry