23.3.11

SAP Note 25463 - inf750: Invalid distribution format found

Symptom:

After zooming a table column with
ALTER TABLE MODIFY ( CHAR ())
where, "new_size" > "old_size" is valid,

  • the following SELECT statement SELECT * FROM WHERE ='value'
  • as wells as the call of dbschema -hd

leads to the error: inf750: Invalid distribution format found for

Cause and prerequisites

The Informix query optimizer attempts to access the changed column of this table using old statistics information. (Bug in Informix online 6.x/7.x)

Solution
Execute an "UPDATE STATISTICS MEDIUM/HIGH" on the affected columns. Should that not help, please do an "update statistics low for table drop distributions"
before doing an "update statistics medium for table ".

Additional key words

PTS PTS_BUG PTS_BUG_xxxxx

No comments:

Post a Comment