|
View previous topic :: View next topic
|
| Author |
Message |
autobox
New User
Joined: 19 Aug 2005
Posts: 51
|
|
|
|
Hi all,
We now have a tablespace which is big, there are some information from SYSTABLESPACE catalog table:
| Code: |
+---------+---------+---------+
DSSIZE TYPE SPACE
+---------+---------+---------+
0 3326400 |
Can you please advise what's the space limitation of this kind of tablespace? Any reference to check?
If the tablespace is full, how to handle it?
Thanks in advance! |
|
| Back to top |
|
 |
Nic Clouston
Global Moderator
Joined: 10 May 2007
Posts: 2454
Location: Hampshire, UK
|
|
|
|
| One of the DB2 manuals - your DBA should be able to advise on all those points. |
|
| Back to top |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010
Posts: 3076
Location: NYC,USA
|
|
| Back to top |
|
|
autobox
New User
Joined: 19 Aug 2005
Posts: 51
|
|
|
|
Hi Nic, Robit and all,
Thanks for the reply, and checked some references:
For table space type is empty, if the DSSIZE column is zero, the table space is not greater than 64 gigabytes.
I am kinda of DBA role in my team and monitor tablespace status daily, so really need advice here if this tablespace will grow to 64G?
Thanks again! |
|
| Back to top |
|
|
|
|
