#DateForumTypeThreadPost
5213 Sep 2015 @ 11:17 PDTViewpointReplyIdentifying Data Lab expiration dates on the system tablesHi gryback, is there any table in teradata so that we can find expiry date in there. Otherwise we have to go one by one lab to find the expiry date.    
5110 Aug 2015 @ 07:37 PDTDatabaseTopichow to get the current_timestamp value in micro format like 11/08/2015 12:22:09.754321Hi All, when we execute below SQL statment we get output like 11/08/2015 12:22:09.750000. Evn our table Timestamp column have this format value.   Sel Current_timestamp;   we wa...
5007 Jul 2015 @ 12:31 PDTDatabaseTopicwhere does Volatile table Stats informtion storeHi All,   We can collect stats on Volatile tables(VT) but if the DBC does not contain any information for VT the where does this stats information store. Is there any table in dbc. ?  
4916 Jun 2015 @ 08:34 PDTDatabaseReplyFailure 9128 The transaction exceeded the maximum number of rowhash locks allowedHi Dieter, Write lock on table does not allow Hash Lock ? By default insert table has write lock and select table read lock. please elaborate how placing write lock on source table help in this i...
4815 Jun 2015 @ 08:06 PDTDatabaseTopicThe transaction was aborted by the user.HI All, I was restoring few tables. But some one has aborted the backup. I found in DBQL "The transaction was aborted by the user".   is there any way to find the user name or any...
4718 May 2015 @ 03:25 PDTDatabaseReplyHow can we find when was the maximum LOAD utilites (Fload/Mload/Fexport) were running.Hi Velu, Thanks for the response. still i am not able to find at what time maximum loads utilities were running in system. Please help how to use above quey output.  
4614 May 2015 @ 09:16 PDTDatabaseReplyStats Manager Issue during Analyze job :Unable to synchronize SystemId: 2 | id: 4 with Teradata on 'AnalyzeJob:5'!HI, Please check the table/database list. it may be possible that the list object does not exist now.  
4514 May 2015 @ 09:01 PDTDatabaseReplyHow can we find when was the maximum LOAD utilites (Fload/Mload/Fexport) were running.thnks Glass
4414 May 2015 @ 08:59 PDTDatabaseTopicStats Collection on table that is being used by PI column onlyHi ,   If a table is being accessed only by PI then do we we still require stats collection on the table. other question : if table is well distributed do we still need to collect stats on ...
4310 Apr 2015 @ 03:26 PDTDatabaseTopicHow can we find when was the maximum LOAD utilites (Fload/Mload/Fexport) were running.Hi all, We are facing issue like "Too many load/unload tasks are running" due to maximum utilies limit reached. but how can we find when or at what time maximum fastload/mload, exports w...
4223 Dec 2014 @ 09:31 PSTDatabaseReplyFallback Table Restriction in System Thanks Dnoeth.   but there is one DBS Control Parameter in Internal Group-113. This parameter has three values. But it is not fulfil my requirment as it help in fallback direction.
4123 Dec 2014 @ 09:27 PSTDatabaseReply(DBQL- DBC.Qrylog ) How to convert ELAPSEDTIME (HH:MM:SS.00) to Seconds yes, there is DBS Contraol Internal Group parameter-113.
4023 Dec 2014 @ 01:35 PSTDatabaseTopicTable Restoration Through DSA Issue : 1004 Hi All,   Please help on this below restoration through DSA. We are facing this issue. Please help   Error Code : 1004 Error Message : 1004: DSA DSMAIN-BARNC Commu...
3922 Dec 2014 @ 01:46 PSTDatabaseReplySelect Access Error in Procedure GRANT SELECT ON prd_DB.Prd_tbl TO PRD_RS_Hst ??   but still we are facing the same error msg
3822 Dec 2014 @ 01:11 PSTDatabaseReplySelect Access Error in Procedure its PRD_RS_Hst.      and procedure name :  PRD_RS_Hst.ETL_Rolbk
3722 Dec 2014 @ 12:48 PSTDatabaseTopicSelect Access Error in Procedure Hi All, We are running a procedure and getting an error :" ETL_Rolbk:user does not have SELECT access to prd_DB.Prd_tbl.prd_colmn" user has all the rights on the prd_db database.  ...
3611 Dec 2014 @ 02:53 PSTDatabaseReply(DBQL- DBC.Qrylog ) How to convert ELAPSEDTIME (HH:MM:SS.00) to Seconds Raja,   I Have one more doubt. Can we restrict users to create a fallback table in system ? can we restrict fallback table creation at user/database/system level ?
3511 Dec 2014 @ 01:31 PSTDatabaseReply(DBQL- DBC.Qrylog ) How to convert ELAPSEDTIME (HH:MM:SS.00) to Seconds Thanks Raja :)
3410 Dec 2014 @ 08:33 PSTDatabaseTopic(DBQL- DBC.Qrylog ) How to convert ELAPSEDTIME (HH:MM:SS.00) to Seconds Hi All,   just want to conver the elapsedtime (H:MM:SS.00) to Seconds. DBC.Qrylog has one column Elapsedtime but i want this value in seconds only.   Please suggest .
3308 Dec 2014 @ 01:09 PSTDatabaseReplyFallback Table Restriction in System Hi Experts, Any suggestion ??
3218 Nov 2014 @ 07:45 PSTDatabaseReplyCurrentperm more than Maxperm on one AMP for database Vpro  CurrentPerm MaxPerm 29  0.24  0.07 0  0.01  0.07 4  0.01  0.07 24  0.01  0.07
3118 Nov 2014 @ 07:42 PSTDatabaseTopicCurrentperm more than Maxperm on one AMP for databaseHi All,   We are facing an issue regarding some skew.   When we assign space to a database then this space get divide even to the all AMPs. So any amp has limited space for database. ...
3016 Nov 2014 @ 08:06 PSTDatabaseTopicWhat is the meaning of this partionHi All,   Please help me to clear the defination of below partition syntex. PARTITION BY CASE_N( EDW_END_TS = TIMESTAMP '9999-12-31 23:59:59.999999+10:00', NO CASE OR UNKNOWN); w...
2914 Nov 2014 @ 01:39 PSTDatabaseReplyTransaction aborted by Administrator or operation staff Raja, if you are talking about rewind option to go back and check, then there is nothing such information except it state i.e. abort.
2814 Nov 2014 @ 01:31 PSTDatabaseReplyLock on DBC.Accessright table and other Create/drop/Alter statement in Block stateHi Raja Itis recurring situation. @Todd- Its a appliance develpment box with sles-11 and TD 14.10.  

Pages