Skip to main content

Partitioning the Remaining Database Tables (Data Warehouse Tables)

Flexera provides two database-specific scripts that partition the database tables for the FlexNet Manager for Engineering Applications Reporting server. You can run the partitioning script regardless of whether you chose to partition the usage-related tables during installation/upgrade.

  • If you chose to create table partitions for the Reporting server database at installation or upgrade time, you must run the database-specific partitioning script provided by Flexera to partition the data warehouse tables. The FlexNet Manager for Engineering Applications server will not start if some tables are partitioned, while other tables are not.
  • If you did not choose to create table partitions at installation or upgrade time, you can partition the database tables at any time by running the script. Running the partitioning script will partition both the usage-related tables and the data warehouse tables.

The partitioning script may take 12–18 hours to process up to one billion usage events in the database. A multi-CPU database server may show CPU usage between 30 and 40 percent. It is recommended that you increase the database space by 100 percent before running the partition-creation script.

Follow the instructions in the section that applies to the database type your enterprise uses. See the subsection, Partitioned Tables, for a list of the database tables that are partitioned as a result of running the partition-creation script.