You have hit a BIG bug. You will soon start to get login errors on this
system (Check the diag for: ZRC=0x805C006Aÿ). You need to bounce the
instance to clear this up. You may also need to kill -9 the db2chkpwd
processes (owned by root!) to get them to come down. The perm fix is to
apply the AIX 5.3 TL5 SP3 OS patch.

Good luck.


David Baker
Taido Ryu Jujitsu
www.TaidoRyu.com
518-210-1000


-----Original Message-----
From: John Kruger
[mailto:db2udbdba-ezmlmshield-x35145142.[Email address protected]
Sent: Friday, December 29, 2006 8:55 AM
To: LazyDBA Discussion
Subject: Db2ckpwd consuming resources like a pig in heaven

TGIF!!!!!!!!!!!!


Yesterday While I was out, process db2ckpwd was consuming resources like
a pig in heaven.
Anyone run into this proplem yet? What did you do to solve this?




I found on the internet Dogpile and Googole AIX authentication APARs
may impact DB2 password checking daemons (db2ckpwd processes) causing a
variety of symptoms, including authentication errors, hangs, and DB2
crashes.

Content

DB2's password checking daemons (db2ckpwd processes) are vulnerable to
various AIX 5.3 authentication APARs (IY71365, IY75151, IY78341,
IY84813, IY86265, IY86266, IY90020). These can result in authentication
errors, hangs/looping, and crashes, . It is therefore generally
recommended to disable the password checking daemons by issuing "db2set
DB2_NUM_CKPW_DAEMONS=0" and recycling the instance. A minimum of DB2
Version 8.1 Fixpak 11 is recommended for this setting due to DB2 APAR
IY82133. ( see
http://www.ibm.com/support/docview.wss?rs=71&uid=swg1IY82133 )

On systems with high authentication rates, disabling password checking
daemons may cause performance degradation as each authentication will
require forking a separate process (db2ckpw). In the case where password
checking daemons cannot be disabled, it is recommended to obtain the
applicable interim fixes from AIX support. See the following document
for information on the most current AIX APARs and recommended minimum
maintenance levels:
http://www.ibm.com/support/docview.wss?rs=71&uid=swg21165448



We're at DB2 Version 8.1 Fixpak 10. We always seem to be a day late and
a dollar short




---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



DB2 & UDB email list listserv db2-l LazyDBA home page