Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2003
    Posts
    30

    Unanswered: Deploying a Db2 PL stored procedure on the production server

    We are setting up a DB2 (UDB 8.1 on Windows 2000 ) environment.
    I need some guidance to set up the development and deployment process.

    Lets say I have a development server A and a production server B.

    We do all the DB2 PL stored procedures development on the server A which is running windows 2000.
    Hence we have installed the Visual C++ complier to complie the stored procedures.

    Can I deploy/move those stored procedures from SERVER A to SERVER B
    with out recompiling it on server B.

    Our operations team is very much against installing a C/C++ complier on production SERVER B.

    How do we go about doing this whereby we would be able to develop the stored procedures on server A
    and then deploy it on SERVER B.

    We do not have the option of using JAVA stored procedures.

    Any help in this matter is very well appreciated.

    Thanks
    -Soumil
    soumil@hotmail.com

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Deploying a Db2 PL stored procedure on the production server

    In the faq section , check the stored procedure deployment faq ..

    http://www.tek-tips.com/faq.cfm?spid=178

    This was true for V7 , should also hold good for V8 ...

    Please let us know how you get along ...

    HTH

    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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