Re: VM DB2 7.3 question
Thank you Roland. This was the information I have been looking for. Bill Pettit -Original Message- From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf Of Roland P. Chung Sent: Thursday, January 28, 2010 8:38 PM To: IBMVM@LISTSERV.UARK.EDU Subject: Re: VM DB2 7.3 question Hi Bill, This means the agent wants to read a directory block from disk, but there are no available directory buffers, so the agent waits for another agent to free up a buffer. When a buffer is freed, this agent will be "un-waited" so it can try to get the buffer again. This indicates an increase in the number of Directory buffers is needed. There is also an "out of page" wait state for when page buffers are all in use. I hope this helps. ...Roland --- On Thu, 1/28/10, Bill Pettit wrote: --- snipped --- -Original Message- From: The IBM z/VM Operating System [mailto:IBMVM@LISTSERV.UARK.EDU<http://ca.mc881.mail.yahoo.com/mc/compose?to=ib...@listserv.uark.edu>] On Behalf Of Bill Pettit Sent: Wednesday, January 27, 2010 5:20 PM To: IBMVM@LISTSERV.UARK.EDU<http://ca..mc881.mail.yahoo.com/mc/compose?to=ib...@listserv.uark.edu> Subject: VM DB2 7.3 question We encountered several slow running batch jobs last night and the only thing that stood out was the following entry when the operator command SHOW ACTIVE was entered: User Agent: 4 User ID: ONLINE is R/O APPL 2431F6FE Agent is processing and is in out of block wait. I have been searching off and on through the manuals today and I still cannot find any reference to the "Agent is processing and is in out of block wait" condition, and what it is attributed to. I suspect it has something to do with a shortage of the lock request blocks allowed and available for an active user, but I cannot find anything that actually tells me that.. Anyone have any knowledge about what this message means? Thank you Bill Pettit
Re: VM DB2 7.3 question
Hi Bill, This means the agent wants to read a directory block from disk, but there are no available directory buffers, so the agent waits for another agent to free up a buffer. When a buffer is freed, this agent will be "un-waited" so it can try to get the buffer again. This indicates an increase in the number of Directory buffers is needed. There is also an "out of page" wait state for when page buffers are all in use. I hope this helps. Roland --- On Thu, 1/28/10, Bill Pettit wrote: --- snipped --- -Original Message- From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf Of Bill Pettit Sent: Wednesday, January 27, 2010 5:20 PM To: IBMVM@LISTSERV.UARK.EDU Subject: VM DB2 7.3 question We encountered several slow running batch jobs last night and the only thing that stood out was the following entry when the operator command SHOW ACTIVE was entered: User Agent: 4 User ID: ONLINE is R/O APPL 2431F6FE Agent is processing and is in out of block wait. I have been searching off and on through the manuals today and I still cannot find any reference to the "Agent is processing and is in out of block wait" condition, and what it is attributed to. I suspect it has something to do with a shortage of the lock request blocks allowed and available for an active user, but I cannot find anything that actually tells me that. Anyone have any knowledge about what this message means? Thank you Bill Pettit
Re: VM DB2 7.3 question
Do you have Control Center? It's an IBM Licensed Program Product. If so, select Option M from the main menu. Add a Monitor, and select "User Locking". This does have the side effect of displaying messages any time locks are encountered, so check out the appropriate "notify" parameters. We monitor the locks on the production database every 5 minutes, and generate a report weekly. I review the NLRBS and NLRBU usage to see if changes are needed. The report does not show you who had the problem, but at each monitoring interval, it shows you the number of NLRBS allocated, the number used, and the number free, and the number of NLRBU allocated, and the maximum used by the LUW. Sample data from last week: MAX USED DATE TIMENLRBS IN USE FREENLRBU BY LUW -- --- --- --- --- --- 01/17/2010 00:15:00 3 0 3 150009134 20 line(s) not displayed 01/17/2010 02:00:00 3 200 29800 150009134 01/17/2010 02:05:00 3 618 29382 150009134 01/17/2010 02:10:00 3 0 3 150009134 01/17/2010 02:15:00 3 0 3 150009134 01/17/2010 02:20:00 3 596 29404 150009134 01/17/2010 02:25:00 3 596 29404 150009134 01/17/2010 02:30:01 3 596 29404 150009134 120 line(s) not displayed --- 01/17/2010 12:35:00 3 38 29962 150009134 01/17/2010 12:40:01 3 38 29962 150009134 01/17/2010 12:45:00 3 38 29962 150009134 01/17/2010 12:50:00 3 38 29962 150009134 01/17/2010 12:55:00 3 38 29962 150009134 01/17/2010 13:00:01 3 235 29765 15000 716 01/17/2010 13:05:00 3 38 29962 15000 716 Nora Graves nora.e.gra...@irs.gov Main IRS, Room 6531 (202) 622-6735 Fax (202) 622-3123 -Original Message- From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf Of Bill Pettit Sent: Thursday, January 28, 2010 10:07 AM To: IBMVM@LISTSERV.UARK.EDU Subject: Re: VM DB2 7.3 question Unfortunately no monitor. Not since CA pulled the rug out from under the DBMonitor product Sterling had. Thank you Nora. Bill -Original Message- From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf Of Graves Nora E Sent: Thursday, January 28, 2010 6:46 AM To: IBMVM@LISTSERV.UARK.EDU Subject: Re: VM DB2 7.3 question Do you run a User Locking monitor? If so, you can view the report at any time from the Control Center Monitor List function. That will show you the number of User and System blocks allocated and used. I do not see any references to this condition either. Nora Graves nora.e.gra...@irs.gov Main IRS, Room 6531 (202) 622-6735 Fax (202) 622-3123 -Original Message- From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf Of Bill Pettit Sent: Wednesday, January 27, 2010 5:20 PM To: IBMVM@LISTSERV.UARK.EDU Subject: VM DB2 7.3 question We encountered several slow running batch jobs last night and the only thing that stood out was the following entry when the operator command SHOW ACTIVE was entered: User Agent: 4 User ID: ONLINE is R/O APPL 2431F6FE Agent is processing and is in out of block wait. I have been searching off and on through the manuals today and I still cannot find any reference to the "Agent is processing and is in out of block wait" condition, and what it is attributed to. I suspect it has something to do with a shortage of the lock request blocks allowed and available for an active user, but I cannot find anything that actually tells me that. Anyone have any knowledge about what this message means? Thank you Bill Pettit
Re: VM DB2 7.3 question
Unfortunately no monitor. Not since CA pulled the rug out from under the DBMonitor product Sterling had. Thank you Nora. Bill -Original Message- From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf Of Graves Nora E Sent: Thursday, January 28, 2010 6:46 AM To: IBMVM@LISTSERV.UARK.EDU Subject: Re: VM DB2 7.3 question Do you run a User Locking monitor? If so, you can view the report at any time from the Control Center Monitor List function. That will show you the number of User and System blocks allocated and used. I do not see any references to this condition either. Nora Graves nora.e.gra...@irs.gov Main IRS, Room 6531 (202) 622-6735 Fax (202) 622-3123 -Original Message- From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf Of Bill Pettit Sent: Wednesday, January 27, 2010 5:20 PM To: IBMVM@LISTSERV.UARK.EDU Subject: VM DB2 7.3 question We encountered several slow running batch jobs last night and the only thing that stood out was the following entry when the operator command SHOW ACTIVE was entered: User Agent: 4 User ID: ONLINE is R/O APPL 2431F6FE Agent is processing and is in out of block wait. I have been searching off and on through the manuals today and I still cannot find any reference to the "Agent is processing and is in out of block wait" condition, and what it is attributed to. I suspect it has something to do with a shortage of the lock request blocks allowed and available for an active user, but I cannot find anything that actually tells me that. Anyone have any knowledge about what this message means? Thank you Bill Pettit
Re: VM DB2 7.3 question
Do you run a User Locking monitor? If so, you can view the report at any time from the Control Center Monitor List function. That will show you the number of User and System blocks allocated and used. I do not see any references to this condition either. Nora Graves nora.e.gra...@irs.gov Main IRS, Room 6531 (202) 622-6735 Fax (202) 622-3123 -Original Message- From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf Of Bill Pettit Sent: Wednesday, January 27, 2010 5:20 PM To: IBMVM@LISTSERV.UARK.EDU Subject: VM DB2 7.3 question We encountered several slow running batch jobs last night and the only thing that stood out was the following entry when the operator command SHOW ACTIVE was entered: User Agent: 4 User ID: ONLINE is R/O APPL 2431F6FE Agent is processing and is in out of block wait. I have been searching off and on through the manuals today and I still cannot find any reference to the "Agent is processing and is in out of block wait" condition, and what it is attributed to. I suspect it has something to do with a shortage of the lock request blocks allowed and available for an active user, but I cannot find anything that actually tells me that. Anyone have any knowledge about what this message means? Thank you Bill Pettit
VM DB2 7.3 question
We encountered several slow running batch jobs last night and the only thing that stood out was the following entry when the operator command SHOW ACTIVE was entered: User Agent: 4 User ID: ONLINE is R/O APPL 2431F6FE Agent is processing and is in out of block wait. I have been searching off and on through the manuals today and I still cannot find any reference to the "Agent is processing and is in out of block wait" condition, and what it is attributed to. I suspect it has something to do with a shortage of the lock request blocks allowed and available for an active user, but I cannot find anything that actually tells me that. Anyone have any knowledge about what this message means? Thank you Bill Pettit