MonitorSQLSteps Truncated?

Database
Enthusiast

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 (1)
1 REPLY
Teradata Employee

Re: MonitorSQLSteps Truncated?

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.