Just found out that the QUERYOPT was configured with 2. I changed the DFT_QUERYOPT and flshed the package cache and ran db2rbind.
Now I know.... a rebind does not take the QUERYOPT from DFT_QUERYOPT so my packages are still using the (too low) value of 2.
Is there a way to rebind and increase the QUERYOPT value? I am using V8.2 on aix.