View previous topic :: View next topic
|
Author |
Message |
tjk3030
New User
Joined: 18 Mar 2006 Posts: 22
|
|
|
|
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 |
|
|
the_gautam
Active User
Joined: 05 Jun 2005 Posts: 165 Location: Bangalore
|
|
|
|
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 |
|
|
|