Results 1 to 6 of 6
  1. #1
    Join Date
    Dec 2002
    Location
    Madrid - Spain
    Posts
    422
    Provided Answers: 1

    Unanswered: The last time to run reorg in a table db2 v8.

    Hi colleagues,
    As i know the last time that it was executed reorg a table db2 v8.
    Thank you very much.

  2. #2
    Join Date
    Aug 2011
    Posts
    45
    I dont get ur question, but if u want to know the last reorg time for a table, try below:

    db2pd -d db_name -reorg

    Regards,
    Harsh V

  3. #3
    Join Date
    Dec 2002
    Location
    Madrid - Spain
    Posts
    422
    Provided Answers: 1
    hi colleagues,

    I need know when were the last time i execute reorg in table db2 v8.

    Thank you for advanced.

  4. #4
    Join Date
    Feb 2004
    Posts
    18
    In table sysibm.syscolumns,
    there is a column named statstime,

    STATSTIME
    TIMESTAMP
    NOT NULL WITH
    DEFAULT
    If RUNSTATS updated the statistics, the date and time when the last invocation of RUNSTATS updated the statistics. The default value is '0001-01-01.00.00.00.000000'. If the value is '0001-01-02.00.00.00.000000', which indicates that an ALTER TABLE statement was executed to change the length of a VARCHAR column, RUNSTATS should be run to update the statistics before they are used. This is an updatable column.

  5. #5
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    (welyngj) : runstats and reorg is NOT the same....
    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

  6. #6
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Quote Originally Posted by georgipa View Post
    hi colleagues,

    I need know when were the last time i execute reorg in table db2 v8.

    Thank you for advanced.
    LIST HISTORY REORG ALL FOR database-alias

    Not a direct answer, but this should help you with the details.
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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