Moving from Endevor Stage B to D

mkk157 · Active User Joined: 17 May 2006 Posts: 310

When a cobol-db2 program moves from Endevor stage B to D then what are all the actions will be taken at the back-end like deleting or updating the entries for PLAN in PLAN_TABLE or anything others.

HappySrinu · Active User Joined: 22 Jan 2008 Posts: 194 Location: India

Hi,
It completely depends up on your site installation.
Usualy when you move an element it creates a component list and moves to your target stage. then deletes from sending stage (Depend on your site again) .

This component list does have input/output fields information

dbzTHEdinosauer · Posted: Tue Mar 11, 2008 5:15 pm

endevor does not directly modify db2 sys tables. at our site, since there is a different db2 creator at each stage, as modules are promoted, their corresponding bind elements are re-bound (if necessary) otherwise not.

endevor controls components of run-units. as far as db2 is concerned, the plan tables, etc... are only updated thru execution of binds.

If the module is not recompiled and the creator for the db does not change there are no required updates to the plan-table. but, in an environment like mine, binds are executed - which updates the db2 sys tables.

Mistermind · New User Joined: 08 Feb 2008 Posts: 46 Location: Dublin

Assuming you merely MOVE but do NOT recompile from stage B to stage D, an automated delete of DB2 package at stage B will mean that in any future Unit retest at stage B, the loadmodule will be availablve via concatenation from stage D, but the DB2 plan will be gone, i.e. falling back to a retest in B to compare against D will not be possible without rebind.

If DBRM is also deleted by ENDEVOR, then recompile as well as rebind will be necessary. If Unit re-test does not uncover a need for program change, then B-to-D re-promotion without change will be necessary -- quite a lot of wasted work.