On 2006-03-30 at 15:05, concerning "DB2 Question", WA Stout <[EMAIL PROTECTED]> wrote to IBM-Main:
> Is there a way (or tool) to reverse engineer a plan to get a DBRM > member? Some of our DBRM's have gotten corrupted and I want to > recreate without having to recompile. DBRM's are simply (almost text) members in a library that don't change until re-gen'd. (usually during re-compile) Have you considered restoring the corrupted members from a backup? Especially if they haven't been re-compiled in GT weeks, you won't have much of a inconsistency re: timing issue. There is a location in the DBRM where you can compare the time-stamp (as DB2 does) with the load module but you'll need to check over on DB2-L for such details. Even a google might give the details: "Results 1 - 10 of about 826 for DB2 +DBRM +timestamp". ----------> signature = 6 lines follows <-------------- Neil Duffee, Joe SysProg, U d'Ottawa, Ottawa, Ont, Canada telephone:1 613 562 5800 x4585 fax:1 613 562 5161 mailto:NDuffee of uOttawa.ca http:/ /aix1.uottawa.ca/ ~nduffee "How *do* you plan for something like that?" Guardian Bob, Reboot "For every action, there is an equal and opposite criticism." "Systems Programming: Guilty, until proven innocent" John Norgauer 2004 ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html