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
------------------------------
Original Message:
Sent: Wed February 12, 2020 02:55 PM
From: Keith Tidball
Subject: Optim Licensing
I can second Danny's point about PVUs being counted regardless of environment; it is definitely not Production alone.
------------------------------
Keith Tidball
Progressive Insurance
Original Message:
Sent: Wed February 12, 2020 11:04 AM
From: Danny Lankford
Subject: Optim Licensing
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
Original Message:
Sent: Wed February 12, 2020 10:31 AM
From: Optim Learner
Subject: Optim Licensing
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
Original Message:
Sent: Tue February 11, 2020 07:16 PM
From: Vishwas Balakrishna
Subject: Optim Licensing
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
Original Message------
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
------------------------------
#InfoSphereOptim
#Optim