Wednesday, 12 February 2014

IBM Operational Decision Manager 8.5.1.0 - Problems with missing DB2 Buffer Pool

One about which I'd forgotten.

I saw this exception: -

Failed to execute SQL statement "CREATE TABLESPACE RESDWTS PAGESIZE 32K BUFFERPOOL BP32K".
DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=BP32K, DRIVER=3.65.97

when configuring the DB2 database for an IBM Operational Decision Manager (ODM) 8.5.1.0 Decision Server ( aka Rules Execution Server == RES ) environment.

ODM provides a nice GUI for configuration, and I got hit with this: -

 

I validated this on the DB2 server directly: -

$ db2 connect to resdb
$ db2 "CREATE TABLESPACE RESDWTS PAGESIZE 32K BUFFERPOOL BP32K"

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 :-)

No comments:

Yay, VMware Fusion and macOS Big Sur - no longer "NAT good friends" - forgive the double negative and the terrible pun ...

After macOS 11 Big Sur was released in 2020, VMware updated their Fusion product to v12 and, sadly, managed to break Network Address Trans...