#DateForumTypeThreadPost
18326 Apr 2015 @ 10:21 PDTViewpointTopicViewpoint 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...
18222 Apr 2015 @ 09:36 PDTDatabaseReplyStats CollectionThanks 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...
18121 Apr 2015 @ 07:47 PDTDatabaseReplyStats CollectionWe are using Teradata 14.10 version
18021 Apr 2015 @ 04:54 PDTDatabaseReplyStats CollectionI am reading the stats statements from a metadata table
17921 Apr 2015 @ 04:52 PDTDatabaseTopicStats 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 ...
17821 Apr 2015 @ 01:42 PDTDatabaseReplyRuleType in tdwm.ruledefsThanks Pierre.Any idea what are the ruletypes designated by 5,6 and 7?
17714 Apr 2015 @ 09:13 PDTDatabaseTopicsystem-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...
17619 Feb 2015 @ 09:27 PSTDatabaseTopicAccessCnt in DBC.ObjectUsageWhat is the difference between UserAccessCnt and SysAccessCnt columns in DBC.ObjectUsage table?How are the columns populated when we access any object?
17515 Feb 2015 @ 08:55 PSTDatabaseTopicResetting User Default DBI 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...
17412 Feb 2015 @ 07:05 PSTDatabaseReplyDropping usersBefore 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...
17306 Feb 2015 @ 09:39 PSTDatabaseTopicStats collection based on UseCountHow 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? 
17205 Jan 2015 @ 08:54 PSTDatabaseTopicManaging space with DBCWhat 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...
17122 Nov 2014 @ 11:38 PSTDatabaseTopicPackdiskWe 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...
17012 Nov 2014 @ 07:19 PSTGeneralTopicRunning 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...
16926 Oct 2014 @ 05:39 PDTDatabaseTopicTSET CollectionVolatile 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...
16816 Oct 2014 @ 09:20 PDTDatabaseTopicSP 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 ...
16712 Oct 2014 @ 10:14 PDTDatabaseTopicStats Collection WITH USE COUNTHow to use the DBQL option WITH USE COUNT to determine if stats colletion should be done or deactivated for table(s)?
16629 Sep 2014 @ 08:16 PDTDatabaseReplyProfiles and Account StringsThanks 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 ...
16529 Sep 2014 @ 08:05 PDTDatabaseTopicAccessing Secured DataHi, 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...
16420 Sep 2014 @ 09:20 PDTDatabaseReplyProfiles and Account StringsThanks 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...
16318 Sep 2014 @ 09:11 PDTDatabaseTopicProfiles and Account StringsA 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!!
16218 Sep 2014 @ 08:59 PDTThird Party SoftwareTopicMultiStream Netvault Backup JobWhat 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...
16115 Sep 2014 @ 11:37 PDTDatabaseTopicCrash Dump Errors in TeradataWhat are the different type of errors due to which crash dump may get collected in Teradata?
16004 Sep 2014 @ 08:29 PDTGeneralTopicArcmain InstallWhat 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
15930 Aug 2014 @ 01:59 PDTDatabaseTopicLocking on DBC.AllUser 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...

Pages