請(qǐng)教：用哪個(gè)DB2命令查看DB2 instance是啟動(dòng)還是停止的？

shirley

我知道可以用db2_ps命令列出DB2 的進(jìn)程，但是有沒(méi)有其他的命令能夠直接給出"DB2 is started/alive" or "DB2 is down"這類信息的？

謝謝了！

wangzhonnewnew

easiest: db2pd -inst

when instance is down:
(taoewang@p6db2serv) /wsdb/db2_v91fp5/aix64nocc/s080406 $ db2pd -inst
Unable to attach to database manager.  Please ensure db2start has been run.

when instance is up:
Instance taoewang uses 64 bits and DB2 code release SQL09015
with level identifier 01060107
Informational tokens are DB2 v9.1.0.5, s080406, U815922, Fix Pack 5.

Operating System Information:

OSName:   AIX
NodeName: p6db2serv
Version:  5
Release:  3
Machine:  00088FAA4C00

CPU Information:
TotalCPU    OnlineCPU   ConfigCPU   Speed(MHz)  HMTDegree  Cores/Socket
6           6           6           752         1           n/a

Physical Memory and Swap (Megabytes):
TotalMem    FreeMem     AvailMem    TotalSwap   FreeSwap
12288       4775        n/a         13504       13423

Virtual Memory (Megabytes):
Total       Reserved    Available   Free
.....

wangzhonnewnew

or
ps -ef | grep -i "db2sysc" | grep -i "<instance name>"

when instance is up you'll see db2sysc process

huyuhui001

原帖由 wangzhonnewnew 于 2008-4-10 22:43 發(fā)表
or
ps -ef | grep -i "db2sysc" | grep -i ""

when instance is up you'll see db2sysc process

我一般都這樣看一下是不是已經(jīng)起來(lái)了，簡(jiǎn)單。

wenchjun

db2gcf命令：以db2inst1用戶運(yùn)行db2gcf -s。如果db2實(shí)例啟動(dòng)，則顯示available

lklgdkp

上面的命令好！