Changing locking scheme

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

**Table 3-4: 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