How to do it...

1. Get current database parameters:

   	db2 => connect to nav;
   
   	   Database Connection Information
   
   	 Database server        = DB2/LINUXX8664 9.7.4
   	 SQL authorization ID   = DB2INST1
   	 Local database alias   = NAV
   
   	db2 => GET DB CFG;
   
   	       Database Configuration for Database
   	 Database configuration release level                    = 0x0d00
   	 Database release level                                  = 0x0d00  
   	….
   

   We'll look for specific items:

   	 Database page size                                    = 8192
   	 Degree of parallelism                    (DFT_DEGREE) = 1
   	 Changed pages threshold              (CHNGPGS_THRESH) = 80
   	 Default prefetch size (pages)       (DFT_PREFETCH_SZ) = AUTOMATIC
   
   	 Default number of containers                            = 1
   	 Default tablespace extentsize (pages)   (DFT_EXTENT_SZ) = 32
   

2. Create proper buffer pool, if necessary:

   Determine the optimum page size for your table space. Create or choose a buffer pool with the corresponding page size...