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!