Saving and Restoring External SQL Routine Definitions
January 30, 2008 Hey, Mike
A vendor whose software we use separates objects into two main libraries–a data library and an object library. I had to restore all the data, so I deleted the data library and restored it. After that, the application stopped working. The problem turned out to be that some stored procedures that they created in their data library got wiped out, and the Restore Library (RSTLIB) command didn’t put them back. The story ends happily because the vendor had a program in place for just such emergencies, but (and I’m sure IBM disagrees), I consider this a big old bug in |