关于instance启动停止-CSDN博客

本文链接：https://blog.csdn.net/guoyanxi/article/details/83761376

当前的instance：


//windows
C:\Documents and Settings\Mark>set DB2instance
DB2INSTANCE=DB2

C:\Documents and Settings\Mark>echo %DB2INSTANCE%
DB2

//linux
[db2inst1@server1 ~]$ db2 get instance

 The current database manager instance is:  db2inst1

[db2inst1@server1 ~]$ echo $DB2INSTANCE
db2inst1

启动：


[db2inst1@server1 ~]$ db2start
SQL1063N  DB2START processing was successful.

停止：


[db2inst1@server1 ~]$ db2stop
SQL1064N  DB2STOP processing was successful.

查看状态：


//停止的
[db2inst1@server1 ~]$ db2_ps
Node 0
     UID        PID       PPID    C     STIME     TTY     TIME CMD

//启动的
[db2inst1@server1 ~]$ db2_ps
Node 0
     UID        PID       PPID    C     STIME     TTY     TIME CMD
db2inst1      21263      21261   11     14:31   pts/1 00:00:00 db2sysc
    root      21264      21263    0     14:31   pts/1 00:00:00 db2ckpwd
    root      21265      21263    0     14:31   pts/1 00:00:00 db2ckpwd
    root      21266      21263    0     14:31   pts/1 00:00:00 db2ckpwd

开机自动：


[db2inst1@server1 ~]$ db2iauto ?
DB2I1024I Usage: /home/db2inst1/sqllib/bin/db2iauto [-h|-?] -on|-off InstName

是否设置了开机启动：


//以下为自动启动
[db2inst1@server1 ~]$ db2set -i|grep DB2AUTOSTART
DB2AUTOSTART=YES