System Control Area |
|
The System Control Area (SCA) is where concurrency control blocks are stored. Large transactions requiring many lock resources will need a larger SCA to function properly. If too many resources are being allocated for concurrency control, the SCA can be enlarged, or the threshold of lock escalation can be decreased (refer to Engine Control later in this section). The Size of System Control Area (pages) setting can be altered by inputting a value in the field or by using the up and down arrows to the right of the field. This setting corresponds to the DB_ScaSz keyword in the dmconfig.ini file. The default value is 200 pages.
Related topic: