16.20 - Example: Generating a Report of the PackDisk between January and the Current Date - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ SystemFE Macros

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
created_date
March 2019
category
Administration
featnum
B035-1103-162K

The following statement would give a report of the PackDisk between January 21, 2013, and the date of today.

Exec PackDisk ('2013-01-21',);
The date specified is the same as the date the macro was run.

The resulting report follows:

Exec PackDisk ('2013-01-21',);
*** Query completed. 23 rows found. 6 columns returned.
13/01/21         PackDisks Performed Between 2013-01-21 and 2013-01-21 21:49
Vproc       Date             Time         Event
------  --------  ---------------  ------------
     0  13/01/21  21:30:20.390000   34-05144-00
                  21:30:37.290000   34-05145-00
                                       ------
***** Number of PackDisks On vproc 0 =      1
     1  13/01/21  21:30:20.380000   34-05144-00
                  21:30:34.740000   34-05145-00
                                       ------
***** Number of PackDisks On vproc 1 =      1
     2  13/01/21  21:30:20.380000   34-05144-00
                  21:30:37.840000   34-05145-00
                                       ------
***** Number of PackDisks On vproc 2 =      1
     3  13/01/21  21:30:20.360000   34-05144-00
                  21:30:53.320000   34-05145-00
                                       ------
***** Number of PackDisks On vproc 3 =      1
     4  13/01/21  21:30:20.360000   34-05144-00
                  21:30:51.280000   34-05145-00
                                       ------
***** Number of PackDisks On vproc 4 =      1
     5  13/01/21  21:30:20.350000   34-05144-00
                  21:30:39.520000   34-05145-00
                                       ------
***** Number of PackDisks On vproc 5 =      1
     6  13/01/21  21:30:20.320000   34-05144-00
                  21:30:30.910000   34-05145-00
                                       ------
***** Number of PackDisks On vproc 6 =      1
     7  13/01/21  21:30:20.320000   34-05144-00
                                       ------
***** Number of PackDisks On vproc 7 =    1