Hello. I have a question about the storage optimization feature.
IBM Informix Storage Optimization Ferature for Enterprise Edition was detected as a result of an Informix license check from my customer through IBM License Metric Tool (ILMT).
It seems that the use of the storage optimization function can be checked in the sysmaster:syslicenseinfo table.
The information in the syslicenseinfo table is not documented in the knowledge center. Therefore, I referenced the value of the feature_flags column in the syslicenseinfo table in the below content of $INFORMIXDIR/etc/sysmaster.sql.
--- sysmater.sql
{ License Info }
insert into flags_text values ('syslicenseinfo',1,'HDR Primary');
insert into flags_text values ('syslicenseinfo',2,'HDR Secondary');
insert into flags_text values ('syslicenseinfo',4,'HDR RSS');
insert into flags_text values ('syslicenseinfo',8,'HDR SDS');
insert into flags_text values ('syslicenseinfo',16,'Enterprise Replication');
insert into flags_text values ('syslicenseinfo',512,'Parallel Data Query');
insert into flags_text values ('syslicenseinfo',1024,'Database Mirroring');
insert into flags_text values ('syslicenseinfo',8192,'Database Compression');
insert into flags_text values ('syslicenseinfo',16384,'Database Defragmentation');
insert into flags_text values ('syslicenseinfo',32768,'Enhanced de-duplication');
Does the storage optimization feature include all features corresponding to the above values? Or just compression?
------------------------------
SangGyu Jeong
Software Engineer
Infrasoft
Seoul Korea, Republic of
------------------------------
#Informix