Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2003
    Location
    kualaumpur
    Posts
    33

    Unhappy Unanswered: SP Deployment Problem ...pls help

    Dear All

    we are using the following Environment

    OS : AIX 5
    Db2 udb v 8.1 with fixpack 4 a

    successfully created no of stored procedures in the development server and
    created the binary files using
    GET ROUTINE INTO FILE_NAME FROM PROCEDURE SCHEMA.PROC_NAME

    after that i did ftp accross those files in binary mode to production server which is having the same environment as development .

    but when I tried with this command

    PUT ROUTINE FROM FILE_NAME its giving me following error....

    SQL0443N Routine "SYSFUN.PUT_ROUTINE_SAR" (specific name "PUT_SAR1PARM") has
    returned an error SQLSTATE with diagnostic text "-970, 55009, ".
    SQLSTATE=38000

    I donno how to resolve this ...any suggestions will be highly appeciated.

    rgds

  2. #2
    Join Date
    Jun 2001
    Posts
    20
    If you are deploying the stored procedures as Instance Owner, then

    1. Add the Instance Owner to the Fenced User's Group
    2. Bounce the Instance
    Renga

  3. #3
    Join Date
    Nov 2003
    Location
    kualaumpur
    Posts
    33

    Question pls help

    hi Renga

    i am not sure how to do the same which you have suggested .
    Need your more input for the same . I am struggling with this problem....

    regards

  4. #4
    Join Date
    Jun 2001
    Posts
    20
    Trinmoy,

    I am assuming the following

    Instance Owner : db2inst1 Group : db2grp1

    Fenced User : db2fenc1 Group : db2fgrp1 Group ID : 103

    The Stored procedures are owned by Instance Owner (db2inst1)

    As a privileged user, edit /etc/group and add db2inst1 to db2fgrp1. The entry should look like the following

    db2fgrp1::103:db2inst1

    Save the changes.

    Login as Instance Owner. Shutdown and Start the database.

    Ensure that the Production and development database are running the same version of DB2 and Fixpack Level.
    Renga

  5. #5
    Join Date
    Nov 2003
    Location
    kualaumpur
    Posts
    33

    Smile Thankx

    Thanks you so much .... the problem got resolved .

    regards

    Trinmoy

Posting Permissions

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