Hvrcatalogupgrade
Name
hvrcatalogupgrade - Upgrade the catalog tables in hub database.
Synopsis
hvrcatalogupgrade [options] hubdb
Description
Command hvrcatalogupgrade allows you to upgrade the existing catalog tables in hub database to the new version after an HVR upgrade. If this command is run without option -s, all catalog tables except hvr_stats will be upgraded to the new version.
The argument hubdb specifies the connection to the hub database. For more information about supported hub databases and the syntax for using this argument, see Calling HVR on the Command Line.
- It is recommended to backup (using hvrcatalogexport) the catalog tables before upgrading to new version.
- This command does not have any impact on the catalog tables if they are already upgraded to the new version.
Options
This section lists and describes all options available for hvrcatalogupgrade.
Parameter | Description |
---|---|
-hclass | Location class of the hub database. Valid values for class are db2, db2i, ingres, mysql, oracle, postgresql, sqlserver, or teradata. For more information, see Calling HVR on the Command Line. |
-s | Statistics (hvr_stats) table upgrade. This option will force the hvr_stats table to be upgraded. |
-uuser[/pwd] | Connect to hub database using DBMS account user. For some databases (e.g. SQL Server) a password must also be supplied. |