If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

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 -

"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 "

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.

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 Certifiedhttp://www.infocura.be