All Forums Tools
Cvinodh 32 posts Joined 10/11
18 Nov 2012
Teradata PMon based Java application

Hi all,
my project uses a TD 13.10 system.
we are planning to develop a Java based application to dynamically view the queries run by our ETL jobs.
specifically queries that are blocked by other queries. I know this can be accomplished by PMon tool.
but we would like to view this information in a custom built application.
Does teradata provide any JDBC or native API to support this requirement.
or can this information can be queried from the DBC tables or macros?
if so what table(s) or macro?
Thanks,
Charles

dnoeth 4628 posts Joined 11/04
18 Nov 2012

The PMon API is still available, but afaik it's CLI based.
And since TD12(?) there's a SQL implementation using UDFs in SYSLIB, check the "Workload Management API" manual, Chapter 4: System PMPC APIs
Dieter
 

Dieter

tomnolan 594 posts Joined 01/08
19 Nov 2012

Yes, the Teradata JDBC Driver provides Monitor partition connections to enable your application to invoke PM/API commands. The Monitor partition connection support is documented in the Teradata JDBC Driver Reference here on Developer Exchange.
http://developer.teradata.com/doc/connectivity/jdbc/reference/current/jdbcug_chapter_2.html#BGBGGDCC
Also, please refer to the sample programs page:
http://developer.teradata.com/doc/connectivity/jdbc/reference/current/samplePrograms.html
Sample program T20914JD.java demonstrates how to use a Monitor partition connection to invoke PM/API commands.

Cvinodh 32 posts Joined 10/11
20 Nov 2012

Thanks Dieter and Nolan..
This is what I was searching for..

You must sign in to leave a comment.