In view point from query monitor we are able to identify the long running job by seeing the time , session id and username . with this information can we able to back track and find jobname ( TPT) and unix process id . please let me know if this is possible or not .
is it possible to compare the unix process id and teradata session id .
Hopefully this data is in the query band. Starting with Viewpoint 14.10, you should see query band data showing up for the control sessions when running load/unload jobs.