互联网服务Db2性能调优
并发操作时，db2syscr（root）占用100%cpu导致性能下降
在suse10上使用c程序做连接数据库db2v9.1操作，使用top发现有三个root用户起的进程db2syscr占用大量cpu，导致性能急剧下降，完成一次打开数据库操作操作200毫秒。而在redhat上，没有该进程，并且同样程序同样的并发，完成一次只需要10来毫秒。不知道有没有人遇到过类似情况，有没有解决的办法。
已基本解决，感谢各位的帮忙。
db2syscr占用的资源已经降到1%左右，其基本操作是
dbserver:/etc/default # gstack 5273
#0 0xffffe410 in __kernel_vsyscall ()
#1 0xb363846f in msgrcv () from /lib/libc.so.6
#2 0xb6985b2b in sqlorqueInternal () from /opt/ibm/db2/V9.1/lib32/libdb2e.so.1
#3 0xb69858cc in sqlorque2 () from /opt/ibm/db2/V9.1/lib32/libdb2e.so.1
#4 0xb6b09937 in sqlockpw_daemon_main ()
#5 0xb6b0a14c in sqlockpw_daemon_init ()
#6 0xb551efb6 in sqloSystemControllerMain ()
#7 0xb551dcd4 in sqloRunInstance () from /opt/ibm/db2/V9.1/lib32/libdb2e.so.1
#8 0x0804d47e in DB2main ()
#9 0x0804cd6c in main ()
suse下，完成一次操作已经提高到40多毫秒。
已基本解决，感谢各位的帮忙。
db2syscr占用的资源已经降到1%左右，其基本操作是
dbserver:/etc/default # gstack 5273
#0 0xffffe410 in __kernel_vsyscall ()
#1 0xb363846f in msgrcv () from /lib/libc.so.6
#2 0xb6985b2b in sqlorqueInternal () from /opt/ibm/db2/V9.1/lib32/libdb2e.so.1
#3 0xb69858cc in sqlorque2 () from /opt/ibm/db2/V9.1/lib32/libdb2e.so.1
#4 0xb6b09937 in sqlockpw_daemon_main ()
#5 0xb6b0a14c in sqlockpw_daemon_init ()
#6 0xb551efb6 in sqloSystemControllerMain ()
#7 0xb551dcd4 in sqloRunInstance () from /opt/ibm/db2/V9.1/lib32/libdb2e.so.1
#8 0x0804d47e in DB2main ()
#9 0x0804cd6c in main ()
suse下，完成一次操作已经提高到40多毫秒。
30同行回答
学习。。。收起
浏览2555
从上面日志看，不知道为什么在suse下，会不停的去打开/etc/shadow，可能是为了验证用户名和密码，有什么办 ...fociceo 发表于 2012-4-26 10:45
频繁shutdown会造成lsn空间浪费，尤其是log file size比较大时。...另外，我仔细看了一下passwd文件，貌似缺省是用des方式加密的，
# This file contains some information for
# the passwd (1) command and other tools
# creating or modifying passwords.
# Define default crypt hash
# CRYPT={des,md5,blowfish}
CRYPT=des
# Use another crypt hash for group passwowrds.
# This is used by gpasswd, fallback is the CRYPT entry.
# GROUP_CRYPT=des
# We can override the default for a special service
# by appending the service name (FILES, YP, NISPLUS, LDAP)
# for local files, use a more secure hash. We
# don't need to be portable here:
#CRYPT_FILES=blowfish
# sometimes we need to specify special options for
# a hash (variable is prepended by the name of the
# crypt hash).
不知道为什么会去调blowfish的加密方式。还是，有其他的原因。收起
# This file contains some information for
# the passwd (1) command and other tools
# creating or modifying passwords.
# Define default crypt hash
# CRYPT={des,md5,blowfish}
CRYPT=des
# Use another crypt hash for group passwowrds.
# This is used by gpasswd, fallback is the CRYPT entry.
# GROUP_CRYPT=des
# We can override the default for a special service
# by appending the service name (FILES, YP, NISPLUS, LDAP)
# for local files, use a more secure hash. We
# don't need to be portable here:
#CRYPT_FILES=blowfish
# sometimes we need to specify special options for
# a hash (variable is prepended by the name of the
# crypt hash).
不知道为什么会去调blowfish的加密方式。还是，有其他的原因。收起
浏览2586
浏览2523