17.00 - 17.05 - Usage Notes - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SystemFE Macros

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
17.05
Release Date
June 2020
Content Type
Administration
Publication ID
B035-1103-170K
Language
English (United States)

The MiniCylPacks report is based on event codes 034-05141-00, 034-05142-00, and 034-05143-00.

You can use the ListErrorCodes macro to get a brief description of these events. For a detailed description, see “Teradata Database Messages” in Teradata Vantage™ - Database Messages, B035-1096.

This macro is useful to determine whether MiniCylPacks were done successfully, and whether they were performed in anticipation of their use or while there were other tasks waiting. This information is determined based on the specific event code, as follows:

Event Code Description
5141 Indicates an anticipated, successful freeing of cylinders.
5142 Indicates a successful freeing of cylinders, but caused other tasks to wait.
5143 Indicates no success at freeing cylinders, and that the event caused other tasks to wait.
These event codes can also be viewed in the ListErrorCodes report (see “ListErrorCodes”).