Table queue overflows

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Raj - 27 Jan 2006 19:08 GMT

Hi we have a lot of tablequeue overflows on the prod box, how can we
avoid them? we are on V8.2 partitioned.

Thanks,
Raj

Reply to this Message

Serge Rielau - 27 Jan 2006 21:56 GMT

> Hi we have a lot of tablequeue overflows on the prod box, how can we
> avoid them? we are on V8.2 partitioned.

Three angles:
1. Is your data partitioned properly? No? => Fix it
2. Is one of the involved tables smallish (maybe a lookup table)? Yes =>
consider a replicated table?
3. That's life. Make sure you got SMS TEMPSPACE backed up by sufficient
bufferpool

Cheers
Serge

Signature

Serge Rielau
DB2 Solutions Development
DB2 UDB for Linux, Unix, Windows
IBM Toronto Lab

Reply to this Message