How to find the application from which a query was submitted

Database
The Teradata Database channel includes discussions around advanced Teradata features such as high-performance parallel database technology, the optimizer, mixed workload management solutions, and other related technologies.
Fan

How to find the application from which a query was submitted

Hello,

 

I want to find the application from which a particular query was submitted by a user using the PDCRINFO.DBQL* tables. For instance I would want to know if a query was submiited by a user from SQL Asst, or from Business Objects, or from Informatica, or from simply a bteq script on unix etc.

I know how to locate a query in history from PDCRINFO.DBQLOGTBL_HST.

However, any pointers to the above requirement would be extremely helpful.. I am using Teradata v14

 

Thanks in advance...

1 REPLY
Teradata Employee

Re: How to find the application from which a query was submitted

For other than JDBC connections, the AppID column should contain some identifying info you can use, e.g. the utility name, executable program name on the client, etc.

 

For JDBC, this field contains only the driver and JDK version. Best practice is to use Query Band to indicate the application; otherwise some combination of UserName, ClientID, or ClientAddr might give you a clue.