Procedure Execution life

[Gary Yonaites]

On Jan 20, 2008, at 10:54 AM, Elon Close wrote:

> But this indicates the statement is acting on DB2 since it is closing
> the “currently” active DB. It seems that a procedure continues to run
> even
> after the DB which contains its source code is “closed“.
>
> In other words Panorama runs the procedure to completion and if the
> actions
> pertain to the active DB, that DB is not necessarily the one that
> contains
> the procedure. This is OK with me, but a little unexpected.

Yes, a procedure will continue on to the end even with the  
originating db closed as long as it is not trying to do something  
that is expecting that database to be open. This is a useful scheme  
in some instances where files are closed and new files need to be  
opened or other actions need to be taken on remaining files after the  
originator closes.

Gary
gary at yonaites.com