Database Scanner Properties

Properties for the Database Scanner match the settings that are required for your particular database with Sterling B2B Integrator.

Global Property

The Database scanner has the following global property:

Test Timeout determines the maximum amount of time that is given for a test to complete before a timeout error is reported.

Default value is 120 seconds, or 2 minutes.

Test Properties

Each subtest in the DB2, Oracle, or MSSQL Database scanner has a property that enables or disables each test. Tests can be customized with parameters that are found in the healthcheck.properties file. To customize HealthCheck tests, ensure that you add parameters that you want to customize in the customer_overrides.properties file.

Table 1. DB2 Database Scanner - Test Names and Properties. Displays each test in the DB2 Database Scanner with the command line short name and property value.
Test Name	Command Line Short Name	Property
DB2 Disk Free Test	`DBS.db2.diskSpace`	`DatabaseScanner.db2.diskSpace`
DB2 Index Fragmentation	`DBS.db2.fragmentation`	`DatabaseScanner.db2.fragmentation`
Eval Uncommitted	`DBS.db2.settings.db2_evaluncommitted`	`DatabaseScanner.db2.settings.db2_evaluncommitted`
Skip Deleted	`DBS.db2.settings.db2_skipdeleted`	`DatabaseScanner.db2.settings.db2_skipdeleted`
Skip Inserted	`DBS.db2.settings.db2_skipinserted`	`DatabaseScanner.db2.settings.db2_skipinserted`
Use Alternate Page Cleaning	`DBS.db2.settings.db2_use_alternate_page_cleaning`	`DatabaseScanner.db2.settings.db2_use_alternate_page_cleaning`
Lock to RB	`DBS.db2.settings.db2lock_to_rb`	`DatabaseScanner.db2.settings.db2lock_to_rb`
Monitor Buffer Pool	`DBS.db2.settings.dft_mon_bufpool`	`DatabaseScanner.db2.settings.dft_mon_bufpool`
Monitor Lock	`DBS.db2.settings.dft_lock`	`DatabaseScanner.db2.settings.dft_mon_lock`
Monitor Sort	`DBS.db2.settings.dft_mon_sort`	`DatabaseScanner.db2.settings.dft_mon_sort`
Monitor Statements	`DBS.db2.settings.dft_mon_stmt`	`DatabaseScanner.db2.settings.dft_mon_stmt`
Monitor Table	`DBS.db2.settings.dft_mon_table`	`DatabaseScanner.db2.settings.dft_mon_table`
Monitor Timestamp	`DBS.db2.settings.dft_mon_timestamp`	`DatabaseScanner.db2.settings.dft_mon_timestamp`
Monitor Unit of Work	`DBS.db2.settings.dft_mon_uow`	`DatabaseScanner.db2.settings.dft_mon_uow`
Monitor Heap Size	`DBS.db2.settings.mon_heap_sz`	`DatabaseScanner.db2.settings.mon_heap_sz`

