I have DB2 v8 FP 17.

I notice that if I do an REORG TABLE PROD.ACTION IN PLACE ALLOW WRITE ACCESS;

These are asynchronous. I want to do synchronous instead since I have an update stats and rebind at the end of the script (these get executed almost immediately). How can I achieve that easily? I can probably switch to ALLOW READ ACCESS if that's the case...

Well, don't do it INPLACE then.

Two options :

a) After issuing the reorgs, check the status of them on a periodic basis ... Do the runstats and rebind after all reorgs complete. There is a admin function for the reorg status ...

b) Do the reorgs on one day and the runstats/rebind the next day

The second option is easy and OK only if you are doing a 'casual' reorg, and NOT after a specfiic operation like DELETE of a huge number of rows.

Go with option a above. You can check the status in a script, while still running go to sleep for a bit, then check again, when complete then start next set of commands.

Correct. Used to do that. One of the reasons why I do not like INLINE reorgs: complex scripts and a lot of logging, slow and additional action required to reorg your indexes as well.