ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

DeqW

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • DeqW

    Hi, so there is an interactive job that runs along just fine for several minutes. Then it starts to crawl. When looking at the job thread we see.
    PHP Code:
                                         Total           Aux        Run    
    Opt     Thread       Status           CPU            I
    /O     Priority  
            00000153       DEQW        256.249        106458          20 
    When we look at the active job it is either in a DSPW or DSPA.

    The help for deqw blows.

    Any thougts?

    Thanks.
    Hunting down the future ms. Ex DeadManWalks. *certain restrictions apply

  • #2
    Re: DeqW

    Yo.. .DMW

    This could be one of MANY issues.
    --How many tables does it have open?
    --Is the record this job is trying to process locked by another job?
    --Has the other job released the table yet?
    --etc, etc...

    DEQW is waiting on a dequeue to complete, but this might be hindered by another job holding it up.

    I know this isn't the answer you're looking for .. but, it helps me sleep at night!

    -Rick

    Comment


    • #3
      Re: DeqW

      Thanks, this turns out to be a UFO. The session that it is running on is still crawling, but we ran this on another session and it flew like it has done before. it just builds a file , member based by user, so no record locks.

      Thanks agian.
      Hunting down the future ms. Ex DeadManWalks. *certain restrictions apply

      Comment


      • #4
        Re: DeqW

        OH yea.. it could be the session it's running on too!

        Comment

        Working...
        X