ingstop Command—Stop an Ingres Instance

Permission required: Installation owner, privileged user.

Important! To use this command, you must be logged into the installation owner account.

The ingstop command shuts down an Ingres installation. It stops the servers in an orderly fashion for reconfiguration or system shutdown. It automatically brings down all or selected server-related processes in the installation. It can shut down servers, the archiver and recovery processes, and deallocate shared memory.

The ingstop command provides a graceful shutdown: the program waits for all traffic to terminate and for all users to exit from Ingres before shutting down the Ingres processes. You can optionally specify a forced shutdown.

Because it is important that processes be brought down in the correct sequence, you should use ingstop whenever you shut down the entire installation. You can also use ingstop to shut down the locking and logging system. For information about shutting down an Ingres installation that includes an ICE Server, see the "Managing and Monitoring the Web Deployment Option" chapter in the Web Deployment Option User Guide.

Note: On VMS, the ingstop command has no flags or parameters.

The ingstop command has the following format:

ingstop [-iigcn|-dmfrcp|-dmfacp|-client|-rmcmd|-icesvr|
[-iidbms|-iigcc|-iigcb|-iigcd|-iijdbc|-iistar|-oracle|-informix|
-mssql|-sybase|-db2udb|-rdb|-rms [= connect_id]]]
[-f] [-timeout=minutes] [-kill] [-show |-check] [-force|-immediate]
[-cluster] [-node nodename] [-help]

• -iigcn

  Stops the Name Server.

• -dmfrcp

  Stops the recovery process.

• -dmfacp

  Stops the archiver process.

• -client

  Stops a client service by stopping only a Name Server and Communications Server. Valid on Windows only.

• -rmcmd

  Stops the Remote Command Server required by Visual DBA.

• -icesvr

  Stops the ICE Server.

• -iidbms

  Stops the DBMS Server. You can optionally specific a config_name as the name of the server.

• -iigcc

  Stops the Communications Server. You can optionally specify a config_name as the name of the server.

• -iigcb

  Stops the Bridge Server. You can optionally specify a config_name as the name of the server.

• -iigcd

  Stops the Data Access Server. You can optionally specify a config_name as the name of the server.

• -iistar

  Stops the Star Server. You can optionally specify a config_name as the name of the server.

• -informix

  Stops Enterprise Access for Informix. Valid on UNIX and Windows only.

• -mssql

  Stops Enterprise Access for MS SQL Server. Valid on Windows only.

• -oracle

  Stops Enterprise Access for Oracle.

• -rdb

  Stops Enterprise Access for RDB. Valid on VMS only.

• -rms

  Stops Ingres RMS Access. Valid on VMS only.

• -sybase

  Stops Enterprise Access for Sybase. Valid on UNIX and Windows only.

• -db2udb

  Stops Enterprise Access for IBM DB2 UDB. Valid on UNIX and Windows only.

• connect_id

  Specifies the connect ID of the server to be stopped. To see a list of DBMS server connect IDs, use the iinamu command.

• -f

  Forces immediate shutdown.

• -timeout=minutes

  Waits the specified number of minutes for active sessions to terminate before shutting down the installation.

• -kill

  Shuts down the installation without waiting for currently executing transactions to complete. Transaction recovery will be required when the installation is restarted. Any Ingres processes that cannot be shut down by conventional means are terminated.

• -force

  Forces the shut down of active servers in the installation without waiting for users to disconnect.

• -immediate

  Shuts down the installation immediately. It does not wait for currently executing transactions to complete. Transaction recovery will be required when the installation is restarted.

• -show | -check

  Displays a list of currently running Ingres processes, but does not shut them down.

• -cluster

  Shuts down Ingres on all nodes in the cluster. Valid in a cluster installation only.

• -node nodename

  Shuts down Ingres on the specified node. Valid in a cluster installation only.

• -help

  Displays command syntax online.