Results 1 to 4 of 4

Thread: row count

  1. #1
    Join Date
    May 2002
    Posts
    47

    Unanswered: row count

    How do I get a table row_count by querying the system tables?
    Are there multiple ways of doing it?
    ie. a quick way and a long way?

    Is there a better SQL editor that Command Center?

    DB2 v.8.1

    -Kevin

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: row count

    The CARD column in syscat.tables gives you the number of records in a table when runstats was last run ...

    I like WINSQL for SQL s

    Cheers
    Sathyaram

    Originally posted by ksexton
    How do I get a table row_count by querying the system tables?
    Are there multiple ways of doing it?
    ie. a quick way and a long way?

    Is there a better SQL editor that Command Center?

    DB2 v.8.1

    -Kevin
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    May 2002
    Posts
    47

    run stats?

    How do I run the statistics against the table?

    -Kevin

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    See the runstats command in the Command Reference Manual.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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