Re: DB2 CF Lock Structure DSNDP3G_LOCK1

2006-09-07 Thread Rebecca Martin
Shane wrote on 07/09/2006 12:32:46 +1000 As a general statement, if the structure owner chooses to use async rather than sync, why would you care ???. If none are actually being converted, pat yourself on the back for a job well done, and go find a real problem to worry about. Don't be so quick

Re: DB2 CF Lock Structure DSNDP3G_LOCK1 Performance

2006-09-07 Thread Neil Ervin
Your comments are exactly what I am searching for. Shane asked 'why wwould I be concerned' and the answer is that the Async requests to the DB2 lock structure seem to happen around the times of application timeouts. I do hope that others, including IBM'ers, will join in with their comments

Re: DB2 CF Lock Structure DSNDP3G_LOCK1 Performance

2006-09-07 Thread Lock Lyon
Mainframe Discussion List IBM-MAIN@BAMA.UA.EDU To IBM-MAIN@BAMA.UA.EDU cc Subject Re: DB2 CF Lock Structure DSNDP3G_LOCK1 Performance Your comments are exactly what I am searching for. Shane asked 'why wwould I be concerned' and the answer is that the Async requests to the DB2 lock

DB2 CF Lock Structure DSNDP3G_LOCK1

2006-09-06 Thread Neil Ervin
Under what conditions might there be Async requests for this DB2 lock structure? The RMF 'Sync changed to Async' value is 0 during the intervals containing Async requests 0. The Async requests occur infrequently but I'm wondering if they might cause sync requests to suffer, or might be the

Re: DB2 CF Lock Structure DSNDP3G_LOCK1

2006-09-06 Thread Shane Ginnane
Neil wrote on 07/09/2006 08:37:16 AM: Under what conditions might there be Async requests for this DB2 lock structure? The RMF 'Sync changed to Async' value is 0 during the intervals containing Async requests 0. The Async requests occur infrequently but I'm wondering if they might cause