In DB2 8.1 or previous versions, create a stored procedure requires a C compiler. If there is no C compiled environment in the operating system, the stored procedure cannot be created, the solution is to upgrade DB2 to 8.2.2 8.2 Creating a stored procedure will not require C's compilation environment.