Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2013
    Posts
    26

    Unanswered: Regarding SYSPROC.REORGCHK_TB_STATS

    Hi, Does SYSPROC.REORGCHK_TB_STATS do update of statistics before it does a reorgchk?

    Thanks

  2. #2
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    Hi,

    No, it doesn't.
    Actually it's easy to check comparing the timestamps from the 1-st and the 3-rd queries of:
    Code:
    SELECT STATS_TIME FROM SYSCAT.TABLES WHERE TABSCHEMA='MYSCHEMA' AND TABNAME='MYTABLE';
    CALL SYSPROC.REORGCHK_TB_STATS('T', 'MYSCHEMA.MYTABLE');
    SELECT STATS_TIME FROM SYSCAT.TABLES WHERE TABSCHEMA='MYSCHEMA' AND TABNAME='MYTABLE';
    Regards,
    Mark.

  3. #3
    Join Date
    Nov 2013
    Posts
    26
    Thanks Mark

Posting Permissions

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