Results 1 to 9 of 9
  1. #1
    Join Date
    Sep 2003
    Posts
    78

    Unanswered: DB2 Control Center "Statistics time" column

    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

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    syscat.tables: STATS_TIME

    Andy

  3. #3
    Join Date
    Sep 2003
    Posts
    78
    that doesn't have the same dates that show on the "control center"

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    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

  5. #5
    Join Date
    Sep 2003
    Posts
    78
    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.

  6. #6
    Join Date
    Sep 2003
    Posts
    78
    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.

  7. #7
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    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

  8. #8
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    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
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  9. #9
    Join Date
    Jul 2006
    Location
    Pune , India
    Posts
    433
    may be syscat.indexes : stats_time !!
    Rahul Singh
    Certified DB2 9 DBA / Application Developer

Posting Permissions

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