Using the Product in a DB2 Environment › Background DB2 Catalog Extraction › Synchronous Data Gatherer › Limit Harvested SQL

Limit Harvested SQL

As in sampling and catalog extraction, the Harvester can also obtain SQL statements. The harvested statements are from internal DB2 objects and are a more reliable source than sampling, due to the synchronous nature of the process.

There might be circumstances, however, where the harvested SQL is redundant or too voluminous to be processed efficiently. To avoid these instances, CA MAT automatically eliminates redundant SQL records.