#DateForumTypeThreadPost
2807 Sep 2016 @ 02:44 PDTDatabaseReplyCollect Stats with insert statementA third statement for collecting stats is required.
2707 Sep 2016 @ 10:39 PDTDatabaseReplyFind blocking sessions and tables You can use following functions to map the ids to names IdentifyTable IdentifyDatabase   dbid=1 is for DBC tid=102 is for AccessRights table
2607 Sep 2016 @ 09:31 PDTDatabaseReplyCompute with immediate previous row value derived Let say your table has first record (2016-11-01, 1000) then you can run the below SQL once everyday which will calculate new Amount and insert it into the same table.   INS into dbn...
2506 Aug 2016 @ 01:53 PDTDatabaseReplyCannot view internal dbs control settings through viewpoint -teradata 1650 - Error Illegal optionTo view DBS Control Record - Internal Fields, enter the following command mod systemfe=T It will say  WARNING: Running DBSControl in SystemFE mode may result in inconsistent system behavior...
2406 Aug 2016 @ 01:31 PDTDatabaseReplyUser's DDLLike others mentioned there is no direct way that will show the DDL of any user.In addition what is mentioned in above replies you can try the below steps and see if thats what you are looking for....
2328 Jul 2016 @ 11:12 PDTDatabaseReplyFind the list of active running queries through SQL I believe you can't directly get the list of sessions querying a particular database using MonitorSQLText,MonitorSession.  You will have to complete all the 3 steps mentioned above ...
2211 Jul 2016 @ 10:39 PDTDatabaseReplyRestore using DSA with NO BUILD option.Tables which are being restored using DSA cannot be built by BUILD command using ARCMAIN. DSA restore job will automatically perform the build as one of the job phases.
2123 May 2016 @ 11:12 PDTDatabaseReplyAutomating release lock after database copy failureYou can test the "Forced" option for Release Lock and see it works for you. Forced =  Instructs Teradata ARC to try and release any placed locks if the archive fails. However there ...
2023 May 2016 @ 10:44 PDTDatabaseReplyWho dropped the table in teradata? If the table has “online logging” enabled, we need to disable online logging when table is dropped. But currently for most of the drop table statements Teradata submits a “...
1920 Nov 2015 @ 02:57 PSTPrivate Forum
1813 Nov 2015 @ 10:43 PSTDatabaseReplyNeed way to see how long sessions have been idle when VIEWPOINT services cannot be run. The below query will give you the list of all IDLE sessions on the system.   sel * FROM TABLE (MonitorSession(-1,'*',0)) AS t2 Where AMPState='IDLE' and PESTATE=...
1701 Oct 2015 @ 04:12 PDTDatabaseReplyBackup and Restore only statistics in Teradata If you use “Copy” in arcmain and table name remains same then stats is also copied. If you rename the table in your copy script then “copy” will not bring over the st...
1628 Sep 2015 @ 03:24 PDTDatabaseReplyFind the list of active running queries through SQL You can create a shell script which will have something like below This way you do not have to pass the parameters manually every-time for each session .   1 -    ...
1525 Sep 2015 @ 11:40 PDTDatabaseReplyFind the list of active running queries through SQL Step 1:- To get Active Queries    Sel *  FROM TABLE (MonitorSession(-1,'*',0)) AS T1 Where  AMPState='Active’;   Step 2:-  ...
1422 Jul 2015 @ 12:02 PDTDatabaseReplyOptimizing Stats CollectionAmit, I think its because of this parameter .Like i mentioned , If you change the value of SysSampleOption to 2 , this feature will be disabled and all of your full stats will never be converted (...
1321 Jul 2015 @ 11:03 PDTDatabaseReplyOptimizing Stats Collection Amit, Check the value of SysSampleOption  (DBS Control Record - Optimizer Statistics Fields) I believe the issue is due to DBS control value SysSampleOption = 0 (Enabled; Default va...
1217 Jul 2015 @ 10:29 PDTDatabaseReplyBackup and Restore only statistics in TeradataArpit, You can extract/save the statistics information using the below statements Show statistics values column (column_name) On DB_name.Table_name;   Show summary statistics valu...
1114 Jul 2015 @ 09:54 PDTViewpointReplyNot able to view SQL explain in Query monitorYou should also check the following settings Setttings > RoleManager > Click on the appropriate role > Click on portlets > Query Monitor > Click on Set Permissions > Permiss...
1012 Jul 2015 @ 11:14 PDTPrivate Forum
906 Nov 2014 @ 10:35 PSTDatabaseReplyDATABASE BACKUPI don't think you can find from dbc tables whether a backup job succeeded or failed. If you use Netvault then under Reports option you can see genearte report option (historic jobs) which...
806 Nov 2014 @ 10:20 PSTDatabaseReplySummary Statistics The Summary statistics are collected automatically when statistics on any column of the table are collected. You may refer the orange book "TD14.10 Statistics enhancement". It has ...
709 Oct 2014 @ 04:20 PDTDatabaseReplyAccess Right 'G' abbreviation In older Teradata releases, accessrights included the GRANT privilege, denoted as 'G'. Eventually, the functionality of GRANT was morphed into 'with grant option’.So "G&qu...
615 Jul 2013 @ 04:20 PDTDatabaseReplyARCMAIN giving Error 3802:Database '$ARC' does not exist.CATALOG has tape positioning information of a table/database.It is useful when you want to restore few tables from one saveset.
528 Jun 2013 @ 10:28 PDTDatabaseReplyAborting SessionYou can use commands like LIST STATUS,LIST ROLLBACK TABLES.If that session is listed in output of above command then rollback is still in progress. If CPU is not an issue then increase the rollback...
421 Jun 2013 @ 02:10 PDTDatabaseReplyObject access details - when and how many times a table/index/constraint being used by queriesYou can reset Accesscount and lastaccesstimestamp counters via macros under dbc.   Thanks Abhishek

Pages