Also make sure that the max file size for the instance owner has not
been exceeded (ulimit command).
Erik
-----Original Message-----
From: Schwanbeck Bernie (RBC Dain)
[mailto:db2udbdba-ezmlmshield-x19498901.[Email address protected]
Sent: Wednesday, April 27, 2005 8:19 AM
To: LazyDBA Discussion
Subject: RE: SYSCATSPACE Tablespace is full
Have your unix Admins increasing the file system, where the DB resides,
on the unix side via "chfs" cmd.
-----Original Message-----
From: BBlake
[mailto:db2udbdba-ezmlmshield-x64259063.[Email address protected]
Sent: Wednesday, April 27, 2005 10:13 AM
To: LazyDBA Discussion
Subject: SYSCATSPACE Tablespace is full
Hi everyone,
We have been having some problems with our DB2 (7.2) database over the
last couple weeks. Upon some investigation, I am seeing errors like
this in the db2diag.log file:
2005-04-27-07.56.22.590000 Instance:DB2 Node:000
PID:1808(db2syscs.exe) TID:2632 Appid:7F000001.310D.050427134225
lob_manager sqldx_lob_create Probe:50 Database:OWSH7333
DIA9999E An internal error occurred. Report the following error code :
"0xFFFFD121".
Looking in the Control Center for this database, it looks like I have
several databases that are 100% full:
- TEMP32K
- TEMP4K
- SYSCATSPACE
- USERSPACE1
These are all System Managed Tablespaces. I am assuming that this is
what is causing the errors I am seeing. However, I can't find a way to
extend these tablespaces, to increase the size so that they are not 100%
full. It appears that you can only extend Database-Managed tablespaces.
Can anyone enlighten a new DB2 Admin??
Thanks,
Brad Blake
[Email address protected]
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
RBC Dain Rauscher does not accept buy, sell or cancel orders by e-mail,
or any instructions by e-mail that would require your signature.
Information contained in this communication is not considered an
official record of your account and does not supersede normal trade
confirmations or statements. Any information provided has been prepared
from sources believed to be reliable but is not guaranteed, does not
represent all available data necessary for making investment decisions
and is for informational purposes only.
This e-mail may be privileged and/or confidential, and the sender does
not waive any related rights and obligations. Any distribution, use or
copying of this e-mail or the information it contains by other than an
intended recipient is unauthorized. If you receive this e-mail in
error, please advise me (by return e-mail or otherwise) immediately.
Information received by or sent from this system is subject to review by
supervisory personnel, is retained and may be produced to regulatory
authorities or others with a legal right to the information.
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
DB2 & UDB email list listserv db2-l LazyDBA home page