Changing locking scheme

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

Table 5-5: 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