IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

DB2 tablespace space limitation


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
autobox

New User


Joined: 19 Aug 2005
Posts: 51

PostPosted: Tue Nov 03, 2020 3:22 pm
Reply with quote

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
View user's profile Send private message
Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 2455
Location: Hampshire, UK

PostPosted: Tue Nov 03, 2020 4:09 pm
Reply with quote

One of the DB2 manuals - your DBA should be able to advise on all those points.
Back to top
View user's profile Send private message
Rohit Umarjikar

Global Moderator


Joined: 21 Sep 2010
Posts: 2772
Location: NYC,USA

PostPosted: Tue Nov 03, 2020 7:13 pm
Reply with quote

www.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/sqlref/src/tpc/db2z_sql_createtablespace.html#db2z_sql_createtablespace__dt-maxtssize

Talk to DBA pls.
Back to top
View user's profile Send private message
autobox

New User


Joined: 19 Aug 2005
Posts: 51

PostPosted: Wed Nov 04, 2020 9:15 am
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Map VSAM Dataset to a Table/Tablespace DB2 5
No new posts Eliminating blank space in XML parsed... COBOL Programming 0
No new posts Getting space used/allocated for many... CLIST & REXX 10
No new posts What is a table space in db2 for z/os? DB2 13
No new posts VSAM Space allocated and used space ... JCL & VSAM 5
Search our Forums:

Back to Top