467,172 Members | 1,259 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,172 developers. It's quick & easy.

Index creation status

Hello, The create index statement executes for the past 1 hour while
trying to add a new index to a logically partitioned table which has 58
million records. Is there a command/utilit where I can check the status
of index creation phase?

Env: DB2 8.2/AIX 5.3

Thanks,
db2udbgirl

Apr 25 '06 #1
  • viewed: 3620
Share:
2 Replies
Well it has failed now with error "SQL0911N The current transaction
has been rolled back because of a deadlock or timeout. Reason code
"68". SQLSTATE=40001"

But my question is still open.

Thanks,
db2udbgirl.

Apr 25 '06 #2
"db2udbgirl" <Vi**********@gmail.com> wrote in message
news:11**********************@i40g2000cwc.googlegr oups.com...
Well it has failed now with error "SQL0911N The current transaction
has been rolled back because of a deadlock or timeout. Reason code
"68". SQLSTATE=40001"

But my question is still open.

Thanks,
db2udbgirl.


RC 68 is lock timeout. Probably someone else has a lock on the catalog
tables.
Apr 25 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by eatyou@rediffmail.com | last post: by
reply views Thread by HumanJHawkins | last post: by
reply views Thread by Guy Deprez | last post: by
14 posts views Thread by Sean C. | last post: by
13 posts views Thread by LUIS FAJARDO | last post: by
1 post views Thread by chettiar | last post: by
reply views Thread by ssims | last post: by
7 posts views Thread by rAinDeEr | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.