Table 2. Oracle Database Scanner - Test Names and Properties. Displays each test in the Oracle Database Scanner with the command line short name and property value.
Test Name	Command Line Short Name	Property
Oracle Disk Free Test	`DBS.oracle.diskSpace`	`DatabaseScanner.oracle.diskSpace`
Oracle Index Fragmentation	`DBS.oracle.fragmentation`	`DatabaseScanner.oracle.fragmentation`
Table Compression	`DBS.oracle.tableCompression`	`DatabaseScanner.oracle.tableCompression`
Index Compression	`DBS.oracle.indexCompression`	`DatabaseScanner.oracle.indexCompression`
Character Set	`DBS.oracle.settings.characterSet`	`DatabaseScanner.oracle.settings.characterSet`
Cursor Sharing	`DBS.oracle.settings.cursor_sharing`	`DatabaseScanner.oracle.settings.cursor_sharing`
Open Cursors	`DBS.oracle.settings.open_cursors`	`DatabaseScanner.oracle.settings.open_cursors`
Optimizer Mode	`DBS.oracle.settings.optimizer_mode`	`DatabaseScanner.oracle.settings.optimizer_mode`
Processes per Node	`DBS.oracle.settings.processes_per_node`	`DatabaseScanner.oracle.settings.processes_per_node`
Timed Statistics	`DBS.oracle.settings.timed_statistics`	`DatabaseScanner.oracle.settings.timed_statistics`
Undo Management	`DBS.oracle.settings.undo_management`	`DatabaseScanner.oracle.settings.undo_management`
SGA (System Global Access) Max Size	`DBS.oracle.settings.sga_max_size`	`DatabaseScanner.oracle.settings.sga_max_size`
PGA (Program Global Area) Aggregate Target	`DBS.oracle.settings.pga_aggregate_target`	`DatabaseScanner.oracle.settings.pga_aggregate_target`
SGA (System Global Access) Target	`DBS.oracle.settings.sga_target`	`DatabaseScanner.oracle.settings.sga_target`
Memory Target	`DBS.oracle.settings.memory_target`	`DatabaseScanner.oracle.settings.memory_target`
Memory Max Target	`DBS.oracle.settings.memory_max_target`	`DatabaseScanner.oracle.settings.memory_max_target`

Table 3. Microsoft SQL Server Database Scanner - Test Names and Properties. Displays each test in the Microsoft SQL Server Database Scanner with the command line short name and property value.
Test Name	Command Line Short Name	Property
MSSQL Disk Free Test	`DBS.mssql.diskSpace`	`DatabaseScanner.mssql.diskSpace`
MSSQL Index Fragmentation	`DBS.mssql.fragmentation`	`DatabaseScanner.mssql.fragmentation`
Collation	`DBS.mssql.settings.collation`	`DatabaseScanner.mssql.settings.Collation`
Is Auto Create Statistics	`DBS.oracle.settings.isAutoCreateStatistics`	`DatabaseScanner.mssql.settings.isAutoCreateStatistics`
Is Auto Update Statistics	`DBS.oracle.settings.isAutoUpdateStatistics`	`DatabaseScanner.mssql.settings.isAutoUpdateStatistics`
Page Verify Option	`DBS.oracle.settings.page_verify_option`	`DatabaseScanner.mssql.settings.page_verify_option`
Read Committed Snapshot	`DBS.oracle.settings.read_committed_snapshot`	`DatabaseScanner.mssql.settings.read_committed_snapshot`

Some tests have further properties. The value of the properties is set to values that are required for Sterling B2B Integrator. As a result, it is not suggested that you alter these values:

The DB2 Disk Space, MSSQL Disk Space, and Oracle Disk Space tests each have the following properties:

Min Free is a threshold value that determines what percentage of the disk space must remain free.

Required value is 25.

Note: The Min Free property exists in the Disk Space test for all three database types: IBM DB2, Oracle, and Microsoft SQL Server.

The DB2 Index Fragmentation, MSSQL Index Fragmentation, and Oracle Index Fragmentation tests each have the following properties:

Index Fragmentation Severe Threshold determines whether there are fragmented indexes in your database, by checking large tables for fragmentation. Severe Threshold sets a threshold for the size of tables that are checked for index fragmentation. Ensure that you defragment tables that are flagged by the threshold immediately.

Required value is 500000.
Index Fragmentation Error Threshold determines whether there are fragmented indexes in your database, by checking large tables for fragmentation. Error Threshold sets a threshold for the size of tables that are checked for index fragmentation. Ensure that you defragment tables that are flagged by the threshold as soon as possible.

Required value is 5000.
Exclude is a comma-separated list of indexes to exclude from this test.

The Oracle Index Compression and Oracle Table Compression tests each have the following property:

Exclude is a comma-separated list of indexes and tables to ignore (for the Index Compression test), or a comma-separated list of tables to ignore (for the Table Compression test). This property is available to users with Oracle 12c databases.