JR53913: CREATE TABLESPACE STATEMENTS IN THE GENERATED CREATETABLESPACE SQL FILE ARE COMMENTED WHEN USETABLESPACE=TRUE

Version 8.5 Refresh Pack 7 for the IBM Business Process Manager products

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