Incomplete Query String in QueryText Column

General
Enthusiast

Incomplete Query String in QueryText Column

Hi ,

I am working on TD 12 and noticed that DBC QRYLOG view and underlying DBQL table have incomplete query string in QueryText column ( around 200 chars ) even though datatype shows VARCHAR(10000) .

Is there any other table we can retrieve this information from or is there a property which can be tuned for this ?

Thanks 

2 REPLIES
Senior Supporter

Re: Incomplete Query String in QueryText Column

It depend on the query log settings. So you can define how much chars should be logged in the qrylog table.

If SQL logging is enabled - which is often the case if the SQL is shorten for the qrylog table - you might find the SQL text in the corrosponding SQL table.

Otherwise you can ask your DBA to extend the SQL text logging for you

Enthusiast

Re: Incomplete Query String in QueryText Column

Thanks Ulrich .