1 Reply Latest reply on Mar 26, 2019 8:50 AM by Phil Grainger

    Has anyone faced Lock escalation on SYSCOLDIST_HIST and SYSCOLUMNS_HIST during REORG? Global Options are RUNSTATS(NO) and we are expecting REORG not to run RUNSTATS. But the REORG job caused lock escalation on these catalog tables.

    Mohamed Shajahan MKS
      Share:|

      Has anyone faced Lock escalation on SYSCOLDIST_HIST and SYSCOLUMNS_HIST during REORG?

      We have Global Options as RUNSTATS(NO) and we are expecting reorg NOT to run RUNSTATS.

      Cannot find any information on the CDBPRINT about stats being applied to these tables.

       

      Thanks

      Shaj