Fixes are available
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 number
RS01485
Reported component name
WS DECISION CTR
Reported component ID
5725B6900
Reported release
851
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2013-12-03
Closed date
2013-12-03
Last modified date
2013-12-03
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
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSQP76","label":"IBM Operational Decision Manager"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.5.1","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
08 January 2022