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

Version 8.0 Refresh Pack 1 for the IBM Business Process Manager products
Version 7.5.1 Fix Pack 2 for the IBM Business Process Manager products
Version 7.5.1 Fix Pack 1 for the IBM Business Process Manager products

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