runstats columns faroffpos& zos/390 db2v7

Steve Neff

runstats columns faroffpos& zos/390 db2v7
Hello,

Here is my situation. I run runstats with the following syntax
RUNSTATS TABLESPACE database.tablespace INDEX(ALL) TABLE(ALL) SAMPLE 25
SHRLEVEL(CHANGE).
I then check the index statistics in SYSIBM.SYSINDEXPART. Certain columns
still have a -1 and these columns are CARD FAROFFPOS & NEAROFFPOS. The
STATSTIME is populated with the time the runstats job was run. Why would
these columns not have stats? I do the same syntax with other table spaces
and the columns do have stats. Does RUNSTATS populate these columns
differently and if so why.

Thank you

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm