473,378 Members | 1,209 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,378 software developers and data experts.

Growing SYSCATSPACE

hi,
the problem i am having is that the SYSCATSPACE of one of the
ODS's growing overnight. I am sure no new objects are being created.
What can be the cause of this? I am on db2udb for aix 8.2 fp 12. Please
let me kow if I need to be more specific

Aug 28 '06 #1
3 3422

Asphalt Blazer schrieb:
hi,
the problem i am having is that the SYSCATSPACE of one of the
ODS's growing overnight. I am sure no new objects are being created.
What can be the cause of this? I am on db2udb for aix 8.2 fp 12. Please
let me kow if I need to be more specific
One reason could be that a RUNSTATS WITH DISTRIBUTION was run for the
first time against all (or most) tables. This blows up system table
SYSCOLDIST (and others ...)

HTH
Joachim

Aug 28 '06 #2
I found some objects that were created unauthorized, i managed to drop
those objects but syscatspace has not gone down yet. Its at the same
level.
its not the problem with runstats, I have ascertained that.

Joachim Klassen wrote:
Asphalt Blazer schrieb:
hi,
the problem i am having is that the SYSCATSPACE of one of the
ODS's growing overnight. I am sure no new objects are being created.
What can be the cause of this? I am on db2udb for aix 8.2 fp 12. Please
let me kow if I need to be more specific

One reason could be that a RUNSTATS WITH DISTRIBUTION was run for the
first time against all (or most) tables. This blows up system table
SYSCOLDIST (and others ...)

HTH
Joachim
Aug 29 '06 #3

am******@gmail.com schrieb:
I found some objects that were created unauthorized, i managed to drop
those objects but syscatspace has not gone down yet. Its at the same
level.
its not the problem with runstats, I have ascertained that.

Joachim Klassen wrote:
Asphalt Blazer schrieb:
hi,
the problem i am having is that the SYSCATSPACE of one of the
ODS's growing overnight. I am sure no new objects are being created.
What can be the cause of this? I am on db2udb for aix 8.2 fp 12. Please
let me kow if I need to be more specific
One reason could be that a RUNSTATS WITH DISTRIBUTION was run for the
first time against all (or most) tables. This blows up system table
SYSCOLDIST (and others ...)

HTH
Joachim
AFAIK System tables behave like "normal" tables, means once they are
blown up they stay at that size until a reorg is done. Run runstats and
reorgchk on your system catalog to see which tables are overallocated
and reorg them.

HTH
Joachim

Aug 29 '06 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
by: Ryan R. Rosario | last post by:
Hi - **I apologize for posting this again. I dont think my first one went thru** I am in the process of converting a table based website over to a CSS based website and I am having a problem....
3
by: Esger Abbink | last post by:
Hello, it is very possible that this is a well described problem, but I have not been able to find the solution. On two production server (7.2rc2) of ours the data directory is growing to...
5
by: Bruce Pullen | last post by:
DB2 7.2 (ESE) on AIX 5.2. In 3 weeks, we've seen the following : Tablespace name = SYSCATSPACE Direct writes = 150306 Direct write elapsed...
0
by: Mark | last post by:
I understand the concept of catalog cache (memory allocated from the dbheap to allow catalog lookups without the need to access disk each time). But the DB2 catalog tablespace (SYSCATSPACE) is...
14
by: Sonic | last post by:
I have an MDE file that is growing exponentially (from 3,900 KB to over 132,000 KB today). I am not saving data in this MDE, although I use a mix of offline and SQL tables for Read Only querying. ...
41
by: Nitin Bhardwaj | last post by:
Hi all, I wanted to know whether the stack in a C program is growing upwards or downwards.So I wrote a little code to see that.Please guide me as to whether this code is correct in telling this...
1
by: Keith | last post by:
I have just tried form inheritance for the first time and I am having trouble with the controls shrinking each I build the project on my home computer and growing each time I build on my work...
4
by: yashgt | last post by:
Hi, We have created a SQL server 2000 database. We observe that the transaction log keeps growing over time. We are now about to run out of space. We have been periodically shrinking the...
6
by: Burkhard Schultheis | last post by:
I've installed a fresh DB2 V9.1 server (Express-C). Now I see, that the number of applications (db2 list applications) is growing all the times when a script is run which makes some database...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
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: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
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...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
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...

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.