This document describes how to measure the number of terabytes of user data in each database that you analyze with InfoSphere Warehouse.
If your entitlement to InfoSphere Warehouse is based on terabyte pricing, then the cost of your entitlement is determined by the sum of the number of terabytes (TB) of user data in each database that you analyze. The size of each database is rounded up to the next terabyte. A terabyte is 2 to the 40th power bytes and is the unit of measure by which the product is licensed.
IBM provides an SQL script that measures the number of terabytes that are allocated to your data. Your IBM representative will ask you to run the script at certain times, such as after you create a prototype, put an application into production, or expand your user data.
Running the script
The tbpsize_entitlement_req.sql script is located in <install_location>\Scripts, where <install_location> is the directory in which you installed the server component. Run the script against each database that you use for InfoSphere Warehouse applications and send the output to your IBM representative.
How the script measures the size of user data
The SQL script queries the administrative view ADMINTABINFO to add up the sizes of the user data stored in all the user tables of the currently connected database. The cost of your entitlement is determined by the output of this script.
The sizes of user data are determined by adding the logical sizes of data objects, long objects, LOB objects and XML objects. This includes the sizes of metadata stored inside user tables, such compression dictionaries, data record headers, and free space control records.
The following types of table objects are included in the output of the script:
- user-created temporary tables
- hierarchy tables
- detached tables
- materialized query tables
- typed tables
- untyped tables
The following objects are not included in the output of the script:
- system-created temporary files
- system/catalog tables
- index objects
- database log files
- table aliases
- If you have one database that contains 1.75 TB of data, then you must acquire a 2 TB entitlement.
- If you have one database that contains 1.4 TB and another with 3.2 TB, then you must acquire a 6TB entitlement. Each database is rounded up to the next highest terabyte, and the two terabyte numbers are added to determine the total cost of entitlement.