Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2007
    Posts
    66

    Unanswered: Runstats on a check pending table

    Can we run runstats on a table with check pending status??

    Is there anyway that a table will go into check pending status other than after a load??

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    I do not know about running runstats on a check pending table. You can always try it in a test environment and see what transpires.

    A table can also get into that state by the SET INTEGRITY statement.

    http://publib.boulder.ibm.com/infoce...n/r0000998.htm

    Andy

  3. #3
    Join Date
    Sep 2004
    Location
    Belgium
    Posts
    1,126
    or by adding a foreign key or check constraint.
    --_Peter Vanroose,
    __IBM Certified Database Administrator, DB2 9 for z/OS
    __IBM Certified Application Developer
    __ABIS Training and Consulting
    __http://www.abis.be/

Posting Permissions

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