what’s the best lock size that you could use when you create a tablespace ?
The answer is Locksize = ANY. Unless you are Sure what’s the Purpose of tablespace ie., Read-only or R/W. If you use lock size =any, Db2 would automatically determine what type of locks it should use.