You can set default values to keep a limit on the size and retention period of saved reports. You can set default values for specifications users are allowed to make when saving reports:
Report retention period:
If a user saves a report without specifying how many days it is to remain saved, the report is saved for the number of days specified by the report retention. This default is set during system generation with:
ADD/MODIFY OLQ ... REPORT RETENTION IS retention-period
Keep in mind when using the batch facility, reports saved through batch do not honor the defaults set during system generation. You must specify these options explicitly when saving a batch report.
Maximum report retention:
You can define the maximum report retention (the maximum length of time in days) that a user can specify when saving a CA OLQ report in the queue area. If the user specifies a retention period greater than the default report retention period, the retention period defaults to this maximum. Use the system generation statement:
ADD/MODIFY OLQ ... MAXIMUM REPORT RETENTION IS retention-period
Report dictionary name:
Since CA OLQ stores reports through the catalog, each saved report has a catalog entry and passkeys assigned. You can, during system generation, specify in which dictionary this catalog information is stored with:
ADD/MODIFY OLQ ... REPORT DICTNAME IS dictionary-name
The specified report dictionary is also the dictionary in which CA OLQ looks to find the job control language needed for batch job submission.
Report size:
You can better estimate the size of the scratch and queue areas if you limit the size of CA OLQ reports retrieved.
To monitor the size of CA OLQ reports retrieved into scratch and saved into queue, you can specify the page size, the number of pages retrieved from the database, and the number of reports allowed per user.
Define the report page size during system generation with:
ADD/MODIFY OLQ ... REPORT FILE PAGE SIZE IS report-file-page-size
The specified page size must be at least large enough to accommodate the largest database or logical record to be included in the report.
When a CA OLQ report exceeds the maximum report pages, as set with this option, system ends the retrieval process and stops writing report pages and issues the message:
OLQ 097004 00 Maximum report size has been exceeded
The incomplete report is retrieved into scratch, is available for viewing, and can be sorted.
Define the number of pages allowed per report during system generation with:
ADD/MODIFY OLQ ... MAXIMUM REPORT PAGES IS max-report-pages
Define the number of reports allowed per user during system generation with:
ADD/MODIFY OLQ ... MAXIMUM REPORT COUNT IS max-report-count
This way you can control the quantities of reports saved and better estimate the size of the queue area. Use the SELECT (OLQ access mode) statement to retrieve the records. With SELECT (OLQ access mode) you can sort and group the records while retrieving them.
|
Copyright © 2013 CA.
All rights reserved.
|
|