#DateForumTypeThreadPost
2102 May 2013 @ 10:34 PDTPrivate Forum
2001 May 2013 @ 08:07 PDTPrivate Forum
1930 Apr 2013 @ 02:44 PDTPrivate Forum
1823 Apr 2013 @ 01:34 PDTPrivate Forum
1723 Apr 2013 @ 12:37 PDTPrivate Forum
1623 Apr 2013 @ 09:09 PDTDatabaseReply Arcmain I've used ACRMAIN for some time and have run many restores over the years.  The ARC0805 error has always plagued us as it is extremely vague and gives very little to go on in the erro...
1515 Apr 2013 @ 05:43 PDTDatabaseReplydisable enable logonsThat would certainly work to revoke the specifc users access but I'd need to know what they had so I could indivifulally grant it back to them as the test progresses.  Also, can you t...
1412 Apr 2013 @ 05:55 PDTDatabaseTopicdisable enable logonsWe have a need to selectively disable logons as part of our D/R test.  I know how to disable ALL logons but we would like to disable logons and then enable only specific groups over a per...
1312 Apr 2013 @ 05:39 PDTDatabaseReplyBest way to generate the Sequential numbers : CSUM or IDENTITY columns?Hi Dieter, I've always been told to steer clear of the IDENTITY in the past because it has some limitations in the past.  Such as the gaps in numbers and the limit to the number of values...
1226 Jul 2012 @ 12:30 PDTDatabaseTopicGroup AMP Join in a 13.10 Explain plan While testing the 13.10 version of the DBMS on our staging system, we found a query that performs much better under 13.10 and is using a "Group AMP Join", where the 12.0 version E...
1130 May 2012 @ 10:49 PDTPrivate Forum
1029 May 2012 @ 07:21 PDTDatabaseReplyAfter upgrading to V2R13.04.01 Datastage receives waitOnState(2) timed out ERROR We have now also seen this same issue running a FastExport from the mainframe so it appears to not only be a Datastage issue.  Reducing the sessions from 16 to 1 in the job allows it to run...
929 May 2012 @ 02:31 PDTDatabaseTopicAfter upgrading to V2R13.04.01 Datastage receives waitOnState(2) timed out ERROR After upgrading to V2R13.04.01 Datastage receives waitOnState(2) timed out ERROR.  The Enterprise stage will run with 2 sessions but fail if the developer tries to run with anymore sessions...
804 Apr 2012 @ 06:20 PDTViewpointTopicAlert Notifications We are new to Viewpoint and have migrated all of the Alert Policies we had setup in Teradata Manager to Viewpoint.  We see that the email message alerts that we receive from Viewpoint ...
709 Mar 2012 @ 01:57 PSTDatabaseReply13.10 upgrade...CPU hog? We encountered this when we went from 12.0.2 to 12.0.3.  The stats version changed from v3 to v4 and we did have to recollect all of our stats, which was time consuming.  I'm assum...
609 Mar 2012 @ 01:14 PSTViewpointReplyCanary Query Details Thanks!  Just curious, the query that is aborted after the 30 minute timeout...does it appear in Viewpoint's chart?  I believe DBQL only captures queries that complete...corre...
509 Mar 2012 @ 11:44 PSTViewpointReplyCanary Query Details We are in the process now of moving our canaries, which are implemented using the PDCR Toolkit, over to Viewpoint.  Our concern was there is logic in the PDCR script that looks to make sure...
409 Mar 2012 @ 11:06 PSTDatabaseTopic13.10 upgrade...CPU hog? We are currently running V2R12.0.3 and plan to upgrade to V2R13.10 in the near future.  We are concerned to know if anyone has made this upgrade and seen any kind of spike in CPU consumptio...
315 Feb 2012 @ 11:18 PSTGeneralReplyStale Statistics Query received 2616 Numeric Overflow I knew I had read that the stats version had changed but I couldn't remember if it was 2 to 3 or 3 to 4 in 12.0.3.  Thank you very much!!   -Mike
215 Feb 2012 @ 08:16 PSTGeneralTopicStale Statistics Query received 2616 Numeric Overflow I have a query that I believe Dieter shared with the group a couple years ago that will identify tables that have "stale statistics".  I've used this query regularly and ...
129 Nov 2011 @ 07:57 PSTGeneralTopicTASM Workload Exception Raise Alert check box is not sending alert. We have TASM running on TTU 12 and RDBMS 12.0.2.2.  We have a number of workload definitions with exceptions that have the Raise Alert check box checked.  In that entry field we have s...

Pages