Sample Db2 for z/OS commands for allocating buffer pools

Work with your Db2® for z/OS® database administrator to determine which buffer pools to use. For each buffer pool, you can define the buffer pool BPn with yyyyy pages by using the following DB2® command:

-ALTER BUFFERPOOL (BPn) VPSIZE(yyyyy)

For example:

-ALTER BUFFERPOOL (BP1) VPSIZE(20000)

You can also run the Db2 commands in a batch job, for example:

//JOBLIB  DD  DISP=SHR,DSN=db2hlq.SDSNLOAD
//STEP1   EXEC PGM=IKJEFT01,DYNAMNBR=20
//SYSTSPRT DD  SYSOUT=*
//SYSPRINT DD  SYSOUT=*
//SYSUDUMP DD  SYSOUT=*
//SYSTSIN  DD  *
  DSN SYSTEM(ssid)
  -ALTER BUFFERPOOL (BPn) VPSIZE(yyyyy)
  RUN PROGRAM(DSNTIAD)  PLAN(DSNTIAnn) -
       LIBRARY('db2hlq.RUNLIB.LOAD')
  END
//SYSIN    DD  *
GRANT USE OF BUFFERPOOL BPn TO PUBLIC ;
/*