Toad World® Forums

How to update the value of LOCKMAX

Hi, all,

[1] I would like to update the value of LOCKMAX (parameter for lock escalation control in DB2-LUW ) using “ALTER TABLESPACE”.

[2] I have tried a lot of options to do so (Appendix 1) , however, I got a syntax error for all of them (variations of SQL0104N).

Does anybody know what is wrong here?

Thanks,

Jovanni

Appendix 1:

db2 "ALTER TABLESPACE database_name.TS_01 ‘-LOCKMAX0’ "
db2 "ALTER TABLESPACE database_name.TS_01 ‘-LOCKMAX 0’ "
db2 "ALTER TABLESPACE database_name.TS_01 -LOCKMAX 0 "
db2 "ALTER TABLESPACE database_name.TS_01 -LOCKMAX0 "
db2 "ALTER TABLESPACE database_name.TS_01 ‘LOCKMAX0’ "
db2 "ALTER TABLESPACE database_name.TS_01 ‘LOCKMAX 0’ "