| 51 | 18 Feb 2014 @ 08:19 PST | Teradata Applications | Reply | TPT export and error code 2595 | Yes 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
|
| 50 | 17 Feb 2014 @ 10:30 PST | Teradata Applications | Reply | TPT export and error code 2595 | Sorry if that confuses you but this is typical TPT script running from custom java wrapper on windows server 2008.
|
| 49 | 16 Feb 2014 @ 09:32 PST | Teradata Applications | Reply | TPT export and error code 2595 | We 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... |
| 48 | 14 Feb 2014 @ 06:44 PST | Teradata Applications | Reply | TPT export and error code 2595 | Hi Ulrich
were you able to identidy the fix for this ?
Appreciated
Thanks
Abhijit
|
| 47 | 22 Aug 2013 @ 04:49 PDT | Database | Reply | volatile table as select..with data - not loading data | You 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
... |
| 46 | 04 Aug 2013 @ 09:13 PDT | Database | Reply | AWT Usage while session in RESPONSE state | Hi 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 ... |
| 45 | 19 Jul 2013 @ 01:46 PDT | Private Forum |
| 44 | 17 Jul 2013 @ 03:58 PDT | Database | Reply | DBQL Metrics | because 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... |
| 43 | 01 May 2013 @ 10:28 PDT | Database | Reply | Creating a new secondary index on table | another 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... |
| 42 | 22 Apr 2013 @ 04:22 PDT | Private Forum |
| 41 | 02 Apr 2013 @ 10:22 PDT | Private Forum |
| 40 | 27 Mar 2013 @ 09:46 PDT | Private Forum |
| 39 | 20 Dec 2012 @ 01:40 PST | Viewpoint | Reply | Workload management in a multi-client data warehouse | Unless 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 ... |
| 38 | 11 Dec 2012 @ 03:50 PST | Private Forum |
| 37 | 30 Oct 2012 @ 04:04 PDT | Private Forum |
| 36 | 30 Oct 2012 @ 09:31 PDT | Private Forum |
| 35 | 01 Oct 2012 @ 08:49 PDT | Viewpoint | Reply | Viewpoint Time in State and Total duration from SQLS coming through procedure | Thanks Steve
|
| 34 | 01 Oct 2012 @ 06:15 PDT | Viewpoint | Reply | Viewpoint Time in State and Total duration from SQLS coming through procedure | Thanks Steve for quick feedback is there any JIRA which we can refer and follow up for fix ? Any idea on possible fix timelines ? |
| 33 | 01 Oct 2012 @ 03:27 PDT | Viewpoint | Topic | Viewpoint 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... |
| 32 | 03 Aug 2012 @ 11:14 PDT | Private Forum |
| 31 | 02 Aug 2012 @ 04:25 PDT | Private Forum |
| 30 | 26 Jul 2012 @ 10:41 PDT | Tools | Reply | SQL 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
|
| 29 | 10 Jul 2012 @ 02:59 PDT | Database | Reply | LogonTime 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... |
| 28 | 02 Jul 2012 @ 02:21 PDT | Tools | Reply | Request 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 ... |
| 27 | 19 May 2012 @ 07:56 PDT | Tools | Reply | WDID in tables? |
Starting from 13.10 PDCRDATA.Dbqloghtbl_Hst also includes Start and Final Workload name.
|