Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004

    Unanswered: Not fenced stored procedures in V9

    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.


  2. #2
    Join Date
    May 2003
    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.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts