Results 1 to 8 of 8
  1. #1
    Join Date
    May 2002
    Posts
    30

    Unanswered: reorg and runstats

    When performing an offline or online reorg, we schedule runstats to run after completion of the reorg step.

    This doesn't work as expected for inplace reorg.

    How to identify the completion of asynchronous inplace reorg and do runstats?

    Thanks

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    What DB2 version and OS?

    Andy

  3. #3
    Join Date
    May 2002
    Posts
    30
    DB2 8.2.x. Database servers are at different fixpak levels in 8.2

    OS - AIX and Linux

    Thanks in advance.

    Quote Originally Posted by ARWinner
    What DB2 version and OS?

    Andy

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    You can run the list utilities command and wait until there is no output. The online reorg by definition is asynchronous.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  5. #5
    Join Date
    Sep 2004
    Location
    Belgium
    Posts
    1,126
    Isn't there an option of REORG to do the RUNSTATS as (last) part of the REORG?
    I know this is possible on z/OS.
    --_Peter Vanroose,
    __IBM Certified Database Administrator, DB2 9 for z/OS
    __IBM Certified Application Developer
    __ABIS Training and Consulting
    __http://www.abis.be/

  6. #6
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    Unfortunately, this is not (yet) possible in DB2 LUW.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  7. #7
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    You can also run the following query in a loop until reorg_status = 4.

    select snapshot_timestamp,reorg_current_counter,reorg_max _counter,reorg_status from table (snapshot_tbreorg(cast(? as varchar(255)),-1)) as x where table_schema = ? and table_name = ? and reorg_start >= ?

    Andy

  8. #8
    Join Date
    Jun 2007
    Posts
    66
    db2pd -reorg -db databasename

    This command can be used to track the completion of a reorg

Posting Permissions

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