3305519 - DB2 is reporting sql error SQL1218N.

While performing some database activity (ie, SAP upgrade) you notice SQL1218N error is being reported.

====================================================================
ERROR:
Detected the following errors:

# /dump2/SUM/abap/log/SAPI701EHP.PRD:
4 ETW000 [dev trc,00000] &+
4 ETW000 [dev trc,00000] &+
4 ETW000 [dev trc,00000] &+ *** ERROR in DB6Execute[/bas/749_REL/src/dbs/db6/dbdb6.c, 5275] (END)
4 ETW000 [dbtrtab ,00000] ***LOG BY4=>sql error -1218 performing INS on table FUPARAREF
4 ETW000 [dbtrtab ,00000] ***LOG BY0=>SQL1218N There are no pages currently available in bufferpool "4098". SQLSTATE=57011
====================================================================

In this case it is bufferpool "4098" reporting the error.  You can determine the bufferpool name and pagesize used with the following command:

db2pd -db <database> -buff

Address                      Id       Name                        PageSz     PA-NumPgs 
0x00007F8FE72C63E0 1        IBMDEFAULTBP           16384      193634    
0x00007F8FE72921E0 4096   IBMSYSTEMBP4K        4096        16        
0x00007F8FE729F260 4097   IBMSYSTEMBP8K        8192        16        
0x00007F8FE72AC2E0 4098  IBMSYSTEMBP16K   16384      16        
0x00007F8FE72B9360 4099   IBMSYSTEMBP32K      32768      16     

Bufferpool "4098" is IBMSYSTEMBP16K.

• IBM DB2 LUW (DB6) any release

bufferpool , DB2_OVERRIDE_BPF , SQL1218N , -1218 , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , BC-DB-DB6-UPG , Upgrade SAP System , Problem