RS01485: PERFORMANCE ISSUE WITH MIGRATION SCRIPT WHEN HANDLING ELEMENTS VERSIONS

Operational Decision Manager V8.5.1: Interim Fix 13 Rev B
Operational Decision Manager V8.0.1.2 Fix Pack
Operational Decision Manager V8.5.1: Interim Fix 23 Revision B
Operational Decision Manager V8.5.1.1 Fix Pack
Operational Decision Manager V8.5.1.0: Interim Fix 69

APAR status

• Closed as program error.

Error description

• The SQL queries which copies the version records for the
  various project elements perform poorly.
  This may block the migration script execution.
  

Local fix

• This is fixed by adding conditions on VERSION ELTORIGINALID and
  
  TYPE columns. for instance :
  INSERT INTO RTSDB85.VERSION (ID, PROJECT, MINOR, USERNAME,
  DELETED, ELTORIGINALID, MAJOR,
    COMMENTAIRE, VERSDATE, SYSVERS, BASELINE, TYPE)
   SELECT  DISTINCT OLDVERSION.ID, OLDRULEPACKAGE.PROJECT,
  OLDVERSION.MINOR, OLDVERSION.USERNAME,
    OLDVERSION.DELETED, OLDVERSION.ELTORIGINALID, OLDVERSION.
  MAJOR, OLDVERSION.COMMENTAIRE,
    OLDVERSION.VERSDATE, 'F', RTSDB85.BASELINE.ID, MM.ID
   FROM RTSDB71.VERSION OLDVERSION, RTSDB85.METAMODEL MM,
  RTSDB71.METAMODEL OLDMETAMODEL,
    RTSDB85.BASELINE, RTSDB71.RULEPACKAGE OLDRULEPACKAGE
   WHERE MM.TYPE = OLDMETAMODEL.TYPE AND OLDMETAMODEL.ID =
  OLDVERSION.TYPE AND
    RTSDB85.BASELINE.CONTAINER = OLDRULEPACKAGE.PROJECT AND
   OLDVERSION.ELTORIGINALID = OLDRULEPACKAGE.ORIGINALID and
   OLDVERSION.TYPE = OLDRULEPACKAGE.TYPE and
    ((OLDVERSION.DELETED = 'F' AND RTSDB85.BASELINE.PARENT IS
  NULL) OR
      (OLDVERSION.DELETED = 'T' AND RTSDB85.BASELINE.NAME =
  'recyclebin')) AND
    (OLDVERSION.ID = OLDRULEPACKAGE.STARTID OR
     (OLDVERSION.ID !=  2147483647 AND OLDVERSION.ID =
  OLDRULEPACKAGE.ENDID)) AND
    OLDMETAMODEL.TYPE IN ('brm.RulePackage') ;
  

Problem summary

• migration SQL queries need to be optimized to account for large
  databases when migrating from 7.1
  

Problem conclusion

• The code is modified to improve migration performance
  

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:

Modules/Macros

• 999
  

Fix information

• Fixed component name

  WS DECISION CTR

• Fixed component ID

  5725B6900

Applicable component levels

• R851 PSY

     UP