This may be an off-the-wall answer, but something to think about.
The QZDASOINIT jobs that handle the ADO requests are set up by default to handle 200 "uses" before they die and another takes their place. See WRKSBSD QSYS/QUSRWRK option 10, 5 on QZDASOINIT. This is off-the-wall because it should NOT affect your ADO
connection, but then again it might. What put me on it was the number of rowsets you get successfully. If there are two "uses" per rowset ...
Try changing the number of uses in the prestart job entry and see if it changes the number of rowsets you get successfully.
This mailing list archive is Copyright 1997-2013 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact