I need to change locking scheme for MDATables from Allpages to datarow,but unfortunately I'm not able to do it.
I have already changed sp_configure 'lock scheme', 0, datarows
(just after instance installation)
and tried to alter table:
alter table monProcessWaits lock datarows
returns an error: Action requested is not valid for remote tables
I've tried also reinstall mon tables with script
ASE/scripts/installmontables without success
(prints info that montables are installed by default with installmaster script)
Is there any way to change locking scheme for MDAtables from Allpages to datarows?
Adaptive Server Enterprise/15.7/EBF 22774 SMP SP122 /P/Sun_svr4/OS
5.10/ase157sp12x/3662/64-bit/FBO/Sun Apr 20 12:06:36 2014