
Table 9-3. Data Purging Scripts
Script Description
purgeCostData
This script removes the cost-related data that is older than the specified number of months. The
number of months is specified using the MONTHS_IN_HISTORY parameter in the Oracle script
and the @MONTHS_IN_HISTORY parameter in the SQL Server script. You can set this parameter
appropriately before running the script. The script removes the data from the following tables:
n
CB_BASE_RATE
n
CB_BILLING_POLICY
n
CB_ENTITY_METERING
n
CB_RATE_FACTOR
n
CB_FIXED_COST
purgeHierarchyData
This script removes the hierarchy-related data that is older than the specified number of months.
The number of months is specified using the MONTHS_IN_HISTORY parameter in the Oracle script
and the @MONTHS_IN_HISTORY parameter in the SQL Server script. You can set this parameter
appropriately before running the script. The script removes the data from the following tables:
n
CB_VC_ENTITY_RELATION
n
CB_VC_ENTITY_PROPERTY
n
CB_VC_ENTITY_MAPPING
n
CB_HIERARCHY_RELATION
purgeReportData
This script removes the report-related data that is older than the specified number of months
from the CB_REPORT table. The number of months is specified using the MONTHS_IN_HISTORY
parameter in the Oracle script and the @MONTHS_IN_HISTORY parameter in the SQL Server script.
You can set this parameter appropriately before running the script.
purgeStatsData
This script removes the vCenter Server performance statistics data that is older than the specified
number of months from the CB_VC_PERFORMANCE_STAT table. The number of months is
specified using the MONTHS_IN_HISTORY parameter in the Oracle script and the
@MONTHS_IN_HISTORY parameter in the SQL Server script. You can set this parameter
appropriately before running the script.
purgeTables
This script is a superset of the purgeCostData, purgeHierarchyData, purgeReportData, and
purgeStatsData scripts. The script removes the cost, hierarchy, report, and vCenter Server
performance statistics related data that is older than the specified number of months. The
number of months is specified using the MONTHS_IN_HISTORY parameter in the Oracle script
and the @MONTHS_IN_HISTORY parameter in the SQL Server script. You can set this parameter
appropriately before running the script.
About the Statistics Data Purging Stored Procedure
vCenter Chargeback schedules a daily roll up of vCenter Server performance statistics data in the vCenter
Chargeback database. The CB_STATS_ROLLUP_PROC stored procedure in the vCenter Chargeback database purges
the vCenter Server performance statistics data that is no longer required. The stored procedure purges data in
the database in batches of 50,000 rows.
You can also manually run this stored procedure. This procedure must be called multiple times till it returns
the value '1', indicating that the roll up is complete.
vCenter Chargeback User’s Guide
132 VMware, Inc.
Commentaires sur ces manuels