| 76 | 10 Jun 2016 @ 12:56 PDT | Database | Reply | No spool space error,when running SP in BTEQ. | And how much spool is currently allocated to that User ID?
|
| 75 | 10 Jun 2016 @ 12:48 PDT | Database | Reply | No 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?
|
| 74 | 10 Jun 2016 @ 04:52 PDT | Database | Reply | Unable to release locks | Thanks 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... |
| 73 | 09 Jun 2016 @ 06:51 PDT | Database | Topic | Unable to release locks | We 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 ... |
| 72 | 05 May 2016 @ 04:58 PDT | Database | Reply | Evaluating for Primary Index | Thank you so much
|
| 71 | 04 May 2016 @ 08:32 PDT | Database | Topic | Evaluating for Primary Index | Good 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.
... |
| 70 | 03 May 2016 @ 04:23 PDT | Tools | Reply | DSA logs | Thanks seven11,
I found the logs at /opt/teradata/PUTTools/td14.xx.xx.xx.xx/DSA_scripts
|
| 69 | 09 Mar 2016 @ 12:06 PST | Database | Topic | How 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... |
| 68 | 25 Nov 2015 @ 11:47 PST | Teradata Studio | Topic | Database Explorer Tree | Is it possible to have ONLY the databases to which a user has access load to the explorer tree in Studio Express?
|
| 67 | 28 Jul 2015 @ 05:35 PDT | Viewpoint | Reply | Set a Maintenance Window | Just 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... |
| 66 | 24 Jul 2015 @ 07:16 PDT | Viewpoint | Topic | Multiple 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... |
| 65 | 03 Jun 2015 @ 06:12 PDT | Tools | Topic | 2573 Invalid match tag found | Good 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 ... |
| 64 | 09 Apr 2015 @ 09:55 PDT | Tools | Topic | DSA logs | Hi,
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... |
| 63 | 11 Feb 2015 @ 12:49 PST | Database | Reply | Help Stats Displays Incorrect Statistics | I 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).&... |
| 62 | 11 Feb 2015 @ 12:46 PST | Database | Reply | Help Stats Displays Incorrect Statistics | I found the USING THRESHOLD option.
|
| 61 | 10 Feb 2015 @ 12:22 PST | Database | Reply | Help Stats Displays Incorrect Statistics | Dieter 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?
|
| 60 | 06 Nov 2014 @ 12:07 PST | Database | Topic | Encryption in the index | Can a column that will be encrypted be used as part of an index?
|
| 59 | 29 Oct 2014 @ 01:02 PDT | Database | Reply | Deadlock on dbc.accessrights | Thank you so much!
|
| 58 | 29 Oct 2014 @ 10:59 PDT | Database | Topic | Deadlock 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.
... |
| 57 | 29 Oct 2014 @ 10:33 PDT | Tools | Topic | Informatica 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 ... |
| 56 | 25 Jun 2014 @ 07:18 PDT | Database | Reply | unable 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>... |
| 55 | 24 Jun 2014 @ 09:56 PDT | Database | Topic | unable 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... |
| 54 | 01 May 2014 @ 09:45 PDT | Database | Topic | Column encryption | We 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... |
| 53 | 17 Jan 2014 @ 01:06 PST | Database | Reply | Find usage | How can I adjust this to show a period of time instead of just the current date?
|
| 52 | 17 Jan 2014 @ 11:41 PST | Database | Reply | Find usage | Thank you so much!
|