#DateForumTypeThreadPost
1812 Jul 2012 @ 05:34 PDTDatabaseReplyCLI error: MTDP: EM_GSSINITFAIL(235): call to gss_init failed Problem solved I've used 64-bit binary for TDGSS, cliv2, tdicu with 32-binary for bteq (no 64 for bteq exist). Using 32-bit for all binaries fixed the issue. Best regards
1712 Jul 2012 @ 01:40 PDTDatabaseTopicCLI error: MTDP: EM_GSSINITFAIL(235): call to gss_init failed GSS TTU 13.10 installation problem: this is Suse linux server # uname -a Linux ViewPoint_00-16 2.6.16.60-0.87.TDC.1.R.1-smp #1 SMP Thu Nov 10 04:53:43 PST 2011 x86_64 x86_64 x86_64 GNU/...
1619 Jun 2012 @ 05:05 PDTDatabaseTopicNo partition pruning when Partitioning using date expression on timestamp column   TABLE DDL where partiting prunning occur: CREATE MULTISET TABLE db1.tbl1 ,      (       Activity_Id INTEGER NOT NULL, ..... &nbs...
1519 Jun 2012 @ 04:50 PDTDatabaseReplyTD 12 Timestamp Partitioning... what about MLPPI?   TRY Cast it as DATE and add [AT TIME ZONE 0 ]    PARTITION BY RANGE_N(CAST((C3) AS DATE AT TIME ZONE 0 )  BETWEEN ....   i don't know why ...
1429 May 2012 @ 03:33 PDTViewpointTopicCustomize Mail Alert Is there's a way to customize the Mail alerts Generared by VP  14:     For Example SESSION alert [Blocked time] generates the following mail: Event Timestamp: ...
1307 May 2012 @ 02:05 PDTDatabaseReplyDBQL tables changes between 12 and 13.10 Not sure it's a correct place for this comment but there's something wrong with DBQL downlaods: http://downloads.teradata.com/download/database/dbql-scripts Migration scripts for...
1230 Apr 2012 @ 04:04 PDTDatabaseReplyDictionary Archive gets full data full data It's a problem with my archive script, dictionary archive  require single stream while my mistake was specifying  muliple streams.
1129 Apr 2012 @ 03:04 PDTDatabaseTopicDictionary Archive gets full data full data   we are using the following archive job to have weeklty backup for objects definitions:   ARCHIVE DICTIONARY TABLES (DBC) ALL ,  RELEASE LOCK, FILE=ARCHIV...
1024 Apr 2012 @ 03:13 PDTDatabaseTopicDBQL tables changes between 12 and 13.10   We've upgraded from 12.0 to 13.10:   Using TDWA to get Workload recommendation returned the following error:   [column statementgroup not found in SYS_MG...
917 Apr 2012 @ 08:08 PDTDatabaseTopicMigrate Viewpoint Alerts between system Scenario: we have 2 systems both configured to be monitored by Viewpoint 13.10. Is there's a way to export/import curent Viewpoint alerts set for a given system  and import it to an...
806 Feb 2012 @ 03:06 PSTDatabaseTopicLow cardinality with [Is Null] Predicate for an Indexed Timestamp column     A Timestamp indexed column suffers from very low cardinality when using [IS NUL] as predicate which estimates 1 row while actually 57264480 returned.   The col...
724 Jan 2012 @ 02:01 PSTDatabaseTopicVP: spool alert available For Viewpoint 13.10 is there an alert for SPOOL reserved  for session? If not which version have this type of alert If any?
607 Dec 2011 @ 01:08 PSTDatabaseTopicHow to identify which columns included in which index indexes view do not contain columnname. How to identify which column included in secondary/multicolumn/value-ordered indexes (other than using TD administrator).  
501 Dec 2011 @ 06:40 PSTDatabaseTopicHow to identify tables which aren't used since long time My Aim: to identify tables which hadn’t been queried for a year or more and delete it to reclaim space.   Since there no view which reflect table usage I thought we can use DB...
403 Nov 2011 @ 04:15 PDTDatabaseTopicspool vs free cylinder in Ferret show space output This is output of Ferre’s show space:                          &n...
302 Nov 2011 @ 12:09 PDTDatabaseTopicFormat funciton ignored from SQL Assistant Format funciton is kind of ignored from SQL Assistant SELECT CURRENT_TIME (FORMAT 'HH-MI-SS'); 20:56:50+00:00 SELECT CURRENT_DATE (FORMAT 'DD-MM-YY'); 02-Nov-11 ...
219 Oct 2011 @ 12:58 PDTDatabaseTopicCollect column statistics for a single partition Is it possible to collect column statistics for a specific partition? Our situation as follows: The weekly collect stats job (runs on Friday) is working fine for all queries which access...
128 Sep 2011 @ 02:23 PDTDatabaseTopicidentify total rows changes to identify tables with Stale statistics My goal is to build a script for gathering table statistics: My main directive is to include tables with amount of changes (inserts. updates, deletes) more than specific percent (EX: 10%) fr...

Pages