IBM Support

Knowledge Collection: DB2 Stored Procedure and FMP issues

Question & Answer


Question

This Knowledge Collection is a focused compilation of links to documents for DB2 Stored Procedure and FMP issues.

Answer


DB2 Stored Procedure and FMP
The following document links contain information concerning DB2 Stored Procedure and FMP issues.

[1383251] Collecting data: DB2 Stored Procedures Problems
[1432522] How to calculate the number of db2fmp processes allowed using the DB2_FMP_COMM_HEAPSZ variable
[1166020] How to determine the fenced user id for the instance
[1393338] FMP Exiting with DIA8305C
[1429756] SQL1326N The file or directory cannot be accessed
[1448684] -818 error calling an external embedded SQL Stored Procedure or UDF with KEEPFENCED=YES
[1419525] Relationship between Java Stored Procedures and Jar files
[1233920] Which stored procedure does my package reside in?
[1385309] Java stored procedure returns SQL0464W
[1287821] SQL0476N error during execution of DROP PROCEDURE statement
[1449630] SQL0443N with diagnostic text "SYSIBM:CLI:-805". SQLSTATE=38553 when calling stored procedure SYSIBM.SQLXXXXXXX()
[1433369] SQL30020N Reason Code "0x124C"("010B")"" calling a stored procedure with a package name longer than 18 characters from DB2 Connect v9.1
[1399105] SQL1042C running a fenced routine (stored procedure/UDF)
[1432402] Accumulation of db2fmp (Java) processes
[1433093] My stored procedure call fails with SQL0751N

Definition of a Knowledge Collection


A Knowledge Collection is a focused compilation of links to documents that share a common theme. Knowledge Collections are navigation aids that organize content to help users quickly find relevant information. Knowledge Collections are not designed to be an all-inclusive list of all documents dealing with the specific theme.

[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Routines (SP & UDF) - db2fmp","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.7;9.5;9.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21452349