Adaptive Server provides two mechanisms to help you observe runtime adjustments of query plans:
set process_limit_action allows you to abort batches or procedures when runtime adjustments take place.
showplan prints an adjusted query plan when runtime adjustments occur, and showplan is effect.
