Native SQL Stored Procedures - 31-bit Virtual Storage Constraint Relief in DB2 10
flodubois 270000K6H5 Visits (1414)
If you have created native SQL stored procedures in V9 and you want to maximize the 31-bit virtual storage constraint relief on entry in DB2 10 CM, REBINDing the associated packages is not enough. You will need to regenerate the stored procedure so that the SQL control statements as well as the non-control statements are rebound.
To regenerate an existing version of a native SQL procedure: