#DateForumTypeThreadPost
5118 Feb 2014 @ 08:19 PSTTeradata ApplicationsReplyTPT export and error code 2595Yes that's right. Now that's clarified that there is no JDBC involvement can you kindly share any inputs on how this can be addressed ?   Thanks Abhijit
5017 Feb 2014 @ 10:30 PSTTeradata ApplicationsReplyTPT export and error code 2595Sorry if that confuses you but this is typical TPT script running from custom java wrapper on windows server 2008. 
4916 Feb 2014 @ 09:32 PSTTeradata ApplicationsReplyTPT export and error code 2595We have also seen similar issue with TPT Export running through JDBC via windows host.What is also strange that the error does not come up at a certain file size. It varies from some 10 to 40 GigaB...
4814 Feb 2014 @ 06:44 PSTTeradata ApplicationsReplyTPT export and error code 2595Hi Ulrich were you able to identidy the fix for this ? Appreciated   Thanks Abhijit    
4722 Aug 2013 @ 04:49 PDTDatabaseReplyvolatile table as select..with data - not loading dataYou will have to use Primary index something like below   create table TWM_SANDBOX.Tbl_frm_Query1 as ( SELECT CAST (RP.REGIS_DATETM AS DATE), COUNT(DISTINCT RP.REGIS_PRSNA_ID) FROM  ...
4604 Aug 2013 @ 09:13 PDTDatabaseReplyAWT Usage while session in RESPONSE stateHi Velu Sessions in responding mode doesn't hold up AWT. AWTs are ionvolved when AMPS are in active state, once AMP became idle it won't use AWTs. But when response was sent to dispatcher ...
4519 Jul 2013 @ 01:46 PDTPrivate Forum
4417 Jul 2013 @ 03:58 PDTDatabaseReplyDBQL Metricsbecause they are based onCPU Milliseconds per I/OException criteria. An anticipated range of appropriate CPU milliseconds per I/O values to set typically varies between 3 and 10. A typical query te...
4301 May 2013 @ 10:28 PDTDatabaseReplyCreating a new secondary index on tableanother option that you have is enable DBS parameter ObjectUsecountCollectrate and analyze values of access count and last access timestamp. You will see both access count and lastaccesstimestamp v...
4222 Apr 2013 @ 04:22 PDTPrivate Forum
4102 Apr 2013 @ 10:22 PDTPrivate Forum
4027 Mar 2013 @ 09:46 PDTPrivate Forum
3920 Dec 2012 @ 01:40 PSTViewpointReplyWorkload management in a multi-client data warehouseUnless you go to SLS 11 there is no absolute priority. Meaning a bad SQL running on PBOX can consume more than what it should have in 30 seconds interval. its all relative. You should try with Two ...
3811 Dec 2012 @ 03:50 PSTPrivate Forum
3730 Oct 2012 @ 04:04 PDTPrivate Forum
3630 Oct 2012 @ 09:31 PDTPrivate Forum
3501 Oct 2012 @ 08:49 PDTViewpointReplyViewpoint Time in State and Total duration from SQLS coming through procedureThanks Steve
3401 Oct 2012 @ 06:15 PDTViewpointReplyViewpoint Time in State and Total duration from SQLS coming through procedureThanks Steve for quick feedback is there any JIRA which we can refer and follow up for fix ? Any idea on possible fix timelines ?
3301 Oct 2012 @ 03:27 PDTViewpointTopicViewpoint Time in State and Total duration from SQLS coming through procedure  We have seen a situation where in which we observed Request count increased from a session who is submitting SQLs from a procedure and Time in State value is added up however what we see in...
3203 Aug 2012 @ 11:14 PDTPrivate Forum
3102 Aug 2012 @ 04:25 PDTPrivate Forum
3026 Jul 2012 @ 10:41 PDTToolsReplySQL Assistant 14.01 download availability? You can get ot from T@YS Windows download section and SQLA 14.01.0.01 works with ODBC 13.10 and .NET 13.11 as well.   Thanks Abhijit
2910 Jul 2012 @ 02:59 PDTDatabaseReplyLogonTime and StartTime if you are on 13.10 CHECK WORKLOAD FOR and CHECK WORLOAD END statements should appear in DBQL before load job starts. this was implemented to cleanly delay Utilities which was not possible earli...
2802 Jul 2012 @ 02:21 PDTToolsReplyRequest size exceeds maximum.   When submitted directly to the parser, the maximum SQL request size is 1mb(sysmaxreqsize).However, when submitted inside a stored procedure, each request is limited to a maximum size ...
2719 May 2012 @ 07:56 PDTToolsReplyWDID in tables? Starting from 13.10 PDCRDATA.Dbqloghtbl_Hst also includes Start and Final Workload name. 

Pages