Search the VMware Knowledge Base (KB)
View by Article ID

Scripts called from DB_and_schema_creation_scripts_dbType.sql are missing in vSphere 5.1 (2039860)

  • 6 Ratings


In vCenter Server 5.1, some of the scripts called by DB_and_schema_creation_scripts_dbType.sql are not available.


In vSphere 5.1, the following script is no longer used or required and therefore is not available in the software distributions (both .zip and ISO versions): purge_stat1_proc_dbType.sql
Note: In vSphere 5.0 and earlier releases, this script was required to prepare the vCenter Server database for installation
However, this script is still listed in the released versions of the DB_and_schema_creation_scripts_ dbType.sql file and in the product documentation. This script should be omitted when performing the outlined steps.

Also, vSphere 5.1 includes these additional scripts:
  • l_stats_rollup3_proc_ dbType.sql
  • l_purge_stat2_proc_ dbType.sql
  • l_purge_stat3_proc_ dbType.sql
  • l_stats_rollup1_proc_ dbType.sql
  • l_stats_rollup2_proc_ dbType.sql
Be sure to run these scripts after completing the process_license_snapshot_dbType.sql script script.
Note: Replace dbType with the type of the database being used, such as mssql, oracle, or db2.

See Also

Request a Product Feature

To request a new product feature or to provide feedback on a VMware product, please visit the Request a Product Feature page.


  • 6 Ratings

Did this article help you?
This article resolved my issue.
This article did not resolve my issue.
This article helped but additional information was required to resolve my issue.

What can we do to improve this information? (4000 or fewer characters)

Please enter the Captcha code before clicking Submit.
  • 6 Ratings