Informix - Problem description
Problem IT40128 | Status: Closed |
"... FRAGMENT BY RANGE ... STORE IN(D1,D2)" WORKS WHEN THE DBSPACES HAVE A DIFFERENT PAGE SIZE | |
product: | |
INFORMIX SERVER / 5725A3900 / E10 - | |
Problem description: | |
Example: Dbspaces address number flags fchunk nchunks pgsize flags owner name 50f7cdd0 9 0x20001 9 1 2048 N BA informix d7 50fcbde0 10 0x20001 10 1 8192 N BA informix d8 create index .... fragment by range(c1) interval(1) store in(d7,d8) ... works, but should return the following error: -793 Page size of the dbspace does not match page size of the table or index. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 14.10.xC9. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 14.10.xC9. * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 14.10.xC9. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 14.10.xC9. * **************************************************************** | |
Comment | |
Fixed in Informix Server 14.10.xC9. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 03.03.2022 30.09.2022 30.09.2022 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |