List of Contributions

Benoit Chamberland

Contact Details

My Content

1 to 6 of 6 total
Posted By Benoit Chamberland Tue June 06, 2023 08:30 AM
Found In Egroup: Informix
\ view thread
Hello, Since CSM is deprecated, we're on our way to implement TLS 1.2 According to IBM support, there is no method to select which TLS 1.2 (or 1.3) ciphers Informix is allowed to use. Our servers are monitored by Tenable and only these TLS 1.2 ciphers are considered safe. Others will generate ...
Posted By Benoit Chamberland Tue November 16, 2021 08:31 AM
Found In Egroup: Informix
\ view thread
This is exactly it. Thanks Mike Benoît Benoît Chamberland Administrateur de bases de données | Database Administrator T : 514-870-2440 M : 514-207-7015
Posted By Benoit Chamberland Tue November 16, 2021 07:58 AM
Found In Egroup: Informix
\ view thread
Thanks Marc. I would be great if IBM included the 14.10 updates on https://www.ibm.com/support/pages/recommended-fixes-informix-server-products Unless there is another page? Benoît Chamberland ------------------------------ Benoit Chamberland ------------------------------
Posted By Benoit Chamberland Fri June 04, 2021 09:08 AM
Found In Egroup: Informix
\ view thread
Thanks Tom, This is what I thought. In our case rebuilding the indexes every time we're doing our weekly automatic fragment rotation on a, lets say, 320G of data table is out of question. It would be great though if this functionality was available, especially where we need compression ...
Posted By Benoit Chamberland Thu June 03, 2021 11:20 AM
Found In Egroup: Informix
\ view thread
Thanks Art and Jean-François! I observe a reduction of 30-40% in the number of data pages after activating the compression. Often, the indexes are taking as much space than the data but by fragmenting the table, these btree indices being attached are not compressible. Are there any strategies ...
Posted By Benoit Chamberland Wed June 02, 2021 04:11 PM
Found In Egroup: Informix
\ view thread
Hi everyone, we're using Informix 14.10.FC5. I need to fragment a table in let's say one 30G dbspace a week (7 millions records/ week) for easier data rotation (detach full fragment, attach empty fragment strategy). Btree indexes are of course attached. In order so save some space, I was asked if ...