InfoSphere Optim

 View Only
Expand all | Collapse all

Optim Licensing

  • 1.  Optim Licensing

    Posted Tue February 11, 2020 01:55 PM

    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

    IBM Champion
    Posted Tue February 11, 2020 07:16 PM
    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 Wed February 12, 2020 10:31 AM
    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 Wed February 12, 2020 11:04 AM
    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 Wed February 12, 2020 02:56 PM
    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 Fri February 14, 2020 07:11 AM
    Edited by System Fri January 20, 2023 04:38 PM
      |   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)
       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,
          (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 +
       ) / 1024 / 1024 as TOTAL_GB
       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
       t.tabschema in ('BNK1', 'BNK2');


    Erwin Hattingh
    Systems Engineer / Db2 DBA
    Triodos Bank


  • 7.  RE: Optim Licensing

    Posted Tue February 18, 2020 11:30 AM
    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

  • 8.  RE: Optim Licensing

    Posted Mon February 14, 2022 08:48 AM
    Hi Erwin,

    Did you ever get feedback on this from IBM? I can't find anything to determine the terabytes in use for licensing...really frustrating!


    Keith Manning

  • 9.  RE: Optim Licensing

    Posted Wed July 20, 2022 02:29 AM
    How or where to get the license cost and cost for a TB of data archive using IBM Optim ?
    Does the pricing vary by onprem or on cloud ?
    Can someone pls share


  • 10.  RE: Optim Licensing

    IBM Champion
    Posted Wed July 20, 2022 08:33 AM

    The short answers are:
    1.  Optim is generally licensed by the terabyte count of the non-system areas of the database.  This means, all data tables in a source are counted using the uncompressed byte count.  Optim doesn't provide this calculation as it's different for each database type.
    2.  There is no difference whether the data is on -prem or in the cloud.

    Your best bet is to get in contact with the sales team for your account.  If you'd like, the ABMartin sales manager, Dave Welch -, can help you.


    Jimmy Wilson

    1999 S. Bascom Ste 700

    Campbell, CA 95008

    Phone +1(972) 567-5558


    Unstructured Data Masking

    Data Privacy/Test data Management - fabrication, optimization, obfuscation