storage optimization feature
SangGyu Jeong asked which features count as Storage Optimization after ILMT flagged it at a customer on 12.10.FC12W1. Art Kagel said before 14.10 Enterprise Edition included all of it except compression, and since 14.10 everything is included. Eric Rowell said ILMT reads tag files and syslicenseinfo shows actual use. Gaurav Kumar suggested an ILMT support case about false reporting.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
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
SangGyu: Prior to v14.10 Storage Optimization in EE included all features except for table and index compression which were extra cost. Since v14.10, all Storage Optimization features are included in Enterprise Edition. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.
Thanks for the answer. Art. ------------------------------ SangGyu Jeong Software Engineer Infrasoft Seoul Korea, Republic of ------------------------------
The ILMT system found the swtag and fxtag files in the "$INFORMIXDIR/properties/version" for the option which is installed as part of the EE package. If audited you have ILMT for when the software was installed and syslicenseinfo to prove if you used it. As Art stated this feature was split years back and thankfully is put back into the enterprise license. Check your contract to see if your licensing may have included it. In multiple cases, renewals from versions before 11 have "grandfathered" clauses put in the contract but no line item in the invoice. This method is easier for the sales reps, but may not help you at audit time. Hope this helps, ------------------------------ ~~~~~~~~~ Eric Rowell ------------------------------
Hello Eric, Thank you for good information. If the customer has not purchased a storage optimization license, should the swtag file be manually deleted after installing Informix? ------------------------------ SangGyu Jeong Software Engineer Infrasoft Seoul Korea, Republic of ------------------------------
Hi SangGyu, May i know your ids version? It seems that this may be a known issue with ILMT and Informix that some people are working around by excluding the instance in ILMT Web UI with a comment, however I cannot make a recommendation on this. Since it seems as though it's a problem with ILMT, you will need to open a PMR with their support and get the final word from their team on how to best handle the false reporting. ------------------------------ Gaurav Kumar ------------------------------
Thanks for the reply, Gaurav, The version of Informix using is 12.10.FC12W1. Today I opened a case because a client asked for an official IBM answer. ------------------------------ SangGyu Jeong Software Engineer Infrasoft Seoul Korea, Republic of ------------------------------
Hi I am saying to open a case with ILMT support and get the final word from their team on how to best handle the false reporting. Regards, Gaurav ------------------------------ Gaurav Kumar ------------------------------