183 | 26 Apr 2015 @ 10:21 PDT | Viewpoint | Topic | Viewpoint showing 'no data' for Disk Space | We are observing "no data" for Total Statistics Portal under Monitoring Tools in View point for one of our production Teradata servers .Why is it showing like this, even when we hav... |
182 | 22 Apr 2015 @ 09:36 PDT | Database | Reply | Stats Collection | Thanks VandeBergB ,Dieter for the suggestions.While I will explore the auto stats collection portlet in view point, as an immediate resolution I am planning to adopt SP (queue table appr... |
181 | 21 Apr 2015 @ 07:47 PDT | Database | Reply | Stats Collection | We are using Teradata 14.10 version
|
180 | 21 Apr 2015 @ 04:54 PDT | Database | Reply | Stats Collection | I am reading the stats statements from a metadata table
|
179 | 21 Apr 2015 @ 04:52 PDT | Database | Topic | Stats Collection |
I am running a few stats collection statement ,sequentially , by reading and executing through a cursor called from within a stored proc.At any point, if a stats collection statement is failing ... |
178 | 21 Apr 2015 @ 01:42 PDT | Database | Reply | RuleType in tdwm.ruledefs | Thanks Pierre.Any idea what are the ruletypes designated by 5,6 and 7?
|
177 | 14 Apr 2015 @ 09:13 PDT | Database | Topic | system-determined change threshold for Stats Collection |
We are collecting stats on a table , however the stats collection is getting skipped.
This is confirmed from the StatsSkipCount flag in DBC.StatsV for the table.
On going for explain for... |
176 | 19 Feb 2015 @ 09:27 PST | Database | Topic | AccessCnt in DBC.ObjectUsage | What is the difference between UserAccessCnt and SysAccessCnt columns in DBC.ObjectUsage table?How are the columns populated when we access any object?
|
175 | 15 Feb 2015 @ 08:55 PST | Database | Topic | Resetting User Default DB | I modified default db of a user whose default Db was null to a specific value.
Now I want to revert back the default DB to null:
MODIFY USER user_name AS DEFAULT DATABASE=null;
The above s... |
174 | 12 Feb 2015 @ 07:05 PST | Database | Reply | Dropping users | Before dropping the user, all objects in the user Db have to be cleaned up, you may use following syntax(TD 14.10):
DELETE USER user_name ALL;
DROP USER user_name;
There may be dead locks, as th... |
173 | 06 Feb 2015 @ 09:39 PST | Database | Topic | Stats collection based on UseCount | How to decide whether to COLLECT STATISTICS on a table based on UDI (Update Delete Insert ) count after enabling USECOUNT option for the database in Teradata 14.10?
|
172 | 05 Jan 2015 @ 08:54 PST | Database | Topic | Managing space with DBC | What percentage of the Database space sould be assigned or reserved for DBC? Is there is general recommendation ?
What percentage of DBC should usually be free?We are reaching ~ 90% of the DB util... |
171 | 22 Nov 2014 @ 11:38 PST | Database | Topic | Packdisk | We are running packdisk through ferret at table level (FSP=5),we observed a peculiar behavior:
Inquire request has been sent
Sun Nov 22, 2014 07:15:47
Slowest vproc 2632&nbs... |
170 | 12 Nov 2014 @ 07:19 PST | General | Topic | Running arcmain backup jobs on each partition |
A table contains 5 years of billing information.
The table is partitioned on rptg_dt date field and yearly partitions are defined.
Is it possible to run 5 different backup jobs simultane... |
169 | 26 Oct 2014 @ 05:39 PDT | Database | Topic | TSET Collection | Volatile tables are available only in the sessions where they are defined.A query involving volatile tables has caused snapshot dump on the Teradata system to be detected.How to collect TSET for su... |
168 | 16 Oct 2014 @ 09:20 PDT | Database | Topic | SP call statement in Teradata 14.10 |
ON TD 14.10 ,the call statement of a stored proc is executed in WD Default workload and does not consume any CPU.
How do I Summarize the execution time and cpu consumption of all statements ... |
167 | 12 Oct 2014 @ 10:14 PDT | Database | Topic | Stats Collection WITH USE COUNT | How to use the DBQL option WITH USE COUNT to determine if stats colletion should be done or deactivated for table(s)?
|
166 | 29 Sep 2014 @ 08:16 PDT | Database | Reply | Profiles and Account Strings | Thanks Dieter!
How do we change the AccountName in dbc.dbase if the account is modified using the 'MODIFY PROFILE' command.I checked the explain for Modify Profile command , but DBC.Dbase ... |
165 | 29 Sep 2014 @ 08:05 PDT | Database | Topic | Accessing Secured Data | Hi,
There is a secured table in a DB containing highly confidendial customer data.
We provide users access to the database through roles, which are entirely at database level:
Grant select on DB... |
164 | 20 Sep 2014 @ 09:20 PDT | Database | Reply | Profiles and Account Strings | Thanks Rglass!
If I want to modify the account string of a profile (need to remove '&S' from account string because of excessive logging which is impacting system performance),which al... |
163 | 18 Sep 2014 @ 09:11 PDT | Database | Topic | Profiles and Account Strings | A profile may be associated with multiple account strings.
What is the query to know the various account strings associated with a particular profile?
Thanks in Advance!!
|
162 | 18 Sep 2014 @ 08:59 PDT | Third Party Software | Topic | MultiStream Netvault Backup Job | What are multistream jobs in Netvault backup jobs for taking Teradata backup ?How do they split the table's data across multiple streams?What is the concept on which they work?
How do we decid... |
161 | 15 Sep 2014 @ 11:37 PDT | Database | Topic | Crash Dump Errors in Teradata | What are the different type of errors due to which crash dump may get collected in Teradata?
|
160 | 04 Sep 2014 @ 08:29 PDT | General | Topic | Arcmain Install | What is the command to know if arcmain is installed on a Linux host?
Like to know if bteq is installed or not , we use: "which bteq " command
|
159 | 30 Aug 2014 @ 01:59 PDT | Database | Topic | Locking on DBC.All | User X is blocked by another user Y as user Y is holding a WRITE lock on table DBC.All
What is the DBC.All table?When is it used?what is the write operation that is being performed by the user ses... |