Informix

nested-group-icon.png

DB2

Expand all | Collapse all

storage optimization feature

Jump to Best Answer
  • 1.  storage optimization feature

    Posted Thu September 17, 2020 08:53 AM
    Edited by SangGyu Jeong Thu September 17, 2020 10:14 AM
    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
    ------------------------------


  • 2.  RE: storage optimization feature

    Posted Thu September 17, 2020 09:06 AM
    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


    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.








  • 3.  RE: storage optimization feature

    Posted Thu September 17, 2020 10:16 AM
    Thanks for the answer. Art.

    ------------------------------
    SangGyu Jeong
    Software Engineer
    Infrasoft
    Seoul Korea, Republic of
    ------------------------------



  • 4.  RE: storage optimization feature
    Best Answer

    Posted Fri September 18, 2020 10:06 AM
    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
    ------------------------------



  • 5.  RE: storage optimization feature

    Posted Fri September 18, 2020 10:35 AM
    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
    ------------------------------



  • 6.  RE: storage optimization feature

    Posted Wed September 23, 2020 04:56 AM
    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
    ------------------------------



  • 7.  RE: storage optimization feature

    Posted Wed September 23, 2020 05:10 AM
    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
    ------------------------------



  • 8.  RE: storage optimization feature

    Posted Wed September 23, 2020 05:16 AM
    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
    ------------------------------