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!

largest tables in database

Status
Not open for further replies.
cougartrace

cougartrace

Technical User
Sep 9, 2003
29
US
Can someone help me with a query that will give me the 30 largest tables in a DB2 UDB database?

Thanks,

CougarTrace
 
Sort by date Sort by votes
Something like:

Code: 
Select * from SYSCAT.TABLES WHERE TABSCHEMA = 'TARGET' order by NPAGES DESC FETCH FIRST 30 ROWS ONLY

Ties Blom
Information analyst
 
Upvote 0 Downvote
Ties is assuming you are using same pagesize for all tables, which of course in most cases is correct. otherwise you need to join with syscat.tablespaces to get the pagesize and multiply.

(assuming from the host system catalog structure)

Juliane
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

handle907
  • Locked
  • Question
ADM10501W - Health indicator "Database Automatic Storage Utilization"
Replies
0
Views
367
handle907
handle907
gdg1976
  • Locked
  • Question
extract rows with characters in char field
Replies
6
Views
354
gdg1976
gdg1976
handle907
  • Locked
  • Question
Tablespace utilization rate is 80% but only few small tables there.
Replies
0
Views
144
handle907
handle907
gdg1976
  • Locked
  • Question
hi all, input TAB1 COL1
Replies
0
Views
176
gdg1976
gdg1976
ANGELDANY
  • Locked
  • Question
WEEK ISO with Dates in string format YYYYMMDD 1
Replies
4
Views
389
ANGELDANY
ANGELDANY

Part and Inventory Search

Sponsor

Back
Top