Tuning Performance › VSAM Data Set Tuning › Database Activity Management

Database Activity Management

Database activity tuning applies to NDBs. Consider the following points when using NDBs to enhance performance:

• Open an NDB as a UDB by using the UDBCTL OPEN command with the LSR and DEFER options.
• Define the LSR pool with sufficient buffers of appropriate size for the NDB data set data and index.
• Check that SYSPARMS, NDBSUBMN, and NDBSUBMX values are adequate for the amount of concurrent SCAN activity that is occurring.
• Choose values for the NDB scan limit system parameters that stop users from running scans that consume excessive system resources.

Important! Do not use the DEFER option of the NDB START command unless you are bulk loading.