Some reports are working properly and some are not after changing CA Deliver and View option ARCH=1 to ARCH=DIRECT?
How CA Balancing works
CA Balancing will allocate the CA VIEW (SAR) database to run the RULESET jobs (reports) and follow whatever guidelines are required.
The OPEN of the CA VIEW DB is a READ ONLY function and requires access to the INDEX portion of the RSDS DB file.
Only information in the INDEX will be considered obtainable. This is important to know.
How CA View and CA Deliver works
With ARCH=1 the output is spooled to the JES spool and then CA VIEW will open the spool and move the output to the SAR DB. This is done by opening the spool file and sequentially downloading the information to the SAR DB and updating the INDEX in the SAR DB as it goes.
With ARCH=DIRECT/SAR DB Name the output is NEVER sent to the JES spool and the output is dumped into the CA View SAR DB as a OPEN FILE. The file stays open until all the writes are completed and the the INDEX is updated. Depending on how large the output dump is at the time this could take many minutes. Plus you then have the internal index update within the RSDS file. This could lead to a large clock time window where not all items are updated in the index of the RSDS and "some" CA Balancing reports will not be correct and yet "some" will be correct.
The problem is most prevalent when the spool was not used and the sequential updates were not performed to the CA View SAR DB and less prevalent when the spool is utilized.
CA Balancing is doing exactly what it is supposed to do. CA View and CA Deliver is working as designed.
CA View and CA Deliver support recommend the same process as CA Balancing support.
Use ARCH=DIRECT/SAR DB name if you like but all CA Balancing jobs must have a time delay so the index has time to be updated and the reports will find the data.
Use ARCH=1 and CA Balancing will still require a time delay, although smaller, so the index is updated and the reports can be acquired.
Nothing is broken, this is a product design. All that is required is a time delay for the CA Balancing reports before they are submitted. Some customers recommend 5 to 10 minutes before jobs for CA Balancing are submitted for execution.