208 | 09 Jun 2016 @ 12:11 PDT | Database | Topic | Stats 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... |
207 | 16 Mar 2016 @ 12:15 PDT | Database | Topic | TD 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... |
206 | 12 Mar 2016 @ 12:04 PST | Database | Topic | Anlysing DBQLXMLTbl Data | Recently we have enabled XML logging on our Teradata system.Found out some missing stats in the xmlplan:
<StatsMissing Importance="High">
... |
205 | 11 Mar 2016 @ 08:32 PST | Tools | Topic | Teradata Metadata Manager | Has the Teradata Metadata Services been discontinued since TD 14.10?
Where can I download it , if its available?
|
204 | 08 Mar 2016 @ 03:22 PST | Database | Topic | Removing all occurrences of Untranslatable Character | I 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;
... |
203 | 09 Feb 2016 @ 08:02 PST | Database | Topic | Capturing INS,UPD,DEL from DBQLObjTbl | I 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... |
202 | 09 Feb 2016 @ 02:16 PST | Database | Reply | After Initial BLC Loading | Thanks Dieter:)
|
201 | 07 Feb 2016 @ 04:20 PST | Database | Topic | After Initial BLC Loading | As 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... |
200 | 01 Jan 2016 @ 03:37 PST | Database | Topic | FastLoad Job LSN | A 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?
|
199 | 19 Dec 2015 @ 06:47 PST | Database | Topic | Nested Roles | We 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... |
198 | 19 Dec 2015 @ 06:30 PST | Viewpoint | Topic | Monitor Partition | We 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 ... |
197 | 27 Oct 2015 @ 07:14 PDT | Database | Topic | Ordering of values in a Column | I 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... |
196 | 27 Sep 2015 @ 02:49 PDT | Database | Reply | ResponseTimeMet 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... |
195 | 26 Sep 2015 @ 10:18 PDT | Database | Reply | ResponseTimeMet in DBQL | Sorry,don't have permission there.
|
194 | 26 Sep 2015 @ 08:21 PDT | Database | Reply | ResponseTimeMet in DBQL | Hi 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... |
193 | 23 Sep 2015 @ 09:48 PDT | Database | Topic | ResponseTimeMet in DBQL | ResponseTimeMet 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... |
192 | 25 Aug 2015 @ 03:11 PDT | Database | Topic | AMP CPU Skew | A 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... |
191 | 11 Jul 2015 @ 08:21 PDT | Database | Topic | Understanding 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... |
190 | 01 Jul 2015 @ 09:56 PDT | Database | Reply | Optimizing Stats Collection | Thanks 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... |
189 | 28 Jun 2015 @ 10:09 PDT | Database | Topic | Optimizing 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 ... |
188 | 28 Jun 2015 @ 07:11 PDT | Database | Topic | Personal Information Identification | What is PII(Personal Information Identification)?How is customer confidential and sensitive data stored in Teradata ?What are the encryption algorithms , udfs used?
|
187 | 16 Jun 2015 @ 11:04 PDT | Viewpoint | Reply | ARCMAIN job | Thanks Glass
|
186 | 19 May 2015 @ 02:17 PDT | Viewpoint | Topic | ARCMAIN 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
 ... |
185 | 04 May 2015 @ 09:54 PDT | Viewpoint | Reply | Viewpoint showing 'no data' for Disk Space | Thanks 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... |
184 | 26 Apr 2015 @ 10:22 PDT | Viewpoint | Reply | Viewpoint showing 'no data' for Disk Space | "no data" is for total disk space in Total Statistics Portal, while others are having values.
|