IBM Support

JR42540: BPMGENERATEUPGRADESCHEMASCRIPTS.SH DOES NOT GENERATE CORRECT SCRIPTS FOR DB2 ON Z/OS

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as fixed if next.

Error description

  • Customer using BPM on zLinux and using DB2 on z/OS. When they
    upgrade from 7.5.0.1 to 7.5.1 They run the
    BPMGenerateUpgradeSchemaScripts.sh script on Dmgr profile part
    of the process. Once they run BPMGenerateUpgradeSchemaScripts.sh
    ,they check the generated Dbscripts and  they are not z/Os ready
    .  They notice that the scripts miss currentsqlid,dont spcify
    the tables space name before creating tables and have GO
    statements which are invalid for z/Os
    

Local fix

  • N/a
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:  Users of BPM on DB2 for z/OS database       *
    ****************************************************************
    * PROBLEM DESCRIPTION: Customer using BPM on zLinux and        *
    *                      using DB2 on z/OS. When they            *
    *                      upgrade from 7.5.0.1 to 7.5.1 They      *
    *                      run the                                 *
    *                      BPMGenerateUpgradeSchemaScripts.sh      *
    *                      script on Dmgr profile part             *
    *                      of the process. Once they run           *
    *                      BPMGenerateUpgradeSchemaScripts.sh      *
    *                      ,they check the generated Dbscripts     *
    *                      and  they are not z/Os ready            *
    *                      .  They notice that the scripts miss    *
    *                      currentsqlid,dont spcify                *
    *                      the tables space name before creating   *
    *                      tables and have GO                      *
    *                      statements which are invalid for z/Os   *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    :
    Customer using BPM on zLinux and using DB2 on z/OS. When they
    upgrade from 7.5.0.1 to 7.5.1 They run the
    BPMGenerateUpgradeSchemaScripts.sh script on Dmgr profile part
    of the process. Once they run
    BPMGenerateUpgradeSchemaScripts.sh
    ,they check the generated Dbscripts and  they are not z/Os
    ready
    .  They notice that the scripts miss currentsqlid,dont spcify
    the tables space name before creating tables and have GO
    statements which are invalid for z/Os
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    JR42540

  • Reported component name

    BPM ADVANCED

  • Reported component ID

    5725C9400

  • Reported release

    751

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-04-13

  • Closed date

    2012-08-03

  • Last modified date

    2012-08-03

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels

  • R750 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":"7.5.1","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
11 October 2021