NetBackup for Informix

Licensing for Informix is specific to the Informix-On-Bar policy type. This type of licensing collects the total number of Front-End Terabytes (FETBs) protected by NetBackup.

The following Informix query is used to gather file size information of all the databases in all the DB spaces:

DATABASE sysmaster;
SELECT
         SUM(i.ti_npused * i.ti_pagesize) USED_SIZE
FROM     systabnames n, systabinfo i, sysdatabases d
WHERE    n.partnum = i.ti_partnum
AND      n.dbsname = d.name;
CLOSE DATABASE;