The current implementation of the "Rebuild run unit content" has a serious problem in that it brings to the queue all run units that need rebuilding. This is a shotgun approach that does not allow for selectivity when trying to resolve only some of the RUs.
It would help if the requeue process was separated into a preceding stage "Requeue incomplete RUs". This would allow to control the queue stopping just after this new step and the use some side SQL to remove from the queue unwanted RUs.
I am bringing this up because run unit resolution speed is very bad. We are experiencing over 12 hours for 4-5K RUs. This combined with the inexplicable lack of a stop postprocessor request does not help with the inventory process.
This topic has been locked.
3 replies Latest Post - 2012-10-24T19:11:56Z by jcdelmo
Pinned topic Inventory collection progress should have additional stage
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-10-24T19:11:56Z at 2012-10-24T19:11:56Z by jcdelmo
jcdelmo 0600012HN8342 PostsACCEPTED ANSWER
Re: Inventory collection progress should have additional stage2012-10-23T17:05:03Z in response to SystemAdminThe idea has merit. Let me consider it for a fix pack.
On the 'very bad' -- this has been brought up before. I've analyzed the process a number of times. There are only 6 basic SQL statements involved in run unit building. Would it be possible for you to debug a few run units with -D9 and SET DD:DB2TRACE = c:\temp\db2Trace.log for me? I need more information to address the 'very bad', as I do not have it occurring here in development environment.
Thanks in advance...
SystemAdmin 110000D4XK849 PostsACCEPTED ANSWER
Re: Inventory collection progress should have additional stage2012-10-23T17:58:52Z in response to jcdelmoThank you John,
Is this what you mean?
set SET DD:DB2TRACE = c:\temp\db2Trace.log
bin\dmh6000.bat DMHDB id pw -H:raahome -A -S5 -Q5 -D9
And kill it after the Analysis queue shows it has loaded all pending and has consumed some of them ?