Adjusting page size is a complex topic. To learn more details about it, see Important - PAGE_SIZE Conversions.
Warning: Changing the PAGE_SIZE is a maintenance task that should be done carefully and with a full reliable backup. Practice on a copy of your data and other folders until you are confident with the results. FairCom DB V12 has a default PAGE_SIZE 32K (V11 defaulted to 8K) and it will automatically attempt to convert the FairCom Internal files (FAIRCOM.FCS, *.FSD, *.FDD) during the initial startup. The automatic conversion requires the file ctscmp.exe (ctscmp on Linux/Unix) to be present in the working directory where the FairCom Server binary (faircom.exe for V12) is located (the \server directory for V12).
Notice that a file created with a larger PAGE_SIZE cannot be opened by a system with a smaller PAGE_SIZE.
Follow these procedures to rebuild the affected files:
Move this copy to a different machine from your live system. Keep a clean copy in case you need to start over.
PAGE_SIZE 32768
ctscmp.exe <server directory>\data\ctdbdict.fsd 256
ctscmp.exe <server directory>\data\ctreeSQL.dbs\SQL_SYS\ctreeSQL.fdd 256
ctscmp.exe <server directory>\data\FAIRCOM.FCS 256
./ctcmpcif (server directory)/data/ctreeSQL.dbs/MyData.dat ADMIN ADMIN FAIRCOMS -256
./ctcmpcif.standalone (server directory)/data/ctreeSQL.dbs/MyData.dat -256
If using ctcmpcif, restart the server first.
./ctrbldif (server directory)/data/ctreeSQL.dbs/MyData.dat -256
Variable-length files: Rebuild the indexes using ctcmpcif.exe as follows:
ctcmpcif.exe <your application data directory>\your_file.dat 256
Note: It is acceptable to use ctcmpcif.exe to rebuild both fixed and variable-length files. The ctcmpcif.exe utility creates a new copy of the data file by copying all the active records into a new file, and then calling ctrbldif.exe to generate a new index. This step is required to ensure the deleted space management index is properly built within the variable length data file. Fixed-length files don’t have any internal indexes, therefore calling ctrlbdif.exe is sufficient.