Results 1 to 4 of 4

Thread: Snapshot

  1. #1
    Join Date
    Nov 2006
    Posts
    31

    Unanswered: Snapshot

    Hi all,
    I have a DB2 8.2 with a FixPak '7' on AIX 5.2.
    There is a procedure created on the db2 which basically waits for the time given and then displays all the rows of a table.It's working fine if I run it but when a user is trying to run the same procedure from a different server using db2 command line it works sometimes and just hangs the other times.
    I tried to get the snapshot command using the id, I noticed that the application id is changing from 'UOW Executing' to 'UOW Waiting' after the time period.

    How do I verify if it returned the results? Is it a network issue as the user is connecting from a remote server?
    -Thanks in advance..

  2. #2
    Join Date
    Jun 2006
    Posts
    471

    uow

    have you done : list applications show detail, whenever the hang occured ?
    maybe there is a lock wait. db2 get snapshot for application agentid xx
    could indicate the conditions
    executing means what indicated (executing)
    uow waiting, the db is waiting for the application todo a request
    this seems ok
    Best Regards, Guy Przytula
    DB2 UDB LUW certified V6/7/8

  3. #3
    Join Date
    Nov 2006
    Posts
    31
    Hi,
    I did a list applications show detail while it was within the time limit submitted for the application and the status was 'UOW Executing' and once the time limit was reached it changed the status to 'UOW Waiting'..
    I did a snapshot for bothe the applications that returned results and the one which failed, below is the main difference,
    The application with the result:
    UOW log space used (Bytes) = 0
    Previous UOW completion timestamp = 01/17/2007 15:51:49.276448
    Elapsed time of last completed uow (sec.ms)= 31.055513
    UOW start timestamp = 01/17/2007 15:52:18.919463
    UOW stop timestamp = 01/17/2007 15:52:49.974976
    UOW completion status = Committed - Commit Statement

    The one failed :
    UOW log space used (Bytes) = 0
    Previous UOW completion timestamp = 01/17/2007 16:00:58.152406
    Elapsed time of last completed uow (sec.ms)= 0.000000
    UOW start timestamp = 01/17/2007 16:01:36.353992
    UOW stop timestamp =
    UOW completion status =

    I see that the UOW does not commited in the second request, but my question is if the same procedure is running from two different systems why one is failing..

  4. #4
    Join Date
    Jun 2006
    Posts
    471

    uow

    executing : means waiting for the database resultset
    why does it fail ? You have to find out
    always print/display the sqlca : sqlcode/state... whenever an error occures for a statement. this can give an idea..
    otherwise put some debug statements and see where the error occured
    Best Regards, Guy Przytula
    DB2 UDB LUW certified V6/7/8

Posting Permissions

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