usually better chance for an answer on DB2 listserv but I lurk here also. The ability to generate a DBRM is dependent on the status of the information in SYSSTMT and SYSPACKSTMT. BIND COPY accross subsystems does not have enough information to rebuild the DBRM. REMOTE binds do not have enough information to create a DBRM
It depends on how many you need to rebuild - If you only have a few, there have been REXX code to rebuild DBRM. Otherwize we have a tool that will revuild any number. http://www.hlstechnologies.com/dbrmCheck.html Mike On 3/30/06, WA Stout <[EMAIL PROTECTED]> wrote: > > Gang forgive me, I am not a DBA but I need to ask this... > > 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. Any help would be appreciated. Thanks! > > ---------------------------------------------------------------------- > 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 > -- Mike ---------------------------------------------------------------------- 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
