SEO

#1 (**permalink**) 02-27-2008, 06:51 AM

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

#2 (**permalink**) 02-27-2008, 06:51 AM

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.

#3 (**permalink**) 02-27-2008, 06:51 AM

"db2udbgirl" <VictorVijesh@gmail.com> wrote in message
news:1145982563.392688.283490@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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Index creation status