#DateForumTypeThreadPost
97114 Apr 2016 @ 10:14 PDTGeneralReplySet tenacity and sleep in Tearadata JDBCFor Teradata utilities, it is generally recomended to use Utility Throttles rather than the old Tenacity / Sleep approach.   If you require similar behavior, the JDB...
97014 Apr 2016 @ 08:01 PDTDatabaseReplyPerformance - Steps in die Execution Plan differs massiv from the real executionFor queries with the same ProcID, are you seeing the CacheFlag sequence S-G-T (Specific, Generic, Cached generic) where the G and T perform badly? Check Carrie's article on "peek...
96913 Apr 2016 @ 06:08 PDTGeneralReplyTimestamp Error - Code:6760 TPTAPI requires that TIMESTAMP data be passed as a character string. For TIMESTAMP(0) use 'yyyy-mm-dd hh:mi:ss' format.
96813 Apr 2016 @ 05:58 PDTViewpointReplyERROR: Unable to start viewpointIs your system clock really set to April 2012? Or is that just an old log message that was left when the VM image was built.  
96712 Apr 2016 @ 03:25 PDTDatabaseReplyIdentity column question - increment behaviourFor single-row INSERTs, the PE obtains the next identity column value. For load or INSERT/SELECT, which potentially can involve many rows, the AMPs each obtain a "batch" of numbers a...
96611 Apr 2016 @ 01:18 PDTDatabaseReplyActive Directory on Teradata Review the Security Administration Guide for your database software version, for more information regarding how to implement Kerberos authentication and directory-based authorization. Ne...
96511 Apr 2016 @ 01:08 PDTCloud ComputingReplyTeradata Express+VMware with Windows10?The Teradata Express database downloads are Linux virtual machine images. To run the virtual machine, you need to install a compatible "player" on your host system (which could be Windows...
96407 Apr 2016 @ 03:40 PDTDatabaseReplyActive Directory on Teradata Could you provide more information on what you are trying to accomplish? We would not "install" directory server software on a Teradata database node.
96306 Apr 2016 @ 12:29 PDTDatabaseReplyDBC.ResUsageSpma - AMPs per NodeIt does appear that at some point 1-05 was down and VProcs migrated to 1-02. You could filter your ResUsage query based on date/time to see if that state is recent or just historical.   ...
96206 Apr 2016 @ 12:19 PDTDatabaseReplyFormulae to calculate total available CPU Seconds per DayThe 6800H has 2 processors x 14 cores x 2 hyperthreads = 56 "virtual CPUs" per node, unless some cores are disabled intentionally. PMCOD capacity multiplier is important for underst...
96105 Apr 2016 @ 08:28 PDTDatabaseReplyExclude databases from TARA job backupEXCLUDE ("DBC"),("ALL"),("PUBLIC"),("DEFAULT"),
96005 Apr 2016 @ 08:24 PDTDatabaseReplyconvert integer value to binaryInteger math also works in simple cases, and is faster.   23 MOD 8 = 7 You didn't specify whether you are adding the zeros on the left or right for the other case, but 23 / 8 = 2 or...
95901 Apr 2016 @ 05:30 PDTDatabaseReplyFormulae to calculate total available CPU Seconds per DayThat calculation may be correct for some system, but definitely not for a 6800 nor for PMCOD
95831 Mar 2016 @ 02:22 PDTDatabaseReplyHow PDE increase Teradata performance?PDE doesn't create hyperthreads, and doesn't boost performance. Teradata's optimizer and architecture are designed to maximize parallelism automatically. See the "Introduction to ...
95731 Mar 2016 @ 02:13 PDTDatabaseReplyInaccurate Space accountingPerhaps someone neglected to end online archive logging, e.g. after a backup job failure. Check dbc.ArchiveLoggingObjsV
95631 Mar 2016 @ 02:00 PDTDatabaseReplyFormulae to calculate total available CPU Seconds per DayA 6800H node has two E5-2697 V3 processors with 14 cores each and 2 pipelines per core. That would make your multiplier 56 per node not 32. Some of those CPU cycles will be consumed by the OS, so ...
95529 Mar 2016 @ 03:12 PDTDatabaseReplyHow PDE increase Teradata performance?PDE is a virtualization layer between the operating system and the DBMS and is an important part of the Teradata architecture. But it doesn't magically provide higher capacity. Hyperthrea...
95429 Mar 2016 @ 02:50 PDTDatabaseReplyUDF Default DatabaseLike TD_SYSFNLIB, SYSLIB gets searched by default and contains some system-supplied functions. Unlike TD_SYSFNLIB, you can potentially add your own functions to SYSLIB.     Bu...
95329 Mar 2016 @ 02:39 PDTDatabaseReplyTable size are different from DEV to PRODIt's likely that DEV has block-level compression enabled by default, while PROD does not. Block compression reduces space and I/O at the expense of increased CPU consumption. Talk with your DB...
95228 Mar 2016 @ 08:27 PDTDatabaseReplyPermanent journal Since you didn't specify a journal table name in the CREATE TABLE, it will use the default journal table for the database in which the table is defined.   You can use MODIFY DATABA...
95127 Mar 2016 @ 04:16 PDTConnectivityReplyCannot connect to database using Linux Teradata client 15.10The ODBCINST file for the driver manager maps the driver name Teradata to the actual tdata.so library. But if ODBCINST isn't set, the driver checks the ODBCINI file [ODBC] ...
95027 Mar 2016 @ 03:39 PDTDatabaseReplyOnline backup performance1. DSA (online or not) does not copy objects to spool. 2. Online backup journals changes to a PermSpace subtable for each table being backed up. Search the documentation for "online arch...
94927 Mar 2016 @ 02:57 PDTTeradata ApplicationsReplyT-PUMP DML ERRORRemove the semicolon between BEGIN LOAD and the load options.
94825 Mar 2016 @ 11:38 PDTDatabaseReplyDate prompt in Pass Through QueryThis is not a Teradata question. You might have better luck in a MS Access forum. SQL Assistant recognizes the ?mydatevar as a named parameter and generates the prompt. Access does something simil...
94720 Mar 2016 @ 11:52 PDTToolsReplyTPT load failure - Please suggestThe Teradata-branded Progress DataDirect ODBC drivers are installed with TPT-Base 15.00.00.02 and later eFix (patch) levels and as part of the initial release for 15.10. There is no addit...

Pages