#DateForumTypeThreadPost
3203 Sep 2012 @ 08:28 PDTDatabaseTopicTDWMSummaryLog - DelayedCount and DelayedQueries Can someone provide a description of the fields delayedcount and delayedqueries in the table DBC.TDWMSummaryLog? What's the difference between them? Thanks...
3120 Aug 2012 @ 07:38 PDTViewpointReplyAlert Notifications More control over the description portion is indeed a requirement especially as the exclusion list is also a part of this description. This is particularly important when various tools are e...
3018 Jul 2012 @ 02:08 PDTViewpointReplyGetting started with Viewpoint Email Alerts Have a look at Viewpoint Alerts Configuration and User Guide http://developer.teradata.com/viewpoint/reference/config-guide   Regards...
2909 Jul 2012 @ 05:47 PDTViewpointReplyCanary query logins Thanks for the reply Steve. Although I think it is the case but just confirming that this connection pool is internally controlled and not visible and/or modifiable as such? Regards...
2802 Jul 2012 @ 07:35 PDTViewpointReplyQuery Throughput and comparison to Viewpoint DBC.DBQL_ALL is not a teradata provided view. It is a customer created view on most sites to get the join of dbqlogtbl, dbqlsqltbl and dbqlobjtbl. Having said that, it should return much greater...
2729 Jun 2012 @ 04:03 PDTViewpointTopicCanary query logins Hi, I have set up canary queries for a couple of workloads with 'login each time query runs' option unchecked. I have also set up alerts for any users connected to the box for over 1...
2618 Jun 2012 @ 07:33 PDTToolsReplyQueryman and SQLA as APPID in DBQL Thanks. I was asking about the APPID column in DBC.DBQLOGTBL but correlating that column with logonsource in DBC.logonoff, it is one and the same thing. Thanks again. Regards...
2523 May 2012 @ 12:40 PDTGeneralReplyDBQL Columns TD13.10 documentation...pdf doc 1093 Database Administration Chapter 14 Tracking Processing Behavior with DBQL   Regards...
2417 May 2012 @ 05:46 PDTToolsTopicQueryman and SQLA as APPID in DBQL Hi, When the APPID in DBQL is recorded as 'Queryman' and when it is recorded as 'SQLA'? Regards...
2309 May 2012 @ 02:06 PDTDatabaseReplyConverting CHAR to DATE Cast('2012-01-20 02:32:37.000000' as Timestamp(6)); Regards...
2204 May 2012 @ 07:34 PDTViewpointReplyDelay tab not available - Out of turn released from delay queue Thanks Gary. Previously the example observed was against a workload throttle whereas I've seen this behaviour again today for utility throttle. I'll follow it up with a gsc incident....
2104 May 2012 @ 04:35 PDTDatabaseReplyHow to find the time a fastload was blocked because no utility slot was available Presuming no third party tools are being used and you are on a DBMS version with TASM that delays the utility sessions rather than just reject them , you can look for delaytime column in dbc.dbq...
2002 May 2012 @ 04:51 PDTViewpointTopicDelay tab not available - Out of turn released from delay queue After recent upgrade to TD13.10 with viewpoint V13.11.00.04-b59, we have noticed the delay queue users getting released out of order where as they should have been getting release on first come ...
1901 May 2012 @ 03:51 PDTDatabaseTopicError message with TPT FASTLOAD (Could Not Find Message Catalog opermsgs.cat) Hi, We've been getting this error message intermittently for TPT FASTLOAD running from SAS   ERROR: Teradata connection: Could Not Find Message Catalog opermsgs.cat Correct ...
1830 Apr 2012 @ 07:56 PDTToolsReplyhow does fastexport multiple sessions works? The actual fetching of data from the database is done by a single session however it is really the return of the data to the user that those multiple sessions come handy in. They return the data...
1724 Apr 2012 @ 06:44 PDTViewpointReplyProblem deleting workloads Hi, There does'nt need to be a criteria against these workloads however some other workload queries are being demoted into one of the deleted workloads as part of an exception. Pleas...
1623 Apr 2012 @ 01:14 PDTDatabaseReplyAlerts for blocking? Yes, pretty much the same concept with Teradata Manager as well, please refer to the TD Manager documentation. It's explained pretty neatly in there. Regards...
1520 Apr 2012 @ 01:09 PDTDatabaseReplyAlerts for blocking? You can easily send email to users through viewpoint in case there is a blocking. Admin -> Alert Policies -> Delivery Settings -> Email (Specify your SMTP host here)   ...
1419 Apr 2012 @ 06:01 PDTDatabaseReplyHow to find out Active sessions at any point of time.   This sql will give you all the current running (ACTIVE) sessions and the time they have been logged on for.       SELECT Username , LogonSequenceNo , PA...
1319 Apr 2012 @ 02:31 PDTGeneralReplyVolatile table issue Could be trivial but double check that you are looking at the default databases at the right place i.e. profile details if profile is allocated and user details if it is not.
1218 Apr 2012 @ 08:46 PDTThird Party SoftwareTopicSAS Fastload Sleep and Tenacity & SessDalyed   I could be a bit vague in describing the scenario but I'll give it my best shot.   Are there any recommendations around setting or otherwise of the 'sleep' an...
1116 Apr 2012 @ 05:59 PDTGeneralReply Target row updated by multiple source rows Yes, invoice_id and Item_nr is not unique in IPI. You can run the following to get the duplicates   select sub.invoice_id, sub.item_nr, count(*) Dup from ( Select i...
1013 Apr 2012 @ 04:48 PDTGeneralReplyPerformance of Global temp tables vs permanent tables? Global temporary tables don't use permanent journals. They have a session level scope, the data loaded in it is not available after the session is disconnected therefore its usage is really ...
911 Apr 2012 @ 06:25 PDTDatabaseReplyChecktable No solution to your problem but just adding that we have seen the same issue with packdisk as well. Regards...
811 Apr 2012 @ 06:22 PDTDatabaseReplyIncremental Backup Incremental backups are used with permanent journals. You need to enable journalling. These journals keep a snapshot of all the changes that have taken place since the last backup and while back...

Pages