Changing locking scheme

Concurrency optimization affects only data-only-locked tables. Table 20-3 shows the effect of changing the locking scheme.

Table 20-3: Effects of alter table on concurrency optimization settings

Changing locking scheme from

Effect on stored value

Allpages to data-only

Set to 15, the default

Data-only to allpages

Set to 0

One data-only scheme to another

Configured value retained