Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2003
    Posts
    2

    Unanswered: GET ROUTINE problem URGENT!!

    Hi all,

    i have problems distribute my db on a second db2 database with stored procedure. When i call GET ROUTINE from db2cmd i get the following error:

    C:\TEMP>db2 GET ROUTINE INTO tp.sar FROM PROCEDURE TestProc
    SQL0443N Routine "GET_ROUTINE_SAR" (specific name "") has returned an error
    SQLSTATE with diagnostic text "-31, ,
    C:\Programme\IBM\SQLLIB\bnd\psmgtptp.bnd". SQLSTATE=38000

    the file psmgtptp.bnd is missing on my DB2 installing. On a fresh installing on a different computer it's missing too.

    Where can i get this file or is that a workaround for distribution stored procedures. There's no C-Compiler on the second server.

    OS: WinXP/Win2003 Server
    DB2: 8.1.3.132

    thanks in advance

    Gonso

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

    Re: GET ROUTINE problem URGENT!!

    I think you need to have your app development client installed ...

    Just a guess ..

    sathyaram

    Originally posted by gonso
    Hi all,

    i have problems distribute my db on a second db2 database with stored procedure. When i call GET ROUTINE from db2cmd i get the following error:

    C:\TEMP>db2 GET ROUTINE INTO tp.sar FROM PROCEDURE TestProc
    SQL0443N Routine "GET_ROUTINE_SAR" (specific name "") has returned an error
    SQLSTATE with diagnostic text "-31, ,
    C:\Programme\IBM\SQLLIB\bnd\psmgtptp.bnd". SQLSTATE=38000

    the file psmgtptp.bnd is missing on my DB2 installing. On a fresh installing on a different computer it's missing too.

    Where can i get this file or is that a workaround for distribution stored procedures. There's no C-Compiler on the second server.

    OS: WinXP/Win2003 Server
    DB2: 8.1.3.132

    thanks in advance

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

  3. #3
    Join Date
    Aug 2003
    Posts
    2

    Re: GET ROUTINE problem URGENT!!

    Hi
    i install all from the DB2 CDs. The File is missing.

    gonso

    Originally posted by sathyaram_s
    I think you need to have your app development client installed ...

    Just a guess ..

    sathyaram

Posting Permissions

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