Problem with creationg buffer pool

chakribobby · #1 (**permalink**) 10-27-07, 10:37

Hi,

While running the following command as db2inst1 user
I got this error

bash-3.2$ db2 CREATE BUFFERPOOL create-buffer
DB21016E The Command Line Processor encountered a system error while sending
the command to the backend process.
DB20000I The SQL command completed successfully.

Thanks in advance

guyprzytula · #2 (**permalink**) 10-27-07, 11:44

have a look in db2diag.log - probably not enough memory to allocate

chakribobby · #3 (**permalink**) 10-27-07, 12:25

Thanks for you reply
Now I got this error
DYM8204E Create DB bufferpool command failed with error com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: ISPB_BP16K;BUFFERPOOL

guyprzytula · #4 (**permalink**) 10-28-07, 03:48

-601 mens bufferpool already existing
the previous error/command did completed (bp created), but could not be allocated (memory)- now already existing - verify in sysibm.sysbufferpools

chakribobby · #5 (**permalink**) 10-28-07, 11:56

problem is resolved
bufferpool is already existing
thank for you help

Internet Services

Web Development

Digital Marketing

Consumer Tech