A fix is available
APAR status
Closed as program error.
Error description
When you create a IBM Business Process Manager (BPM) deployment environment with IBM DB2 databases and set bpm.de.db.#.usetablespaces=true for the BusinessSpace database in the configuration properties file, the CREATE TABLESPACE statements in the generated createTablespace_*.sql file are commented out. Also, the IN BSPREGTP clauses of the 'CREATE TABLE' statements are commented out in the generated createSchema*.sql file.
Local fix
For the concern about createSchema_AdvancedOnly.sql, there is a bug in the code that generates the SQL scripts for BSpace, it does not uncomment the "-- IN @TSPRE@REGTP" part when usetablespace=true is set. As a workaround, the customer can manually remove the "--" comment sign from "IN BSPREGTP" in createSchema_AdvancedOnly.sql.
Problem summary
The BPMConfig command does not remove the comment characters from the template SQL files when generating the SQL files to set up the BusinessSpace database tables.
Problem conclusion
A fix that allows the BPMConfig command to correctly generate the SQL files for BusinessSpace will be included in an IBM BPM V8.5.6.0 cumulative fix.
Temporary fix
In the configuration properties file, set bpm.de.deferSchemaCreation=true Then, before you run the generated SQL files, manually fix them: 1.In the generated createTablespace*.sql file, change the following specifications: -- CREATE BUFFERPOOL MASHUPS32KBP IMMEDIATE SIZE 8000 AUTOMATIC PAGESIZE 32K; -- -- CREATE SYSTEM TEMPORARY TABLESPACE @TSPRE@TMPTP -- PAGESIZE 32K MANAGED BY SYSTEM -- USING ( '@TSDIR@TMPTP' ) -- EXTENTSIZE 16 -- BUFFERPOOL MASHUPS32KBP -- FILE SYSTEM CACHING -- ; -- CREATE REGULAR TABLESPACE @TSPRE@REGTP -- PAGESIZE 32K MANAGED BY SYSTEM -- USING ( '@TSDIR@REGTP' ) -- EXTENTSIZE 16 -- BUFFERPOOL MASHUPS32KBP -- FILE SYSTEM CACHING -- ; ---------------------------------------------------------------- ------------------ -- For improved performance on DB2 v9.x, you can instead use the following blocks: ---------------------------------------------------------------- ------------------ -- CREATE BUFFERPOOL MASHUPS32KBP IMMEDIATE SIZE 8000 AUTOMATIC PAGESIZE 32K; -- -- CREATE SYSTEM TEMPORARY TABLESPACE @TSPRE@TMPTP -- PAGESIZE 32K MANAGED BY SYSTEM -- USING ( '@TSDIR@TMPTP' ) -- EXTENTSIZE 16 -- PREFETCHSIZE AUTOMATIC -- BUFFERPOOL MASHUPS32KBP -- FILE SYSTEM CACHING -- ; -- -- CREATE REGULAR TABLESPACE @TSPRE@REGTP -- PAGESIZE 32K MANAGED BY SYSTEM -- USING ( '@TSDIR@REGTP' ) -- EXTENTSIZE 16 -- PREFETCHSIZE AUTOMATIC -- BUFFERPOOL MASHUPS32KBP -- NO FILE SYSTEM CACHING -- ; ------------- bufferpool for regular tablespaces CREATE BUFFERPOOL BP32K_BSP IMMEDIATE SIZE 250 PAGESIZE 32 K; ------------- bufferpool for temp tablespace CREATE BUFFERPOOL TMPBP32K_BSP IMMEDIATE SIZE 250 PAGESIZE 32 K; ------------- tablespace for DataServices (DS) CREATE REGULAR TABLESPACE @TSPRE@BSPACE PAGESIZE 32 K MANAGED BY AUTOMATIC STORAGE BUFFERPOOL BP32K_BSP; ------------- tablespace (temp) for sorts/joins CREATE SYSTEM TEMPORARY TABLESPACE @TSPRE@TMPT_BS PAGESIZE 32 K MANAGED BY AUTOMATIC STORAGE EXTENTSIZE 8 OVERHEAD 10.5 PREFETCHSIZE 32 TRANSFERRATE 0.14 BUFFERPOOL TMPBP32K_BSP; to ------------- tablespace for Mashups CREATE REGULAR TABLESPACE BPM01REGTP PAGESIZE 32K MANAGED BY AUTOMATIC STORAGE EXTENTSIZE 16 PREFETCHSIZE AUTOMATIC; ------------- tablespace for DataServices (DS) CREATE REGULAR TABLESPACE BPM01BSPACE PAGESIZE 32K MANAGED BY AUTOMATIC STORAGE; 2.In the generated createSchema*.sql file, remove the comments from all lines that look like the following lines: -- IN @TSPRE@REGTP --IN @TSPRE@BSPACE
Comments
APAR Information
APAR number
JR53913
Reported component name
BPM ADVANCED
Reported component ID
5725C9400
Reported release
856
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2015-07-29
Closed date
2015-10-26
Last modified date
2015-10-26
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
BPM ADVANCED
Fixed component ID
5725C9400
Applicable component levels
R856 PSY
UP
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSFTN5","label":"IBM Business Process Manager Advanced"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"856","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
16 October 2021