For standard auditing, space allocation for the SORT file depends on the number of error extract records created in the audit phase. If your database has numerous errors or the sets containing errors are long, the extract file may also be large. In that case, you may need more than four sort work datasets.
If you are auditing integrated index sets and you have index orphans, then you need enough sort space to accommodate twice the number of index orphans written to the index extract file.
In most cases, the number of extracts created is small. In a typical situation with Standard auditing, four sort work files with a cylinder allocation of 5,2 should be adequate. The total sort work file allocation should be twice the space allocation of the EXTRACTS file.
For QuickCheck auditing, allocate space to sort 26-byte records for every record swept in the database. For each record swept, CA IDMS/DB Audit creates a 26-byte extract record and a 26-byte match record for each set in which the swept record participates. Additionally, two 26-byte records are created for each SR7 and SR8 for index sets in the swept area.
Total Number of Bytes to Sort = 26 * 2mn
Represents the number of records swept
Represents the number of sets of which those records are participants
Represents the number of records sorted
Represents the length of sort record
|
Copyright © 2013 CA.
All rights reserved.
|
|