Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2007
    Posts
    21

    Unanswered: CARD is giving different result with COunt(*)

    Hi,

    I've a query

    select tabname,card from syscat.tables
    where
    tabname like 'CD%'
    and card<>0 with ur;

    in which the result is

    CDORDER_DETAILS_EPISODES - 11779

    when I issue count(*) from CDORDER_DETAILS_EPISODES, the result is 0.

    Why the result is different in both cases?

    The first query is used to check the number of records in CD tables for the replication process.

    Regards,
    Ananth.

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    The catalog statistics are only updated when you run the runstats command.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Nov 2007
    Posts
    21
    Thnaks,
    It's working now.

Posting Permissions

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