473,394 Members | 1,812 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,394 software developers and data experts.

Impact of Overflows and Page Reorgs

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
1 2728
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

179
by: SoloCDM | last post by:
How do I keep my entire web page at a fixed width? ********************************************************************* Signed, SoloCDM
3
by: datapro01 | last post by:
I have a question concerning reorgs. We have a relatively new DB2 system (8.1) on Aix 5.1 and we are trying to institute regular reorgs via scripts. Does it matter if the index for a table or...
1
by: fraffin | last post by:
I've tried this post on the listserv with little or no results. Hopefully someone can clear this confusion up for me. I've got a situation that has me somewhat befuddled. I have three tables...
10
by: datapro01 | last post by:
Running DB2 8.1.6A on AIX 5.1 We are experience package cache overflows. The high water mark for package cache is showing as 16,108,513 bytes, or approximately 3933 4K pages. The package...
3
by: hikums | last post by:
I have taken a table snapshot, and noticed two tables with high overflows. What should be done, if any. Table Schema = CASTING Table Name = ABC Table Type = User Data...
3
by: db2udbgirl | last post by:
Table level snapshot showed me a entry as below Table Schema = CARD Table Name = DEALER Table Type = User Data Object Pages = 3480 Index Object Pages = 2622 Rows...
2
by: datapro01 | last post by:
Running DB2 8.2 on AIX 5.2 I have a question on reorgs and reorgchk results. My reorg script is using the db2reorgchk (which I understand has certain limitations) to determine if a table or an...
3
by: rdudejr | last post by:
Hi all, Ive got a script Ive built which runs reorgs on all tables needing it based on output of reorgchk. The reorgs are ran inline. This past weekend, the reorgs were running against 450...
1
by: daiesy.ember | last post by:
I'm working on implementing online reorgs(V8 FP11 on AIX), and am seeing a lot of transaction logging during the reorgs. My problem is that the archive logs are filling up the active log path...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.