|14996||10 Mar 2010 @ 11:10 PST||kumar||Database||Topic||DELETE query is taking too long time in the production....||Hi,
I need your help to identify the issue in the below query to optimize...
|14995||10 Mar 2010 @ 09:03 PST||amit.s||Database||Reply||Stored procedures and macros - Perm space||Thank you! |
|14994||10 Mar 2010 @ 08:34 PST||monisiqbal||Database||Topic||DBQL showing null Operating Environment and System Condition with TASM enabled||TDWM is working and TASM is enabled on the system. I can see WDID in the DBQLogTbl however the OpeEnvId and SysConId are null. How can this be possible?
I think that when appropriate SysCon and Op... |
|14993||10 Mar 2010 @ 07:20 PST||dnoeth||Database||Reply||Monitoring Daily Spool space usage.||It's just like any other history:
Use a scheduled job to insert/select from dbc.diskspace or (preferred on TD12) syslib.monitorsessions.
Of course Viewpoint already collects spool space metric... |
|14992||10 Mar 2010 @ 07:09 PST||hrmikwen||General||Topic||About data integration and real time||Hello,
We have been looking for a real time data integration program.
We have not found the right software yet.
Basically we'll be using the tool for the migration of contacts and data in... |
|14991||10 Mar 2010 @ 06:11 PST||Random_Thought||Database||Topic||Monitoring Daily Spool space usage.||Hi,
I need to monitor the spool space used throughout the day (every 10 minutes or so). So I can trend the actual usage over the month. I need to verify that we are using 30% or less or else w... |
|14990||10 Mar 2010 @ 12:10 PST||dnoeth||Database||Reply||Using the FLEX application to pass variables to Teradata SQL||Hi Pat,
you should be glad that it doesn't work, because that query is (how shall i put this? ahem...) totally stupid:
It's a CROSS JOIN between two potentially large answer sets, followed by a G... |
|14989||09 Mar 2010 @ 11:38 PST||ChinaGuy||Cloud Computing||Reply||Is there any way to control the size of the virtual machine for my small laptop disk?||the pdisks don't shrink because they are raw partitions. by deleting unused data, you can make sure it is not bigger than already is. there is no perfect way. OS drives can be shrinked. |
|14988||09 Mar 2010 @ 11:19 PST||reichel0110||Third Party Software||Reply||Informatica vs Teradata BTEQ||At our company we use Informatica as the standard data integration platform. Currently, we're in the process of implementing an Enterprise Data Warehouse based on Teradata (using cLDM). From an arc... |
|14987||09 Mar 2010 @ 03:49 PST||varun2327||Training||Reply||Teradata 12 Certification||Hi friends,
I am planning to take Teradata 12 certification exams. If anyone already done with basics or SQL, please send me your material and I promise I will help others the same way. I thank ... |
|14986||09 Mar 2010 @ 03:48 PST||Teradactyl||Cloud Computing||Reply||Is there any way to control the size of the virtual machine for my small laptop disk?||Ok, so you're saying I really do have control here. If it grows too big, I just delete data I don't need in Teradata, and then shrink the virtual OS drives with VMware, and I'll get back down close... |
|14985||09 Mar 2010 @ 02:04 PST||pcavanaugh||Database||Topic||Using the FLEX application to pass variables to Teradata SQL||I am attempting to use the FLEX application as a front end user interface to pass variables to Teradata SQL so only the desired records are returned. I am getting an error that I have been able to... |
|14984||09 Mar 2010 @ 12:33 PST||MerSteveDPC||Jobs||Topic||Teradata/ETL/Data Modeler Needed - Dayton Ohio - US Citizens only - OPEN RATE||We are looking for 3 Teradata Engineers for a long term opportunity located in Dayton, OH.
You will need to be onsite M-F, however travelling home on the weekends is fine :)
Specifically, we ... |
|14983||09 Mar 2010 @ 12:17 PST||chris34662002||Tools||Reply||Fast Load I/O error||I had a similar problem when we first upgraded to Version 12 utilities. The fix that worked for me was to switch from using the Oracle provider in the source selection to using the Microsoft for Or... |
|14982||09 Mar 2010 @ 09:24 PST||dnoeth||Database||Reply||varchar concatenation||
2 sec ago
What's the datatype of m.pla_rw_place_number?
CAST(substr(e.pla_rw_place_number_,char(e.pla_rw_place _number_)-3,4) as integer)
in the recursive part will fail if the previous pl... |
|14981||09 Mar 2010 @ 08:41 PST||dnoeth||Database||Reply||Calculate AMPs used by a query||Hi Rahul,
in dbc.qrylog there's NumOfActiveAMPs.
Based on that it's easy to find out which queries used all AMPs:
WHERE NumOfActiveAMPs = HASHAMP()+1
|14980||09 Mar 2010 @ 08:33 PST||dnoeth||Database||Reply||Stored procedures and macros - Perm space||A MACRO is just source code, like a VIEW. The definition is stored in the Data Dictionary (= dbc tables), thus doesn't need any perm space in the target database.
But the source code of an SP is... |
|14979||09 Mar 2010 @ 07:22 PST||rahulraj||Database||Topic||Calculate AMPs used by a query||Hi Gurus,
I'm trying to figure out how many AMPs are being used by queries on daily basis. My ultimate goal is to create a report of ALL queries that used all the AMPs available. Is there any way ... |
|14978||09 Mar 2010 @ 02:01 PST||Teradata_Newbie||General||Reply||Teradata and Chinese Language||Thanks ChinaGuy! Good interesting read on that article. |
|14977||09 Mar 2010 @ 12:54 PST||svs1986||Database||Topic||Pros and cons||Hi
Could u please let me know the pros and cons of below mentioned ones for exporting data
1. Using FastExport
2. Using Informatica
3. Using Data extract
4. Using parameter file
|14976||09 Mar 2010 @ 12:41 PST||amit.s||Database||Topic||Stored procedures and macros - Perm space||Macros dont use perm space
Stored procedure requires perm space
|14975||09 Mar 2010 @ 12:37 PST||pierrehenri||Database||Reply||varchar concatenation||Sure it's better with some sample :
WITH RECURSIVE RECTABLE(pla_pnr_message_group_id_, pla_rw_place_number_, ligne) AS
SELECT m.pla_pnr_message_group_id, m.pla_rw_place_number, m.ligne
|14974||09 Mar 2010 @ 12:22 PST||FAQ||Database||Reply||Problems with SP compilation ||I have 2 Visual Studio versions installed on my system VS 6 and VS 2008; I am getting the same error, how can I configure Teradata to use VS 6 for compiling Stored Procedures? |
|14973||08 Mar 2010 @ 06:36 PST||ChinaGuy||Cloud Computing||Reply||Is there any way to control the size of the virtual machine for my small laptop disk?||Generally we haven't seen the vm virtual disk's physical size on disks growing much more than the amount of data you have loaded into database. My advice is to
1. periodically check the total pe... |
|14972||08 Mar 2010 @ 04:02 PST||Teradactyl||Cloud Computing||Topic||Is there any way to control the size of the virtual machine for my small laptop disk?||My laptop only has an 80 GB disk. I want to run the Teradata Express 13.0 Virtual machine, and my laptop meets all of the requirements for this. It's nice that the initial installation size starts ... |