To resolve this issue , we need to follow below steps

• Run Rebuild all and reorganize all on the tables mentioned in the deadlock error
• Run update statistics on the same tables
• Run resume.bat to resume the rules upgrade

Below is the sample sql statement

ALTER INDEX ALL ON rules.pr_index_reference

REORGANIZE ;

GO

UPDATE STATISTICS rules.pr_index_reference

GO

Hi,

When you run the upgrade, if the property "rebuild.indexes" in setupDatabase.properties file is set as true, then the upgrade step calls the SPPR_REBUILD_INDEXES procedure to rebuild indices and forces the re-computation of table stats for the purpose of upgrade performance.

By default, this property is set as FALSE for all DB except DB2 Z/oS. I understand that this step is time consuming.

Won't setting up this property avoided your problem in the first place ?

Thanks, Jaffer