Topic
  • 6 replies
  • Latest Post - ‏2013-09-26T21:04:31Z by tch
tch
tch
8 Posts

Pinned topic Where did my SQL external procedure go?

‏2013-09-24T21:22:45Z |

We have several RPG programs that are exposed to Java clients as SQL external procedures.  Ocassionally, the SQL procedure is dropped when the external program object is changed by our change management software.  We suspected the change managment system was responsible but that idea was eliminated since it does not manage the procedure DDL.

Will DB2 for i automatically drop an SQL external procedure if the high level language program object it calls is changed?

  • krmilligan
    krmilligan
    450 Posts

    Re: Where did my SQL external procedure go?

    ‏2013-09-24T21:54:17Z  

    How do you notice that the external stored procedure is dropped?  Do Calls fail?  Or does it disappear from procedures folder in System i Navigator?

  • tch
    tch
    8 Posts

    Re: Where did my SQL external procedure go?

    ‏2013-09-24T22:23:42Z  

    How do you notice that the external stored procedure is dropped?  Do Calls fail?  Or does it disappear from procedures folder in System i Navigator?

    The calls to the procedure fail.  We verify the procedure is missing in IBM i Nav.

  • krmilligan
    krmilligan
    450 Posts

    Re: Where did my SQL external procedure go?

    ‏2013-09-25T03:06:17Z  

    How do you notice that the external stored procedure is dropped?  Do Calls fail?  Or does it disappear from procedures folder in System i Navigator?

    What release level and Database Group PTF level?

  • tch
    tch
    8 Posts

    Re: Where did my SQL external procedure go?

    ‏2013-09-25T13:47:32Z  

    What release level and Database Group PTF level?

    Release 7.1

    PTF Group     Level     Status  
    SF99701        20           Installed
    SF99701        23           Installed

     

  • krmilligan
    krmilligan
    450 Posts

    Re: Where did my SQL external procedure go?

    ‏2013-09-25T15:39:01Z  
    • tch
    • ‏2013-09-25T13:47:32Z

    Release 7.1

    PTF Group     Level     Status  
    SF99701        20           Installed
    SF99701        23           Installed

     

    Guessing that you're being affected by this recent DB2 for i enhancement below.  Is it possible MOVOBJ or RNMOBBJ are being executed on the external stored procedure program object? 

     

    https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki/IBM%20i%20Technology%20Updates/page/Improved%20catalog%20management%20for%20procedures%20and%20functions

  • tch
    tch
    8 Posts

    Re: Where did my SQL external procedure go?

    ‏2013-09-26T21:04:31Z  

    Guessing that you're being affected by this recent DB2 for i enhancement below.  Is it possible MOVOBJ or RNMOBBJ are being executed on the external stored procedure program object? 

     

    https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki/IBM%20i%20Technology%20Updates/page/Improved%20catalog%20management%20for%20procedures%20and%20functions

    Yes.  The change managment sofware uses RNMOBJ to archive the original object.