In the words of Dr Cathy Ryan, "If you don't write it down, it never happened".
To paraphrase one of my clients, "Every day is a school day".
I do, I learn, I share
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 184.108.40.206 - 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 :-)