because databases are still active.
06-04-2006 09:02:49 2 0 SQL1025N The database manager was not stopped because databases are still active.
06-04-2006 09:02:49 3 0 SQL1025N The database manager was not stopped because databases are still active.
06-04-2006 09:02:49 4 0 SQL1025N The database manager was not stopped because databases are still active.
06-04-2006 09:02:49 5 0 SQL1025N The database manager was not stopped because databases are still active.
06-04-2006 09:02:49 6 0 SQL1025N The database manager was not stopped because databases are still active.
06-04-2006 09:02:49 7 0 SQL1025N The database manager was not stopped because databases are still active.
06-04-2006 09:02:49 8 0 SQL1025N The database manager was not stopped because databases are still active.
06-04-2006 09:02:49 9 0 SQL1025N The database manager was not stopped because databases are still active.
06-04-2006 09:02:49 10 0 SQL1025N The database manager was not stopped because databases are still active.
06-04-2006 09:02:49 11 0 SQL1025N The database manager was not stopped because databases are still active.
06-04-2006 09:02:49 12 0 SQL1025N The database manager was not stopped because databases are still active.
home/db2nfs/db2inst1 🙂 db2_kill
db2svr01: ipclean: Removing DB2 engine and client’s IPC resources for db2inst1.
db2svr01: db2nkill [] completed ok
db2svr02: ipclean: Removing DB2 engine and client’s IPC resources for db2inst1.
db2svr02: ipclean: Error 22 removing ipc 1225654299
db2svr02: ipclean: Error 22 removing ipc 128843808
db2svr02: ipclean: Error 22 removing ipc 1383464993
db2svr02: ipclean: Error 22 removing ipc 44302374
db2svr02: ipclean: Error 22 removing ipc 864419926
db2svr02: ipclean: Error 22 removing ipc 1413873752
db2svr02: ipclean: Error 22 removing ipc 7209060
db2svr02: db2nkill [] completed ok
home/db2nfs/db2inst1 🙂 db2_ps
Node 1
UID PID PPID C STIME TTY TIME CMD
db2svr01: db2nps ## completed ok
Node 2
UID PID PPID C STIME TTY TIME CMD
db2svr01: db2nps ## completed ok
Node 3
UID PID PPID C STIME TTY TIME CMD
db2svr01: db2nps ## completed ok
Node 4
UID PID PPID C STIME TTY TIME CMD
db2svr01: db2nps ## completed ok
Node 5
UID PID PPID C STIME TTY TIME CMD
db2svr01: db2nps ## completed ok
Node 6
UID PID PPID C STIME TTY TIME CMD
db2svr01: db2nps ## completed ok
Node 7
UID PID PPID C STIME TTY TIME CMD
db2svr02: db2nps ## completed ok
Node 8
UID PID PPID C STIME TTY TIME CMD
db2svr02: db2nps ## completed ok
Node 9
UID PID PPID C STIME TTY TIME CMD
db2svr02: db2nps ## completed ok
Node 10
UID PID PPID C STIME TTY TIME CMD
db2svr02: db2nps ## completed ok
Node 11
UID PID PPID C STIME TTY TIME CMD
db2svr02: db2nps ## completed ok
Node 12
UID PID PPID C STIME TTY TIME CMD
db2_ps
ps -ef |grep db2|awk ‘{print “kill -9 “$2}’|sh
db2_all ipclean -a
db2_all ipcs|grep db2inst
ipcs -a
ipcs -a | grep dw | awk ‘{print “ipcrm -“$1,$2}’
ipcs -a | grep db2inst1| awk ‘{print “ipcrm -“$1,$2}’
db2 “restart db zmccdw”
/home/db2nfs/db2inst1 🙂 db2_all ipcs|grep db2inst
m 22413324 0xffffffff D-rw-rw-rw- db2inst1 db2iadm1
m 22413324 0xffffffff D-rw-rw-rw- db2inst1 db2iadm1
m 22413324 0xffffffff D-rw-rw-rw- db2inst1 db2iadm1
m 22413324 0xffffffff D-rw-rw-rw- db2inst1 db2iadm1
m 22413324 0xffffffff D-rw-rw-rw- db2inst1 db2iadm1
m 22413324 0xffffffff D-rw-rw-rw- db2inst1 db2iadm1
m 1966089 0xffffffff D-rw-rw-rw- db2inst1 db2iadm1
m 7209060 0xffffffff D-rw-rw-rw- db2inst1 db2iadm1
m 1966089 0xffffffff D-rw-rw-rw- db2inst1 db2iadm1
m 7209060 0xffffffff D-rw-rw-rw- db2inst1 db2iadm1
m 1966089 0xffffffff D-rw-rw-rw- db2inst1 db2iadm1
m 7209060 0xffffffff D-rw-rw-rw- db2inst1 db2iadm1
m 1966089 0xffffffff D-rw-rw-rw- db2inst1 db2iadm1
m 7209060 0xffffffff D-rw-rw-rw- db2inst1 db2iadm1
m 1966089 0xffffffff D-rw-rw-rw- db2inst1 db2iadm1
m 7209060 0xffffffff D-rw-rw-rw- db2inst1 db2iadm1
m 1966089 0xffffffff D-rw-rw-rw- db2inst1 db2iadm1
m 7209060 0xffffffff D-rw-rw-rw- db2inst1 db2iadm1
#db2start
#cd /home/db2nfs/db2inst1/sqllib/db2dump
#tail –f db2diag.log
#tail –f db2inst1.nfy
#db2 activate db zmccdw (db2_name) /*激活内存,可省)
# db2_all “db2 terminate; db2 connect to zmccdw” /节点连接测试*/
13.9 Client cfg
db2 “catalog tcpip node NODE164 remote 10.70.36.164 SERVER 60000”
db2 “catalog database zmccdw as dw164 at node NODE164 authentication SERVER_ENCRYPT”
13.10 ……………..
13.11 问题sql
以下文章点击率最高
Loading…