#DateForumTypeThreadPost
9913 Sep 2007 @ 05:48 PDTDatabaseReplyArcmain RollforwardCorrection: "use restored journal" instead of current journal. Also, note that, by default, the restored journal is automatically deleted after the rollforward is complete. You can specify "no de...
9812 Sep 2007 @ 02:48 PDTDatabaseReplycollect stats programatically without use of dynamic SQL?From the messages reference manual:SPL1078: "%s:E(L%d), User is not authorized to use the DDL/DCL/Dynamic SQL statement."Explanation: The reason is that the creator and theimmediate owner of the st...
9710 Sep 2007 @ 06:11 PDTDatabaseReplyTeradata Demo ConfigurationHistorically, adding AMPs to the Teradata configuration has not been considered a customer activity. Unless the policy has changed recently, it is always performed by a Teradata field engineer, us...
9610 Sep 2007 @ 02:24 PDTDatabaseReplyJoin IndexJoe,Maintaining non-local indexes is more complex and expensive than local indexes, but that is true regardless of Multiload. I think Multiload's limitations have more to do with development prior...
9506 Sep 2007 @ 08:12 PDTDatabaseReplyJoin IndexTPUMP is really just a front end for standard SQL operators and does not have any of the limitations of Fastload and Multiload.Fastload and Multiload have these limitations mainly because a decisio...
9406 Sep 2007 @ 02:30 PDTDatabaseReplyJoin IndexThe load utilities (multiload and fastload) were simply not designed to maintain join indexes. The load utilities don't support a number of newer features (e.g., triggers, LOBs, RI). For tables t...
9305 Sep 2007 @ 01:55 PDTDatabaseReplywhat is cover indexWhile it is true that traversing a covered index may be faster than traversing the base table, I would think the more important value of a covered index comes into play when the index is used as an...
9204 Sep 2007 @ 09:39 PDTDatabaseReplyCharacter to Date & Date DifferenceThe system parameter called "Century Break" determines how the system interprets a 2-digit year. The default setting is 0, which causes all year values in 'yy' format to be converted to '19yy'. I...
9104 Sep 2007 @ 04:58 PDTToolsReplySQL Syntax CheckerThe method I use is simply to prefix the SQL statement with the word EXPLAIN. This will catch any syntax errors and verify that all the names referenced in the statement are valid.
9031 Aug 2007 @ 06:07 PDTDatabaseReplyHow teradata handles EBCDIC data?Character data is stored internally in the server character set that is designated for that column in the table definition (default is LATIN1, a superset of ASCII). The mapping of character and co...
8931 Aug 2007 @ 04:39 PDTDatabaseReplyDifferent query output between windows system and MVS system!!Unfortunately, there is no single accepted standard "newline" encoding in ASCII. Newline interpretation varies by OS, application, toolset, and display device. Some recognize LF as a newline; some...
8830 Aug 2007 @ 03:21 PDTConnectivityReplyArcmain and lockARCMAIN has a "group read lock" option that allows concurrency with updates, but it requires the user to define a permanent journal, which is archived along with the base table.Teradata 12.0, which...
8727 Aug 2007 @ 06:37 PDTDatabaseReplyPE and AMP are called VprocsCorrection: vproc stands for "virtual processor". In the earliest versions of Teradata, PEs and AMPs were specialized hardware components, each containing a CPU, peripheral connections, and softwa...
8617 Aug 2007 @ 05:44 PDTToolsReplysaving vprocmanager outputVprocmanager reads commands from stdin. Did you try redirecting stdin to a file?
8517 Aug 2007 @ 11:46 PDTDatabaseReplyreturning a reference from the method.Do you mean return a reference to an object in a table? No, only values are returned. The only way to change a value in an existing row in a table is with the SQL UPDATE statement.
8416 Aug 2007 @ 09:59 PDTDatabaseReplyConnection being reset systematicallyI think I've seen this before. You're getting an access violation when Teradata attempts to execute some generated machine code. (The other events in your log appear to be either unrelated or seco...
8316 Aug 2007 @ 02:06 PDTAnalyticsReplyHow can we Reverse a String in TeradataOr create a UDF.
8216 Aug 2007 @ 01:31 PDTToolsReplysaving vprocmanager outputOf course. Just execute it as a shell command. You can redirect stdin/stdout and/or execute it from inside a shell script.In Linux: /usr/tdbms/bin/vprocmanagerIn MP-RAS: /tpasw/bin/vprocmanagerIn ...
8114 Aug 2007 @ 07:03 PDTDatabaseReplyUDF performance.ALTER FUNCTION dbudfdev.is_integer EXECUTE NOT PROTECTED;In NOT PROTECTED mode, the UDF is loaded and executed directly bythe AMP worker threads.In PROTECTED mode (the default) the UDF is loaded an...
8013 Aug 2007 @ 01:40 PDTConnectivityReply[NCR][ODBC Teradata Driver][Teradata Database] Insufficient memory for a Concrete Step for this requestUsing a less ancient version of the Teradata Database might solve this problem. I believe p a r s e r memory management has been greatly improved in more recent releases.
7913 Aug 2007 @ 11:51 PDTDatabaseReplyByte(4) conversion?More precisely, 'x' indicates that the form of the literal is hexadecimal, and 'b' indicates that the data type is byte.
7802 Aug 2007 @ 04:07 PDTDatabaseReplyError: No more room in database DBCI assume you are creating tables in a user database, not in DBC. Database DBC contains only system tables. If it has no more room, it could be because either (a) not enough space is allocated to ...
7731 Jul 2007 @ 01:18 PDTDatabaseReplyQuery Probelm !!In other words, you want to expand a query expression into a regular time series. There is a book by Richard Snodgrass, "Developing Time-Oriented Database Applications in SQL" that may be helpful i...
7631 Jul 2007 @ 12:40 PDTDatabaseReplyCollection of statistics on DBC databaseUnless you regularly query dictionary tables, collecting statistics on them serves no purpose. The system-initiated dictionary retrievals that occur during SQL compilation do not benefit from stat...
7527 Jul 2007 @ 03:50 PDTDatabaseReplyWhat is meant by "SPOIL" in explain plan?There is a plan cache (usually called the "request cache"), but "spoil" is an operation on the dictionary cache, though it may have a secondary effect on the request cache as well. Spoiling insure...

Pages