Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 08 Jun 2009 @ 19:29:50 GMT


     
  <Prev Next>  
<<First
<Prev
Next> Last>>  


Subj:   Requests to Data Dictionary have low priority
 
From:   Joerg Mutsch

Hi,

We are running a tool which is accessing the Data Dictionary of Teradata to retrieve Table Structure, Table Names, Column Names and Column Types.

The connections is done via JDBC (and also tried via ODBC) on a Terdata V12

The workload of the System is constantly at 100% during the day and also most of the night due to batch processing. Our client is running TASM for workload management.

I know that requests to the Data Dictionary will handled with a very low priority within Teradata. However the amount of data is quite low and we have to leave the request for overnight since we are almost not able to establish a connection to the Database due to the heavy workload and the low priority.

Is there a way what we could to speed up the request that does not involve changing anything on the clients TASM setup?

We tried already to uncheck the USE X VIEWS options but it did not improve the response time. In addition we tried some of the performance recommendations of the JDBC User guide but in the end we are still struggling with the low priority anyway.

Any ideas?


Thanks

Joerg



     
  <Prev Next>  
<<First
<Prev
Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016