DB2 per terabyte licensing

[frit...@gmail.com]

I've got the db2 per terabyte licensing on Infosphere Warehouse v10.1 and I'm trying to figure out how to determine how much of my license I'm consuming. I know that indexes don't count towards my utilization for licensing purposes, so it's not so straightforward as the total amount of disk space used.

There must be some utility that will give me this information, but I've searched all over and I can't find anything. Can anyone help?

Thanks,
Greig Wise

[Ian]

On Monday, April 15, 2013 2:55:06 PM UTC-7, frit...@gmail.com wrote:
> I've got the db2 per terabyte licensing on Infosphere Warehouse v10.1 and I'm trying to figure out how to determine how much of my license I'm consuming. I know that indexes don't count towards my utilization for licensing purposes, so it's not so straightforward as the total amount of disk space used.
>
>
>
> There must be some utility that will give me this information, but I've searched all over and I can't find anything. Can anyone help?
>

IBM provides a script called tbpsize_entitlement_req.sql that you can run against your database to provide the usage metrics. (This is the script they ask you to run when validating license compliance). This file is not installed on the database server, but instead is on the ISW application server.

[TheBoss]

Ian <ian.bj...@gmail.com> wrote in
news:76956529-c60e-4ef1...@googlegroups.com:

In addition to that, more info can be found at following links:

< http://www-01.ibm.com/support/docview.wss?uid=swg21496236 >
< http://lawrenceweber.wordpress.com/2011/05/14/ >

HTH

--
Jeroen