ChannelDB2

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: 167

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

RSS

Featured Downloads

Try BLU Acceleration on Cloud

© 2019   Created by channeldb2.   Powered by

Badges  |  Report an Issue  |  Terms of Service