Start of change

Changes that might require package rebinds

Some changes to database objects that do not cause packages to be invalidated might still require a rebind for the changes to take effect for the application.

The following SQL statements cause Db2 to set the VALID column value to 'A' in the SYSIBM.SYSPACKAGE catalog table. This value indicates that an SQL statement changed the description of the table or base table of a view that the package references. These changes do not invalidate the package. However, a rebind might be required for the package to pick up the changes from the statement.

  • ALTER TABLE statements with the following clauses:
    • ADD COLUMN (except for cases that invalidate packages; see Changes that invalidate packages)
    • ADD or DROP FOREIGN KEY
    • ADD or DROP UNIQUE
    • DROP constraint
    • ADD PARTITIONING KEY
    • ADD or DROP CHECK
    • VALIDPROC
    • VOLATILE or NOT VOLATILE
    • APPEND YES or NO
  • EXCHANGE statements
End of change