hi ..Please help me fast....i am new to db2..i want two sql queries in db2..

1.To count number of users(sql query in db2)

2.To get average table size(sql query in db2)

help as fast as possible....pls...pls...

Views: 168

Reply to This

Replies to This Discussion

use the reorgchk current statistics on table <tabname>  table size

TSIZE indicate as Table size, you need to run the runstats for getting the actual size..

For user count qurey for syscat.tabauth table


Featured Downloads

Try BLU Acceleration on Cloud

© 2020   Created by channeldb2.   Powered by

Badges  |  Report an Issue  |  Terms of Service