Ingres R3 Win Shutdown via command line

Howto ?
Using an Ingres R3 installation on an Windows 2003 Server. Need a
command for shutting down the database, before server shuts down in
case of power loss (ups).

Couldn't find those command in documentation or this group, sorry for
newby-question and happy new year. Thanks a lot !

Assuming that the DBMS is started as a service, this command should
shut it down for you:

ingstop -service

although if you have user sessions connected, you will need to get them
disconnected first...

John Dennis

denjo02-at-hotmail.com wrote:
> Assuming that the DBMS is started as a service, this command should
> shut it down for you:
>
> ingstop -service

That'll work, but it'll confuse the windows service manager, which
maintains its own state information. You can instead so

net stop Ingres_Database_II

(replacing II with your installation code), which will in turn call
ingstop for you.

Emiliano Heyns

Emiliano wrote:
> denjo02-at-hotmail.com wrote:
> > Assuming that the DBMS is started as a service, this command should
> > shut it down for you:
> >
> > ingstop -service
>
> That'll work, but it'll confuse the windows service manager, which
> maintains its own state information. You can instead so
>
> net stop Ingres_Database_II

The "-service" parameter will start or stop the Windows service, as
well as Ingres. Works very well - you can start the service from
Windows or with the "net start ..." command, and stop it from the
command line with the "-service" parameter, or vice-versa. Seems to
work a treat...

Note also that on my machine the service is named "Ingres Intelligent
Database [II]" with spaces, not underscores, but the name is easily
checked from the Windows Services screen.

John Dennis

denjo02-at-hotmail.com wrote:

> The "-service" parameter will start or stop the Windows service, as
> well as Ingres. Works very well - you can start the service from
> Windows or with the "net start ..." command, and stop it from the
> command line with the "-service" parameter, or vice-versa. Seems to
> work a treat...

I did not know that. Odd that it doesn't do that by default.

> Note also that on my machine the service is named "Ingres Intelligent
> Database [II]" with spaces, not underscores, but the name is easily
> checked from the Windows Services screen.

"Ingres Intelligent Database [II]" is the "friendly" name of the
service. If you right-click the service in the service manager and call
up its properties, you'll see the name that you can use for net stop/net
start. In the case of "Ingres Intelligent Database [II]", that would be
Ingres_Database_II.

Emiliano Heyns

Emiliano wrote:

> "Ingres Intelligent Database [II]" is the "friendly" name of the
> service. If you right-click the service in the service manager and call
> up its properties, you'll see the name that you can use for net stop/net
> start. In the case of "Ingres Intelligent Database [II]", that would be
> Ingres_Database_II.

.... and I didn't know that. I've always used what you call the
"friendly" name of the service.

John Dennis