View Issue Details

IDProjectCategoryView StatusLast Update
0005025SymmetricDSImprovementpublic2021-07-13 17:53
Reporterelong Assigned Toelong  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.12.0 
Target Version3.12.11Fixed in Version3.12.11 
Summary0005025: Informix dialect with page size 2k
DescriptionInformix dialect currently requires a 4k page size because some indexes and primary keys have large columns. Modify the schema for Informix so that it fits inside a 2k page size.

The following constraints will not fit in 2k page size:

registration_request - the index with node_group_id, external_id, status, host_name, ip_address
file_snapshot - the primary key with trigger_id, router_id, relative_dir, file_name

Parameter informix.2k.page.size=true will default to expecting the 2k page size and can be overridden for larger columns.
Tagsdialect: informix

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.12 4e6e7cc1

2021-06-11 16:58:36

admin

Details Diff
0005025: Informix dialect with page size 2k Affected Issues
0005025
mod - symmetric-assemble/src/asciidoc/appendix/informix.ad Diff File
mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/informix/InformixSymmetricDialect.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/common/ParameterConstants.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/db/DatabaseUpgradeListener.java Diff File
mod - symmetric-core/src/main/resources/symmetric-default.properties Diff File

SymmetricDS: 3.12 6ae47596

2021-06-11 19:53:11

admin

Details Diff
0005025: Informix dialect with page size 2k Affected Issues
0005025
mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/informix/InformixSymmetricDialect.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/common/ParameterConstants.java Diff File
mod - symmetric-core/src/main/resources/symmetric-default.properties Diff File

Issue History

Date Modified Username Field Change
2021-06-11 16:56 elong New Issue
2021-06-11 16:56 elong Status new => assigned
2021-06-11 16:56 elong Assigned To => elong
2021-06-11 16:56 elong Tag Attached: dialect: informix
2021-06-11 16:59 elong Status assigned => resolved
2021-06-11 16:59 elong Resolution open => fixed
2021-06-11 16:59 elong Fixed in Version => 3.12.11
2021-06-11 17:00 admin Changeset attached => SymmetricDS 3.12 4e6e7cc1
2021-06-11 20:00 admin Changeset attached => SymmetricDS 3.12 6ae47596
2021-07-13 17:53 admin Status resolved => closed