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  extend (all 8000)"

Popular posts from this blog

Jython Script Examples

Skip fields during duplication