|
Replies:
1
-
Pages:
1
-
Last Post:
Aug 28, 2012 11:24 AM
by: kmd
|
|
|
Posts:
1
Registered:
8/20/12
|
|
|
|
Create Index deadlock for DB2
Posted:
Aug 20, 2012 9:17 AM
|
|
|
I'm new with BMF, and just want to follow the instructions to create a "Max TPS (1-5 by 1) Load job. In the "Create Objects for AS3AP" step, all the tables are created and data is load successful, but the job got deadlock on create indexes, then cancelled:
CLI Error (40001,FFFFFC71) - [IBM][CLI Driver][DB2/LINUXX8664] SQL0911N The current transaction has been rolled back because of a deadlock or timeout. Reason code "2". SQLSTATE=40001
Test cancelled due to errors.
What can I do to avoid this error and get the job test going?
Thanks
Rue
|
|
|
Posts:
133
Registered:
1/23/07
|
|
|
|
Re: Create Index deadlock for DB2
Posted:
Aug 28, 2012 11:24 AM
in response to: rvpham_437
|
|
|
With the latest version of BMF there is an option with the Create Objects item called "Parallel Index Creation" which is checked by default. Just uncheck this and re-run the creates.
|
|
|
|
Legend
|
|
Guru: 2001
+
pts
|
|
Expert: 751
- 2000
pts
|
|
Enthusiast: 31
- 750
pts
|
|
Novice: 0
- 30
pts
|
|
Moderators
|
|
Helpful answer
(5 pts)
|
|
Answered
(10 pts)
|
|
