Scans - Options window (Oracle and UDB only)

 

Use this tab to determine if the job should scan segment freelist chains.

 

Field Name

Description

Oracle Options

 

Scan Segment Freelist Chains

Check this box to have Tivoli Storage Resource Manager scan the freelist chains associated with the segments in your Oracle environment. Free list chains represent the pages allocated to a segment that have enough free space for additional rows.

 

Note: Checking this option will increase the time required by the Scan to complete.

Scan Limit

Indicate the number of pages IBM Tivoli Storage Resource Manager should scan on a chain before stopping.

UDB Options

 

Perform runstats on all tables being scanned

Check this box to execute the DB2 utility runstats against the tables being scanned. Checking this box will enable IBM Tivoli Storage Resource Manager to collect the most up-to-date storage statistics about tables from the DB2 catalog.

 

Note: Checking this option will increase the time required by the Scan to complete.

 

For more information, see Monitoring - Scans.