News
Abstract
Db2 for i Index build processing has been enhanced to gauge its aggressiveness for index key processing based upon the run priority of the index build job.
Content
You are in: IBM i Technology Updates > Db2 for i - Technology Updates > Db2 for i Performance Enhancements > Enhanced index build logic for highly concurrent environments
As seen in the table below, when the job priority is high (1-19), Db2 for i will assume there's less system-wide concurrent access for the index and will process the build in larger portions.
For lower priority levels, the index build will use less aggressive steps.
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Component":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB57","label":"Power"}}]
Was this topic helpful?
Document Information
Modified date:
21 January 2020
UID
ibm11168210