#DateForumTypeThreadPost
1729 Jul 2015 @ 04:20 PDTToolsReplyTPT - Instances Vs SessionsHello, What are the ways to identify the IO and network bandwidth?   Regards  
1614 Jul 2015 @ 02:29 PDTDatabaseReplyTASM ReportingHello Robert,   I am using the following query   SELECT wd.RuleName, ql.collecttimestamp(date), day_of_week(collecttimestamp), sum(ampcputime), COUNT(*) FRO...
1507 Jul 2015 @ 04:50 PDTDatabaseTopicTASM ReportingHello All, I am on TD 13.10 (VP 15) and would like to know whether we have any mechanishm to pull out the reports on TASM (like each workload CPU usage over the period of time).   Regards ...
1407 Jan 2015 @ 09:14 PSTGeneralTopicTASM and the user wise CPU % consumptionHello, Could you please help me understand more on deriving the % of CPU utilized by each application/user? TASM is configured and there is no CPU cap limit set . The application/users queries are...
1317 Dec 2014 @ 02:01 PSTToolsReplyTPT ODBC Operator Hello,   Thank you for your quick reply.   I have tried with Teradata native 32bit bit odbc driver but getting the following error   TPT_INFRA: TPT0103...
1216 Dec 2014 @ 06:19 PSTToolsReplyPT job with Oracle and Informix ODBC operator errorHi Feinholz, To be more specific, TPT and ODBC operator are only certified with 32 -bit ODBC drivers from Datadirect?   Regards      
1116 Dec 2014 @ 03:24 PSTToolsReplyTPT ODBC OperatorHello,   We are using TPT 13.1 and we are trying to connect to Oracle using ODBC_OPERATOR on AIX. Could you please confirm the following "Datadirect drivers need to be downloaded and i...
1003 Dec 2014 @ 06:49 PSTViewpointReplyUsing LDAP to create and authenticate Viewpoint usersHello Gary, I have configured the LDAP server on Viewpoint(13.10). The authentication is successfull but not able to login.The first name & last name is appearing as 'Unknown Given Name...
908 Oct 2014 @ 06:56 PDTDatabaseReplyInsert ASCII 222 valueHi Dieter, The ascii value is part of the string which i try to insert into a column. I can see the ascii 222 symbol in the input data.   Regards
808 Oct 2014 @ 05:19 PDTDatabaseTopicInsert ASCII 222 valueHello Team, I am trying to insert the ASCII value 222 to a teradata table but it is failing with 'untranslatable string conversion' error.   Table -  Column Charset is UNICODE ...
706 Mar 2013 @ 03:39 PSTToolsTopicColumn and Row separator in MultiloadHello All, I am getting a flat file with different delimiters for column and row. For an example abc,def,xyz] abc,def,xyz] abc,def,xyz] Column  delimiter is  comma (,) Row deli...
619 Dec 2012 @ 04:08 PSTDatabaseTopicFastload Lock Release without table recreate optionHello All,   I am on Teradata 13 version.I am looking for the options to release the fastload lock apart from dropping and creating the table . Can someone help me in releasing the...
524 Nov 2012 @ 04:17 PSTDatabaseTopicPPI ColumnsHello,   I need to extract the tablenames and its corresponding column names(on which PPI has defined) where PPI is used in the table definition. Any inputs on this please.   Regards
422 Oct 2012 @ 08:50 PDTDatabaseTopicSQLA 13.10.0.04 - Memory IssueHello All, The SQLA 13.10.0.04 is throwing the following error at random times and it is really very painful as it needs the whole SQLA to be restarted(closed and opened a new). It is really ...
311 Oct 2012 @ 03:57 PDTToolsReplySQL Assistant 13 Explorer View doesn't show all tablesHi Mike, Could you please advice on the below messages   SQLA Version: 13.10.0.4 System.AccessViolationException: Attempted to read or write protected memory. This is often an indication ...
208 Oct 2012 @ 02:32 PDTDatabaseTopicTo drop the stale statsHello,   I need to check whether stats defined on the tables are really used by the optimizer or just ignored. Since collect stats are more CPU consuming , need inputs on this to check ...
130 Jul 2012 @ 07:08 PDTDatabaseTopicHut Locks Notification Hello, We need a mail notification whenever we have a hutlock placed on the databases and would like to know the different ways to achieve the same. I have tried in Alert settings on Viewpoi...