In the words of Dr Cathy Ryan, "If you don't write it down, it never happened".
The postings on this site are my own and don’t necessarily represent IBM’s positions, strategies or opinions.
My blog is PERSONAL, and is a repository of the stuff that I learn, play with, enjoy and want to share.
If you follow one of my tips, your mileage MAY well vary - Here be dragons :-)
Wednesday, 12 February 2014
IBM Operational Decision Manager 126.96.36.199 - Problems with missing DB2 Buffer Pool
DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned: SQL0204N "BP32K" is an undefined name. SQLSTATE=42704
Yes, you've guessed it - I'd forgotten to create the Buffer Pool BP32K.
This I did: -
$ db2 create bufferpool BP32K size 8000 pagesize 32 K
DB20000I The SQL command completed successfully.
and re-ran the ODM wizard; this time it all ended happily :-)