You might want to post this on the DB2 list. If you have not joined, you can do so at IDUG.ORG - it is free.
Lizette > -----Original Message----- > From: IBM Mainframe Discussion List [mailto:[email protected]] > On Behalf Of Arie Kremer > Sent: Sunday, June 07, 2015 3:17 AM > To: [email protected] > Subject: DB2 IFI locks a DBD for SHRD > > Hi ALL, > > We have a product that uses IFI 306 request to read DB2 Log content. We > have a number of Sysplex installations that the customers reported some > DBD SHRD lock caused by our process that could be unlocked only stopping > the > process: > > Time of Lock................ 02:53:43.82 > > Lock State.................. SHRD > > Plan Name................... DSNACLI > > Lock Elapsed Time........... 00:20:08.50 > > > The process uses DSNACLI plan to access DB2 including IFI itself. We checked > that all the DB2 statements had been closed, and from the time analyzing of > the Database lock and the product log we may have seen clear that the lock is > caused by IFI request: the product called IFI about 4 seconds before the lock > time, and IFI returned milliseconds after the time of the lock without any > problem indication. > > > IFI documentation explains that IFI may have locked DBD for a short interval, > but here we see the lock that cannot be unlocked but stopping the task. > > > Does somebody have any idea how to manage the problem? > > > Best Regards > > Arie Kremer ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
