All forum activity

#DateUserForumTypeThreadPost
1722404 Oct 2010 @ 09:36 PDTrobpallerDatabaseReplyImpact of disabling DBQL & Listing all the DB/Users under Query/Access logg...1) Check the system view: DBC.DBQLRules 2) If you disable logging you will lose what ever data would have been logged during the maintenance of the DBQL tables. 3) Would depend on how you enabled...
1722304 Oct 2010 @ 09:05 PDTsteverViewpointReplyidle-session alertsSo yes, in order to do all the logic you described about picking up the Teradata database user's email address, you would need to run a BTEQ script on a Windows server. I'm sure you could do this ...
1722204 Oct 2010 @ 08:54 PDTGaryadminViewpointReplyidle-session alertswe were thinking of using the existing alerting on VP - ie Blocked queries by duration or large number of blocked sessions, then trigger SQL which picks up the sessionid of the blocking session, so...
1722104 Oct 2010 @ 08:40 PDTsteverViewpointReplyidle-session alertsThe first 2 items you mentioned are already part of TASM and Viewpoint. For both exceptions and unplanned events, you can specify an alert that will be executed by the Viewpoint Alerting functiona...
1722004 Oct 2010 @ 07:52 PDTGaryadminViewpointReplyidle-session alertsFor alerting, we'd like to have an alert defined that can Email the DBAs if queries get demoted to a 'penalty box' (or any workload move) workload - so we can check quickly whether to Abort manuall...
1721904 Oct 2010 @ 06:56 PDTdsnaveenGeneralTopicETL jobs hangingHi, We do have a below update query, we do not have any PI or USI in WHERE clause. UPDATE target_table SET col_b = :a WHERE col_c = :ix; We do execute the above query from DataStage. ...
1721804 Oct 2010 @ 06:39 PDTdsnaveenToolsTopicETL jobs hangingHi, We do have a below update query, we do not have any PI or USI in WHERE clause. UPDATE target_table SET col_b = :a WHERE col_c = :ix; We do execute the above query from DataStage (ET...
1721704 Oct 2010 @ 06:21 PDTayyappan_mca@email.comToolsReplyfastload error message: Not enough fields in vartext data record number: 1Hi, I am having a file of 27 columns which is comma delimeted and some columns may also have "," in its data. But those column values are enclosed by double quotes. Among the 27 columns any co...
1721604 Oct 2010 @ 05:55 PDTl.kDatabaseTopicRestore a single Database from a .DAT File(Taken backup of Multiple DBs in .DAT file)...Hi, I am doing backup of all objects in all the Databases and users in our environment by using ARCMAIN. In between i got a doubt.. For example i am having 4 databases (sample1,sample2,s...
1721504 Oct 2010 @ 05:19 PDTl.kDatabaseTopicImpact of disabling DBQL & Listing all the DB/Users under Query/Access logg...Hi All, I need to clean up the table DBQLOGTBL in DBC database.Currently it's size is almost 850 GB of permanent space. If i do the clean up of DBQLOGTBL directly ,then DBC is getting blocke...
1721404 Oct 2010 @ 12:34 PDTratchetandclankToolsReplySession and Checkpoint consideration in TTUs and TPTNo need to apologize.. The legacy Fastexport writes to a file. With TPT, are you using dataconnector operator as consumer ? I still am not able to believe that export operator is taking more ti...
1721303 Oct 2010 @ 11:50 PDTRakesh2010DatabaseReplyPPIJoedsilva, I think in case of NUPI , TD has to probe each partition to add uniqueness value into ROWID during row insertion . Correct me if I'm wrong..
1721202 Oct 2010 @ 06:51 PDTQConnectivityReplyjdbc deployment questionok thanks Tom
1721102 Oct 2010 @ 10:14 PDTjulianmarbleDatabaseReplyWhat is method or strategy to calculate the CPU utilized in running a Query?Great information you've ever shared! I'm looking for this information.
1721002 Oct 2010 @ 03:51 PDTjcmerceronhomeExtensibilityReplyXML Service - publishing special character XML 1 sec ago html correctly transforme special character. I 'd like to show that : < should be transformed in & lt > should be transformed in & gt ... xml services should transform as i sh...
1720901 Oct 2010 @ 01:35 PDTgrybackToolsReplyBug in Teradata Caused by Canceling QueriesI've checked with architects and developers on this and we're not sure what the DBA is talking about regarding an "intermittent problem in Teradata". I'd recommend having yourself and the DBA submi...
1720801 Oct 2010 @ 01:02 PDTrobpallerGeneralReplyDownload Links says "Service Unavailble"Excellent news!
1720701 Oct 2010 @ 09:09 PDTemilwuDatabaseReplyWhat is method or strategy to calculate the CPU utilized in running a Query?can you elaborate : 100-(nullifzero(lg.TotalCPUTime/300)/(lg.HotAMP1CPU) *HASHAMP()) "Skew Factor", why divide 300 ?????
1720601 Oct 2010 @ 07:59 PDTSanjeevJobsTopicTeradata DBA - Raleigh,NCHi I Hope you are doing well, my client is looking for Teradata DBA consultants, If you are interested please reply back to this email with your latest copy of your resume along with your expec...
1720501 Oct 2010 @ 03:02 PDTJimmDatabaseReplyHow the below statement will execute? Please explain?For every TBL_NM in work_x_table (with a Seg_Typ_Id other than 15 or 17), it will generate an insert statement to copy the appropriate records into the hist table. These statements are presumably ...
1720401 Oct 2010 @ 02:55 PDTJimmDatabaseReplyCollecting Stats after deleting all dataIt could be a historical thing. In older Teradata releases, you could Collect Statistics on a table (without specifying columns or indices) and it would recollect all defined stats in a single pas...
1720301 Oct 2010 @ 02:54 PDTk_suji86DatabaseTopicHow the below statement will execute? Please explain?Hi, Please explain how the below statement will execute? SELECT ';INSERT INTO x_data_hist.hist_x ( Seg_ID, Group_ID, Individual_ID, ...
1720230 Sep 2010 @ 11:52 PDTdnoethCloud ComputingReplyTeradata DBMS is in bad state in TD Express 12 images (40GB as 1TB) Hi Alain, maybe the download is not available because of that problem :-) Before you BOOTed the amp, did you try to set the amp's status from FATAL to ONLINE? A BOOTed amp needs a TABLE REBU...
1720130 Sep 2010 @ 11:34 PDTenjoycodingExtensibilityReplyMonitorSQLCurrentStep on result set of MonitorSessionHi folks, At least where can I get the source code of these functions. I checked normal udf source code folders /teradata/tdbs_udf on one of the node but its empty as no custom made udfs were c...
1720030 Sep 2010 @ 11:28 PDTdnoethDatabaseReplyCollecting Stats after deleting all dataIt's the same reason as any stats, it tells the optimizer about the number of rows and helps producing a better plan. And there's almost no overhead collecting stats on a an empty table. But if...

Pages