Where is the Control Center getting the information from for the "Statistics time" column? The column tells you the last time statistics were gathered on each table. I would think it's in one of the sysibm views, but I don't see it. Thanks, jeff

syscat.tables: STATS_TIME

Andy

that doesn't have the same dates that show on the "control center"

I looked on my system and the timestamps match. What DB2 version and OS is your server, and what is your client (where you are running control center)?

Andy

the server is aix. my client is windows. the server is 8 fp14 and my client is 9.5. i assume when the gui maps to the screen, it's selecting the runstat time from somewhere. i'll check a 9.1 server and see if the stats match.

i queried the table you suggested, syscat.tables: STATS_TIME, and on v9.1 they do match. I guess my issue specifically is where does my 9.5 client get it from when it connects to an 8.1 database.

I do not know, I no longer have any V8.x databases to check. Maybe you can do a select * from syscat.tables and see if anything there matches. If not, then open a PMR with IBM, because it is obviously a bug.

Andy

this is from v8
C:\Documents and Settings\GUY>db2 describe table syscat.tables

Column Type Type
name schema name Length Scale Nulls
------------------------------ --------- ------------------ -------- ----- ------
TABSCHEMA SYSIBM VARCHAR 128 0 No
TABNAME SYSIBM VARCHAR 128 0 No
DEFINER SYSIBM VARCHAR 128 0 No
TYPE SYSIBM CHARACTER 1 0 No
STATUS SYSIBM CHARACTER 1 0 No
BASE_TABSCHEMA SYSIBM VARCHAR 128 0 Yes
BASE_TABNAME SYSIBM VARCHAR 128 0 Yes
ROWTYPESCHEMA SYSIBM VARCHAR 128 0 Yes
ROWTYPENAME SYSIBM VARCHAR 128 0 Yes
CREATE_TIME SYSIBM TIMESTAMP 10 0 No
STATS_TIME SYSIBM TIMESTAMP 10 0 Yes

may be syscat.indexes : stats_time !!