About data_property_flat table

Products

• VMware Smart Assurance

Issue/Introduction

What is data_property_flat table in the APG database and how is it used?

Environment

Watch4net/M&R - 7.x

Resolution

• What is data_property_flat table used for in the Watch4net APG database? Is it safe to delete (drop) the data_property_flat table?
  • The data_property_flat table is an optimized view of the data_property table. The data_property_flat table is used for improving the performance when generating the reports. Dropping this table will not impact the information collected in the data_property table.

 

• How often is the data_property_flat table recreated?
  • The recreate-data-property-flat-Default task is responsible for recreating the data_property_flat table. By default, the table is recreated every 6 hours. The interval for recreating the data_property_flat table is configurable in the recreate-data-property-flat-Default task configuration file found here:
     

    data/task_repository/mysql-maintenance-tool/Default/recreate-data-property-flat.task

• How do I manually recreate data_property_flat table?
  • This recreate-data-property-flat-Default task is configured to run the recreate-data-property.sh script located in /APG_HOME/bin. To manually recreate this table, all you need to do is run this script.

NOTE: data_property_flat table is deprecated in recent versions of M&R and recreate_data_property scheduled task is disabled by default.

Additional Information

Commands:

To delete/drop the table from mySQL database:

mysql> drop table data_property_flat;

 

To delete only the contents of this table from mySQL database:

mysql> truncate data_property_flat;