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.