15.10 - MiniCylPacks - Teradata Database

Teradata Database SystemFE Macros

prodname
Teradata Database
vrm_release
15.00
15.10
category
Administration
featnum
B035-1103-015K

MiniCylPacks

Returns all MiniCylPacks related events logged in the DBC.Software_Event_Log table for a set period of time.

Syntax

where:

 

Syntax Element …

Specifies …

Fromdate

the date on which the search is to start.

The format is 'YYYY-MM-DD'. This parameter can be coded either as a character string, for example, '2013-05-31', or as a numeric value, for example, 1130531.

Todate

the date on which the search is to stop.

The format is 'YYYY-MM-DD'. This parameter can be coded either as a character string, for example, '2013-05-31', or as a numeric value, for example, 1130531. The default value for Todate is the current date.

Note: This macro is not case sensitive. Uppercase and lowercase letters can be used interchangeably.

Usage Notes

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 the “Teradata Database Messages” chapter of Messages.

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.

Note: These event codes can also be viewed in the ListErrorCodes report (see “ListErrorCodes” on page 29).

Example  

The following statement generates a MiniCylPacks report for the last seven days:

Exec MiniCylPacks (Date-6,);

Example  

The following statement gives a report of the MiniCylPacks between January 1, 2013 and March 10, 2013:

Exec MiniCylPacks ('2013-01-01', '2013-03-10');

Example  

The following statement gives a report of the MiniCylPacks between January 21, 2013, and the date of today:

Exec MiniCylPacks ('2013-01-21',);

The resulting report follows:

Exec MiniCylPacks ('2013-01-21',);
*** Query completed. 14 rows found. 6 columns returned.
13/01/21    MiniCylPacks Performed Between 2013-01-21 and 2013-01-21    21:49
 Vproc      Date             Time 	        Event
------  --------  ---------------  ------------
     1  			13/01/21  21:29:26.610000  34-05142-00       
                                                      ------
***** Number of MiniCylPack log messages On vproc 1 =      1
     2 		13/01/21 21:29:25.630000  34-05142-00
                                                      ------
***** Number of MiniCylPack log messages On vproc 2 =      1
     3 		13/01/21 21:29:24.950000  34-05142-00
                                                      ------
***** Number of MiniCylPack log messages On vproc 3 =      1
     4 		13/01/21 21:29:24.670000  34-05142-00
                                                      ------
***** Number of MiniCylPack log messages On vproc 4 =      1
     5 		13/01/21 21:29:24.660000  34-05142-00
                                                      ------
***** Number of MiniCylPack log messages On vproc 5 =      1
     6 		13/01/21 21:29:25.130000  34-05142-00
                                                      ------
**** Number of MiniCylPack log messages On vproc 6 =       1
     7 		13/01/21 21:29:25.250000  34-05142-00
                                                      ------
***** Number of MiniCylPack log messages On vproc 7 =      1
*** Query completed. No rows found.
*** Echo accepted.