By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,584 Members | 1,750 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,584 IT Pros & Developers. It's quick & easy.

Impact of Overflows and Page Reorgs

P: n/a
I'm working with several stored procedures processing a large volume of
data. After monitoring their execution using Quest's Spotlight
functionality I noticed a fair number of overflow accesses against
system tables such as SYSTABLES. I also observe page reorgs for the
SYSCOLDIST and SYSCOLUMNS tables.

My question for someone with experience tuning DB2 is how much of a
performance impact do these overflows and page reorgs have? Are they
worth addressing? I increased the buffer pool sizes for the syscat
tablespace somewhat but haven't seen a significant decrease in
overflows. Is more memory the best way to address this? Etc.

Any background would be helpful.

TIA.

Jun 26 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
David Beardsley wrote:
I'm working with several stored procedures processing a large volume of
data. After monitoring their execution using Quest's Spotlight
functionality I noticed a fair number of overflow accesses against
system tables such as SYSTABLES. I also observe page reorgs for the
SYSCOLDIST and SYSCOLUMNS tables.

My question for someone with experience tuning DB2 is how much of a
performance impact do these overflows and page reorgs have? Are they
worth addressing? I increased the buffer pool sizes for the syscat
tablespace somewhat but haven't seen a significant decrease in
overflows. Is more memory the best way to address this? Etc.

In the grand scheme it won't matter. DB2 has a separate catalog cache.
It won't go after the catalog after a it's warmed up.

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ond...ness/conf2006/
Jun 26 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.