INDEX CLEANUP THREADS field (INDEX_CLEANUP_THREADS subsystem parameter)
Specifies the maximum number of threads that can be created to process the cleanup of pseudo-deleted index entries on this subsystem or data sharing member. Pseudo-deleted entries in an index are entries that are logically deleted but still physically present in the index.
| Acceptable values: | 0–128 |
|---|---|
| Default: | 10 |
| Data sharing scope: | Members are not required to use the same setting |
| Online changeable: | Yes |
| Update: | option 20 on panel DSNTIPB |
| DSNZPxxx: | DSN6SPRM INDEX_CLEANUP_THREADS |
This parameter works in conjunction with the SYSIBM.SYSINDEXCLEANUP catalog table, which controls cleanup processing of pseudo-deleted index entries.
The default setting is appropriate for most situations. However, a larger setting might be appropriate in cases where large indexed tables or large numbers of indexed tables are constantly modified. A smaller value might be appropriate in cases where thread count is severely constrained.
When INDEX_CLEANUP_THREADS is set to 0, no cleanup is performed by the subsystem or data sharing member regardless of the entries in the SYSIBM.SYSINDEXCLEANUP catalog table.