Teradata SQL query run

General
Enthusiast

Teradata SQL query run

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

4 REPLIES
Teradata Employee

Re: Teradata SQL query run

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

Junior Contributor

Re: Teradata SQL query run

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

Enthusiast

Re: Teradata SQL query run

Thank you.

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

Junior Contributor

Re: Teradata SQL query run

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)