Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2006
    Location
    Columbus, OH
    Posts
    69

    Unanswered: Benchmarking table counts

    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

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    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

  3. #3
    Join Date
    Sep 2006
    Location
    Columbus, OH
    Posts
    69
    Yea this may be all I need. I was planning on running a count once a day.

    Thanks,

    Charlie.

  4. #4
    Join Date
    Jul 2006
    Location
    Pune , India
    Posts
    433
    if you want to have a check on storage
    db2cc>manage storage
    Rahul Singh
    Certified DB2 9 DBA / Application Developer

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •