DB2 Tablespace and Bufferpool Commands



View the names, pagesize, and number of pages of the bufferpools in your database:

=>db2 "select bpname,pagesize,npages from syscat.bufferpools"

Make a bufferpool resize automatically.  You must have STMM turned on at the database configuration level

=>db2 alter bufferpool bp1 size AUTOMATIC 

Alter a bufferpool size that is a fixed size

=>db2 ALTER BUFFERPOOL IBMDEFAULTBP SIZE 15000;

Add space to a DMS tablespace:

=>db2 "alter tablespace <tblspace> extend (all 8000)"