Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2005
    Posts
    102

    Unanswered: REORGCHK generates blank values

    Hi Everybody!

    I am working on DB2 UDB v8.2 FP 7 on Windows 2003 Standard Edition.

    I am doing a REORGCHK with current statistics on all my tables using (REORGCHK current statistics on table all) but the output it is generating is all blank. No values are recorded against any of the table.

    DO I need to do a RUNSTATS before I do REORGCHK with current statistics? I don't want to run REORGCHK with update statistics since its a prod environment and there are tons of tables in this database.

    Thanks
    Anks

  2. #2
    Join Date
    Feb 2004
    Location
    Copenhagen
    Posts
    220

    Arrow ?

    You cannot do a serious check for need of reorganisation without
    current statistics !!
    Kristian K. Hansen
    Project Supervisor
    National Board of Health

  3. #3
    Join Date
    Aug 2002
    Location
    Chennai, India
    Posts
    184
    You could use the 'shrlevel change' option of runstats in V7 so that other users of the table can read from and write to the table while statistics are calculated.

    Example:
    runstats on table db2inst1.emp with distribution and detailed indexes all shrlevel change

    You can generate a script for all tables in the database in this fashion...

    However, as you are on v8 you can use the 'allow write access' option ...

    select 'runstats on table db2inst1.'||tabname||' with distribution and detailed indexes all allow write access;' from syscat.tables where tabschema = 'DB2INST1';

    HTH.
    Last edited by ggnanaraj; 06-23-06 at 01:07.

  4. #4
    Join Date
    Jul 2005
    Posts
    102
    Thanks to both of you.

    anks

Posting Permissions

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