Linux
Db2 8.2

I'm looking to monitor table growth via record count. I was just going to right a simple script to select count(*) from x, but wanted to see if there any good scripts or db2 tools out there.

Thanks,
Charlie

How often do you plan to do this benchmarking? If a table has tons and tons of rows, the count(*) can take quite a while. If the benchmarks are taken at about the same time that runstats are executed, then you can just query the syscat.tables view like this: select tabschema,tabname,card from syscat.tables. It will not be 100% accurate, just when the last runstats ran. But this maybe all you need.

HTH

Andy

Yea this may be all I need. I was planning on running a count once a day.

Thanks,

Charlie.

if you want to have a check on storage
db2cc>manage storage