Topic Thread

Expand all | Collapse all

Optim Licensing

  • 1.  Optim Licensing

    Posted 11 days ago
    ​Hello,

    I have a question related to licensing and want to know if there is any official documentation related to this.

    If I were to work in a Development (DEV) environment, unit test it in DEV, move everything to UAT env, have the customer test there and finally move it to PROD, would I need to purchase 3 licenses?

    How does licensing work in case of Optim?

    I understand that the cost depends on the amount of the data we are archiving but from a licensing stand point, do we need to purchase 3 licenses (DEV,UAT and PROD?).

    If possible, please provide a link to any official IBM documentation on this.

    Thank you

    ------------------------------
    Optim Learner
    ------------------------------


  • 2.  RE: Optim Licensing

    Posted 10 days ago
    Optim licensing is counted as the Total  uncompressed size of data in production.

    If you use Optim in Dev and Test, license is not counted. 

    Thanks and regards,
    Vishwas Balakrishna
    Estuate, Inc. Princeton, NJ





  • 3.  RE: Optim Licensing

    Posted 10 days ago
    Thank you Vishwas. I too have the same understanding that using Optim in Dev or QA should not cost but would need something to back this statement when I talk to my management.  

    Appreciate if you can share any links or similar which clearly states this.

    ------------------------------
    Optim Learner
    ------------------------------



  • 4.  RE: Optim Licensing

    Posted 10 days ago
    Thought i'd share just a wee-bit more detail on this from our experience because I wish someone would have done this for me.Our specific area of licenses usage is Datagrowth. For years I was unable to get a solid answer on this licensing situation with Optim. I know what I'm invoiced for and what we pay annually for Optim software and support but it wasn't until we were audited by PWC on behalf of IBM that I truly understood what the licensing was. If you disregard special licensing scenarios, enterprise licensing agreements then here's what you might pay for. 

    • IBM Infrosphere Optim Software and Support on an annual basis.
      • TDM, DataGrowth, Masking. Each can vary. 
    • (PVU licensing for ALL servers regardless of NON-PROD or PROD systems) 
      • We got burned on this one. PWC did not care if the systems were NON-PROD or PROD.
      • They counted all PVU's where Optim products were installed. 
      • We argued our case on this one for over a year. 
    • A "source" system volume (SIZE) license for native (TIER1/LUW) datasources. 
      • This really means HOW large was the uncompressed source that you connected to. 
    • A "source" system volumn (SIZE) license for z/OS or (TIER2/mainframe data sources)
      • This really means HOW large was the uncompressed source that you connected to. 
    • ODM Open Data manager volume size licensing. 
      • How much data did you provision access to via ODM, or Optim Connect. 
    • Various other special connector licensing like JDE, Oracle, Etc.. 


    ------------------------------
    Danny Lankford
    3M - IT Manager
    ------------------------------



  • 5.  RE: Optim Licensing

    Posted 10 days ago
    I can second Danny's point about PVUs being counted regardless of environment; it is definitely not Production alone.

    ------------------------------
    Keith Tidball
    Progressive Insurance
    ------------------------------



  • 6.  RE: Optim Licensing

    Posted 8 days ago
    Edited by Erwin Hattingh 8 days ago
      |   view attached
    I have an official "Optim Solutions Terabyte Compliance Guide.pdf" (from 2013) that we received from IBM in June 2017 around the time we purchased Optim TDM . As they then stated ". It's for DB2 z/OS, but might 'translate' nicely to LUW"
    see attachement.

    Problem in our case with Optim TDM, for Db2 LUW sources (and others like MS-SQL), was and actually still is :
    How exactly can one calculate the 'official' uncompressed size of a source database ?
    Surprisingly, IBM doesn't have a straightforward and clear SQL do do this this calculation, to be fully compliant for the (Terrabyte) license one purchased ...

    This is the SQL Calc we came up with (for Db2 LUW) our self 
    (but never received formal feedback from IBM, if it really IS the proper way for calculating the volume source data size .....) : 

    Notice, we only select the database schema(s) that actually contain 'user data' that Optim TDM will use as source.

    -- Uncompressed size of a Database (Optim TDM licensing)
    select 
       current timestamp as CURRENT_TIMESTAMP,
       sum(dp.npages * (1.0/(1.0 - (cast(dp.pctpagesaved as decimal(5,2))/100))) * ts.pagesize/1024/1024/1024) as UNCOMPRESSED_TABLE_DATA_GB, 
       sum(ti.LONG_OBJECT_P_SIZE)/1024/1024 as LONG_GB,
       sum(ti.LOB_OBJECT_P_SIZE)/1024/1024 as LOB_GB,
       sum(ti.XML_OBJECT_P_SIZE)/1024/1024 as XML_GB,
       sum(
          (dp.npages * (1.0 / (1.0 - (cast(dp.pctpagesaved as decimal(5,2))/100))) * ts.pagesize / 1024) + 
          ti.LONG_OBJECT_P_SIZE + 
          ti.LOB_OBJECT_P_SIZE +
          ti.XML_OBJECT_P_SIZE 
       ) / 1024 / 1024 as TOTAL_GB
    from 
       syscat.tables t join syscat.datapartitions dp on t.tabschema = dp.tabschema and t.tabname = dp.tabname 
       join syscat.tablespaces ts on dp.tbspaceid = ts.tbspaceid  
       join table(sysproc.admin_get_tab_info(NULL, NULL)) as ti on ti.tabschema = dp.tabschema and ti.tabname = dp.tabname and ti.data_partition_id = dp.datapartitionid
    where 
       t.tabschema in ('BNK1', 'BNK2');

    ------------------------------

    Erwin Hattingh
    Systems Engineer / Db2 DBA
    Triodos Bank
    ------------------------------

    Attachment(s)



  • 7.  RE: Optim Licensing

    Posted 4 days ago
    Thank you everyone. You have provided information more than I was expecting.

    This community is awesome and I am having a great time learning Optim​

    ------------------------------
    Optim Learner
    ------------------------------