Sample DB2 for z/OS commands for allocating buffer pools

Before running the createDatabase.sh script to configure your databases, you must allocate the required 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 ;
/*

If you are in data sharing mode, make sure that you define the cache XCF structures for the group buffer pools being used. For further information, see Cross-system coupling facility component of z/OS in the DB2 for z/OS Information Center.