99 | 17 Nov 2015 @ 07:29 PST | General | Reply | Need Help with DBQL query to find top 10 queries with high cpu usage | Hi Sangeetha,
The below query gives the top 50 queries; please modify it according to your needs; (courtesy Akos Levoi)
select top 50
ProcID
, QueryID
, AMPCPUTime
, ... |
98 | 16 Nov 2015 @ 08:38 PST | Viewpoint | Topic | How to setup bteq, program, sending email on VMWare 15 | Greetings Experts,
I have downloaded and installed the TDExpress15.00.01_Sles10_40GB_vp on VMware-player-7.1.0-2496824
I am trying to setup alerts for sending email. ... |
97 | 06 Nov 2015 @ 08:31 PST | Database | Topic | SQL Aggregation logic - Not sure |
Greetings Experts,
I am implementing the multiple separate logics between 2 tables by joining them in a view. I need to have minimal number of views with all logics implemen... |
96 | 31 Aug 2015 @ 10:41 PDT | Database | Reply | Columnname on which error occurred | Dear Experts,
Was expecting your suggestions on this.
|
95 | 31 Aug 2015 @ 10:40 PDT | Database | Topic | Bad argument for ** operator - POWER function |
Greetings Experts,
We are facing a strange situation in which the following sql skeleton is failing with the error "Bad argument for ** operator" Please note that ... |
94 | 25 Aug 2015 @ 08:35 PDT | Database | Topic | Columnname on which error occurred | Greetings Experts,
We doesn't have access to our PROD and we develop scripts and test in SIT, UAT. When promoted to PROD, occassionally the following errors occur.
Invalid Date/Timestam... |
93 | 15 Aug 2015 @ 07:44 PDT | Database | Topic | Any effects of timezone on data | Greetings Experts,
I need a clarification on how the different timezone or relative settings effect the users on server and clients.
Say, a user from Australia inserted into a table with 2 cols (... |
92 | 15 Aug 2015 @ 07:22 PDT | Viewpoint | Topic | Performance degradation - action to be taken | Greetings Experts,
Apologies if this post doesn't seem to be in this category and for a generic query.
If the TD performance is degraded, what are the steps that are to be taken to identify t... |
91 | 15 Aug 2015 @ 07:10 PDT | Viewpoint | Topic | More sessions in delayed state - Best action to be taken | Greetings Experts,
I am new to Viewpoint and going through the User Guide; Just wanted to know if there is heavy load on TD and many sessions end up in "Delayed" state, how to cope... |
90 | 14 May 2015 @ 12:38 PDT | Database | Topic | Comparing 2 different datatypes giving undesired results |
Greetings All,
When comparing 2 different char/varchar datatypes in TD , the comparison is returning undesired results as the hexadecimal representation of the data in col... |
89 | 22 Sep 2014 @ 12:09 PDT | Database | Reply | UTF -8 or UTF-16? | Hi All,
I have seen that when using TPT, we should declare the columns which uses utf8 as size*3 and for utf16 as size*2. Can you please explain these.
So, does that mean in utf8, e... |
88 | 22 Sep 2014 @ 12:00 PDT | Database | Reply | Identify the time zone from a timestamp column | Hi Raja,
The column is defined as "timestamp with time zone" Also, is there any possibility to find the same information from only a timestamp column.
|
87 | 19 Sep 2014 @ 04:26 PDT | Database | Reply | Identify the time zone from a timestamp column | Thank you Raja,
To be clear, we have a table on a server on which the records are inserted from different countries which have different time zone, I need to find what are all the records that ... |
86 | 19 Sep 2014 @ 03:01 PDT | Database | Topic | Identify the time zone from a timestamp column | Greetings All,
I have a requirement to identify the time zone of a record (from a time stamp or date column) from existing populated table. Can you please help me on this.
|
85 | 29 Aug 2014 @ 10:43 PDT | Database | Topic | My perception on EXPLAIN was wrong | Greetings experts,
We are in the testing environment, where we will not have select access to some of the tables. When I need to run a complex query with multiple joins to other tables with ... |
84 | 29 Aug 2014 @ 10:17 PDT | Database | Topic | String contains an untranslatable character | Greetings Experts,
I need to find out what are the columns that has any language characters other than english (unicode with other language characters in it - not dbc.columns.chartype=2) Ter... |
83 | 14 Jul 2014 @ 11:37 PDT | Database | Topic | How is SPOOL space allocated and used. | Greetings Experts,
In the scenario of NO MORE SPOOL SPACE, can this be attributed to any one of the AMPs (similar to the permanent space, on which one of the amp has high peak perm space). I... |
82 | 14 Jul 2014 @ 11:21 PDT | Database | Topic | Compare DDL's of tables in 2 testing phases - find differences |
Greetings Experts,
I have a database in which there are around 600 tables being used in SIT. As we are moving to UAT, I need to compare the DDL's of the tables (column n... |
81 | 10 Mar 2014 @ 11:06 PDT | Tools | Reply | Handle records in Mload ET table in TEXT mode - A column or character expression is larger than the max size | Hi Sudhansu,
That worked, thank you. I was expecting the data to be in unreadable format due to DATA mode. But I could see that the content is readable. Any thoughts on this? &nb... |
80 | 10 Mar 2014 @ 12:37 PDT | Tools | Topic | Handle records in Mload ET table in TEXT mode - A column or character expression is larger than the max size | Greetings experts,
I have fastexported a table in text mode and loaded the data in to target table using Mload in text mode (I am using 13.00 Demo version on windows 7).
source/target tabl... |
79 | 27 Feb 2014 @ 07:22 PST | Tools | Reply | Fast export and mload in vartext mode - Data item too large for field issue | Hi All,
Modified the input select statement (of fast export) to include TRIM there by eliminating the blanks as below
1
2
... |
78 | 27 Feb 2014 @ 02:00 PST | Tools | Reply | Fast export and mload in vartext mode - Data item too large for field issue | Hi Ivy/All,
Thank you for your input. This one worked with fastload format.
I am looking for some script that does export the data in delimited fashion through fast export utility and load into T... |
77 | 26 Feb 2014 @ 12:58 PST | Tools | Topic | Fast export and mload in vartext mode - Data item too large for field issue | Greetings experts,
I am facing the following issue in TD Demo version 13.0 , windows 7
Scenario: Fast exporting from a table samples.itemppi_bkp in "mode record format text" (vart... |
76 | 25 Feb 2014 @ 12:01 PST | Tools | Reply | fast export and mload in fastload format issue - error code 2793 | Perfect, thank you Dieter and Steven.
|
75 | 25 Feb 2014 @ 11:11 PST | Tools | Reply | fast export and mload in fastload format issue - error code 2793 | Hi Dieter,
Yes, the rows are already present in the target table. I have deleted them and ran the entire process again. Now data loaded into target table, but I could see mismatch in the dat... |