Refreshed data in dbc.qrylogsteps

Database
Enthusiast

Refreshed data in dbc.qrylogsteps

Hi,

I am running this query in SQL Assistant ( sel * from dbc.qrylogsteps ), its giving some old data of year 2006.

Could anyone help me to get the latest data with this query.

Thanks in Advance,

SJ
2 REPLIES
Enthusiast

Re: Refreshed data in dbc.qrylogsteps

My guess would be that query logging is not turned on at the step level and that's why you're not seeing recent data.

If you are trying to capture the step level information for your query and you have the authority, you can go into Teradata Administrator and select the "Query Logging" option from the "Tools" menu item. You can then turn query logging on at the step level for your user ID (check "Step Information"). If you don't have the authority, you'll have to ask your DBA to do this.

You probably don't want to capture step level data on all your queries as it is pretty resource intensive, so I would turn it off once you get what you need. Alternatively, you could have a special ID or account that you use only when you want step level data. That way, you don't have to keep switching it on and off.

Enthusiast

Re: Refreshed data in dbc.qrylogsteps



Thanks, Barry