And for good measure that the filesystem is 'large file enabled'.
Colin.
|---------+--------------------------------------------------------->
| | "Erik Smith " |
| | <db2udbdba-ezmlmshield-x74791264.[Email Address Removed] | azyDBA.com> |
| | |
| | 27/04/2005 16:36 |
| | |
|---------+--------------------------------------------------------->
>-----------------------------------------------------------------------------------------------|
| |
| To: "LazyDBA Discussion" <[Email address protected] |
| cc: |
| Subject: [Possible Spam] RE: SYSCATSPACE Tablespace is full |
>-----------------------------------------------------------------------------------------------|
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
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
*********************************************************************
Notice: This email is confidential and may contain copyright material
of the John Lewis Partnership. If you are not the intended recipient,
please notify us immediately and delete all copies of this message.
(Please note that it is your responsibility to scan this message for viruses).
Email to and from the John Lewis Partnership is automatically
monitored for operational and lawful business reasons.
*********************************************************************
John Lewis plc Registered in England 233462
Registered office 171 Victoria Street London SW1E 5NN
Websites: http://www.johnlewis.com http://www.waitrose.com
http://www.johnlewispartnership.co.uk
DB2 & UDB email list listserv db2-l LazyDBA home page