Is there any command or SQL statement can be used to find a list of tables being loded by TPT jobs?

Database
Teradata Employee

Is there any command or SQL statement can be used to find a list of tables being loded by TPT jobs?

Hi ,

 

In td 15.10.5.4  Is there any command or SQL statement can be used to find a list of tables being loded by TPT jobs?

 

Best Regards,

Sunder

2 REPLIES
Senior Apprentice

Re: Is there any command or SQL statement can be used to find a list of tables being loded by TPT jo

Hi Sunder,

 

I don't think there's a specific command, but have you tried my suggestion listed here: https://community.teradata.com/t5/Database/How-to-I-know-how-many-tables-or-which-table-being-loaded...

 

HTH
Dave

Ward Analytics Ltd - information in motion
www: http://www.ward-analytics.com
Tags (3)
Enthusiast

Re: Is there any command or SQL statement can be used to find a list of tables being loded by TPT jo

If you are a DBA, you can run "check table ..pendingop". 

More non-intrusive way would be to run what Dave suggested.

I wish Teradata comesup with an API to run such utilities.