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
