#DateForumTypeThreadPost
1503 Mar 2014 @ 12:45 PSTGeneralReplyGet the Stored Procedure name currently executing you can verify all the queries that are currently being executed using the viewpoint or the performance monitor. if you want to know those which were executed today you can verify the DBQL ta...
1403 Mar 2014 @ 11:42 PSTViewpointReplySession expiration timeOn viewpoint under Admin>>viewpoint config>>General you have Session Timeout where you can set the session timeout.
1303 Mar 2014 @ 11:34 PSTViewpointReplyTDWM / TASM rule set changes/modifications ?in most of the TDWM tables you have the remove date and removetime columns. Also they have the created date and create time columns. the TDWM.RuleDefs table has the rule sets(RULEID) that are defin...
1203 Mar 2014 @ 11:24 PSTGeneralReplyInvalid Timestamp ErrorThere is nothing like DUMMY_table in Teradata. The below would give you the output. However the below format might not show up in SQL Assistant but you can see that when you are running in BTEQ Ei...
1103 Mar 2014 @ 09:44 PSTToolsReplyError in FastLoad ScriptFrom the error it appears that there is an issue with the source file /home.jugal/finsert.txt. The error says that there is a unexpected data format or a control character in an unexpected pos...
1028 Feb 2014 @ 02:10 PSTDatabaseReplyPrimary Index - for accessI do not think this would be  the only query that runs on this table and always that this join will be there in all the associated queries. if otherwise, then that should not be a ba...
928 Feb 2014 @ 12:11 PSTGeneralReplyunwanted space is coming in resulted export file usually the export results in a char format. Hence takes the  length of the column and replaces with blanks. Instead, try casting all the columns to varchar(max(length of that column)). Also t...
828 Feb 2014 @ 11:45 PSTDatabaseReplyGRANT optionAlso the level1 database needs to have select with grant on the level 0 else the intial select also will not work(from dblevel1 to dblevel0) in short select will be given to a user on a datab...
728 Feb 2014 @ 11:20 PSTDatabaseReplyGRANT option  In a normal scenario, the DBA's grant select access to a user on a view which directly points to a table but the table will not be given a direct access. The views usually are in a diff...
628 Feb 2014 @ 10:20 PSTDatabaseReplyUnused Secondary Indexes The below should give the space occupied by the secondary index on any table. First you need to collect demographics COLLECT DEMOGRAPHICS FOR databasename.tablename INTO qcd ALL;   &n...
527 Feb 2014 @ 12:14 PSTGeneralReplyerror: The format or data contains a bad characterPlease remove the bracket after -1 as bolded below and it should work fine on (a12.FiscalWeekID= cast(substr(a13.FiscalWeekId,1,4) as integer)-1||cast(substr(a13.fiscalweekid,5,2) as integer)). &...
427 Feb 2014 @ 09:59 PSTDatabaseReplyQuery HelpIf they are in 2 different tables having the same structure, then a minus between the current and the previous versions of the table will give the once added and the minus from the previous to the ...
327 Feb 2014 @ 08:57 PSTDatabaseReplysessions delayed due to throttlesDeepak, The delayed sessions can be identified by verifying the dbc.qrylogtdwm table where delaytime is not null. In some cases the delaytime can be 0. Based on the delaytime in the above, captur...
202 Dec 2013 @ 03:42 PSTDatabaseReplyLocking of the DBC tablesThanks Dieter
130 Apr 2013 @ 01:53 PDTDatabaseTopicLocking of the DBC tableswe have batch jobs running 24 hours. Through out the day there are fastload jobs using multiple users which include dropping and rebuilding the tables. Due to this there are locks on the dbc tables...

Pages