Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Space allocated for a DB2 table..

Status
Not open for further replies.
balajipn

balajipn

Programmer
Mar 30, 2004
65
IN
Hi,

I am an average DB2 user and I would to know a way to find out the following.

1. Space allocated for a DB2 table in tracks, cyls and MB or GBs.
2. Space occupied by the data in the table in tracks, cyls or MB or GBs.

Is it possible to find out the above info from DB2 catalog tables?. Or by using TSO commands like LISTCAT with underlying VSAM cluster name of a DB2 table as a parameter?.

Thanks,
Balaji.
 
Status
Not open for further replies.

Similar threads

P
  • Locked
  • Question
DB2 LUW SYSCATSPACE is full
Replies
0
Views
393
prashant_0701
P
tekpr00
  • Locked
  • Question
Adding storage to DB2 PureScale Cluster
Replies
0
Views
305
tekpr00
tekpr00
C
  • Question
Conditionally have a subfile display record blink
Replies
5
Views
420
mikrom
mikrom
gdg1976
  • Locked
  • Question
db2 sql extract double rows (different in case sensitive) 1
Replies
6
Views
252
mikrom
mikrom
Thomas B
  • Locked
  • Question
"BMC AMI Ops Monitor for Db2" (mvmon) trace for prepared statements (from Java)
Replies
0
Views
170
Thomas B
Thomas B

Part and Inventory Search

Sponsor

Back
Top