IBM Support

JR28114: CLR STORED PROCEDURES DEPLOYED WITH IBM DATABASE ADD-INS FOR VIS UAL STUDIO CANNOT BE RUN

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • I tried creating a CLR SP with VS2005 v9.5 tooling, but when I
    run it no data is being returned and error -
    Error occurred: ERROR [42724] [IBM][DB2/NT] SQL20282N  .NET
    procedure or user-defined function "ERICJ.GETSTAFFEMPLOYEE",
    specific name "GETSTAFFEMPLOYEENA" could not load .NET class
    "DB2ClassLibrary1.DB2Class1". Reason code "1".
    SQLSTATE=42724
    : IBM.Data.DB2: -2147467259
    is being displayed.
    

Local fix

  • IBM Database add-ins for Visual Studio deploys CLR stored proced
    ures to the incorrect location on the database server.  The stor
    ed procedures are deployed to the install path, but they should
    be deployed to the instance profile path.  The user may work aro
    und the problem by manually moving the CLR assembly after deploy
    ing it.
    The CLR assembly is installed to the function directory installa
    tion path, usually c:\program files\ibm\sqllib\function.  The CL
    R assemblies are the files inside the CLR directory at this loca
    tion.  They should be moved to the function directory in the ins
    tance profile path, which is usually something like c:\documents
     and settings\all users\application data\ibm\db2\db2copy1\functi
    on.
    

Problem summary

  • Users are unable to run CLR stored procedures after deployment
    to a DB2 server using IBM Database add-ins for Visual Studio
    2005.  The reason is that in DB2 v9.1, the location changed to
    which CLR stored procedures need to be deployed.  The stored
    procedure that IBM Database add-ins for Visual Studio uses for
    deploying CLR stored procedures needs to be updated to deploy to
    the correct location.
    

Problem conclusion

  • Project db2_v91fp5
    

Temporary fix

  • IBM Database add-ins for Visual Studio deploys CLR stored proced
    ures to the incorrect location on the database server.  The stor
    ed procedures are deployed to the install path, but they should
    be deployed to the instance profile path.  The user may work aro
    und the problem by manually moving the CLR assembly after deploy
    ing it.
    The CLR assembly is installed to the function directory installa
    tion path, usually c:\program files\ibm\sqllib\function.  The CL
    R assemblies are the files inside the CLR directory at this loca
    tion.  They should be moved to the function directory in the ins
    tance profile path, which is usually something like c:\documents
     and settings\all users\application data\ibm\db2\db2copy1\functi
    on.
    

Comments

APAR Information

  • APAR number

    JR28114

  • Reported component name

    DB2 UDB ESE WIN

  • Reported component ID

    5765F4101

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2007-12-13

  • Closed date

    2008-07-15

  • Last modified date

    2008-07-15

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    DB2 UDB ESE WIN

  • Fixed component ID

    5765F4101

Applicable component levels

  • R910 PSY

       UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"910","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
12 October 2021