All Forums General
sravan244 7 posts Joined 04/14
23 Jun 2014
Teradata SQL query run

is there anyway we can check if Teradata SQL query is going to finish in sometime now?

Sun_shine_jgd 39 posts Joined 07/13
24 Jun 2014

You can check that only through viewpoint or from PMON (depending on your TD version).It tells which step it is running.But cannot estimate how long that particular step will take again.
 
Thanks

dnoeth 4628 posts Joined 11/04
24 Jun 2014

If you got luck (i.e. access rights) you might also access PMon data using some table-UDFs, e.g.
MonitorMySessions
MonitorSQLSteps
MonitorSQLCurrentStep
 
Check the "Application Programming Reference" manual for details

Dieter

sravan244 7 posts Joined 04/14
25 Jun 2014

Thank you.
I have acess to MonitorMySessions.but when i execute other two i get error function doesnt exist.

dnoeth 4628 posts Joined 11/04
26 Jun 2014

Check syslib if they exist, maybe you're not using them correctly.
Both need parameters, e.g.

REPLACE FUNCTION SYSLIB.MonitorSQLSteps

(HostIdIn SMALLINT,

SessionNoIn INTEGER,

RunVProcNo SMALLINT)

Dieter

You must sign in to leave a comment.