Unanswered: Recreating procedures after change from 32-bit to 64-bit
I discovered recently that I had installed DB2 9.7 FP4 32-bit on a 64-bit server. This is not a problem, but it does not make full use of server resources. Now I am attempting to upgrade from 32-bit FP4 to 64-bit FP6 as preparation for a front-end application upgrade that requires FP6.
I uninstalled FP4, installed FP6, did my upgrade DB statement (not sure if that is even necessary going from FP4 to FP6 within 9.7), but now when I attempt to open front-end apps, I get this error:
SPL0471N Invocation of routine [StoredProcNameHere] failed due to reason "1" SQLState=55023
From what I can tell in reading up on this, stored procs need to be recreated when switching from 32-bit to 64-bit. I see a bit of documentation on db2updv97 -a; however, it appears that is for upgrades from pre-9.7 to 9.7.
How do I get my DB (or at least the stored procs and anything else that needs to be migrated) moved from 32-bit to 64-bit?