Results 1 to 4 of 4
  1. #1
    Join Date
    May 2016
    Posts
    2

    Unanswered: Process using Primary Log File

    Heys Guys

    I'm new here and also don't have much experience working with DB2 and AIX.

    My problem is the following (and might be quite simple to solve by one of you). I've several long threads running on my server and one of them is using my Active Log file since yesterday...my question is: I can identify which OS process is using the log file but what I want to know is which DB2 process is using it and not doing a (required) commit so it can advance....

    I know that when my log is full I will be able to see which process was being executed but I don't want to wait until my log is full. Is there any DB2 command to see this? I've already listed the db2 apps that are executing and they're hundreds (end of the month jobs and stuff)....

    I don't know if I was very clear but I hope you can help me

    Thanks for your help
    Regards

  2. #2
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    Hi,

    try this:
    Code:
    select application_handle, application_id, uow_start_time
    from table(MON_GET_UNIT_OF_WORK(null, -2))
    order by uow_start_time
    fetch first 10 rows only;
    MON_GET_UNIT_OF_WORK
    Regards,
    Mark.

  3. #3
    Join Date
    May 2016
    Posts
    2

    ...

    Hey Mark

    Thanks for the reply but that doesn't help too much. I know that my DB is waiting for something, probably a commit, that will release the logs. However is not certain that the process holding this is the oldest one and that query retrieves that...I need to know what is holding the log file at this moment. Maybe is the oldest UOW, maybe it isn't

  4. #4
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    Try this:

    Select appl_id_oldest_xact
    From table(SNAP_GET_DB(current server, -2))

    http://www.ibm.com/support/knowledge...0%2F3-6-1-4-12
    Regards,
    Mark.

Tags for this Thread

Posting Permissions

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