#DateForumTypeThreadPost
2418 Apr 2016 @ 11:40 PDTToolsTopicARC MultiStream & ARC Server QuestionsHi! I have some questions about the arcmain utility that I'm hoping someone could answer... I couldn't find documentation to specifically answer...   1. In order to use the "mul...
2312 Mar 2016 @ 08:19 PSTConnectivityReplyODBC.INI configuration with LDAP Authentication MechanismJust to let you know - you're not alone in that. I couldn't get the Linux ODBC drivers to actually use LDAP... gave up after a few days and resigned to just using local accounts for ODBC. I...
2210 Mar 2016 @ 09:08 PSTTeradata ApplicationsReplyMultiple sessions in FastloadFastload can only load one table per job. Increasing the sessions will generally increase the throughput of the load - the sessions can connect to multiple nodes to push data in parallel. All of th...
2109 Mar 2016 @ 08:39 PSTConnectivityReplyLDAP authentication - lockout and expiry1. I'm not sure if it is always the same, but in my environment, lockouts are controlled only through LDAP when connecting specifying LDAP as the authentication. Teradata won't even log a f...
2009 Mar 2016 @ 07:33 PSTDatabaseReplyUnion of tables with different columnsHmm... I didn't re-create the DDL so I could test, but I think the fix is fairly simple - I don't think it has anything to do with the union. You can run the two queries separately to confi...
1903 Mar 2015 @ 09:23 PSTDatabaseTopicMonitorSQLSteps Truncated?Hi all,   I understand that MonitorSQLSteps does not provide the full explain plan - this is fine. However, the text that it is returning is truncated. The definition of the function states ...
1803 Feb 2015 @ 11:55 PSTDatabaseReplyInconsistent CPU: ResUsageScpu vs ResUsageSpsApologies - I actually meant to say that CPUUExec is accurate, whereas CPUUServ is under reporting.
1703 Feb 2015 @ 11:50 PSTDatabaseTopicInconsistent CPU: ResUsageScpu vs ResUsageSpsHi all. We're working on creating operational reports to measure key metrics for Teradata 13.10. We typically use DBQL/Acctg to report on users and ResUsage tables for platform-wide metrics. &...
1605 Dec 2014 @ 12:11 PSTDatabaseTopicAcctg vs DBQL vs ResUsageHi all, We're looking at reporting on CPU usage and trying to understand the difference between the CPU metrics in each table. We have PDCR to archive the acctg table in hourly and daily ...
1523 Aug 2014 @ 08:37 PDTDatabaseReplyHow to fetch only month end dates from SYS_CALENDAR from Current dateI'm not sure if I am interpretting your scenario correctly...   CREATE MULTISET TABLE some_tbl AS (SELECT calendar_date AS SNAP_DT     FROM Sys_Calendar."CALENDAR...
1422 Aug 2014 @ 10:02 PDTDatabaseTopicDBQL Join EfficiencyHi all. We use PDCR to archive our DBQL tables - the primary index on the tables is (logdate,procid,queryid) and they are partitioned by logdate.   SELECT * FROM PDCRINFO.DBQLogTbl_Hst lo...
1311 Aug 2014 @ 10:29 PDTDatabaseReplyDetermine status on a given dateI used the following to recreate your example:   CREATE VOLATILE TABLE vt_stage_moves , NO FALLBACK , NO JOURNAL ( _date DATE, account_id INTEGER, oldValue CHAR(1), newValue C...
1211 Aug 2014 @ 01:10 PDTDatabaseReplyProfiles and WorkloadsSorry, I am not aware of any other solution. We are using TD 13.10. They may have changed the data model... no idea.   The main reason to join to the classify order table was to make it easi...
1111 Aug 2014 @ 12:53 PDTDatabaseReplyCursor in Dynamic SQLI believe it should work. Could you post the whole loop? Preferably in a code block :) (there is a code button).
1008 Aug 2014 @ 02:56 PDTDatabaseReplyProfiles and WorkloadsAt our site, there is a user in the database called TDWM that contains the configuration. It is not very straight-forward though.   SELECT * FROM tdwm.RuleQualifyCriteria rc INNER JOIN td...
906 Aug 2014 @ 07:29 PDTDatabaseReplyUser not listed in DBC.UsersVhttps://forums.teradata.com/forum/database/grant-select-on-dbc-users-for-typicall-user   DBC.UsersV shipped with the code of a typical "VX" view restricted to showing only the curr...
805 Aug 2014 @ 05:24 PDTDatabaseReplyWhy did the numeric value search in the varchar field fail; and a date format display questionPosting the DDL for your table would help as well as the error.   As for the date problem, I believe SQL Assistant has date formatting settings. Tools->Options->Date Format. It is proc...
705 Aug 2014 @ 05:16 PDTDatabaseReplyNeed metrics for database, table, and column usage in queries. TD 13.10/14.10http://www.info.teradata.com/htmlpubs/DB_TTU_13_10/index.html#page/Database_Management/B035_1093_109A/ch14.16.01.html   The two view you would probably be interested in are QryLog and QryLog...
605 Aug 2014 @ 04:57 PDTDatabaseReplyError while Granting Access RightPretty sure DROP PROFILE is a system-level access right. It is used to actually drop profiles from the system. In other words, it does not have an "ON" clause.   GRANT DROP PROFILE...
505 Aug 2014 @ 03:00 PDTDatabaseReplyHow to store queriesI'll start by saying that I have no experience with Access, so I do not know what a listbox is. However, views are intended to be queried. So, if you can specify query text and you needed to or...
405 Aug 2014 @ 01:16 PDTDatabaseReplyLooping in a rowI'm assuming you are using a stored procedure. I'm not familiar with the WHILE loop syntax, but I may be able to point you in the right direction. You can use a FOR loop to loop through ea...
305 Aug 2014 @ 11:17 PDTDatabaseReplyPDCR DBQL NULL values for WDID,OpEnvName,SysConNameAh, I forgot a vital piece of info - the database version is 13.10.07.27
205 Aug 2014 @ 11:07 PDTDatabaseTopicPDCR DBQL NULL values for WDID,OpEnvName,SysConNameHi all. I have a requirement to generate reports based on our operating windows via DBQL. As the operating windows are subject to change, I would like to use the OpEnvName field that is populated v...
108 Jul 2014 @ 06:14 PDTDatabaseReplyCASE statement inside Store ProcedureI just encountered the same problem and found this thread via Google. I suspect the version of Teradata you are using has something to do with it - my site is using 13.10.07.27. I found that when ...