By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,237 Members | 1,228 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,237 IT Pros & Developers. It's quick & easy.

Merge problem

P: n/a
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

May 11 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
cajo_vcambra wrote:
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

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
May 11 '06 #2

P: n/a
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

May 11 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.