Merge problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

cajo_vcambra - 11 May 2006 16:04 GMT

Hello,

I'm running a merge operation on one of my database tables and i was
wondering if there's any way of knowing on which phase the process is
going (similar to list utilities), or in a simpler way, i want to know
how long will it take to finish, any ideas?

Thanks in advance for any help you can give me.

Carlos Ferreira

Reply to this Message

Serge Rielau - 11 May 2006 17:48 GMT

> Hello,
>
> I'm running a merge operation on one of my database tables and i was
> wondering if there's any way of knowing on which phase the process is
> going (similar to list utilities), or in a simpler way, i want to know
> how long will it take to finish, any ideas?

You can run db2pd and see how many rows are being update/inserted.
You should see in much phase it is that way.

Cheers
Serge

Signature

Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

Reply to this Message

Artur - 11 May 2006 21:05 GMT

You can also monitor the application using snapshot or equivalet table
function:

db2 list applications
DB2ADMIN db2bp.exe 8 *LOCAL.DB2.060512023518
SAMPLE 1
DB2ADMIN db2bp.exe 7 *LOCAL.DB2.060512023343
SAMPLE 1

db2 get snapshot for application agentid 8

However I don't think there is a utility in DB2, which will estimate
the time expected to finish a running query.

-- Artur Wronski

Reply to this Message