14 | 04 Feb 2013 @ 02:56 PST | carrie's blog | Teradata 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?
... |
13 | 22 Oct 2012 @ 10:25 PDT | keep it simple | Update on copy / move data between systems | For 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... |
12 | 21 Oct 2012 @ 05:12 PDT | keep it simple | Update on copy / move data between systems | Never 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... |
11 | 21 Oct 2012 @ 03:05 PDT | keep it simple | Update on copy / move data between systems | ok 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 ... |
10 | 19 Oct 2012 @ 02:57 PDT | keep it simple | Update on copy / move data between systems | Ulrich, correct me if I'm wrong. The tool works only if target table is empty right?
|
9 | 18 Oct 2012 @ 09:51 PDT | keep it simple | Update on copy / move data between systems | Sorry...i'm not coming to partners...but feel free to ask for a drink from the Charles Schwab contingent!!! |
8 | 18 Oct 2012 @ 07:27 PDT | keep it simple | Update on copy / move data between systems | :)....Just trying my luck!!!....Thanks a lot for the updated new version. |
7 | 17 Oct 2012 @ 06:47 PDT | Tools | Use Teradata Parallel Transporter to Move Data Without Landing the Data to Disk | Thanks feinholz. |
6 | 17 Oct 2012 @ 06:38 PDT | Tools | Use Teradata Parallel Transporter to Move Data Without Landing the Data to Disk | Great....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... |
5 | 17 Oct 2012 @ 06:26 PDT | Tools | Use Teradata Parallel Transporter to Move Data Without Landing the Data to Disk | So 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?
|
4 | 17 Oct 2012 @ 12:41 PDT | keep it simple | Update on copy / move data between systems | Thanks 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. |
3 | 17 Oct 2012 @ 12:39 PDT | Tools | Use Teradata Parallel Transporter to Move Data Without Landing the Data to Disk | So 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?
|
2 | 16 Oct 2012 @ 02:12 PDT | Tools | Use Teradata Parallel Transporter to Move Data Without Landing the Data to Disk | Feinholz, 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 ... |
1 | 16 Oct 2012 @ 11:35 PDT | keep it simple | Update on copy / move data between systems | Hi 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 ... |