Topic
3 replies Latest Post - ‏2012-10-24T19:11:56Z by jcdelmo
SystemAdmin
SystemAdmin
849 Posts
ACCEPTED ANSWER

Pinned topic Inventory collection progress should have additional stage

‏2012-10-23T14:56:25Z |
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.
Updated on 2012-10-24T19:11:56Z at 2012-10-24T19:11:56Z by jcdelmo
  • jcdelmo
    jcdelmo
    342 Posts
    ACCEPTED ANSWER

    Re: Inventory collection progress should have additional stage

    ‏2012-10-23T17:05:03Z  in response to SystemAdmin
    The 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
      SystemAdmin
      849 Posts
      ACCEPTED ANSWER

      Re: Inventory collection progress should have additional stage

      ‏2012-10-23T17:58:52Z  in response to jcdelmo
      Thank you John,

      Is this what you mean?

      set SET DD:DB2TRACE = c:\temp\db2Trace.log
      cd raahome
      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 ?
      • jcdelmo
        jcdelmo
        342 Posts
        ACCEPTED ANSWER

        Re: Inventory collection progress should have additional stage

        ‏2012-10-24T19:11:56Z  in response to SystemAdmin
        Yes, please send all log files generated (and the DB2 trace output)