Our daily backup is running 8-10 hours a day, which has caused JOBQ and JNUM shortages on numerous occasions.
After the backup runs, it then takes hours for View to pick up all the output created during the 8-10 hours that the backup was running.
Running both standard and interim backups, could it be that the DB could be performing backups potentially all day?
During an interim backup, does View pick up reports?
Release : 14.0
It was suggested that the client run the following SARDBASE job, to collect database statistics both before and after a REORG ASYNCH:
//XXXXXXXX JOB ...
//SARDBASE EXEC PGM=SARDBASE,PARM='VIEW_HLQ' <=== MODIFY DB NAME
//STEPLIB DD DISP=SHR,DSN=VIEW.CVDELOAD <=== MODIFY, IF USED
//SYSPRINT DD SYSOUT=*
//SYSIN DD *
Though the REORG ASYNCH ran for a long time, the amount of database index usage dropped by 10%.
It was also suggested that the client may want to make the database in question a static (historical) database, and to start with a new database.