Has anyone allowed db2 V9 to alter there stored procedures to fenced and not threadsafe? Have you noticed any performance degradation. Is there a way to prevent DB2 from changing the stored procedures ? Actually, all my stored procedures are SQL (internal) so I'm not sure why the db2ckmig program is complaining.

Thanks

SQL stored procedures are unfenced by definition. I am not sure what problem you are having, but you could try and drop and recreate them once you get to V9. You can extract them with db2look. Be sure to change the delimiter with the appropriate db2look option.