All Forums Database
cmedved 24 posts Joined 02/14
03 Mar 2015
MonitorSQLSteps Truncated?

Hi all,
 
I understand that MonitorSQLSteps does not provide the full explain plan - this is fine. However, the text that it is returning is truncated. The definition of the function states that SQLStep is a VARCHAR(128). Our site is running Teradata 13.10.
 
Is this expected behavior for the procedure? Has it been improved since my version? Is the only way to get full step text to use true MONITOR commands by logging into the monitor partition? Every step is longer than 128 chars, which greatly limits the usefulness of the procedure :(

Tags:
tomnolan 594 posts Joined 01/08
03 Mar 2015

In TD 14.0, the SQLStep output column was increased in size to 1024 characters.
In TD 14.10, the SQLStep output column was increased in size to 2048 characters.
 

You must sign in to leave a comment.