I posted a white paper on this a week or so ago about aix. You should consider finding it ... It might help.. Have a great post 4th of July
Sent from my iPhone On Jul 5, 2011, at 5:26 PM, "Mueller, Doug" <[email protected]> wrote: > ** > Viabh, > > Application Pending is a "system work queue" form. > > It is used by a number of subsystems to allow recording that work needs to be > done and then allowing the > operation to continue without having to wait until that work is completed. > And, it allows for queueing up of > work to do if there are floods of work or if other systems needed are not > available at the current time. > > You will get entries in this when DSO is noting that a record needs to be > transferred or when Approval has > some work to do or when a number of other systems like this have background > work to do that may be > lengthy or may involve delays or retries. > > Under normal processing if all is going well, this form should essentially > stay empty. Entries should be > processed and then removed quickly. The fact you never see the form get more > than 2 entries in it is a > sign that all is processing well in your system and the background, > asynchronous work is being done in a > timely manner without delay. > > You may see many reads/writes/creates/deletes from this table, but you > should see that they are all very > fast. The only time that this form and interaction has been even a slight > issue around performance is in high > use situations with lots of background processing before next ID blocking was > available. There could > sometimes be a little queueing on create operations. This form is shipped > with this option on now so that > bottleneck has been eliminated. > > This is unlikely (cannot say NOT because that is the only way I know to make > sure that it IS the problem) > that this form is tied into the performance issue you are having. > > Doug Mueller > > From: Action Request System discussion list(ARSList) > [mailto:[email protected]] On Behalf Of Vaibhav Singhal > Sent: Monday, July 04, 2011 9:27 PM > To: [email protected] > Subject: Thousands of DB read/write operations on T8 table for "Application > Pending" > > ** > Hello All, > > > System Information - > ARS 6.0 > ITSM 6.3 > Platform - AIX > > > We are facing some performance issues on our Prod env. So I was scanning the > logs, and in SQL logs I can see thousands of Read/Write operations ontable T8. > T8 is for form "Pending Application" > And, I can see entries keep on deleting, and at an instance it has a maximum > of 2 entries. > > > I am not sure for what exactly is the purpose of this form. > My blind guess is - some kind of server requests thread management. > Can anyone suggest something on this please? > > > Regards, > Vaibh > > > ::DISCLAIMER:: > ----------------------------------------------------------------------------------------------------------------------- > > The contents of this e-mail and any attachment(s) are confidential and > intended for the named recipient(s) only. > It shall not attach any liability on the originator or HCL or its affiliates. > Any views or opinions presented in > this email are solely those of the author and may not necessarily reflect the > opinions of HCL or its affiliates. > Any form of reproduction, dissemination, copying, disclosure, modification, > distribution and / or publication of > this message without the prior written consent of the author of this e-mail > is strictly prohibited. If you have > received this email in error please delete it and notify the sender > immediately. Before opening any mail and > attachments please check them for viruses and defect. > > ----------------------------------------------------------------------------------------------------------------------- > _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend > WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
