Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2010
    Posts
    11

    Question Unanswered: could not update statistics, Error "-668" was returned

    DB2 Version : DWBE v9.5.0.1
    FIX PACK : 1
    OS : AIX 5.3
    ==================================================

    I am trying to run reorgchk on a database.

    I am able to run reorgchk with current statistics option but when i use
    update statistics option it gives following error.

    db2 => reorgchk update statistics on table all

    Doing RUNSTATS ....


    SQL2310N The utility could not generate statistics. Error "-668" was
    returned.

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    -668 is sql0668n:
    IBM DB2 9.5 Information Center for Linux, UNIX, and Windows


    Some table is not accessible. Check db2diag.log for more information (may need to increase diaglevel to 4).

Posting Permissions

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