17.10 - Example: Generating a PackDisk Report Between January and the Current Date - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - SystemFE Macros

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Administration
Publication ID
B035-1103-171K
Language
English (United States)

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