Index ACT_IDX_JOB_HANDLER too long for DB2

XMLWordPrintable

      As in CAM-7442, when creating the index ACT_IDX_JOB_HANDLER in DB2 (10.1 as well as 11.1), I get the following error message:

      CREATE INDEX ACT_IDX_JOB_HANDLER ON ACT_RU_JOB (HANDLER_TYPE_, HANDLER_CFG_)
      DB21034E  The command was processed as an SQL statement because it was not a 
      valid Command Line Processor command.  During SQL processing it returned:
      SQL0614N  The index or index extension "ACT_IDX_JOB_HANDLER" cannot be created 
      or altered because the combined length of the specified columns is too long.  
      SQLSTATE=54008
      

      Seems it needs to be excluded too

            Assignee:
            Nikola Koevski
            Reporter:
            Jaap Sperling
            Votes:
            2 Vote for this issue
            Watchers:
            6 Start watching this issue

              Created:
              Updated:
              Resolved: