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

What DB2 version and OS?

Andy

DB2 8.2.x. Database servers are at different fixpak levels in 8.2

OS - AIX and Linux

Thanks in advance.

You can run the list utilities command and wait until there is no output. The online reorg by definition is asynchronous.

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.

Unfortunately, this is not (yet) possible in DB2 LUW.

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

db2pd -reorg -db databasename

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