Restart max db using sql statements

[Former Member]

Hi

Can anyone explain me how to restart max db with sql statements?

Thanks in advance

Vidyadhar.

[markus_doehr2]

SQL? No possible because if the database kernel is not running there is nothing available to process the SQL statement.

You can do

dbmcli -u <dbmuser>,<dbmpassword> -d <SID> db_online

to start the database.

Markus

[Former Member]

Hi Markus

Thanks for the reply...

I tried

dbmcli -u <dbmuser>,<dbmpassword> -d <SID> db_restart

and I think its working.

Regards

Vidyadhar