Fixes are available
DB2 Version 9.5 Fix Pack 3b for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 2a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 4a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
APAR status
Closed as program error.
Error description
On Visual Studio 2008 only, project templates for DB2 Class Library and project item templates for DB2 Class are missing in IBM Database add-ins for Visual Studio. This affects the ability to create C# and Visual Basic CLR assemblies. When the user attempts to create a new C# project for use as a CLR stored procedure, the expected templates 'DB2 Class Library for version 8' and 'DB2 Class Library for version 9' are missing. Similarly, the Visual Basic project templates 'DB2 Class Libarary for version 8' and 'DB2 Class Library for version 9' are missing. When the user attempts to add a new item to a C# project for use as a CLR stored procedure, the expected templates 'DB2 Procedure Class for version 8' and 'DB2 Procedure Class for version 9' are missing. Visual Basic project item templates 'DB2 Procedure Class for version 8' and 'DB2 Procedure Class for version 9' are also missing.
Local fix
It is not necessary to use these templates to create CLR procedu res. You can use any public static method from any public class from a C# class library project, or any Public Shared Sub from a Public Class in any Visual Basic library project.
Problem summary
See problem description.
Problem conclusion
Project templates for Visual Studio 2008 have been added starting in DB2 V9.5 FP2. Use the fix links at the top of this page or for the latest fixpack information go to technote 1321001 which is the Recommended Fixes page: http://www.ibm.com/support/docview.wss?rs=71&uid=swg21321001 First fixed in DB2 V9.5 fixpack 2
Temporary fix
Comments
APAR Information
APAR number
JR29263
Reported component name
DB2 UDB ESE WIN
Reported component ID
5765F4101
Reported release
950
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2008-05-12
Closed date
2009-01-23
Last modified date
2009-05-18
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
R950 PSY
UP
Document Information
Modified date:
18 May 2009