#DateWhereItemComment
3410 Apr 2015 @ 01:58 PDTToolsWhat's new in Teradata SQL Assistant 15.0one feature that I particularly do not like since SQL assistant 13 is that queries are checked for syntax before it is submitted to database. It is a feature that makes sense for most cases , howev...
3316 Apr 2012 @ 11:15 PDTToolsWhat's new in Teradata SQL Assistant 14.01interesting feature . favorites is nice. however, once added, how to remove/edit it?
3221 Mar 2012 @ 07:10 PDTToolsTeradata Parallel Transporter Supports Quoted VARTEXT in TTU14.00Thanks for the prompt reply... unfortunately, the source data is coming out of DB2 extracts, during which the db2 export facility default "doubling" the delimiter. the utility does not have capabil...
3119 Mar 2012 @ 12:40 PDTToolsTeradata Parallel Transporter Supports Quoted VARTEXT in TTU14.00Hi, we recently get the tpt14.0 installed and testing out the features of quoted delimited file. However, I am having trouble to deal with "escape" feature by "doubling". The data looks like "good...
3017 Oct 2011 @ 11:02 PDTAccomplishing tasks when you don't know where to start.Using a named pipe archive to copy a database from one system to anotheryup.. cluster backup is the way to go in such case.. I am trying to use all-amp backup, which could take advantage of the amp-local archive features available today to save some By-net traffic and ...
2917 Oct 2011 @ 10:52 PDTAccomplishing tasks when you don't know where to start.Using a named pipe archive to copy a database from one system to anotherJJcrum, thanks for the suggestion. I understand that multiple objects can be separated via multiple jobs across multiple unix boxes. I have been doing that quite a while. The difficulty comes to ve...
2817 Oct 2011 @ 09:06 PDTAccomplishing tasks when you don't know where to start.Using a named pipe archive to copy a database from one system to anotherTeradata's Nparc is doing that (with multiple multiple name pipes in between). older tools like CMS (conterminous migration tool) is doing that too. Name pipe do have one limitations, it all we...
2707 Sep 2011 @ 01:27 PDTToolsTeradata Parallel Transporter “Buffer Mode” for Data Extraction and Loadingthe -h option controls the share memory (13.10 doc). however, the doc does not show the other parameters . where to configure such behavior? Is there a configuration file that we can tweak the a...
2623 Jun 2011 @ 07:40 PDTcarrie's blogTwo Levels of Concurrency Control for Load Utilities in Teradata 13.10it was introduced when TDWM made its way into V2R62. long time;)
2514 Jun 2011 @ 08:52 PDTcarrie's blogNumber of AMP Worker Tasks used by Archive UtilityCarrie, thanks for the information. I know traditionally, priority scheduler does not regulate hwo the Data Session for arcmains. those data sessions were ketp knocking down by SQL sessions. After ...
2411 Jun 2011 @ 08:05 PDTcarrie's blogNumber of AMP Worker Tasks used by Archive UtilityCarrie, i do have an interesting observation of a particular job that we had here to backup a 65TB non-fallback table. i am wondering whether you can provide more insight for me from the AWT perspe...
2331 May 2011 @ 07:44 PDTToolsLogging On Teradata Database Sessions via BTEQdbc.dbase databaseid dbqlogtbl contains actual user name and user id.. help table dbc.dbqlogtbl;
2219 Apr 2011 @ 07:30 PDTToolsLogging On Teradata Database Sessions via BTEQhow to use windows credential to logon (assuming kerbros setup is done in DBS)
2119 Apr 2011 @ 07:25 PDTcarrie's blogTwo Levels of Concurrency Control for Load Utilities in Teradata 13.10Utility throttle will recognize database/table combinations, workload definition does not have option to define database/tables. so.. to limit the sandbox users, utility throttle should be defi...
2011 Apr 2011 @ 01:31 PDTViewpointTeradata Viewpoint 13.11 releasedgreat!!! saw it now, thanks !!! i am getting too old when buttons are moving around!
1908 Apr 2011 @ 02:31 PDTViewpointTeradata Viewpoint 13.11 releasednow, this version of viewpoint killed that tool button on the sesion monitor widget V13.11.00.04-b59 that makes aborting multiple session impossible. if I want to abort a group of sessions (lik...
1811 Mar 2011 @ 01:14 PSTDatabaseTeradata Express 13.10 for VMware PlayerResolved. rm /var/opt/teradata/tdtemp/PanicLoopDetected then tpa start.. all good now
1708 Mar 2011 @ 10:20 PSTDatabaseTeradata Express 13.10 for VMware Playerwell.. I verified the md5. looks good to me. still not luck to start tpa.
1621 Feb 2011 @ 08:07 PSTDatabaseTeradata Express 13.10 for VMware Playerseriously.. the TPA wont start from this download.
1518 Feb 2011 @ 11:27 PSTToolsUse Teradata Parallel Transporter to Move Data Without Landing the Data to Diskgreat! that solves all my questions! Feiholz, you rock!
1418 Feb 2011 @ 11:11 PSTToolsUse Teradata Parallel Transporter to Move Data Without Landing the Data to Diskalso one interesting point to put out there is that the load operator will only help the aquisition phase, rather than application phase. Is that a correct understanding?
1318 Feb 2011 @ 11:11 PSTToolsUse Teradata Parallel Transporter to Move Data Without Landing the Data to Diskfeinholz, thanks for the detail answer for the reader and loader. I do want a little drill down into the loader. It looks to me that the update loader (consumer) still logon as a single mload job ....
1218 Feb 2011 @ 09:30 PSTToolsUse Teradata Parallel Transporter to Move Data Without Landing the Data to DiskTony, I do have a question in regarding to TPT instance count parameter. Can you help? Who can explain TPT instance count and its details In TPT apply clause, you can specify number of instances ...
1111 Feb 2011 @ 08:10 PSTRobG's blogUsing INTERVAL to Add or Subtract Fractional Seconds to or from TIMESTAMP Valuesso.. another undocumented feature ??? LOL..
1011 Feb 2011 @ 08:05 PSTDatabaseTeradata Express 13.10 for VMware Playertried this version, after run /etc/rc.d/tpa start pdestate -a shows down status where would I find the error log >?

Pages