#DateWhereItemComment
1404 Feb 2013 @ 02:56 PSTcarrie's blogTeradata 13.10 Statistics Collection Recommendations I've always had this question and unable to find a clear cut answer. For a partitioned table, is collect stats on "PARTITION" the same as collecting stats on the column on which PPI is defined? ...
1322 Oct 2012 @ 10:25 PDTkeep it simpleUpdate on copy / move data between systemsFor really large tables, i'm afraid to use arcmain because they will cause a HUT lock on the production table(please correct me if I'm wrong) During the time the HUT lock is present, the table c...
1221 Oct 2012 @ 05:12 PDTkeep it simpleUpdate on copy / move data between systemsNever mind. I think i got my answer. I need to use the following commands to get detailed logs: tlogview -l ctp20121021_173435-27.out tlogview -j ctp20121021_173435-27 -p tlogview -j ctp20...
1121 Oct 2012 @ 03:05 PDTkeep it simpleUpdate on copy / move data between systemsok thanks!...I'm trying to copy an 11 billion record table from my production to test system. With 1 reader, 1 writer and 5 sessions for export, 20 sessions for load....I'm getting the job done in ...
1019 Oct 2012 @ 02:57 PDTkeep it simpleUpdate on copy / move data between systemsUlrich, correct me if I'm wrong. The tool works only if target table is empty right?
918 Oct 2012 @ 09:51 PDTkeep it simpleUpdate on copy / move data between systemsSorry...i'm not coming to partners...but feel free to ask for a drink from the Charles Schwab contingent!!!
818 Oct 2012 @ 07:27 PDTkeep it simpleUpdate on copy / move data between systems:)....Just trying my luck!!!....Thanks a lot for the updated new version.
717 Oct 2012 @ 06:47 PDTToolsUse Teradata Parallel Transporter to Move Data Without Landing the Data to DiskThanks feinholz.
617 Oct 2012 @ 06:38 PDTToolsUse Teradata Parallel Transporter to Move Data Without Landing the Data to DiskGreat....That resolves all my doubts. This is just wishful thinking....but is it possible to have a feature (in future versions in teradata) that dynamically calculates the correct number of in...
517 Oct 2012 @ 06:26 PDTToolsUse Teradata Parallel Transporter to Move Data Without Landing the Data to DiskSo this means that a job with 2 instances, 15 sessions each will run faster than the same job running with 3 instances ,10 sessions each but the 3rd instance never getting used. Correct?
417 Oct 2012 @ 12:41 PDTkeep it simpleUpdate on copy / move data between systemsThanks Ulrich! In the meanwhile, is there a possibility you can provide me the .java file? Currently the attachment you have only contains the .jar. I'll try to make this change myself.
317 Oct 2012 @ 12:39 PDTToolsUse Teradata Parallel Transporter to Move Data Without Landing the Data to DiskSo if the 3rd instance is never used, the 10 sessions allocated to this instance are never used. They just sit there as idle connected to the system and do not do any form of work. Is that correct?
216 Oct 2012 @ 02:12 PDTToolsUse Teradata Parallel Transporter to Move Data Without Landing the Data to DiskFeinholz, I have 2 questions based on your following comment on MaxSessions on 18 Feb 2011: "So, if you set MaxSessions to 30 and you have 2 instances of the Update operator, each instance will ...
116 Oct 2012 @ 11:35 PDTkeep it simpleUpdate on copy / move data between systemsHi Ulrich, I have started to use this tool to move data from our production system to test system. I realized that it acquires a read lock(rather than an access lock) during tptexport. This can ...

Pages