How to start DataBase from commandline using plink.exe

Hi Ajit, You can script many of the admintools options. Check the documentation to see the list of those options, https://my.vertica.com/docs/6.1.x/HTML/index.htm#3824.htm One of the options is to restart_db. Hope this helps, Eugenia

Thanks Eugenia Moreno for your reply I am using the following command through plink.exe -ssh -l root -i "C:\xyz.ppk" "/opt/vertica/bin/admintools -t start_db -d DB -p 'password'" But it is showing root user has no permission to do this . As I have a super user dbadmin to do the above opertaion. How can I pass 'su dbadmin' command through plink.