Our shop does not appear to have been using DEFERRED queries in the past but I have a user that is wanting to. This has led me to doing a bit of reading and testing on the subject. From my reading in the manuals I get mixed impressions as to where the DEFERRED query actually runs. There are places where it implies that the held query that is queued up in the DQF is released by a DQBATCH DEFER and runs as a separate job however, there are other places where the doc implies that the released query will run as part of the DQBATCH DEFER job.
All of my tests to date of submitting the deferred query from the SUBMIT command or from the DQENO panel (a JCL member name or using $$DQJCL) the output comes out as a separate job each time once it is released via the DQBATCH DEFER. However, yesterday I accidentally ran the DQBATCH DEFER against my production environment and behold two queued up queries executed as part of the DQBATCH DEFER.
Does anyone know how to recreate that condition?
Thanks.
Bill M