|
Problem IT37182
|
Status: Closed |
ADDING ROWID ON FRAGMENTED TABLE SELECT STATEMENT RETURNS "750INVALID DISTRIBUTION FORMAT FOUND FOR"
|
| product: |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 |
| Problem description: |
Adding the rowid in fragmented table select statement returns
"750 Invalid distribution format found for"
Data stored within the system catalog table sysdistrib is
corrupted for fragmented table when select query run on that
table. This is happen after adding rowid on the fragmented
table. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Users of Informix Server prior to 12.10.xC15 and 14.10.xC7. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Informix Server 12.10.xC15 or 14.10.xC7 (when *
* available). *
**************************************************************** |
| Local Fix: |
Drop and then rebuild the distributions associated with the
tables referred to in your SQL statement by using the UPDATE
STATISTICS command. |
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* Users of Informix Server prior to 12.10.xC15 and 14.10.xC7. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Informix Server 12.10.xC15 or 14.10.xC7 (when *
* available). *
**************************************************************** |
| Comment |
Fixed in Informix Server 12.10.xC15 and 14.10.xC7. |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 09.06.2021
26.08.2021
26.08.2021 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
