Raj wrote:
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
--
Serge Rielau
DB2 Solutions Development
DB2 UDB for Linux, Unix, Windows
IBM Toronto Lab