Why am I not able to use "GET ROUTINE" or "PUT ROUTINE" after applying a fixpack?
A: After applying a fixpack to a v7.1 or v7.2 database you may get an error similar to the following: "SYSFUN.GET_ROUTINE_SAR" could not be loaded. There are several functions that require an update to the system catalog after a fixpack is installed. You may receive errors with built-in functions ABS, DECRYPT_BIN, DECRYPT_CHAR, ENCRYPT, GETHINT, MULTIPLY_ALT, and ROUND.
The built-in procedures GET_ROUTINE_SAR and PUT_ROUTINE_SAR may not be enabled.
To correct problems with these functions and procedures, you can run db2updv7 -d <db_name>. This executable will update the system catalogs to correct or enable these functions.
Please be aware that the database cannot be used with an earlier version of DB2 after running this procedure. For more information see the release notes for the fixpack.