Re: Subsystems and ODP

[Tom Liotta <qsrvbas@xxxxxxxxxxxx>]

Charles St-Laurent wrote:

> Can we consider a subsystem as a job? Can we associate this job to a named
> activation group? And if I open database files in that named activation
> group and don't close the files, will the ODP of that named activation group
> shared to all the (interactive / batch) jobs that are launched in that
> subsystem?

Charles:

I'm not sure that you _really_ want ODPs shared across multiple 
jobs. Try to picture the result if different, unrelated jobs were 
always changing the file pointer to different parts of the file! 
What record would be read the next time any job executed a simple 
READ op-code? Similarly, file status info, at least some storage 
areas and possibly other elements, would also be shared and could 
potentially cause chaos.

IIUC, native I/O within a job can be influenced by the OVRDBF 
SHARE(*YES) setting; but SQL does any sharing through its own 
methods and SHARE(*YES) is ignored. Either way, going _across_ jobs 
would be begging for trouble.

Tom Liotta