db2与oracle的全面对比22

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…

     

如果这文章对你有帮助,请扫左上角微信支付-支付宝,给于打赏,以助博客运营

发表评论

您的电子邮箱地址不会被公开。 必填项已用*标注