Native SQL Stored proc package invalidated after an ALTER table for nullable column

Parvatha Arun

Native SQL Stored proc package invalidated after an ALTER table for nullable column

Hi All,

Currently we are in Db2 v10 and we are facing a strange issue. Whenever we alter a nullable column of VARCHAR type to increase its length, all our packages both related and  unrelated to the table being changed gets invalidated. We tried various options like BIND PACKAGE with DEPLOY option and REBIND but stored procedures works only when we drop and recreate them in the corresponding scemas.

If left as such we are getting SQLCODE 100 or SQLCODE -180, unrelated to the actual issue which is the bind problem.

Has anyone faced this issue? if so, can you please help me in understanding the issue and any solutions or workaround you might have?

Thanks,

Parvatha