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 Rhinorhino 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
Joined
Sep 9, 2003
Messages
29
Location
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 Question
ADM10501W - Health indicator "Database Automatic Storage Utilization"
Replies
0
Views
678
handle907
handle907
gdg1976
  • Locked
  • Question Question
extract rows with characters in char field
Replies
6
Views
950
gdg1976
gdg1976
handle907
  • Locked
  • Question Question
Tablespace utilization rate is 80% but only few small tables there.
Replies
0
Views
439
handle907
handle907
gdg1976
  • Locked
  • Question Question
hi all, input TAB1 COL1
Replies
0
Views
432
gdg1976
gdg1976
ANGELDANY
  • Locked
  • Question Question
WEEK ISO with Dates in string format YYYYMMDD
Replies
4
Views
1K
ANGELDANY
ANGELDANY

Part and Inventory Search

Sponsor

Back
Top