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"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
