#DateForumTypeThreadPost
4916 Feb 2007 @ 02:37 PSTDatabaseReplyAdding two new nodes / PPI considerationsAdding nodes should be relatively painless and transparent to your applications. The Teradata servers are designed from the ground up to be easily expandable. All the details of integrating the n...
4813 Feb 2007 @ 01:24 PSTDatabaseReplyTeradata DWH on an Intel Itanium2 platform.Teradata does not support any IA-64 platform. X8664 is our 64-bit platform of choice. Native X8664 versions of the Teradata Database are currently available for SUSE Linux and Windows Server 2003.
4702 Feb 2007 @ 02:16 PSTDatabaseReplyDrop DatabaseFrom your message on another thread, I take it that you mean "suspended" in the sense that the table is a member of a replication group that is in the suspended state. A table cannot be dropped wh...
4601 Feb 2007 @ 11:27 PSTDatabaseReplyAccessing Row Hash of a recordThere is a HASHROW built-in function. Read about it in the "SQL Reference: Functions and Operators" manual (chapter 12 in the V2R6.2 edition). HASHROW returns the row hash value for a given set of...
4501 Feb 2007 @ 11:04 PSTToolsReplyReplication Group SuspendedYou need to terminate the group before you can drop it.
4430 Jan 2007 @ 05:26 PSTDatabaseReplySpool Question1. When 5 GB is exceeded on any AMP.2. 20 GB total (20/4 GB per AMP).
4330 Jan 2007 @ 05:14 PSTToolsReplyTeradata Administrator - Access Logging optionYou need to run DIP and then select the DIPACC option from the menu. This will create the necessarymacros and views. Then you need to do a DBS restart before you can start access logging.For furt...
4215 Jan 2007 @ 01:26 PSTDatabaseReplyLock InformationI suggest that you read about the Lock Display and Locking Logger utilities in your utilities refererence manual.
4110 Jan 2007 @ 02:24 PSTDatabaseReplyPerfomance for Interpretive vs ExecutableEVL is the Teradata expression evaluator component. Its purpose is to evaluate SQL conditional expressions (e.g. a WHERE clause) or value-producing expressions (e.g. a SET expression in an update ...
4015 Dec 2006 @ 02:27 PSTDatabaseReplyLength of IntegerThe length of an integer is always 4 bytes (32 bits).
3907 Dec 2006 @ 01:10 PSTDatabaseReplyTeradata crash with auto-restartYou are using an ancient version of Teradata. The current release is 6.2.0.0. Perhaps you have encountered a bug that was fixed in a later version. You should contact the Teradata support center...
3817 Nov 2006 @ 02:03 PSTDatabaseReplyHash IndexA hash index is simply a restricted form of join index. It was introduced mainly to satisfy some rules in the TPC-H benchmark specification that did not allow regular join indexes.The syntax for c...
3716 Nov 2006 @ 08:43 PSTToolsReplySpace required for a Multiload JobSee chapter 2 of the MultiLoad Reference for a full discussion of disk space usage. Depending on the number of target tables and usage of optional features (fallback, permanent journals, etc.) the...
3630 Oct 2006 @ 01:50 PSTUDAReplyETL CLOB from Oracle to TeradataThe Teradata load utilities (BTEQ, Fastload, Multiload) currently do not have good support for LOBs. The best-supported interfaces for loading LOB data are the open APIs (ODBC, JDBC). If Informat...
3527 Oct 2006 @ 12:34 PDTDatabaseReplyStoring and accessing large objects ( CLOB/BLOB)The open APIs (e.g., ODBC, JDBC) are your best bets. Unfortunately, none of the Teradata load utilities support large object data.
3420 Oct 2006 @ 05:44 PDTDatabaseReplySupport for generating unique sequence numbersTeradata provides the standard (SQL:2003) IDENTITY attribute for columns.An identity column has, as a default value, an automatically generated unique number. This can usually serve as a satisfact...
3316 Oct 2006 @ 07:55 PDTUDAReplyfastloadFastload doesn't have worktables.
3216 Oct 2006 @ 07:47 PDTDatabaseReplyPopulating into CLOB ColumnYou might get a more helpful response if you post your BTEQ script and tell us what versions of BTEQ and the Teradata Database you are using. Also, please describe how you constructed the file you...
3111 Oct 2006 @ 08:26 PDTDatabaseReplyHow to find out the table create date?Perhaps a query like this is what you want:-- List all tables that have been created or altered within the last 10 daysselect DatabaseName, TableName, LastAlterTimeStampfrom dbc.tableswhere LastAlt...
3011 Oct 2006 @ 01:15 PDTDatabaseReplywhether row hash changes when new nodes or Amp added?The hash map is recomputed when the AMP configuration changes, but the hashing function itself is independent of the configuratiion. In other words, row hash values do not change.
2909 Oct 2006 @ 09:23 PDTDatabaseReplyIs there any way to select "ROWID" of a record?I don't think "select rowid" is supported in recent releases. I vaguely recall that, even in releases that allowed it, rowid could not be referenced in a search condition.To remove duplicate rows,...
2806 Oct 2006 @ 02:01 PDTUDAReplyCompiling Stored Proc - VC++ not installed errorI am not familiar with the demo. It may not have the same features as the regular product. Try opening the Database Window program, then go to the supervisor command window and enter "start cufcon...
2704 Oct 2006 @ 07:17 PDTUDAReplyCompiling Stored Proc - VC++ not installed errorIf you installed the C++ compiler after you installed Teradata, you will need to update the "CompilerPath" and "LinkerPath" settings in the Teradata UDF/TSP configuration record. The simplest way ...
2611 Aug 2006 @ 03:49 PDTDatabaseReplyTeradata and near-line storageNo, not currently.
2507 Jun 2006 @ 08:22 PDTConnectivityReplyExtended Stored Procedure to send mailIf all of your nodes have PEs, and the session that calls the SP can be hosted by any PE, then the answer is yes.

Pages