Ingres Vectorwise 3.0管理

启动关闭命令：

1、/etc/init.d/ingresV3 start / stop

2、ingstart / ingstop

[root@node1 vectorwise-3.0.0-334-NPTL-eval-linux-rpm-x86_64]# /etc/init.d/ingresV3 start

Starting Vectorwise, instance V3:                                                            [  OK  ]

[root@node1 vectorwise-3.0.0-334-NPTL-eval-linux-rpm-x86_64]# 

[root@node1 vectorwise-3.0.0-334-NPTL-eval-linux-rpm-x86_64]# 

[root@node1 vectorwise-3.0.0-334-NPTL-eval-linux-rpm-x86_64]# 

[root@node1 vectorwise-3.0.0-334-NPTL-eval-linux-rpm-x86_64]# 

[root@node1 vectorwise-3.0.0-334-NPTL-eval-linux-rpm-x86_64]# 

[root@node1 vectorwise-3.0.0-334-NPTL-eval-linux-rpm-x86_64]# 

[root@node1 vectorwise-3.0.0-334-NPTL-eval-linux-rpm-x86_64]# 

[root@node1 vectorwise-3.0.0-334-NPTL-eval-linux-rpm-x86_64]# 

[root@node1 vectorwise-3.0.0-334-NPTL-eval-linux-rpm-x86_64]# ps -ef|grep ingres         

ingres   31969     1  0 11:52 ?        00:00:05 /opt/vectorwise30/ingres/bin/mgmtsvr V3 mgmtsvr

root     32817 20179  0 12:25 pts/3    00:00:00 su - ingres

ingres   32819 32817  0 12:25 pts/3    00:00:00 -bash

ingres   40472     1  0 22:30 ?        00:00:00 /opt/vectorwise30/ingres/bin/iigcn V3 gcn

ingres   40642     1  1 22:30 ?        00:00:05 /opt/vectorwise30/ingres/bin/iidbms recovery (dmfrcp) V3

ingres   40671     1  0 22:31 ?        00:00:00 /opt/vectorwise30/ingres/bin/dmfacp V3

ingres   40686     1  1 22:31 ?        00:00:03 /opt/vectorwise30/ingres/bin/iidbms dbms (default) V3

ingres   40728     1  0 22:32 ?        00:00:00 /opt/vectorwise30/ingres/bin/iigcc V3 gcc

ingres   40747     1  0 22:32 ?        00:00:00 /opt/vectorwise30/ingres/bin/iigcd V3 gcd

ingres   40763     1  0 22:32 ?        00:00:00 /opt/vectorwise30/ingres/bin/rmcmd V3 rmcmd

ingres   40807     1  1 22:33 ?        00:00:01 /opt/vectorwise30/ingres/bin/mgmtsvr V3 mgmtsvr

root     40937  1793  0 22:35 pts/1    00:00:00 grep ingres

[root@node1 vectorwise-3.0.0-334-NPTL-eval-linux-rpm-x86_64]# su - ingres

[ingres@node1 ~]$ ingstart

Vectorwise is already running.  Use ingstop to shut down Vectorwise.

[ingres@node1 ~]$ ingstop

Vectorwise/ingstop

Executing ingstop against localhost.

Checking for active Vectorwise processes in installation V3 ...

 --------------------------------------------------------------------------

|                               *** WARNING ***                            |

|  Vectorwise installation V3 on localhost was started as a service and    |

|  may still appear as "running" at the OS level after being shut down by  |

|  this process. To shut down the V3 installation service, run:            |

|                                                                          |

|      /etc/init.d/ingresV3 stop                                           |

|                                                                          |

|  as root.                                                                |

 --------------------------------------------------------------------------

The name server (iigcn) is running.

The recovery server (dmfrcp) is running.

There is one DBMS server (iidbms) running.

There are no Vectorwise servers (iix100) running.

There is one Net server (iigcc) running.

There is one Data Access server (iigcd) running.

The remote command process (rmcmd) is running.

The archiver process (dmfacp) is running.

Shutting down the remote command server...

Shutting down Net server 46609 ...

Shutting down Data Access Server 50498 ...

Shutting down DBMS server 44940 ...

Shutting down the recovery and archiver processes ...

The recovery and archiver processes have exited.

Cleaning up shared memory and semaphores...

Shutting down the name server...

[ingres@node1 ~]$ 

[ingres@node1 ~]$ ingstart

Vectorwise/ingstart

Checking host "localhost" for system resources required to run Vectorwise...

Your system has sufficient resources to run Vectorwise.

Starting your Vectorwise installation...

Starting the Name Server...

Allocating shared memory for Logging and Locking Systems...

Starting the Recovery Server...

II_DBMS_SERVER = 44664

Starting the Archiver Process...

Starting DBMS Server (default)...

II_DBMS_SERVER = 33835

Starting Net Server (default)...

GCC Server = 53551

    TCP_IP port = V3 (28056)

Starting Data Access Server (default)...

DAS Server = 47871

    TCP_IP port = V37 (28063)

Starting the Visual DBA Remote Command Server...

Starting Remote Manager Server... 

Vectorwise installation successfully started.

[ingres@node1 ~]$ ps -ef|grep ingres

ingres   31969     1  0 11:52 ?        00:00:05 /opt/vectorwise30/ingres/bin/mgmtsvr V3 mgmtsvr

root     32817 20179  0 12:25 pts/3    00:00:00 su - ingres

ingres   32819 32817  0 12:25 pts/3    00:00:00 -bash

ingres   40807     1  0 22:33 ?        00:00:01 /opt/vectorwise30/ingres/bin/mgmtsvr V3 mgmtsvr

root     40938  1793  0 22:35 pts/1    00:00:00 su - ingres

ingres   40940 40938  0 22:35 pts/1    00:00:00 -bash

ingres   41850     1  0 22:36 pts/1    00:00:00 /opt/vectorwise30/ingres/bin/iigcn V3 gcn

ingres   42020     1  0 22:36 pts/1    00:00:00 /opt/vectorwise30/ingres/bin/iidbms recovery (dmfrcp) V3

ingres   42040     1  0 22:36 pts/1    00:00:00 /opt/vectorwise30/ingres/bin/dmfacp V3

ingres   42056     1  2 22:36 pts/1    00:00:00 /opt/vectorwise30/ingres/bin/iidbms dbms (default) V3

ingres   42090     1  0 22:36 pts/1    00:00:00 /opt/vectorwise30/ingres/bin/iigcc V3 gcc

ingres   42109     1  0 22:36 pts/1    00:00:00 /opt/vectorwise30/ingres/bin/iigcd V3 gcd

ingres   42125     1  1 22:36 pts/1    00:00:00 /opt/vectorwise30/ingres/bin/rmcmd V3 rmcmd

ingres   42161 40940  0 22:36 pts/1    00:00:00 ps -ef

ingres   42162 40940  0 22:36 pts/1    00:00:00 grep ingres

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/7220098/viewspace-767313/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/7220098/viewspace-767313/