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

SystemFE Macros

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
ynt1557098768177.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1103
lifecycle
previous
Product Category
Teradata Vantageā„¢

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