#DateForumTypeThreadPost
7610 Jun 2016 @ 12:56 PDTDatabaseReplyNo spool space error,when running SP in BTEQ.And how much spool is currently allocated to that User ID?
7510 Jun 2016 @ 12:48 PDTDatabaseReplyNo spool space error,when running SP in BTEQ.What does your stored procedure do?  Does it perform aggregation?  Are you joining tables?  have you run explains on the underlying code?
7410 Jun 2016 @ 04:52 PDTDatabaseReplyUnable to release locksThanks Fred... We will perform our quarterly refresh later this month, so I know that will take care of it.  Was just wondering if there was any other way.     Thanks agai...
7309 Jun 2016 @ 06:51 PDTDatabaseTopicUnable to release locksWe are using DSA as our Backup and Restore option.  Lately, we have had issues with the Restore portion on our DRT system. We had a restore job that ran for several hours but seemed to make ...
7205 May 2016 @ 04:58 PDTDatabaseReplyEvaluating for Primary IndexThank you so much
7104 May 2016 @ 08:32 PDTDatabaseTopicEvaluating for Primary IndexGood morning, I have a table that is highly skewed.  The currentperm per amp ranges from a high of  7,828,770,304  to a low of 1,762,582.528.  There are 42 amps on the system. ...
7003 May 2016 @ 04:23 PDTToolsReplyDSA logsThanks seven11, I found the logs at /opt/teradata/PUTTools/td14.xx.xx.xx.xx/DSA_scripts
6909 Mar 2016 @ 12:06 PSTDatabaseTopicHow does Primary Index Size relate to table data size?When I run this query: select databasename, tablename, sum(currentperm) from dbc.tablesize where database name = <mydatabase> group by 1, 2 order by 2; I receive the following size informat...
6825 Nov 2015 @ 11:47 PSTTeradata StudioTopicDatabase Explorer TreeIs it possible to have ONLY the databases to which a user has access load to the explorer tree in Studio Express?
6728 Jul 2015 @ 05:35 PDTViewpointReplySet a Maintenance WindowJust recently, I made some changes to DBS Controls that required a tpareset in order to activate.  Before the tpareset, I had to open a maintenance window and once the tpareset was complete, I...
6624 Jul 2015 @ 07:16 PDTViewpointTopicMultiple idle sessions for 'viewpoint'Good morning, Our production system is monitored by a different viewpoint server that our dev/test system. I often see multiple sessions for user 'viewpoint' and some sessions will be idl...
6503 Jun 2015 @ 06:12 PDTToolsTopic2573 Invalid match tag foundGood morning, I am attempting to help a developer correct the problem he is having with his MLoad. In all of my years of coding, I don't recall ever receiving this error.   Can anyone ...
6409 Apr 2015 @ 09:55 PDTToolsTopicDSA logsHi, I ran a restore using DSA, and received an error in the postscript.  Where can I find the DSA logs so that I can further investigate my error?  I'm guessing it's on the BAR m...
6311 Feb 2015 @ 12:49 PSTDatabaseReplyHelp Stats Displays Incorrect StatisticsI didn't refresh my screen before posting my last comment.  Thanks so much for further explanation, Carrie!   DefaultUserChangeThreshold is not enabled (value in DBS Control is 0).&...
6211 Feb 2015 @ 12:46 PSTDatabaseReplyHelp Stats Displays Incorrect StatisticsI found the USING THRESHOLD option.
6110 Feb 2015 @ 12:22 PSTDatabaseReplyHelp Stats Displays Incorrect StatisticsDieter and Carrie, Can statistics be forcibly collected?  If I wanted to ignore the system threshold, which is very low in our site at 1%, how would I do that?
6006 Nov 2014 @ 12:07 PSTDatabaseTopicEncryption in the indexCan a column that will be encrypted be used as part of an index? 
5929 Oct 2014 @ 01:02 PDTDatabaseReplyDeadlock on dbc.accessrightsThank you so much!
5829 Oct 2014 @ 10:59 PDTDatabaseTopicDeadlock on dbc.accessrights The application team experienced a deadlock issue. There were three different jobs running: Job A was blocked by Job B. Job B was blocked by Job A. Job C was blocked by both Job A and Job B. ...
5729 Oct 2014 @ 10:33 PDTToolsTopicInformatica and TPT The application team experienced a deadlock issue. There were three different jobs running:  Job A was blocked by Job B.  Job B was blocked by Job A.  Job C was blocked by both Job ...
5625 Jun 2014 @ 07:18 PDTDatabaseReplyunable to cast object of type 'system.dbnull' to type 'system.string'A user runs a query in SQL Assistant and expects null values in a certain column.  In the result set, the null indicator is displayed until row 501.... where it then displays '<Error>...
5524 Jun 2014 @ 09:56 PDTDatabaseTopicunable to cast object of type 'system.dbnull' to type 'system.string'We have a query that we know will return nulls for a certain column.  However, in the result set, sometimes we see null and sometiems it returns <Error> in the column when the value shou...
5401 May 2014 @ 09:45 PDTDatabaseTopicColumn encryptionWe have the scenario where we need to encrypt certain sensitive information. Can you please clarify / confirm encryption of specific columns in Teradata?   Can we control access to who ca...
5317 Jan 2014 @ 01:06 PSTDatabaseReplyFind usage How can I adjust this to show a period of time instead of just the current date?
5217 Jan 2014 @ 11:41 PSTDatabaseReplyFind usage Thank you so much!

Pages