|27614||04 Oct 2012 @ 07:51 PDT||Koushik Chandra||General||Topic||Server configuration for TDE 13.10.00.10 for VM Ware (1 TB) installation||Hi,
Can any one please let me know the configuration required for a Linux VM Ware server for "TDE 13.10.00.10 for VM Ware (1 TB)" installation, considering approximately 100 concurrent u... |
|27613||04 Oct 2012 @ 06:41 PDT||robpaller||Database||Reply||SQL to find Row Count||No. DBQL doesn't seem to log records inserted, deleted, or updated by INSERT, UPDATE, DELETE, or MERGE operations.
Do you have any timestamp or date fields on the table to track when records h... |
|27612||04 Oct 2012 @ 02:51 PDT||carrie||Viewpoint||Reply||Viewpoint / Workload Monitor Dynamic Pipes View.||This question was also posted on my blog on Dev X. Here is the response I gave at that location:
A query is not allocated to a resource partition directly. It is mapped to a performance grou... |
|27611||04 Oct 2012 @ 01:53 PDT||chand308||Database||Topic||SQL to find Row Count||Hi,
I am trying to find if there is any way we can find the record count of queries that logged into DBQL with Insert or Update statement types. I tring to see the row count by taking the ... |
|27610||04 Oct 2012 @ 01:40 PDT||Qaisar Aftab Kiani||Database||Reply||How to force duplication of the rows from a small table on all AMPs||Hi Ayush,
In that case the join will cost more as you are joining two non-index columns. TD will be redistributing the data for both of the tables on the joining columns to make sure that the data... |
|27609||04 Oct 2012 @ 12:55 PDT||Ayush.Jha||Database||Reply||How to force duplication of the rows from a small table on all AMPs||Aftab,
Thanks for the response and the suggestion.
What if I move all the data from the smaller table 'tableb' which has only 15 million rows into another table and create an altogether d... |
|27608||04 Oct 2012 @ 12:53 PDT||Arash||Database||Reply||convert string to date format||Many thanks for all the help Teradata!
It solved my problem.
|27607||04 Oct 2012 @ 12:26 PDT||Qaisar Aftab Kiani||Database||Reply||How to force duplication of the rows from a small table on all AMPs||Hi Ayush,
The reason that your tablea is redistributed is because the join is on UPI and no index. TableA has a three columns NUPI, and in the join condition you are only using one column, so basi... |
|27606||04 Oct 2012 @ 12:16 PDT||Qaisar Aftab Kiani||Database||Reply||convert string to date format||
SELECT '8/12/2012' AS COL1
, CAST(CASE WHEN CHAR_LENGTH(SUBSTRING(COL1 FROM 1 FOR POSITION('/' IN COL1)-1))=1 THEN '0'||SUBSTRING(COL1 FROM 1 FOR POSITION('/' IN... |
|27605||04 Oct 2012 @ 11:49 PDT||ulrich||Database||Reply||convert string to date format||see my last comment on http://forums.teradata.com/forum/general/a-wish-list-for-future-versions-of-teradata
|27604||04 Oct 2012 @ 11:04 PDT||Jim Chapman||Cloud Computing||Reply||Certificate errors when trying to start VMserver. ||If by "VMserver" you mean the Oracle VM Server, then you are using the wrong product. The Teradata VM is requires a VMWare product, such as VMWare Player.
VMWare Player is ava... |
|27603||04 Oct 2012 @ 10:36 PDT||robpaller||General||Reply||Wish list for forum development||Is the goal of the forums here to be more Q&A and less conversational? If so then I would suggest visiting StackOverflow and other StackExchange related sites. I believe there is a lot that cou... |
|27602||04 Oct 2012 @ 10:00 PDT||stani75||Connectivity||Topic||"Invalid date supplied for" error||My database is a Teradata version 13.00.01.19
I retrieve data with a MS Excel v2003 file (using MS Query)
Before to do that, I installed "the tdodbc__windows_i386.13.10.00.05" products ... |
|27601||04 Oct 2012 @ 08:20 PDT||Arash||Database||Reply||convert string to date format||But this still would't work for some dates, e.g. '10/2/2012'
|27600||04 Oct 2012 @ 07:37 PDT||mukeshsingh||Connectivity||Reply||how to install teradata express edition on windows 7||Hi,
I am looking for teradata express for my windows 7 32/64 bit machine.
but what i am getting is only the TDE editions for VMware.
Is there any edition available for Windows 7, so that i ca... |
|27599||04 Oct 2012 @ 06:56 PDT||Ayush.Jha||Database||Reply||How to force duplication of the rows from a small table on all AMPs||All,
I understand that this discussion is old but my problem is new. I am using Teradat 13.10.
I have a large table eg: tablea with NUPI as (col1,col2,col3) . This table has approx 400 million ro... |
|27598||04 Oct 2012 @ 06:27 PDT||td_admirer||Database||Reply||coverting a SQL Server function into a TD SQL UDF||Hi experts,
Any ideas or suggestions are greatly appreciated.
|27597||04 Oct 2012 @ 06:19 PDT||ulrich||Database||Reply||Compile Stored Procedures in Batch||If I understand your question correctly the answer would be no:
see Carries comment in
|27596||04 Oct 2012 @ 05:13 PDT||mjasrotia||Database||Reply||CREATE TABLE Failed. 3933: The Maximum Possible Row Length in the Table is too Large.||Also depends upon the max Data Block size set by the DBA since a table row has to completely fit inside a Data Block.
|27595||04 Oct 2012 @ 04:38 PDT||Qaisar Aftab Kiani||Database||Reply||Compile Stored Procedures in Batch||for example?
|27594||03 Oct 2012 @ 09:58 PDT||geethareddy||General||Reply||Is automation worth for cleaning Orphan Rights and Leftover Spool?||Thanks for the response. But my question is, in case of cleaning the orphan rights the only way is we can clean them during any maintenance activities. And with leftover spool, it is not promised t... |
|27593||03 Oct 2012 @ 09:54 PDT||pradeesh||General||Reply||Is automation worth for cleaning Orphan Rights and Leftover Spool?||It will get be good practice to clear the left over spool space for a system which is not bringing down once in quarter.
We have scheduled a weekly job
|27592||03 Oct 2012 @ 09:17 PDT||DBAMagicman||Tools||Reply||Teradata Wallet||Hi
I tried using TDWallet with two different utilities .BTEQ (T22.214.171.124) and ARCMAIN (T126.96.36.199). It seemed to have worked fine with BTEQ but gave an error in ARCMAIN.Im using CLIV2 T14.0.... |
|27591||03 Oct 2012 @ 08:22 PDT||EN186010||Tools||Topic||Unix Shell Scripts on Teradata utilities that are currently running in production - Wants to set up standard and guildlines||Folks,
Just wondering if you can help me on this, a major client wanted to have some working copies of a currently running unix shell script that executes Bteq which also captures error codes and ... |
|27590||03 Oct 2012 @ 08:16 PDT||EN186010||Tools||Topic||Teradata XML Services||Folks,
Just wondering which one of you are using Teradata XML Services, a client is interested to know how many of our existing customers has used Teradata XML Services and how is it being used (e... |