DBRM's are temporary, once the plan / package is bound there is no need to recover them ... DB2 does not use them after after bind.
Re-compile will not recover the DBRM as you suggested. Both DB2 static statements and DB2 executables are time stamped by actions in the precompile process and at run time the time stamps need to match or a SQL error results. For those on the list who do not understand the process DB2 access is done via an imbeded lanuage called SQL in much the same way a CICS EXEC is an impeded lanuage in the application program. The application source goes through a pre-compile that converts the SQL into constructs consistant with what ever the sournding application code uses. Diffrent than CICS the DB2 precompile also produces the DBRM (Data Base Request Module). The modified application source is input to downstream compiles and links eventully updating a load dataset. The DBRM is input to a down stream SQL BIND updateing the DB2 Catalog. Both are required for the application to run. Neither outpup from the precompiler can be used again ... The DBRM or the modified source and there is no reason to save them ... Some people do save the DBRM so they can use IEHIBALL but I know of no one who saves the modified source. The most helpfull person I know who can advise people on this process (and will sell you a product if you wish but is not very pushy about it) is Gerald Hodge HLS Technologies, Inc. www.hlstechnologies.com The DB2-L list is ofcourse a good option There is some potencial to reconstruct the DBRM from the DB2 catalog statement tables but it is not clear what the value of doing this would be. On Thu, 30 Mar 2006 15:05:01 -0500, 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 ---------------------------------------------------------------------- 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
