IJ51268: BMXAA0652E THE TOTAL LENGTH OF COLUMNS IN AN INDEX CANNOT EXCEED 120000

APAR status

• Closed as program error.

Error description

• ERROR DESCRIPTION:
  BMXAA0652E The total length of columns in an index cannot exceed
  120000
  
  PROBLEM:
  When attempt to save a database configuration for certain fields
  user gets the following error.
  BMXAA0652E - The total length of columns in an index cannot
  exceed 120000.
  Specifically we triggered this trying to save length change to
  personid on the person object.
  Basically error will be thrown if a db config change updates an
  object attribute that is tied to an index
  and any index on that object (does not have to be the index tied
  to the attribute changed) is tied to
  attributes of cumulative length greater than 120000.
  
  Run query:
  select objectname,attributename,sameasobject,sameasattribute
  from maxattributecfg a2 where
  a2.objectname in (select tbname from maxsysindexes i2 where
  i2.name in (select ixname from
  maxsyskeys k2 where ixname in ( select ixname from maxsyskeys k,
  maxattributecfg a, maxsysindexes i
  where k.colname = a.attributename and k.ixname = i.name and
  a.objectname = i.tbname group by
  ixname having sum(a.length) > 120000))) and a2.sameasobject is
  not null and exists (select 1 from
  maxsysindexes i3, maxsyskeys k3 where i3.name = k3.ixname and
  i3.tbname = a2.objectname and
  k3.colname = a2.attributename);
  
  Thus, the error can be triggered by updating any of these
  sameasobject/sameasattribute combinations.
  
  **** For MAM (without ICD) the query will not give the
  person/personid result above in
  the query result set because there does not exist an index on
  docinfo.createby. Thus you can recreate
  by simply creating an index on the DOCINFO object indexing the
  CREATEBY attribute and save and error
  will be thrown *******
  
  
  PERFORMANCE ISSUE: No.
  
  STEPS TO REPRODUCE:
  From Oracle, add the index in the CREATEDBY attribute, DOCINFO
  table.
  CREATE INDEX PMCHGDOCINFO_NDX1 ON DOCINFO(CREATEBY);
  Go to Database Configuration application.
  Refresh Index Tables, so the new index is reflected in metadata.
  
  Open the PERSON object.
  Change the PERSON.PERSONID length from 30 to 31 and save it.
  
  Get the following error message:
  BMXAA0652E - The total length of columns in an index cannot
  exceed 120000.
  
  
  CURRENT ERRONEOUS RESULT:
  The error message is shown and the attribute length is not
  changed.
  
  
  EXPECTED RESULT:
  Attribute length should be changed successfully.
  
  
  ENVIRONMENT (SYSTEM INFO):
  Tivoli's process automation engine 7.6.1.2-IFIX20220628-1241
  Build 20200715-0100
  

Local fix

• NA
  

Problem summary

Problem conclusion

• A fix for this APAR will be included in a future release.
  

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:

Fix information

• Fixed component name

  SYSTEM CONFIG

• Fixed component ID

  5724R46S1

Applicable component levels