QDBSRV04 Job on AS400

rhunt

Well Known Member
Does anybody have information on the QDBSRV04 job? As I understand it, this system job rebuilds access paths when corruption is found in an index. I have seen pockets of time when this job has used 25% of my CPU for several minutes at a time. Additionally, my external reporting tool is taking hours to run general ledger reports that took 2 minutes yesterday.

Does anyone know who to find where the bad index is or have an alternate suggestion?

Thanks in advance.

Ryan
 
Try deleting the SQL package created for the report. Sometimes the package has a prebuilt access path information that is old.
 
Back
Top