Valid for
Extract
Description
Use ALTFILERESOLVE to resolve wildcards during the startup of Extract. As the wildcards are resolved, audited alternate key files are placed on the "exclude list" so no data will be sent for them. This avoids duplicate key errors that can otherwise occur when alternate key file I/O is encountered before primary file I/O. A message is produced for each wildcard entry as it is processed.
Unstructured files, SQL/MP tables, SQL/MX tables, and NSK standard subvolumes are ignored during the scan.
After startup, any file create or alter operation triggers Extract to evaluate the file for audited alternate key files to add to the exclude list.
To avoid the initial scan and its startup overhead, set NOALTFILERESOLVE. When this is set, alternate key files will be identified when the first primary file I/O is encountered.
Default
ALTFILERESOLVE
Syntax
ALTFILERESOLVE | NOALTFILERESOLVE
Example
The following is an example of the message produced during a wildcard scan at startup.
2010-02-16 08:10:58.161307 Scanning $*.A12GEN* for Alternate Key Files 2010-02-16 08:10:58.230067 Files scanned 16 2010-02-16 08:10:58.230788 Scanning $*.A12SQL* for Alternate Key Files 2010-02-16 08:10:58.289293 Files scanned 72