The SQL ALTER DATABASE statement is used to changes the description of a database.
Database alteration syntax is as follows.
ALTER DATABASE database-name BUFFERPOOL bp-name INDEXBP bp-name STOGROUP stogroup-name CCSID ASCII/EBCDIC/UNICODE
Change the default buffer pool for both table spaces and indexes within database ABCDE to BP2.
ALTER DATABASE ABCDE BUFFERPOOL BP2 INDEXBP BP2;
If you have any doubts or queries related to this chapter, get them clarified from our Mainframe experts on ibmmainframer Community!