All forum activity

#DateUserForumTypeThreadPost
5794222 Jun 2016 @ 01:02 PDTJohannes VinkAnalyticsReplyCPU disk ratio error from 'like' statementsProbably the like statements results in a full table scan and thus a high io/cpu estimate. Here the effect is a bit explained: http://www.dwhpro.com/teradata-indexing-2/
5794122 Jun 2016 @ 12:46 PDTCarlosALToolsReplyNeed Help regarding TPT ODBC OperatorHi Steve. I've been using the bundled DD drivers (_tora27) on TPT with ODBC operators with the "warning window / disclaimer" appearing on each execution, but working O...
5794022 Jun 2016 @ 12:02 PDTstami27ToolsReplyTPT Work/error Tables always protected (FALLBACK) ?Hello TD TPT experts/connoisseurs: it would be posible for someone of you to give a comment on my question above? Thanks in advance!
5793921 Jun 2016 @ 09:36 PDTFredTeradata StudioReplyTeradata Studio does not show all of my authorized tables-You can right-click on the "Databases" folder and use Teradata / Set Root rather than having to navigate down the tree.
5793821 Jun 2016 @ 09:31 PDTFredToolsReplyNot able to download SQL AssistantIt's part of the TTU - Windows Install package here on this site. Or get it from T@YS. http://downloads.teradata.com/download/tools
5793721 Jun 2016 @ 09:20 PDTFredDatabaseReplyBteq-import- Error Handling Not workingThe .IF command can only test the results of the most recent SQL statement (ERRORCODE, ERRORLEVEL, or ACTIVITYCOUNT), not other BTEQ commands. You apparently meant to .SET ERRORLEVEL 3807 SEVERITY...
5793621 Jun 2016 @ 07:31 PDTSunny445DatabaseReplyBteq-import- Error Handling Not workingI used a query to find the activity count of the table and if activity count is 0 then I set it to exit out. Is there any better solution t catch the error after the import failed
5793521 Jun 2016 @ 05:43 PDTboagus1DatabaseTopicIdentifying which column is throwing error on INSERT SEL REPAIRABLE, 'TRUE' from T2 WHERE   REGEXP_INSTR(TRIM(REPAIRABLE ), '^[-+]?([0-9]+(\.[0-9]*)?|\.[0-9]+)$')  = 1 ORDER BY 1 DESC 3535 : A character string fai...
5793421 Jun 2016 @ 04:54 PDTToddAWalterAnalyticsReplyCPU disk ratio error from 'like' statementsPlease share the error code and message being received? It sounds like a workload management rule that the system/performance administrators have put in place. There are no system limitations aroun...
5793321 Jun 2016 @ 04:46 PDTmhusseyTeradata StudioReplyTeradata Studio does not show all of my authorized tables-Yeah, that was a good suggestion. I think I have figured out what is going on.. It seems like Teradata Studio is for some reason, going all the way to the root of the database I am connected to. Di...
5793221 Jun 2016 @ 03:09 PDTmikeyb100Teradata StudioReplyIssue Downloading Studio even After Java installedThat worked, you rock! 
5793121 Jun 2016 @ 03:08 PDTsnreyesAnalyticsTopicCPU disk ratio error from 'like' statementsWe are parsing out URL strings in code and are receiving a CPU disk ratio error message.  Can someone help identify the major contributors to CPU disk ratio error?   The below are all i...
5793021 Jun 2016 @ 02:53 PDTfgrimmerTeradata StudioReplyIssue Downloading Studio even After Java installedFor Mac OSX, it requires the JDK to be installed, not just JRE. Can you check if you have installed the JDK 1.7 or 1.8?
5792921 Jun 2016 @ 02:48 PDTfgrimmerTeradata StudioReplyTeradata Studio does not show all of my authorized tables-How about if you change the TMODE setting in the JDBC properties from ANSI to TERA? I had someone with a similar issue and it turned out that the queries were using Views not Tables and changing th...
5792821 Jun 2016 @ 02:20 PDTmhusseyTeradata StudioReplyTeradata Studio does not show all of my authorized tables-The tables were set to V, I changed them to VX after reading your message before, and I have since set them to be V. I don't see the [Filtered], so I don't believe it's an issue of fil...
5792721 Jun 2016 @ 01:57 PDTsrivigneshknToolsReplyTPT RestartabilityThanks Steve, that works.   Alternatively i started executing the TPT scripts with the job name as argument and later delete the logs and checkpoints created by the tpt scripts. $TPT_PATH/t...
5792621 Jun 2016 @ 01:42 PDTshiboo18AsterReplyERROR: SQL-MR function TEXT_PARSER failed: Loading stop word file /stopwords_en.txt failed.Well I found the solution - I did not have to store the stop word file in AFS instead I needed to install it. Steps to install : 1. Login to the database 2. Use the following command - \i...
5792521 Jun 2016 @ 01:37 PDTfeinholzToolsReplyTPT RestartabilityUse the -s 1 command line option. It forces the job to delete the checkpoint restart files and start from the first job step. There is no script command. And you HAVE to delete the checkpoint re...
5792421 Jun 2016 @ 01:22 PDTGauthJesToolsReplyNot able to download SQL AssistantWhere is the downlaod link to SQL Assistant?
5792321 Jun 2016 @ 01:18 PDTfgrimmerTeradata StudioReplyTeradata Studio does not show all of my authorized tables-Mitch, That is probably because you changed the Views to VX. I think you should stick with using the 'V' views. VX views are more restrictive as you only see what you are authorized to see ...
5792221 Jun 2016 @ 12:51 PDTmhusseyTeradata StudioReplyTeradata Studio does not show all of my authorized tables-Francine, Thank you for your recommendations. I tried changing the Datatools Preference to be VX, but that didn't change anything. I don't have anything cached on the database either. I w...
5792121 Jun 2016 @ 12:48 PDTToddAWalterDatabaseReplyCOLUMNAR TABLE- SELECT TOP N* FROM COLUMNAR TABLE NOT GIVING OUTPUTIf you or someone at you site has access to Teradata support, please open an incident for this.
5792021 Jun 2016 @ 12:40 PDTRm186079DatabaseReplyQuery optimization issuea simple insert select is taking 56 mins for 5m rows. stats are collected on doing show sel * its showing create join index on certain table and stats are not collected on that table(join index) ...
5791921 Jun 2016 @ 12:35 PDTshiboo18AsterReplyLoading XML files in AsterI know I am late to answer this question. But hopefully, this will help people in future. Two steps: 1. Create a table  CREATE TABLE TEST( xid int, xml varchar); 2. Format the x...
5791821 Jun 2016 @ 12:22 PDTmadhav6973Teradata StudioReplyConfiguration errorThank You Fgrimmer!  TeradataStudioExpress.exe -configuration C:\Temp\newconfig -data C:\Temp\newworkspace  (worked)    

Pages