|
|
当前的instance:
//windowsC:\Documents and Settings\Mark>set DB2instanceDB2INSTANCE=DB2C:\Documents and Settings\Mark>echo %DB2INSTANCE%DB2//linux[db2inst1@server1 ~]$ db2 get instance The current database manager instance is: db2inst1[db2inst1@server1 ~]$ echo $DB2INSTANCEdb2inst1
启动:
[db2inst1@server1 ~]$ db2startSQL1063N DB2START processing was successful.
停止:
[db2inst1@server1 ~]$ db2stopSQL1064N DB2STOP processing was successful.
查看状态:
//停止的[db2inst1@server1 ~]$ db2_psNode 0 UID PID PPID C STIME TTY TIME CMD//启动的[db2inst1@server1 ~]$ db2_psNode 0 UID PID PPID C STIME TTY TIME CMDdb2inst1 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 DB2AUTOSTARTDB2AUTOSTART=YES |
|