TMSMMSG - Basic Teradata Query

Basic Teradata Query Reference

Product
Basic Teradata Query
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-06-28
dita:mapPath
wmy1488824663431.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2414
lifecycle
previous
Product Category
Teradata Tools and Utilities

Purpose

The TMSMMSG command turns on the production of diagnostic status messages about table-change events.

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 Additional Information) for more information on TMSM.
The TMSMMSG command is not available in BTEQ for z/OS and Apple OS X. It may become available in future release.