SQL0204N "BP32K" is an undefined name. SQLSTATE=42704

Question

While configuring the ODM RES database during a custom IBM ODM installation (aka iLog JRules or WODM), I'm encountering this error:

 

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

 

 

This happens right after executing the following SQL command:

 

 

CREATE TABLESPACE RESDWTS PAGESIZE 32K BUFFERPOOL BP32K

 

 

And then rest of the script execution is also broken because of the above error:

 

 

CREATE SYSTEM TEMPORARY TABLESPACE RESDWTMPTS 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

 

CREATE TABLE EXECUTION_TRACES ( ID INT GENERATED ALWAYS AS IDENTITY (START WITH

1, INCREMENT BY 1) NOT NULL, TIME_STAMP BIGINT, LOCATION VARCHAR(2000), REQUEST_

PATH VARCHAR(2000) NOT NULL, CANONICAL_PATH VARCHAR(2000) NOT NULL, RULESET_PROP

ERTIES CLOB, ELAPSED_TIME BIGINT, USER_DATA CLOB, NB_RULES INT, NB_RULES_FIRED I

NT, NB_RULES_NOT_FIRED INT, NB_TASKS INT, NB_TASKS_EXECUTED INT, NB_TASKS_NOT_EX

ECUTED INT, RULES CLOB, TASKS CLOB, EXECUTION_TRACE_TREE CLOB, EXEC_OUTPUT CLOB,

 INPUT_PARAMS CLOB, OUTPUT_PARAMS CLOB, EXECUTION_ID VARCHAR(255) NOT NULL, FULL

_EXECUTION_TRACE CLOB, CONSTRAINT ET_PK PRIMARY KEY (ID), CONSTRAINT EID_UNQ UNI

QUE (EXECUTION_ID) ) IN RESDWTS

 

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  "RESDWTS" is an undefined name.  SQLSTATE=42704

 

 

Any help will be appreciated.

Answer 1

Preliminarily running

 

CREATE BUFFERPOOL BP32K IMMEDIATE SIZE 250 PAGESIZE 32 K;

 

solves the problem!