Changing the locking scheme

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

Table 7-9: Effects of alter table on concurrency optimization settings

Changing 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