Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Location
    UK
    Posts
    11

    Unanswered: how to find out the lock , when a batch process is running

    V7.2 fix pak 6
    Unix AIX

    I have got a batch proces running for six hours, which was taking 1 hour till yesterday.
    what could be reason ?.
    where to start from?.
    db2 diaglog entries are not showing any problem.

  2. #2
    Join Date
    Apr 2003
    Posts
    191

    Re: how to find out the lock , when a batch process is running

    Hi prakash56,

    you may want to write log entries with timestamps to catch the point that drags out the batch job. Another option would be to create a statement monitor, if you can't change the batch job.

    Very occasionally, I have seen things like this simply going away after termination or completion of the batch job.

    Finally, you may want to have AIX gather work load statistics for yourself.

    Johann

    Originally posted by prakash56
    V7.2 fix pak 6
    Unix AIX

    I have got a batch proces running for six hours, which was taking 1 hour till yesterday.
    what could be reason ?.
    where to start from?.
    db2 diaglog entries are not showing any problem.

  3. #3
    Join Date
    Jan 2004
    Location
    UK
    Posts
    11

    Re: how to find out the lock , when a batch process is running

    Originally posted by jsander
    Hi prakash56,

    you may want to write log entries with timestamps to catch the point that drags out the batch job. Another option would be to create a statement monitor, if you can't change the batch job.

    Very occasionally, I have seen things like this simply going away after termination or completion of the batch job.

    Finally, you may want to have AIX gather work load statistics for yourself.

    Johann
    Yes Johan
    you are absolutely right in interpretation of the problem.
    now please suggest me something to in that direction.
    thanks
    Prakash
    Last edited by prakash56; 02-13-04 at 12:37.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •