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

forcing an application, unable to force, create index statement justgot stuck

P: n/a
Hi,

I am having a difficult situation in here...
Seems there is a query to create an index on a table and has just got
stuck.....
It is showing that it is in UOW executing status (in DB2 monitor) for
the last 1 day.

When i try to force the application, it gives the message that it has
been killed, but it not removed.
As a result, it has put a lock on that table, which i cannot remove.

What could be the possible solution to it?

Thanks a lot,

Rahul Babbar
Dec 2 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"Rahul Babbar" <ra***********@gmail.comwrote in message
news:3d**********************************@a35g2000 prf.googlegroups.com...
Hi,

I am having a difficult situation in here...
Seems there is a query to create an index on a table and has just got
stuck.....
It is showing that it is in UOW executing status (in DB2 monitor) for
the last 1 day.

When i try to force the application, it gives the message that it has
been killed, but it not removed.
As a result, it has put a lock on that table, which i cannot remove.

What could be the possible solution to it?

Thanks a lot,

Rahul Babbar
Restart the instance. Issue ipclean command (Linux and UNIX) if necessary.
Dec 2 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.