How to upgrade the license_key in Vertica database

Using the admintools command line we can create all types of routines and scripts.

  • How to upgrade the license_key policy of our Vertica database using the admintools command line:
For this task you need to use the upgrade_license_key
[dbadmin@bih001 ~]$ admintools -t upgrade_license_key -d test  -l /home/dbadmin/00.dat
Error: License key /home/dbadmin/00.dat not installed. Details follow.
        Vertica license is expired
Where the -d option is followed by the database name, -l is the full path to the new vertica license. In my example the command finished with an error because the license i have used is expired.