DB2 Tablespace and Bufferpool Commands
ABAP
,
BASIS
,
DB2
,
MSSQL
,
SAP Beginners
No comments
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)"
Subscribe to:
Post Comments
(
Atom
)
No comments :
Post a Comment