#DateForumTypeThreadPost
8323 Mar 2014 @ 01:15 PDTDatabaseTopic *** Failure 2631 Transaction ABORTed due to deadlock.I am running a bteq script with a number of revoke statements. At some statement in the script, the revoke is getting stuck and failing with the following error:    *** Failure 2631...
8219 Mar 2014 @ 05:09 PDTViewpointTopicException IntervalWhat is the "Exception Interval" Setting in Viewpoint. What is an asynchronous Expection threshold and what is its use?
8112 Mar 2014 @ 08:07 PDTDatabaseReplycompression calculationsPlease refer below link for more information on compression and identifying and evaluating candidate tables for Compression: http://developer.teradata.com/extensibility/articles/block-level-compre...
8012 Mar 2014 @ 01:12 PDTDatabaseReplyHow to reduce duplicate Access Rights entries from Teradata database Access Rights can be granted directly or through Roles. The preferred way of giving access rights is though roles, as it is a better way of managing access rights(it saves space and improves query ...
7910 Mar 2014 @ 05:45 PDTDatabaseTopicUsing Resusage tablesHow can we use the Resusage tables to derive Resource utilization percentage(system wide)?
7820 Feb 2014 @ 08:14 PSTDatabaseReplyCompiling UDF with Object FileThanks Alexander for the answer and additional info:) One last question: Is it possible to do a SHOW FUNCTION if function is compiled using .o (object) file.  
7716 Feb 2014 @ 07:21 PSTDatabaseTopicCompiling UDF with Object FileWhile compiling UDF in Teradata, We place the .c program of the function in a folder and compile the function structure in Teradata specifying the file path in the EXTERNAL NAME part. How do ...
7611 Feb 2014 @ 05:17 PSTDatabaseReplyhow to get decimal value with no rounding1)You may cast the value as character,take the 2 digits after decimal(use position,String length functions) and again cast back to decimal(18,2)
7510 Feb 2014 @ 08:38 PSTDatabaseTopicAccount ID and Performance GroupIs there any system table in Teradata that contains the Account ID and the corresponding Performance Group(PG) mapping information?   Thanks, Kishore
7407 Feb 2014 @ 05:34 PSTDatabaseReplyTable ID and Table NameThanks Raja!It worked.
7306 Feb 2014 @ 07:49 PSTDatabaseTopicTable ID and Table NameDBC.TVM contains the tableid .Is there any dictionary table which can provide the information of the table name for the corresponding tableids? Thanks, Kishore  
7206 Feb 2014 @ 07:40 PSTDatabaseTopicIdentifying System Restart   How can one identify a system restart from DBC.Software_Event_LogV in Teradata? What is the event_tag value for this event?
7104 Feb 2014 @ 06:09 PSTDatabaseReplyFetching Account Info from DBC.DBQLRulesThanks Dieter:),it worked!!
7003 Feb 2014 @ 10:46 PSTDatabaseTopicFetching Account Info from DBC.DBQLRulesThe column account in DBC.DBQLRules is defined as  CAST(TRANSLATE(DBQLRuleTbl.AccountString USING UNICODE_TO_LOCALE WITH ERROR) AS CHAR(30)) I am able to see different accounts from DBC.DBQL...
6902 Feb 2014 @ 10:50 PSTDatabaseTopicTactical QueriesWhat type of logging should be enabled for queries in Tactical workload? Thanks
6829 Jan 2014 @ 02:38 PSTToolsReplyARC1900 ErrorThanks Raja for the link.
6728 Jan 2014 @ 09:32 PSTToolsTopicARC1900 ErrorWhile taking the backup of a table, got the following error:   Warning ARC1900: NO lock found:Lock on "Db"."TableName" released in the middle of the ArcMain Job. What do...
6603 Dec 2013 @ 10:04 PSTDatabaseTopicForced Log Off Session DetailsA session has been forced logged of by Admin User. The error that is being thrown when user tries to fire a query is : 08055 Session forced off by PMPC or xgtwglobal How to  get is the quer...
6516 Nov 2013 @ 12:34 PSTDatabaseTopicTwo Point CommitI have wriiten an update statement inside a BT-ET block.Now the update will be performed in all/some AMPs of the database table(based on filter condition).The update will fail, if any of the partic...
6415 Nov 2013 @ 10:49 PSTDatabaseTopicWho aborted the session/query?I want to know who aborted a particular query or session. Got a pointer towards same from Dieter's post in the forum, and query is: SELECT TheDate, TheTime, Event_Tag,   &nbs...
6315 Nov 2013 @ 05:59 PSTDatabaseTopicSpool Space UsageSpool space is used by user to store intermediate result of queries.They are released as and when a query finishes. I would like to know is there any way to track the spool space usage of a partic...
6205 Nov 2013 @ 04:48 PSTViewpointTopicExpedite WorkloadWhat is a expedite workload in TASM? How is it defined? Is there is resereved AWT pool for this type of workload?
6103 Nov 2013 @ 03:11 PSTViewpointTopicAWT Max LimitRecently there was a upgrade on the prod Teradata System and TD  Support increased the number of default AWT to some new value. Could you please help where can I get what is the new AWT limit...
6022 Oct 2013 @ 10:23 PDTDatabaseTopicSessionid in TeradataDoes Teradata parser(PE) generate sessionid s/sessionno sequentially? If so, what is the maxmum limit of sessionid  size? Does it resuse the numbers in a cyclic fashion once the upper limit ...
5909 Sep 2013 @ 12:28 PDTDatabaseTopicCost Profile InformationA cost profile is defined .I want to know the DIAGNOSTIC COMMAND associated with the cost profile. I tried finding the same in DBC.profileinfo. Though the name of the cost profile is present in t...

Pages