Starting Up and Shutting Down Altibase

Starting Up and Shutting Down Altibase

iSQL can be used to start up and shut down Altibase.

Starting Up Altibase

To start up Altibase, iSQL must first be launched with the -sysdba option, in the same way as when a database is created.

Altibase startup commands can be executed only with the UNIX account with which Altibase (including iSQL) was installed.

The following is an example of the use of iSQL to start up Altibase. For more information on starting up Altibase, please refer to the Altibase Administrators' Manual Chapter 4: Startup and Shutdown.

$ isql -s 127.0.0.1 -u sys -p manager -sysdba
-------------------------------------------------------
     Altibase Client Query utility.
     Release Version 7.1.0.1
     Copyright 2000, Altibase Corporation or its subsidiaries.
     All Rights Reserved.
-------------------------------------------------------
ISQL_CONNECTION = TCP, SERVER = 127.0.0.1, PORT_NO = 20300
[Connected to idle instance]
iSQL(sysdba)> startup service
Connecting to the DB server... Connected.

TRANSITION TO PHASE : PROCESS

TRANSITION TO PHASE : CONTROL

TRANSITION TO PHASE : META
  [SM] Recovery Phase - 1 : Preparing Database
                            : Dynamic Memory Version => Parallel Loading
  [SM] Recovery Phase - 2 : Loading Database
  [SM] Recovery Phase - 3 : Skipping Recovery & Starting Threads...
                              Refining Disk Table
  [SM] Refine Memory Table : ........................................................ [SUCCESS]
  [SM] Rebuilding Indices [Total Count:100] .................................. [SUCCESS]
TRANSITION TO PHASE : SERVICE
  [CM] Listener started : TCP on port 20300
  [CM] Listener started : UNIX
  [RP] Initialization : [PASS]
--- STARTUP Process SUCCESS ---
Command execute success.

Shutting Down Altibase

Use the SHUTDOWN command to shut down a running Altibase server.

The following is an example of the use of iSQL to shut down Altibase. For more information on shutting down Altibase, please refer to the Altibase Administrators' Manual Chapter 4: Startup and Shutdown.

iSQL(sysdba)> shutdown normal
Ok..Shutdown Proceeding....


TRANSITION TO PHASE : Shutdown Altibase
  [RP] Finalization : PASS
shutdown normal success.