IBM Support

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

Subscribe

You can track all active APARs for this component.

 

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"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"856","Edition":"","Line of Business":{"code":"LOB36","label":"IBM Automation"}}]

Document Information

Modified date:
26 October 2015