#DateForumTypeThreadPost
720 Mar 2014 @ 10:51 PDTDatabaseTopicArcmain table load progress while copy/restore lockingWe are using 13.10 and currently copying a table from one database to another and it's quite large (and yes, we are planning to partition it very soon). Performing an arcmain archive and copy ...
602 Dec 2013 @ 06:06 PSTUDAReplyCancel Rollback on a table with referential integrityNote that we are using an ansi connection which probably does not affect on how it does the rollback.  The UPI is an integer generated by default which should not cause any skew.  There i...
529 Nov 2013 @ 12:08 PSTUDAReplyCancel Rollback on a table with referential integrity/insert/ into table a (f1, f2) select b.f1, b.f2 from table b /where/ not /exists/ (select a1.f1 from a as a1 /where/ a1.f1=b.f1 and a1.f2=b.f2)
429 Nov 2013 @ 11:06 PSTUDAReplyCancel Rollback on a table with referential integrityGood question and great feedback Todd. Yes, you are right, it is a bulk insert (insert select) but it has a where not exists clause on the target table to only insert applicable records which is ...
328 Nov 2013 @ 07:55 PSTUDAReplyCancel Rollback on a table with referential integrityRaja, you mentioned that you killed jobs, do you mean kill specific Teradata processes at the OS layer?  If so, how would you determine which one is performing the rollback?  Note that I ...
228 Nov 2013 @ 06:04 PSTUDAReplyCancel Rollback on a table with referential integrityWe are using 13.10 and the table does have hard RI ("with check option"). The following will initiate the abort but I'm looking at cancelling the abort: SELECT SYSLIB.AbortSessions...
121 Nov 2013 @ 10:35 PSTUDATopicCancel Rollback on a table with referential integrityWe attempted a large load on an empty table that was highly ineficient and had to abort the session after hours of running. Now the rollback has been running for over 24hrs and is still locking th...