Index creation status

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

db2udbgirl - 25 Apr 2006 17:20 GMT

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

Reply to this Message

db2udbgirl - 25 Apr 2006 17:29 GMT

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.

Reply to this Message

Mark A - 25 Apr 2006 18:38 GMT

> Well it has failed now with error "SQL0911N The current transaction
> has been rolled back because of a deadlock or timeout. Reason code
[quoted text clipped - 4 lines]
> Thanks,
> db2udbgirl.

RC 68 is lock timeout. Probably someone else has a lock on the catalog
tables.

Reply to this Message