#DateForumTypeThreadPost
20809 Jun 2016 @ 12:11 PDTDatabaseTopicStats Histogram Accuracy (USING MAXVALUELENGTH) How to identify which  values contained in the histogram for  statistics for column(s) that are occupying more than 25 bytes, as per Teradata 14.10 . Do I need to check the sum...
20716 Mar 2016 @ 12:15 PDTDatabaseTopicTD Stats Manager - error code 7504 I have scheduled an Analyse Job with with scope as custom object list and specified the database name.   Getting following error in StatsManager Portlet while scheduling sta...
20612 Mar 2016 @ 12:04 PSTDatabaseTopicAnlysing DBQLXMLTbl DataRecently we have enabled XML logging on our Teradata system.Found out some missing stats in the xmlplan:           <StatsMissing Importance="High"> ...
20511 Mar 2016 @ 08:32 PSTToolsTopicTeradata Metadata ManagerHas the Teradata Metadata Services been discontinued since TD 14.10? Where can I download it , if its available?  
20408 Mar 2016 @ 03:22 PSTDatabaseTopicRemoving all occurrences of Untranslatable CharacterI am using the following query to find out columns that have untransalatable characters: SEL msg, translate_chk (  msg using LATIN_TO_UNICODE) as pos  FROM Msgtbl WHERE pos<>0; ...
20309 Feb 2016 @ 08:02 PSTDatabaseTopicCapturing INS,UPD,DEL from DBQLObjTblI want to find the queryid associated when performing an INSERT,UPDATE,DELETE on a table,say TableA in the databasebase , using DBQLObjTbl. What will be conditions that need to applied on DBQLObjT...
20209 Feb 2016 @ 02:16 PSTDatabaseReplyAfter Initial BLC LoadingThanks Dieter:)
20107 Feb 2016 @ 04:20 PSTDatabaseTopicAfter Initial BLC LoadingAs space saving initiative, we are applying BLC on certain tables in our Teradata system. We are using queryband "SET QUERY_BAND='BLOCKCOMPRESSION=YES;' FOR SESSION;" to compress...
20001 Jan 2016 @ 03:37 PSTDatabaseTopicFastLoad Job LSNA fastload job is running.All  the sessions associated with the fastload job will have the same LSN in DBC.sessioninfo. How do I identify the control session for the fastload job?  
19919 Dec 2015 @ 06:47 PSTDatabaseTopicNested RolesWe are evaluting redundant access rights that are already mapped through roles.We have role groups, which are nested roles,these role groups are mapped to corresponding roles, which are assigned to...
19819 Dec 2015 @ 06:30 PSTViewpointTopicMonitor PartitionWe are getting alert- Check for a system hang on the monitor partition.  VP was unable to collect data for SQL Explain info. Is there any query to identify system is hung due to a particular ...
19727 Oct 2015 @ 07:14 PDTDatabaseTopicOrdering of values in a ColumnI have a column called Expressionlist, which contains comma separated list of values.I want to order the values in ascending alphabetical order of the values .For example, if the Expressionlist con...
19627 Sep 2015 @ 02:49 PDTDatabaseReplyResponseTimeMet in DBQL Hi Subramanian,   Thanks for the macro.I think the output from TDWM.TDWMSummary()  table function is  valid for that collection interval, which is typically 30 or 60 secon...
19526 Sep 2015 @ 10:18 PDTDatabaseReplyResponseTimeMet in DBQLSorry,don't have permission  there.
19426 Sep 2015 @ 08:21 PDTDatabaseReplyResponseTimeMet in DBQLHi Subramanian, We are using Teradata 14.10 and this macro does not come as part of DIP script in Syslib.Is this something that has been compiled by DBAs?In that case could you please help me with...
19323 Sep 2015 @ 09:48 PDTDatabaseTopicResponseTimeMet in DBQLResponseTimeMet indicates if the query met service level goals. I am querying on DBQLogTbl and found out the value as 'T' for some records and Blank for others. What is the meaning of bla...
19225 Aug 2015 @ 03:11 PDTDatabaseTopicAMP CPU SkewA query got aborted with TASM exception(3156 error code): Request aborted by TDWM. Exception criteria exceeded:   AMP CPU Skew. How is  AMP CPU Skew calculated?How can I troubleshoo...
19111 Jul 2015 @ 08:21 PDTDatabaseTopicUnderstanding BLC features I have few questions on BLC(Block Level Compression): a) Can a table be partially compressed using BLC and partially remain uncompressed?If this is true, how to know if  a table...
19001 Jul 2015 @ 09:56 PDTDatabaseReplyOptimizing Stats CollectionThanks Dieter! Collecting sample stats and multiplying the sampling percent with AMP numbers on the system willhelp.Is there any other way?Is it possible to use Object Usage Count(in TD 14.10) to g...
18928 Jun 2015 @ 10:09 PDTDatabaseTopicOptimizing Stats Collection Hi,   I have a huge table. I want to collect stats on a few important date fields in the table, which are used by business for reporting purpose. Even collecting full stats ...
18828 Jun 2015 @ 07:11 PDTDatabaseTopicPersonal Information IdentificationWhat is PII(Personal Information Identification)?How is customer confidential and sensitive data stored in Teradata ?What are the encryption algorithms , udfs used?
18716 Jun 2015 @ 11:04 PDTViewpointReplyARCMAIN jobThanks Glass
18619 May 2015 @ 02:17 PDTViewpointTopicARCMAIN job I am running an arcmain data copy, I see something like below in the arc/copy log file: 05/17/2015 20:13:00  ARC HAS REQUESTED 4 SESSIONS, TASM HAS GRANTED IT 38      ...
18504 May 2015 @ 09:54 PDTViewpointReplyViewpoint showing 'no data' for Disk SpaceThanks gryback!I checked the data collector for Total Disk Space in View Point and it was not enabled, which is the reason why the value is showing as "no data" in today's stats portl...
18426 Apr 2015 @ 10:22 PDTViewpointReplyViewpoint showing 'no data' for Disk Space"no data" is for total disk space in Total Statistics Portal, while others are having values.

Pages