All forum activity

#DateUserForumTypeThreadPost
1499610 Mar 2010 @ 11:10 PSTkumarDatabaseTopicDELETE query is taking too long time in the production....Hi, I need your help to identify the issue in the below query to optimize... query : DELETE ADSP FROM ARCPROD.AGG_DLY_STR_PROD ADSP, ARCPROD.INC_ETL_CUR_...
1499510 Mar 2010 @ 09:03 PSTamit.sDatabaseReplyStored procedures and macros - Perm spaceThank you!
1499410 Mar 2010 @ 08:34 PSTmonisiqbalDatabaseTopicDBQL showing null Operating Environment and System Condition with TASM enabledTDWM 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...
1499310 Mar 2010 @ 07:20 PSTdnoethDatabaseReplyMonitoring 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...
1499210 Mar 2010 @ 07:09 PSThrmikwenGeneralTopicAbout data integration and real timeHello, 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...
1499110 Mar 2010 @ 06:11 PSTRandom_ThoughtDatabaseTopicMonitoring 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...
1499010 Mar 2010 @ 12:10 PSTdnoethDatabaseReplyUsing the FLEX application to pass variables to Teradata SQLHi 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...
1498909 Mar 2010 @ 11:38 PSTChinaGuyCloud ComputingReplyIs 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.
1498809 Mar 2010 @ 11:19 PSTreichel0110Third Party SoftwareReplyInformatica vs Teradata BTEQAt 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...
1498709 Mar 2010 @ 03:49 PSTvarun2327TrainingReplyTeradata 12 CertificationHi 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 ...
1498609 Mar 2010 @ 03:48 PSTTeradactylCloud ComputingReplyIs 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...
1498509 Mar 2010 @ 02:04 PSTpcavanaughDatabaseTopicUsing the FLEX application to pass variables to Teradata SQLI 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...
1498409 Mar 2010 @ 12:33 PSTMerSteveDPCJobsTopicTeradata/ETL/Data Modeler Needed - Dayton Ohio - US Citizens only - OPEN RATEWe 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 ...
1498309 Mar 2010 @ 12:17 PSTchris34662002ToolsReplyFast Load I/O errorI 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...
1498209 Mar 2010 @ 09:24 PSTdnoethDatabaseReplyvarchar 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...
1498109 Mar 2010 @ 08:41 PSTdnoethDatabaseReplyCalculate AMPs used by a queryHi 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 Dieter
1498009 Mar 2010 @ 08:33 PSTdnoethDatabaseReplyStored procedures and macros - Perm spaceA 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...
1497909 Mar 2010 @ 07:22 PSTrahulrajDatabaseTopicCalculate AMPs used by a queryHi 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 ...
1497809 Mar 2010 @ 02:01 PSTTeradata_NewbieGeneralReplyTeradata and Chinese LanguageThanks ChinaGuy! Good interesting read on that article.
1497709 Mar 2010 @ 12:54 PSTsvs1986DatabaseTopicPros and consHi 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
1497609 Mar 2010 @ 12:41 PSTamit.sDatabaseTopicStored procedures and macros - Perm spaceMacros dont use perm space Stored procedure requires perm space Why?
1497509 Mar 2010 @ 12:37 PSTpierrehenriDatabaseReplyvarchar concatenationSure 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 ...
1497409 Mar 2010 @ 12:22 PSTFAQDatabaseReplyProblems 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?
1497308 Mar 2010 @ 06:36 PSTChinaGuyCloud ComputingReplyIs 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...
1497208 Mar 2010 @ 04:02 PSTTeradactylCloud ComputingTopicIs 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 ...

Pages