Source sizing implementation for datasets

The Source Sizing feature aligns the data source experience with Delphix database standards that will improve your ingestion reporting experience on the per TB pricing model. This feature enables you to calculate the dataset size based on the total allocated space on the mount point provided by the Delphix Engine for the dataset.

Procedure

• For all datasets, the size of the dataset can be calculated using du -sb <dataset> command that provides the correct volume and apparent size of the datasets.

• For AIX hosts, the size of the dataset can be calculated by executing any one of the following commands depending on whether the database is open for connections or not.

  1. select sum(TBSP_TOTAL_SIZE_KB)*1024 from sysibmadm.TBSP_UTILIZATION, if the database is open for connections and it is possible to connect to the database.

  2. db2dart <dbname> /DTSF, if the database is not open for connections and is in rollforward pending state.

• For AIX hosts, the plugin won’t be able to display the size of the database during the creation of dSource, since it needs to be restored to read the size of the database.

• If the plugin is unable to connect to the database or the database is yet to be restored, then the status tab under dSource displays Not available.