Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

How much of a DB2 tablespace is full

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
tjk3030

New User


Joined: 18 Mar 2006
Posts: 22

PostPosted: Wed Apr 16, 2008 1:38 am    Post subject: How much of a DB2 tablespace is full
Reply with quote

Is there a way to monitor or determine the amount of available space in for a DB2 tablespace? I am looking for some way to montior the tablespaces, to set an alert when one is getting full.
Our shop has Platinum utilities but I dont see anything in there. I'm not a DBA, and our DBA's say nothing is available. But I kind of find that hard to believe, the application guys find out when its full when their job errors off, I'd like to monitor it & they we notify the DBA's the table is full. I'd like to be proactive.
Back to top
View user's profile Send private message

the_gautam

Active User


Joined: 05 Jun 2005
Posts: 165
Location: Bangalore

PostPosted: Sat May 10, 2008 7:30 am    Post subject:
Reply with quote

i am not sure about it. since, i am not having mainframes access now, i cant check it also.

Code:
db2 list tablespace show detail

This command will list the detail of ALL tablespaces for the database to which you are currently connected.
Code:

          Tablespaces for Current Database

 Tablespace ID                        = 0
 Name                                 = SYSCATSPACE
 Type                                 = System managed space
 Contents                             = Any data
 State                                = 0x0000
   Detailed explanation:
     Normal
 Total pages                          = 31727
 Useable pages                        = 31727
 Used pages                           = 31727
 Free pages                           = Not applicable
 High water mark (pages)              = Not applicable
 Page size (bytes)                    = 4096
 Extent size (pages)                  = 32
 Prefetch size (pages)                = 192
 Number of containers                 = 1

 Tablespace ID                        = 1
 Name                                 = PROD_USER_TEMP
 Type                                 = System managed space
 Contents                             = User Temporary data
 State                                = 0x0000
   Detailed explanation:
     Normal
 Total pages                          = 1
 Useable pages                        = 1
 Used pages                           = 1
 Free pages                           = Not applicable
 High water mark (pages)              = Not applicable
 Page size (bytes)                    = 4096
 Extent size (pages)                  = 32
 Prefetch size (pages)                = 32
 Number of containers                 = 1

 Tablespace ID                        = 2
 Name                                 = PROD_SYSTEM_TEMP
 Type                                 = System managed space
 Contents                             = System Temporary data
 State                                = 0x0000
   Detailed explanation:
     Normal
 Total pages                          = 2
 Useable pages                        = 2
 Used pages                           = 2
 Free pages                           = Not applicable
 High water mark (pages)              = Not applicable
 Page size (bytes)                    = 4096
 Extent size (pages)                  = 64
 Prefetch size (pages)                = 768
 Number of containers                 = 2

 Tablespace ID                        = 3
 Name                                 = ACCOUNT_TS
 Type                                 = Database managed space
 Contents                             = Any data
 State                                = 0x0000
   Detailed explanation:
     Normal
 Total pages                          = 50000
 Useable pages                        = 49920
 Used pages                           = 29824
 Free pages                           = 20096
 High water mark (pages)              = 36608
 Page size (bytes)                    = 4096
 Extent size (pages)                  = 64
 Prefetch size (pages)                = 64
 Number of containers                 = 1
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Full health checks of IMS databases ashek15 IMS DB/DC 1 Sat Apr 01, 2017 8:34 am
No new posts Image Copy of a tablespace that conta... Robin Sulsona DB2 4 Thu Jun 02, 2016 1:47 am
No new posts IBMHPU - Tablespace and Imagecopy chaitanya bharath DB2 1 Fri Apr 15, 2016 5:54 pm
No new posts Append to file, but also remove old r... Garry Carroll JCL & VSAM 3 Mon Jan 25, 2016 8:05 pm
No new posts Query on Image Copy Tablespace and QU... vickey_dw DB2 3 Fri Oct 23, 2015 10:55 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us