Table space alteration syntax is as follows:
ALTER TABLESPACE [database-name.]tablespace-name using-block free-block LOGGED | NOT LOGGED TRACKMOD YES/NO BUFFERPOOL bp-name CCSID ASCII/EBCDIC/UNICODE CLOSE YES/NO COMPRESS YES/NO LOCKMAX integer LOCKSIZE ANY/TABLESPACE/TABLE/PAGE/ROW MAXROWS integer MAXPARTITIONS integer using-block: USING VCAT catalog-name STOGROUP stogroup-name PRIQTY integer SECQTY integer ERASE YES/NO free-block: FREEPAGE integer PCTFREE integer |
Alter table space DSN8S91D in database DSN8D91A. BP2 is the buffer pool associated with the table space. PAGE is the level at which locking is to take place.
ALTER TABLESPACE DSN8D91A.DSN8S91D BUFFERPOOL BP2 LOCKSIZE PAGE; |
If you have any doubts or queries related to this chapter, get them clarified from our Mainframe experts on ibmmainframer Community!