TMSMMSG Command | Basic Teradata Query - 17.00 - TMSMMSG - Basic Teradata Query

Basic Teradata® Query Reference

prodname
Basic Teradata Query
vrm_release
17.00
created_date
June 2020
category
Programming Reference
featnum
B035-2414-220K

Purpose

This control enables users to specify whether to print diagnostic messages that describe loggable TMSM events.

Syntax


TMSMMSG Syntax

where the following is true:

ON
ON can be enabled only when no database sessions are logged on.

When neither ON or OFF are specified, ON is enabled.

OFF
OFF is the default value when BTEQ is invoked.

Usage Notes

A Teradata Multi-System Monitor (TMSM) client must be enabled so messages can be generated about events that were sent. When the client is disabled, messages are produced about events that would have been sent.

  • The formatting of the messages produced can change at any time.
  • TMSMMSG command is supported only for those BTEQ platforms where TMSM is supported. See manuals for Teradata Multi-System Manager ( see Related Documentation) for more information on TMSM.
  • The TMSMMSG command is not available in BTEQ for z/OS and Apple macOS. It may become available in future release.