Results 1 to 12 of 12
  1. #1
    Join Date
    Mar 2015
    Posts
    31

    Unanswered: job lasting too long

    Hello,
    I have a job that is lasting now for mor then 10 hour in prepro.
    But don't know if it is doing something ...
    How can I see if this job is doing something in the database ? what is the query actually running ? the I/Os generated or output rows ?
    thank you -

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    DB2 database version and OS?

    Andy

  3. #3
    Join Date
    Mar 2015
    Posts
    31
    DB2 for Linux, UNIX, and Windows
    V10.5
    Thanks

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Which OS?

    Andy

  5. #5
    Join Date
    Mar 2015
    Posts
    31
    on AIX
    thanks

  6. #6
    Join Date
    May 2010
    Location
    India
    Posts
    84
    Provided Answers: 2
    Use db2top to check session status. See the following link for details regarding db2top.

    http://www-01.ibm.com/support/docvie...id=swg27009542

  7. #7
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Quote Originally Posted by stiruvee View Post
    Use db2top to check session status. See the following link for details regarding db2top.

    http://www-01.ibm.com/support/docvie...id=swg27009542
    I was going to suggest this also.

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

    try this:
    select * from table(MON_GET_ACTIVITY(my_slow_handle, -2))
    Regards,
    Mark.

  9. #9
    Join Date
    May 2012
    Location
    Canberra, Australia
    Posts
    176
    Provided Answers: 6
    Andy

    "All parts should go together without forcing. You must remember that the parts you are reassembling were disassembled by you. Therefore, if you can’t get them together again, there must be a reason. By all means, do not use hammer.” — IBM maintenance manual, 1975 "

  10. #10
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    Note that db2top still uses old snapshot APIs, so if you run it after the statement was issued and the corresponding instance parameters are switched off currently
    db2 get dbm cfg | grep -i dft_mon_
    you won't get those counters for this statement.
    For example, if DFT_MON_STMT is OFF, you won't get the statement text of the currently executing statement.
    Regards,
    Mark.

  11. #11
    Join Date
    Mar 2015
    Posts
    31
    thank you.
    But to use the db2top I need to access to the unix machine , and I just can access the databse with the IBM Data Studio

  12. #12
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    there is an older tool dbmon that can be used.. asis
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

Posting Permissions

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