Table space LOCKSIZE option

I want to set the LOCKSIZE option to a ROW level in a tablespace.
Can anyone give me the syntax ?

alter tablespace dbname.tablespace1 LOCKSIZE ROW;

is not working. we are running db2 8.1 FP 8/linux.

Many thanks for the help.

The confusion stemmed from the fact that you are referring to the documentation for DB2 on z/OS as opposed to DB2 on Linux. For z/OS, locking is controlled at the TABLESPACE level. For DB2 Linux, Unix and Windows, it is at the TABLE level.

Try this command instead:

ALTER TABLE LOCKSIZE ROW

Full reference of the command:
http://publib.boulder.ibm.com/infoce...n/r0000888.htm

cheers,
k.