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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

question on how to get tables with rows > 1000000

Status
Not open for further replies.
cougartrace

cougartrace

Technical User
Sep 9, 2003
29
US
Hi all,

In DB2 UDB (were on 8.1 on AIX), how can I get a listing of tables that have a rowcount greater than 100,000?

CougarTrace
 
Sort by date Sort by votes
Assuming, stats are current :
db2 "select tabname from syscat.tables where card >100000
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

gdg1976
  • Locked
  • Question
extract rows with characters in char field
Replies
6
Views
190
gdg1976
gdg1976
tekpr00
  • Locked
  • Question
Adding storage to DB2 PureScale Cluster
Replies
0
Views
187
tekpr00
tekpr00
gdg1976
  • Locked
  • Question
db2 sql extract double rows (different in case sensitive) 1
Replies
6
Views
166
mikrom
mikrom
MichaelDe
  • Locked
  • Question
SQL Update with File Join
Replies
10
Views
604
MichaelDe
MichaelDe
ANGELDANY
  • Locked
  • Question
WEEK ISO with Dates in string format YYYYMMDD 1
Replies
4
Views
238
ANGELDANY
ANGELDANY

Part and Inventory Search

Sponsor

Back
Top