#DateForumTypeThreadPost
5117 Jan 2014 @ 08:54 PSTDatabaseTopicFind usage Is there SQL I can submit to find what percentage of the resources are currently being used by the top consuming queries ? For example, I assuming currently a query can get 100% of the resourc...
5017 Jan 2014 @ 08:46 PSTAnalyticsTopicFinding top consuming queriesIs there any way of measuring what percentage of the resources are currently being used by top consuming queries ? For example, assuming currently a query can get 100% of the resources...how do I f...
4917 Dec 2013 @ 07:29 PSTDatabaseTopicObjectUseCountCollectRateI want to modify the ObjectUseCountCollectRate but I need to know if it requires a DBS restart after the MODIFY and WRITE.   Anyone know?
4809 Dec 2013 @ 07:47 PSTDatabaseTopicForeign Keys One of our data modelers came to me with the following scenario.  He is creating two tables and defining a foreign key on one that references the other. CREATE  TABLE EDWSPACE.AMK_...
4718 Nov 2013 @ 09:01 PSTToolsReplyTPT Parallel Connection LimitThank you so much.  I have never used TPT...it is a utility that was introduced after I moved out of the development realm.  The wording 'parallel connection limit' was given to m...
4612 Nov 2013 @ 02:08 PSTToolsTopicTPT Parallel Connection LimitHow do I find the value of the TPT parallel connection limit?  Is this a field that is displayed in DBS Control?  If so, which field is it?  MaxLoadTasks?
4512 Nov 2013 @ 02:07 PSTUDATopicParallel Connection LimitHow do I find the value of the TPT parallel connection limit?  Is this a field that is displayed in DBS Control?  If so, which field is it?  MaxLoadTasks?
4421 Oct 2013 @ 06:38 PDTConnectivityTopicError 8017: The UserId, Password or Account is invalid.We are having an issue with users attempting to logon to the system using LDAP authentication. They are able to logon using a set password with no mechanism chosen.   Any suggestions regard...
4318 Oct 2013 @ 09:28 PDTDatabaseTopicCapacity On DemandHow does one 'validate' that a COD upgrade, from 50% system availabity to 75% system availability, has been implemented successfully?
4222 Aug 2013 @ 09:25 PDTToolsTopicSQL Assistant Change Password Is there any particular reason that a user's 'Change Password' option would be grayed out in SQL Assistant -> Tools ?
4101 Mar 2013 @ 06:59 PSTDatabaseReplydropping partition statisticsI'm sorry.  The DROP STATS statements executed successfully. The attempt to alter the table to add partitions errored out. However, I found the problem.  The partitions was included...
4001 Mar 2013 @ 04:33 PSTDatabaseTopicdropping partition statisticsHello, I am attempting to alter a table by adding ranges to the partition.  I cannot do this because statistics exist on the partition.  I have tried: drop statistics on <databasenam...
3912 Sep 2012 @ 11:45 PDTToolsTopicSpecial Characters in Columnnames in FastExport I have a table with a couple of fields that contain '$_37'.  FastExport is dropping the '$_' and replacing it with nothing.  So, during the execution of the FastExport,...
3816 Dec 2011 @ 05:53 PSTConnectivityTopicTeradata Erro 8017 using SQL Assistant Our users have been receiving the [8017] The UserID, Password or Account is invalid error more frequently lately.  Normally, I can reset the password and they are fine. However, today I...
3710 Aug 2011 @ 08:41 PDTAnalyticsReplySeem to be getting a 2646 spool space error when there is no spool space problemThank you. The profile spool was smaller than the allocated spool, so that explains it. Thank you so much!
3610 Aug 2011 @ 07:35 PDTAnalyticsReplySeem to be getting a 2646 spool space error when there is no spool space problemAnd another instance... DATABASE ACCOUNT VPROC PEAKSPOOL MAXSPOOL B0$FSPRD $LB$&S&D&H 369 443,904.00 662,251,721.00 B0$FSPRD $LB$&S&D&H 379 2...
3510 Aug 2011 @ 06:29 PDTAnalyticsTopicSeem to be getting a 2646 spool space error when there is no spool space problemI have a user whose job keeps abending with a 2646. When I check the spool distribution, not even one amp is touching the allocated spool ceiling. Here is how the data is distributed for the ID...
3410 Aug 2011 @ 06:15 PDTAnalyticsReplyDetermining how much Spool Space is availableSpool space allocation can be seen with 'select * from dbc.users where username = ????';
3325 May 2011 @ 06:11 PDTDatabaseTopicError Message 3668We have a daily job that abended two nights ago with a 3668: A Table listed in the Dictionary is not present. An hour later the job was restarted without a problem. Anyone have any idea a...
3201 Apr 2011 @ 04:29 PDTAnalyticsTopicMulti-Value Compression EvaluationDoes anyone have an algorithm/SQL to evaluate possible opportunities for multi-value compression on a single table?
3111 Mar 2011 @ 08:31 PSTViewpointReplyNO DATA in Today's Statistics PortletThanks, Stever. The first thing I did was check the Data Collectors. No alerts there. I may very well open the incident with the GSC.
3011 Mar 2011 @ 06:33 PSTViewpointTopicNO DATA in Today's Statistics PortletCame in to work this morning and the Today's Statistics portlet is showing 'no data' for the columns 'Last Hour' and 'Since 12 AM Today'. Have not seen this before. It's only reporting this way...
2915 Feb 2011 @ 06:04 PSTConnectivityReplyCONNECTIVITY ERRORThank you! I will research that.
2811 Feb 2011 @ 05:12 PSTConnectivityTopicCONNECTIVITY ERROROne of our application teams just installed TTU13.0 on a server. When trying to connect, they receive the following error: [.NET Data Provider for Teradata[]1150009] Message truncation error, n...
2703 Feb 2011 @ 12:14 PSTAnalyticsReplyRow counts for every table in a given databaseThanks. I had created a dynamic statement like this, but was looking for a 'one-step' process. I appreciate your help!

Pages