![]() |
|
![]() |
We are using Informatica PDO to load TD tables and while running multiple sessions concurrently, we encountered an issue wherein the processes were failing due to a deadlock on dbc.userrights table.
05 Apr 2015
| 1 comment
,
|
![]() |
The application team experienced a deadlock issue.
29 Oct 2014
| 1 comment
,
|
![]() |
CREATE SET TABLE ETL_LOG ,NO FALLBACK , NO BEFORE JOURNAL, NO AFTER JOURNAL, CHECKSUM = DEFAULT, DEFAULT MERGEBLOCKRATIO ( ETL_Rec_Id BIGINT GENERATED ALWAYS AS IDENTITY (START WITH 1 INCREMENT BY 1
13 Mar 2013
| 2 comments
,
|
![]() |
Hello, I have gone through JDBC documentation, but I have not found a property or any other way, how to tell jdbc to retry a query that was aborted due to a deadlock. We are running a lot of concurrent jobs and we get sometimes a deadlock - not because of actual deadlock, but because of lock table being full on an AMP.
17 Jul 2012
| 2 comments
,
|
![]() |
I am trying to understand why BTEQ .PACK command creates dead lock on tables with NUPI. I had a scenario where I needed to load nearly 2 million rows on mutiset table with NUPI. I had lot of duplicates on NUPI columns. When sessions set to 4, PACK set to 2000, my bteq script's run time output displayed the following: *** Growing Buffer to 399 *** Warning: Attempting to resubmit last request.
18 Apr 2011
| 8 comments
,
|
![]() |
I have been looking for answers to a basic question on table partitioning in Teradata. Can someone please shed more light. Here it is -
09 Jul 2010
| 2 comments
,
|
![]() |
I have 2 BTEQs having following type of Statements. Both are submitted at the same time and both are trying to insert in the same table. BTEQ1 BTEQ2 -----------------------------
17 Jun 2010
| 1 comment
,
|