#DateForumTypeThreadPost
8412 Oct 2010 @ 12:47 PDTToolsReplyFastexport - how to export without beginning two bytes ?Another alternative if you are in a UNIX environment is to use AWK or SED on the file after it has been output to strip the leading to characters from each record. Alternatively, you can concate...
8312 Oct 2010 @ 12:41 PDTDatabaseReplyTeradata on AIX?In my experience, AIX is typically found on UNIX application servers running the client load and unload utilities such as BTEQ, MultiLoad, FastExport.
8212 Oct 2010 @ 12:35 PDTDatabaseReplyRestrict a user access to certain time windowCheck the manuals for Teradata Dynamic Workload Manager. I believe it will allow you to accomplish what you have spelled out.
8112 Oct 2010 @ 12:24 PDTUDAReplyCompiling Stored Proc - VC++ not installed errorI found that I was not able to get VC++ 2010 Express to work with TD Express 12. I downloaded and installed VC++ 2008 Express, ran the cufconfig command from the Teradata Command Line, and then...
8012 Oct 2010 @ 11:53 PDTGeneralReplyfor helpCan you paste the arcmain script or more of the log into a message so we can see what was taking place leading up to the failure?
7912 Oct 2010 @ 11:49 PDTGeneralReplyTeradata Express 12 BTEQWIN .LOGON command errorTry the following: .LOGON localtd/tduser, SELECT CURRENT_DATE: .QUIT 0; COP1 is required in the HOSTS file for your Teradata Express entry but is not required as part of the hostid (td...
7804 Oct 2010 @ 09:36 PDTDatabaseReplyImpact of disabling DBQL & Listing all the DB/Users under Query/Access logg...1) Check the system view: DBC.DBQLRules 2) If you disable logging you will lose what ever data would have been logged during the maintenance of the DBQL tables. 3) Would depend on how you enabled...
7701 Oct 2010 @ 01:02 PDTGeneralReplyDownload Links says "Service Unavailble"Excellent news!
7628 Sep 2010 @ 06:01 PDTDatabaseReplyCollect stats on unique primary index failingWhat is the current max spool for the user submitting the collect stats command? Are there multiple sessions associated with this user when the stats are being collected? (Spool is shared across al...
7528 Sep 2010 @ 05:50 PDTGeneralReplyDownload Links says "Service Unavailble"Try contacting them via their Contact Us page. I had a similar problem and had to contact them to get the direct download link via email.
7424 Sep 2010 @ 07:47 PDTDatabaseReplyTable partitioning on TIMESTAMP(3) in Teradata 13With character fields you may have to jump through some hoops to get it to work. I managed to do it on TD 12 but it required the use of HASHROW and HASHBUCKET if I recall correctly and it may have ...
7317 Sep 2010 @ 04:04 PDTDatabaseReply13.00.00.06_SLES10_x64_SMP.zipAre you having problems with the email not arriving? I am trying to get TD Express for Windows (Have the VMWare image but lack a 64 bit processor currently) and the emails are not arriving with the...
7216 Sep 2010 @ 11:43 PDTDatabaseReplyDimensional Model RecomendationsRegarding Collect Stats please refer to these recent discussions: http://forums.teradata.com/forum/database/collect-stats-how-performance-gets-improved http://forums.teradata.com/forum/database...
7116 Sep 2010 @ 07:00 PDTDatabaseReply13.00.00.06_SLES10_x64_SMP.zipIf you go through the registration process at http://www.teradata.com/t/teradata-express-vmware/ you will be sent a link via email to download the version of Teradata Express that you selected. Reg...
7016 Sep 2010 @ 06:49 PDTDatabaseReplyTeradata Backup and Recovery.First, I would suggest spending sometime reviewing the materials in Teradata's Manuals. It would be much easier to provide guidance if you had a more specific question about Teradata's ARC utility ...
6916 Sep 2010 @ 06:39 PDTDatabaseReplyCurrentPerm different after restoreHow large of a discrepancy are you finding? Are you doing any journaling on or online archiving of the tables in question The first thing that comes to mind is fragmentation from cylinder splits...
6816 Sep 2010 @ 06:09 PDTDatabaseReplyDiagnostic Commands in Teradata..You need to capture the EXPLAIN output before and after the statistics are collected. Ideally you are working in a test environment to avoid impacting other queries that reference the affected colu...
6716 Sep 2010 @ 05:53 PDTDatabaseReplyDBQL - Account String logging and individual user logging.Query logging can be enabled and is recommended at the account string level. What account string expansion variables are being used? It is possible that without ASE certain levels of detail can not...
6616 Sep 2010 @ 04:12 PDTDatabaseReplyCalling all Teradata DBAs - Question around drop table grants.A couple suggestions to help address the concerns about audit compliance. Your stored procedure can create some form of audit trail in a table showing when it was called, by whom, and what object w...
6516 Sep 2010 @ 04:01 PDTDatabaseReplyNODE Performance showing 100%It is possible that the workload for this particular job is heavily skewed. If you can provide more details about the job it would allow us to better understand the situation and assist you.
6416 Sep 2010 @ 03:58 PDTDatabaseReplyHow to get Teradata metadata - basic architecture/terminology question1) A Virtual Data Mart is likely a set of views or aggregation tables used to facilitate reporting. The information about the objects will be retained in the same set of views/tables in the data di...
6316 Sep 2010 @ 03:42 PDTDatabaseReplyCollect Stats - How Performance gets improved?Stats generally should be collected on all indexes, join columns, partitioning columns, the PARTITION column for tables with multi-level partitioning, and columns that exist in the WHERE clause as ...
6215 Sep 2010 @ 06:24 PDTDatabaseReplyTable partitioning on TIMESTAMP(3) in Teradata 13I don't have the manuals in front of me to confirm the partitioning on a TIMESTAMP or not. But try this: PARTITION BY RANGE_N(COL_DTM BETWEEN TIMESTAMP '0001-01-01 00:00:00.000' AND TIMESTAM...
6115 Sep 2010 @ 04:58 PDTDatabaseReplyObtaining a Create Table Text String Using the DBC Only.Another option based on Toad's recommendation is to run the SQL using BTEQ and export the results to a flat file. Your flat file will contain all of the SHOW TABLE commands. Afterward you can turn ...
6015 Sep 2010 @ 04:49 PDTDatabaseReplyHow to get Teradata metadata - basic architecture/terminology questionThe data dictionary views you would likely need access to include: DBC.Tables - Includes DatabaseName, TableName DBC.Columns - Includes DatabaseName, TableName, ColumnName, ColumnType, ColumnLe...

Pages