I would recommend investigate into the QZDASOINIT jobs as follow:
- Force debug messages by setting parameter MESSAGES_DEBUG to *YES in the qaqqini file
- Force the joblog to print by temporarily changing the job description.
The joblog will show you the SQL used, how much time every statement taken, and the access plan (How did SQL planned to get the records).
Dig deeper on Physical connections to iSeries
Related Q&A from Shahar Mor
Use work station customize object or printer type in iSeries Access to print the output of an RPG file from the AS/400 to an HP printer.continue reading
Searching for the right API to add users to an EIM SSO implementation? The IBM site includes sample APIs based on C.continue reading
Sending the file binary to the AS/400 after defining the destination file tagged with CCSID of 1200 may solve the problem of incorrect CCSID numbers ...continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.