TSO-ISPF JCL COBOL VSAM DB2 CICS Tools Articles Job Portal Forum Quiz Interview Q&A

DB2 - SQL Alter Database Statement


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

Example 1:

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!

Are you looking for Job Change? Job Portal